I_AdditionalCustomerMaterial

DDL: I_ADDITIONALCUSTOMERMATERIAL SQL: ISDADDCUSTMAT Type: view BASIC
8 Fields 1 Data Sources 1 Associations

Additional Customer Materials

I_AdditionalCustomerMaterial is a Basic CDS View that provides data about "Additional Customer Materials" in SAP S/4HANA. It reads from 1 data source (knmta) and exposes 8 fields with key fields SalesOrganization, DistributionChannel, Customer, Material, Product. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
knmta knmta from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_CustomerMaterial _CustomerMaterial $projection.SalesOrganization = _CustomerMaterial.SalesOrganization and $projection.DistributionChannel = _CustomerMaterial.DistributionChannel and $projection.Customer = _CustomerMaterial.Customer and $projection.Material = _CustomerMaterial.Material and $projection.Product = _CustomerMaterial.Product

Annotations (14)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
EndUserText.label Additional Customer Materials view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
AbapCatalog.sqlViewName ISDADDCUSTMAT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AbapCatalog.buffering.status #ACTIVE view
AbapCatalog.buffering.type #FULL view
Metadata.ignorePropagatedAnnotations true view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY SalesOrganization knmt vkorg SD Sales Org.
KEY DistributionChannel knmt vtweg RefDistCh-Cust/Mat.
KEY Customer knmt kunnr Stock customer
KEY Material knmt matnr Vehicle Model
KEY Product
KEY MaterialByCustomer knmta kdmat Customer Mat.
MaterialDescriptionByCustomer addpostx CustMatDescr.
_CustomerMaterial _CustomerMaterial

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 I_AdditionalCustomerMaterial.
-- 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: ISDADDCUSTMAT

CREATE VIEW I_AdditionalCustomerMaterial AS
SELECT
  knmt.vkorg AS SalesOrganization,
  knmt.vtweg AS DistributionChannel,
  knmt.kunnr AS Customer,
  knmt.matnr AS Material,
  cast (knmt.matnr as productnumber preserving type) AS Product,
  knmta.kdmat AS MaterialByCustomer,
  addpostx AS MaterialDescriptionByCustomer
FROM knmta
LEFT OUTER JOIN I_CustomerMaterial AS _CustomerMaterial ON SalesOrganization = _CustomerMaterial.SalesOrganization AND DistributionChannel = _CustomerMaterial.DistributionChannel AND Customer = _CustomerMaterial.Customer AND Material = _CustomerMaterial.Material AND Product = _CustomerMaterial.Product  -- association [1..1]
;

Learn More