I_CustomerMaterialTP

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_CustomerMaterialTP.
-- 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: ISDCUSTMATTP

CREATE VIEW I_CustomerMaterialTP AS
SELECT
  SalesOrganization,
  DistributionChannel,
  Customer,
  cast (Product as productnumber preserving type) AS Material,
  _SalesOrganization._Text[1: Language=$session.system_language ].SalesOrganizationName AS SalesOrganizationName,
  SalesOrganization AS SalesOrganizationForEdit,
  DistributionChannel AS DistributionChannelForEdit,
  Product AS MaterialForEdit,
  CustomerMaterialSearchTerm,
  MaterialByCustomer,
  MaterialByCustomer AS MaterialByCustomerForEdit,
  _Material._Text[1: Language=$session.system_language ].MaterialName AS MaterialName,
  MaterialDescriptionByCustomer,
  RoundingProfile,
  Plant,
  DeliveryPriority,
  MinDeliveryQtyInBaseUnit,
  BaseUnit,
  PartialDeliveryIsAllowed,
  MaxNmbrOfPartialDelivery,
  UnderdelivTolrtdLmtRatioInPct,
  OverdelivTolrtdLmtRatioInPct,
  UnlimitedOverdeliveryIsAllowed,
  CustomerMaterialItemUsage,
  SalesUnit,
  SalesQtyToBaseQtyDnmntr,
  SalesQtyToBaseQtyNmrtr,
  LastChangedByUser,
  LastChangeDateTime
FROM I_CustomerMaterial_2
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_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_CustomerMaterialLongTextTP AS _CustomerMaterialText ON SalesOrganization = _CustomerMaterialText.SalesOrganization AND DistributionChannel = _CustomerMaterialText.DistributionChannel AND Customer = _CustomerMaterialText.Customer AND Material = _CustomerMaterialText.Material  -- association [0..*]
LEFT OUTER JOIN I_AdditionalCustomerMaterialTP AS _AdditionalCustomerMaterial ON SalesOrganization = _AdditionalCustomerMaterial.SalesOrganization AND DistributionChannel = _AdditionalCustomerMaterial.DistributionChannel AND Customer = _AdditionalCustomerMaterial.Customer AND Material = _AdditionalCustomerMaterial.Material  -- association [0..*]
LEFT OUTER JOIN I_CustMatlAddrDepdntInfoTP AS _CustMatlAddrDepdntInfo ON SalesOrganization = _CustMatlAddrDepdntInfo.SalesOrganization AND DistributionChannel = _CustMatlAddrDepdntInfo.DistributionChannel AND Customer = _CustMatlAddrDepdntInfo.Customer AND Material = _CustMatlAddrDepdntInfo.Material  -- association [0..*]
LEFT OUTER JOIN I_LogisticalRoundingProfile AS _LogisticalRoundingProfile ON Plant = _LogisticalRoundingProfile.Plant AND RoundingProfile = _LogisticalRoundingProfile.LogisticalRoundingProfile  -- association [0..1]
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]
;