C_RFM_MaSaDoSlsItmDeviationChk

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_MaSaDoSlsItmDeviationChk.
-- 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_MaSaDoSlsItmDeviationChk AS
SELECT
  SalesDocument,
  SalesDocumentItem,
  FormattedSalesDocumentItem,
  SalesDocumentType,
  SalesOrganization,
  DistributionChannel,
  OrganizationDivision,
  ShipToParty,
  MarkFor,
  SoldToParty,
  case when CustomerPaymentTerms <> SlsOrdCustomerPaymentTerms then 'X' else '' end AS SlsOrdCustPaytTermsHasDeviated,
  CustomerPaymentTerms,
  SlsOrdCustomerPaymentTerms,
  case when IncotermsClassification <> SlsOrdIncotermsClassification then 'X' else '' end AS SlsIncotermsClassfctnHasDvtn,
  IncotermsClassification,
  SlsOrdIncotermsClassification,
  case when IncotermsLocation1 <> SlsOrdIncotermsLocation1 then 'X' else '' end AS SlsOrdIncotermsLoc1HasDeviated,
  IncotermsLocation1,
  SlsOrdIncotermsLocation1,
  case when CustomerPriceGroup <> SalesOrderCustomerPriceGroup then 'X' else '' end AS SlsOrdCustPriceGrpHasDeviated,
  CustomerPriceGroup,
  SalesOrderCustomerPriceGroup,
  SalesOrderDeliveryPriority
FROM C_RFM_MaSaDoSlsItmCustBasic
;