I_CustomerMaterial_2

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_2.
-- 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: ISDCUSTMATLINFO2

CREATE VIEW I_CustomerMaterial_2 AS
SELECT
  vkorg AS SalesOrganization,
  vtweg AS DistributionChannel,
  kunnr AS Customer,
  cast( matnr as productnumber preserving type ) AS Product,
  kdmat AS MaterialByCustomer,
  postx AS MaterialDescriptionByCustomer,
  rdprf AS RoundingProfile,
  werks AS Plant,
  lprio AS DeliveryPriority,
  minlf AS MinDeliveryQtyInBaseUnit,
  meins AS BaseUnit,
  sortl AS CustomerMaterialSearchTerm,
  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,
  last_changed_by_user AS LastChangedByUser
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_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 Product = _AdditionalCustomerMaterial.Product  -- association [0..*]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN E_CustomerMaterial AS _Extension ON Product = _Extension.Material AND Customer = _Extension.Customer AND SalesOrganization = _Extension.SalesOrganization AND DistributionChannel = _Extension.DistributionChannel  -- association [0..1]
;