C_CustMatlAddrDepdntInfoTP

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 C_CustMatlAddrDepdntInfoTP.
-- 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: CCSTMATADRDEPTP

CREATE VIEW C_CustMatlAddrDepdntInfoTP AS
SELECT
  SalesOrganization,
  DistributionChannel,
  Customer,
  Material,
  AddressID,
  Plant,
  AddressIDForEdit,
  SalesOrganizationForEdit,
  DistributionChannelForEdit,
  CustomerForEdit,
  cast(MaterialForEdit as productnumber preserving type ) AS MaterialForEdit,
  BusinessPartner,
  _Plant.PlantName AS PlantName,
  cast( '' as ad_line_s ) AS FormattedPostalAddressDesc
FROM I_CustMatlAddrDepdntInfoTP
LEFT OUTER JOIN C_CustomerMaterial_F2499 AS _CustMatlAddrDepdntInfo ON SalesOrganization = _CustMatlAddrDepdntInfo.SalesOrganization AND DistributionChannel = _CustMatlAddrDepdntInfo.DistributionChannel AND Customer = _CustMatlAddrDepdntInfo.Customer AND Material = _CustMatlAddrDepdntInfo.Material  -- association [1..1]
LEFT OUTER JOIN I_AllwdPlantsPerSlsOrgVH AS _PlantValueHelp ON Plant = _PlantValueHelp.Plant AND SalesOrganizationForEdit = _PlantValueHelp.SalesOrganization AND DistributionChannelForEdit = _PlantValueHelp.DistributionChannel  -- association [0..1]
LEFT OUTER JOIN C_CustomerBPAddressVH AS _BPAddressValueHelp ON CustomerForEdit = _BPAddressValueHelp.Customer AND AddressIDForEdit = _BPAddressValueHelp.AddressID  -- association [0..1]
;