E_CustomerMaterial

DDL: E_CUSTOMERMATERIAL SQL: ESDCUSTMATLINFO Type: view EXTENSION

Extension View for KNMT

E_CustomerMaterial is a Extension CDS View that provides data about "Extension View for KNMT" in SAP S/4HANA. It reads from 1 data source (knmt) and exposes 4 fields with key fields Material, Customer, SalesOrganization, DistributionChannel.

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
knmt Persistence from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName ESDCUSTMATLINFO view
VDM.viewType #EXTENSION view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ObjectModel.usageType.serviceQuality #P view
EndUserText.label Extension View for KNMT view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY Material knmt matnr
KEY Customer knmt kunnr
KEY SalesOrganization knmt vkorg
KEY DistributionChannel knmt vtweg 
@AbapCatalog.sqlViewName: 'ESDCUSTMATLINFO'
@VDM.viewType: #EXTENSION
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@ObjectModel.usageType.serviceQuality: #P
@EndUserText.label: 'Extension View for KNMT'

define view E_CustomerMaterial as select from knmt as Persistence {
      key Persistence.matnr as Material,
      key Persistence.kunnr as Customer,
      key Persistence.vkorg as SalesOrganization,
      key Persistence.vtweg as DistributionChannel
  
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"KNMT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More