ESH_N_SOR_CUSTMAT

DDL: ESH_N_SOR_CUSTMAT SQL: ESH_L_SORCUSTMAT Type: view Package: VDM_SD_SLS_AUTOEXTRN
9 Fields 1 Data Sources

Anchor view -SOR_CUSTMAT

ESH_N_SOR_CUSTMAT is a CDS View that provides data about "Anchor view -SOR_CUSTMAT" in SAP S/4HANA. It reads from 1 data source (I_CUSTOMERMATERIAL_2) and exposes 9 fields with key fields CUSTOMER, DISTRIBUTIONCHANNEL, PRODUCT, SALESORGANIZATION. Part of development package VDM_SD_SLS_AUTOEXTRN.

Data Sources (1)

SourceAliasJoin Type
I_CUSTOMERMATERIAL_2 I_CUSTOMERMATERIAL_2 from

Annotations (6)

NameValueLevelField
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #REQUIRED view
AbapCatalog.sqlViewName ESH_L_SORCUSTMAT view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY CUSTOMER CUSTOMER Sold-to Party
KEY DISTRIBUTIONCHANNEL DISTRIBUTIONCHANNEL RefDistCh-Cust/Mat.
KEY PRODUCT PRODUCT Product Sold
KEY SALESORGANIZATION SALESORGANIZATION Sales Organization
AUTHORIZATIONGROUP _CUSTOMER AUTHORIZATIONGROUP AuthorizGroup
ADDITIONALMATERIALBYCUSTOMER _ADDITIONALCUSTOMERMATERIAL MATERIALBYCUSTOMER Customer Mat.
MATERIALBYCUSTOMER MATERIALBYCUSTOMER Customer Mat.
ADDLMATERIALDESCBYCUSTOMER _ADDITIONALCUSTOMERMATERIAL MATERIALDESCRIPTIONBYCUSTOMER Customer Descr.
MATERIALDESCRIPTIONBYCUSTOMER MATERIALDESCRIPTIONBYCUSTOMER Customer Descr.

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view ESH_N_SOR_CUSTMAT.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: ESH_L_SORCUSTMAT

CREATE VIEW ESH_N_SOR_CUSTMAT AS
SELECT
  CUSTOMER,
  DISTRIBUTIONCHANNEL,
  PRODUCT,
  SALESORGANIZATION,
  _CUSTOMER.AUTHORIZATIONGROUP AS AUTHORIZATIONGROUP,
  _ADDITIONALCUSTOMERMATERIAL.MATERIALBYCUSTOMER AS ADDITIONALMATERIALBYCUSTOMER,
  MATERIALBYCUSTOMER,
  _ADDITIONALCUSTOMERMATERIAL.MATERIALDESCRIPTIONBYCUSTOMER AS ADDLMATERIALDESCBYCUSTOMER,
  MATERIALDESCRIPTIONBYCUSTOMER
FROM I_CUSTOMERMATERIAL_2
;

Learn More