C_RFM_MaSaDoSlsHdrCustBasic

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_RFM_MaSaDoSlsHdrCustBasic.
-- 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 C_RFM_MaSaDoSlsHdrCustBasic AS
SELECT
  SalesDocument,
  SalesOrganization,
  SoldToParty,
  ShipToParty,
  _PartFuncMarkFor.Customer AS MarkFor,
  SalesDocumentType,
  DistributionChannel,
  OrganizationDivision,
  SalesDocument.SalesDistrict AS SalesOrderSalesDistrict,
  _CustomerSalesArea.SalesDistrict AS SalesDistrict,
  SalesDocument.CustomerPaymentTerms AS SlsOrdCustomerPaymentTerms,
  _CustomerSalesArea.CustomerPaymentTerms AS CustomerPaymentTerms,
  SalesDocument.IncotermsClassification AS SlsOrdIncotermsClassification,
  _CustomerSalesArea.IncotermsClassification AS IncotermsClassification,
  SalesDocument.IncotermsLocation1 AS SlsOrdIncotermsLocation1,
  _CustomerSalesArea.IncotermsLocation1 AS IncotermsLocation1,
  SalesDocument.CustomerPriceGroup AS SalesOrderCustomerPriceGroup,
  _CustomerSalesArea.CustomerPriceGroup AS CustomerPriceGroup,
  SalesDocument.CustomerGroup AS SalesOrderCustomerGroup,
  _CustomerSalesArea.CustomerGroup AS CustomerGroup,
  SalesDocument.AdditionalCustomerGroup1 AS SlsOrdAddlCustomerGroup1,
  _CustomerSalesArea.AdditionalCustomerGroup1 AS AdditionalCustomerGroup1,
  SalesDocument.AdditionalCustomerGroup2 AS SlsOrdAddlCustomerGroup2,
  _CustomerSalesArea.AdditionalCustomerGroup2 AS AdditionalCustomerGroup2,
  SalesDocument.AdditionalCustomerGroup3 AS SlsOrdAddlCustomerGroup3,
  _CustomerSalesArea.AdditionalCustomerGroup3 AS AdditionalCustomerGroup3,
  SalesDocument.AdditionalCustomerGroup4 AS SlsOrdAddlCustomerGroup4,
  _CustomerSalesArea.AdditionalCustomerGroup4 AS AdditionalCustomerGroup4,
  SalesDocument.AdditionalCustomerGroup5 AS SlsOrdAddlCustomerGroup5,
  _CustomerSalesArea.AdditionalCustomerGroup5 AS AdditionalCustomerGroup5,
  SalesDocument.RetailAdditionalCustomerGrp6 AS SlsOrdRetailAddlCustomerGrp6,
  _CustomerSalesArea.RetailAdditionalCustomerGrp6 AS RetailAdditionalCustomerGrp6,
  SalesDocument.RetailAdditionalCustomerGrp7 AS SlsOrdRetailAddlCustomerGrp7,
  _CustomerSalesArea.RetailAdditionalCustomerGrp7 AS RetailAdditionalCustomerGrp7,
  SalesDocument.RetailAdditionalCustomerGrp8 AS SlsOrdRetailAddlCustomerGrp8,
  _CustomerSalesArea.RetailAdditionalCustomerGrp8 AS RetailAdditionalCustomerGrp8,
  SalesDocument.RetailAdditionalCustomerGrp9 AS SlsOrdRetailAddlCustomerGrp9,
  _CustomerSalesArea.RetailAdditionalCustomerGrp9 AS RetailAdditionalCustomerGrp9,
  SalesDocument.RetailAdditionalCustomerGrp10 AS SlsOrdRetailAddlCustomerGrp10,
  _CustomerSalesArea.RetailAdditionalCustomerGrp10 AS RetailAdditionalCustomerGrp10,
  SalesDocument.ShippingCondition AS SlsOrdShippingCondition,
  _CustomerSalesArea.ShippingCondition AS ShippingCondition,
  SalesDocument.SalesOffice AS SlsOrdSalesOffice,
  _CustomerSalesArea.SalesOffice AS SalesOffice
FROM I_RFM_SalesDocument AS SalesDocument
LEFT OUTER JOIN I_SalesDocument AS _SalesDocument ON SalesDocument.SalesDocument = _SalesDocument.SalesDocument  -- association [1..1]
LEFT OUTER JOIN I_RFM_CustomerSalesArea AS _CustomerSalesArea ON SalesDocument.SoldToParty = _CustomerSalesArea.Customer AND SalesDocument.SalesOrganization = _CustomerSalesArea.SalesOrganization AND SalesDocument.DistributionChannel = _CustomerSalesArea.DistributionChannel AND SalesDocument.OrganizationDivision = _CustomerSalesArea.Division  -- association [0..1]
LEFT OUTER JOIN I_RFM_CustomerSalesArea AS _CustSlsAreaShipToPty ON SalesDocument.ShipToParty = _CustSlsAreaShipToPty.Customer AND SalesDocument.SalesOrganization = _CustSlsAreaShipToPty.SalesOrganization AND SalesDocument.DistributionChannel = _CustSlsAreaShipToPty.DistributionChannel AND SalesDocument.OrganizationDivision = _CustSlsAreaShipToPty.Division  -- association [0..1]
LEFT OUTER JOIN I_RFM_CustomerSalesArea AS _CustSlsAreaMarkFor ON MarkFor = _CustSlsAreaMarkFor.Customer AND SalesDocument.SalesOrganization = _CustSlsAreaMarkFor.SalesOrganization AND SalesDocument.DistributionChannel = _CustSlsAreaMarkFor.DistributionChannel AND SalesDocument.OrganizationDivision = _CustSlsAreaMarkFor.Division  -- association [0..1]
;