C_RFM_MaSaDoSlsHdrDeviationChk

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_MaSaDoSlsHdrDeviationChk.
-- 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_MaSaDoSlsHdrDeviationChk AS
SELECT
  SalesDocument,
  SalesOrganization,
  DistributionChannel,
  OrganizationDivision,
  ShipToParty,
  MarkFor,
  SoldToParty,
  SalesDocumentType,
  SalesOrderSalesDistrict,
  SalesDistrict,
  case when CustomerPaymentTerms <> SlsOrdCustomerPaymentTerms then 'X' else '' end AS SlsOrdCustPaytTermsHasDeviated,
  CustomerPaymentTerms,
  SlsOrdCustomerPaymentTerms,
  case when IncotermsClassification <> SlsOrdIncotermsClassification then 'X' else '' end AS SlsIncotermsClassfctnHasDvtn,
  SlsOrdIncotermsClassification,
  IncotermsClassification,
  case when IncotermsLocation1 <> SlsOrdIncotermsLocation1 then 'X' else '' end AS SlsOrdIncotermsLoc1HasDeviated,
  SlsOrdIncotermsLocation1,
  IncotermsLocation1,
  case when CustomerPriceGroup <> SalesOrderCustomerPriceGroup then 'X' else '' end AS SlsOrdCustPriceGrpHasDeviated,
  SalesOrderCustomerPriceGroup,
  CustomerPriceGroup,
  case when ShippingCondition <> SlsOrdShippingCondition then 'X' else '' end AS SlsOrdShippingCndnHasDeviated,
  SlsOrdShippingCondition,
  ShippingCondition,
  case when SalesOffice <> SlsOrdSalesOffice then 'X' else '' end AS SlsOrdSlsOfficeHasDeviated,
  SlsOrdSalesOffice,
  SalesOffice,
  SlsOrdAddlCustomerGroup1,
  AdditionalCustomerGroup1,
  SlsOrdAddlCustomerGroup2,
  AdditionalCustomerGroup2,
  SlsOrdAddlCustomerGroup3,
  AdditionalCustomerGroup3,
  SlsOrdAddlCustomerGroup4,
  AdditionalCustomerGroup4,
  SlsOrdAddlCustomerGroup5,
  AdditionalCustomerGroup5,
  SlsOrdRetailAddlCustomerGrp6,
  RetailAdditionalCustomerGrp6,
  SlsOrdRetailAddlCustomerGrp7,
  RetailAdditionalCustomerGrp7,
  SlsOrdRetailAddlCustomerGrp8,
  RetailAdditionalCustomerGrp8,
  SlsOrdRetailAddlCustomerGrp9,
  RetailAdditionalCustomerGrp9,
  SlsOrdRetailAddlCustomerGrp10,
  RetailAdditionalCustomerGrp10,
  SalesOrderCustomerGroup,
  CustomerGroup
FROM C_RFM_MaSaDoSlsHdrCustBasic
;