I_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_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: ISDCUSTMATLINFO

CREATE VIEW I_CustomerMaterial AS
SELECT
  vkorg AS SalesOrganization,
  vtweg AS DistributionChannel,
  kunnr AS Customer,
  matnr AS Material,
  cast(matnr as productnumber preserving type ) AS Product,
  sortl AS SortField,
  sortl AS ETag,
  kdmat AS MaterialByCustomer,
  postx AS MaterialDescriptionByCustomer,
  werks AS Plant,
  lprio AS DeliveryPriority,
  minlf AS MinDeliveryQtyInBaseUnit,
  meins AS BaseUnit,
  kztlf AS PartialDeliveryIsAllowed,
  antlf AS MaxNmbrOfPartialDelivery,
  untto AS UnderdelivTolrtdLmtRatioInPct,
  uebto AS OverdelivTolrtdLmtRatioInPct,
  uebtk AS UnlimitedOverdeliveryIsAllowed,
  vwpos AS CustomerMaterialItemUsage,
  vrkme_t AS SalesUnit,
  umvkn_t AS SalesQtyToBaseQtyDnmntr,
  umvkz_t AS SalesQtyToBaseQtyNmrtr
FROM knmt
LEFT OUTER JOIN I_SalesOrganization AS _SalesOrganization ON SalesOrganization = _SalesOrganization.SalesOrganization  -- association [0..1]
LEFT OUTER JOIN I_DistributionChannel AS _DistributionChannel ON DistributionChannel = _DistributionChannel.DistributionChannel  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [0..1]
LEFT OUTER JOIN I_Product AS _Product ON Product = _Product.Product  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_DeliveryPriority AS _DeliveryPriority ON DeliveryPriority = _DeliveryPriority.DeliveryPriority  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BaseUnit ON BaseUnit = _BaseUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_PartialDeliveryItem AS _PartialDeliveryIsAllowed ON PartialDeliveryIsAllowed = _PartialDeliveryIsAllowed.PartialDeliveryIsAllowed  -- association [0..1]
LEFT OUTER JOIN I_CustomerMaterialItemUsage AS _CustomerMaterialItemUsage ON CustomerMaterialItemUsage = _CustomerMaterialItemUsage.CustomerMaterialItemUsage  -- association [0..1]
LEFT OUTER JOIN I_AdditionalCustomerMaterial AS _AdditionalCustomerMaterial ON SalesOrganization = _AdditionalCustomerMaterial.SalesOrganization AND DistributionChannel = _AdditionalCustomerMaterial.DistributionChannel AND Customer = _AdditionalCustomerMaterial.Customer AND Material = _AdditionalCustomerMaterial.Material  -- association [0..*]
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]
;