A_CustomerMaterial

DDL: A_CUSTOMERMATERIAL Type: view COMPOSITE
22 Fields 1 Data Sources 1 Associations

Customer Materials

A_CustomerMaterial is a Composite CDS View that provides data about "Customer Materials" in SAP S/4HANA. It reads from 1 data source (I_CustomerMaterial_2) and exposes 22 fields with key fields SalesOrganization, DistributionChannel, Customer, Material. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_CustomerMaterial_2 I_CustomerMaterial_2 from

Associations (1)

CardinalityTargetAliasCondition
[0..1] E_CustomerMaterial _Extension $projection.Material = _Extension.Material and $projection.Customer = _Extension.Customer and $projection.SalesOrganization = _Extension.SalesOrganization and $projection.DistributionChannel = _Extension.DistributionChannel

Annotations (15)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Customer Materials view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
AbapCatalog.sqlViewName ACUSTMATINFORECD view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
Metadata.ignorePropagatedAnnotations true view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY SalesOrganization SalesOrganization Sales Organization
KEY DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
KEY Customer Customer Sold-to Party
KEY Material Product Product Sold
MaterialByCustomer MaterialByCustomer Customer Mat.
MaterialDescriptionByCustomer MaterialDescriptionByCustomer Customer Descr.
RoundingProfile RoundingProfile Rnding Profile
Plant Plant Valuation Area
DeliveryPriority DeliveryPriority Delivery Prior.
MinDeliveryQtyInBaseUnit MinDeliveryQtyInBaseUnit Min. Dely Qty
BaseUnit BaseUnit Unit of Measure
PartialDeliveryIsAllowed PartialDeliveryIsAllowed Partial Deliv.
MaxNmbrOfPartialDelivery MaxNmbrOfPartialDelivery Max.Part.Deliv.
UnderdelivTolrtdLmtRatioInPct UnderdelivTolrtdLmtRatioInPct Underdel. Tol.
OverdelivTolrtdLmtRatioInPct OverdelivTolrtdLmtRatioInPct Overdeliv. Tol.
UnlimitedOverdeliveryIsAllowed UnlimitedOverdeliveryIsAllowed Unlimited Tol.
CustomerMaterialItemUsage CustomerMaterialItemUsage Item Usage
SalesUnit SalesUnit Unit
SalesQtyToBaseQtyDnmntr SalesQtyToBaseQtyDnmntr Denominat.
SalesQtyToBaseQtyNmrtr SalesQtyToBaseQtyNmrtr Numerator
CustomerMaterialSearchTerm CustomerMaterialSearchTerm Search term
ETag Timestamp

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 A_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.

CREATE VIEW A_CustomerMaterial AS
SELECT
  SalesOrganization,
  DistributionChannel,
  Customer,
  Product AS Material,
  MaterialByCustomer,
  MaterialDescriptionByCustomer,
  RoundingProfile,
  Plant,
  DeliveryPriority,
  MinDeliveryQtyInBaseUnit,
  BaseUnit,
  PartialDeliveryIsAllowed,
  MaxNmbrOfPartialDelivery,
  UnderdelivTolrtdLmtRatioInPct,
  OverdelivTolrtdLmtRatioInPct,
  UnlimitedOverdeliveryIsAllowed,
  CustomerMaterialItemUsage,
  SalesUnit,
  SalesQtyToBaseQtyDnmntr,
  SalesQtyToBaseQtyNmrtr,
  CustomerMaterialSearchTerm,
  cast(LastChangeDateTime as customer_material_etag ) AS ETag
FROM I_CustomerMaterial_2
LEFT OUTER JOIN E_CustomerMaterial AS _Extension ON Material = _Extension.Material AND Customer = _Extension.Customer AND SalesOrganization = _Extension.SalesOrganization AND DistributionChannel = _Extension.DistributionChannel  -- association [0..1]
;

Learn More