E_CustomerMaterial

DDL: E_CUSTOMERMATERIAL SQL: ESDCUSTMATLINFO Type: view EXTENSION
4 Fields 1 Data Sources

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.

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 Vehicle Model
KEY Customer knmt kunnr Stock customer
KEY SalesOrganization knmt vkorg SD Sales Org.
KEY DistributionChannel knmt vtweg RefDistCh-Cust/Mat.

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 E_CustomerMaterial.
-- 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: ESDCUSTMATLINFO

CREATE VIEW E_CustomerMaterial AS
SELECT
  Persistence.matnr AS Material,
  Persistence.kunnr AS Customer,
  Persistence.vkorg AS SalesOrganization,
  Persistence.vtweg AS DistributionChannel
FROM knmt AS Persistence
;

Learn More