ESH_N_SOR_CUSTMAT

DDL: ESH_N_SOR_CUSTMAT SQL: ESH_L_SORCUSTMAT Type: view

ESH_N_SOR_CUSTMAT is a CDS View in SAP S/4HANA. It reads from 1 data source (I_CUSTOMERMATERIAL_2) and exposes 9 fields with key fields CUSTOMER, DISTRIBUTIONCHANNEL, PRODUCT, SALESORGANIZATION.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
I_CUSTOMERMATERIAL_2 I_CUSTOMERMATERIAL_2 from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.serviceQuality #A 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
KEY DISTRIBUTIONCHANNEL DISTRIBUTIONCHANNEL
KEY PRODUCT PRODUCT
KEY SALESORGANIZATION SALESORGANIZATION
AUTHORIZATIONGROUP _CUSTOMER AUTHORIZATIONGROUP
ADDITIONALMATERIALBYCUSTOMER _ADDITIONALCUSTOMERMATERIAL MATERIALBYCUSTOMER
MATERIALBYCUSTOMER MATERIALBYCUSTOMER
ADDLMATERIALDESCBYCUSTOMER _ADDITIONALCUSTOMERMATERIAL MATERIALDESCRIPTIONBYCUSTOMER
MATERIALDESCRIPTIONBYCUSTOMER MATERIALDESCRIPTIONBYCUSTOMER 
@AccessControl.authorizationCheck: #MANDATORY
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.dataClass: #MASTER
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #REQUIRED
@AbapCatalog.sqlViewName: 'ESH_L_SORCUSTMAT'
define view ESH_N_SOR_CUSTMAT 
as select from I_CUSTOMERMATERIAL_2 {

key CUSTOMER,

key DISTRIBUTIONCHANNEL,

key PRODUCT,

key SALESORGANIZATION,

_CUSTOMER.AUTHORIZATIONGROUP,

_ADDITIONALCUSTOMERMATERIAL.MATERIALBYCUSTOMER as ADDITIONALMATERIALBYCUSTOMER,

MATERIALBYCUSTOMER,

_ADDITIONALCUSTOMERMATERIAL.MATERIALDESCRIPTIONBYCUSTOMER as ADDLMATERIALDESCBYCUSTOMER,

MATERIALDESCRIPTIONBYCUSTOMER
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ADDITIONALCUSTOMERMATERIAL",
"I_CUSTOMER",
"I_CUSTOMERMATERIAL_2"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More