I_SDMassChgCkptSlsDocHdrChgBsc

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_SDMassChgCkptSlsDocHdrChgBsc.
-- 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 I_SDMassChgCkptSlsDocHdrChgBsc AS
SELECT
  sdmcc_chghdr.slsdocmasschangerequestuuid AS SlsDocMassChangeRequestUUID,
  sdmcc_chghdr.slsdocmasschgactioncategory AS SlsDocMassChgActionCategory,
  sdmcc_chghdr.slsdocmasschgactionid AS SlsDocMassChgActionID,
  sdmcc_chghdr.sddocumentreason AS SDDocumentReason,
  sdmcc_chghdr.salesoffice AS SalesOffice,
  sdmcc_chghdr.salesgroup AS SalesGroup,
  sdmcc_chghdr.salesdistrict AS SalesDistrict,
  sdmcc_chghdr.requesteddeliverydate AS RequestedDeliveryDate,
  sdmcc_chghdr.shippingcondition AS ShippingCondition,
  sdmcc_chghdr.shippingtype AS ShippingType,
  sdmcc_chghdr.receivingpoint AS ReceivingPoint,
  sdmcc_chghdr.customerpaymentterms AS CustomerPaymentTerms,
  sdmcc_chghdr.paymentmethod AS PaymentMethod,
  sdmcc_chghdr.transactioncurrency AS TransactionCurrency,
  sdmcc_chghdr.pricingdate AS PricingDate,
  sdmcc_chghdr.billingdocumentdate AS BillingDocumentDate,
  sdmcc_chghdr.salesdocumentdate AS SalesDocumentDate,
  sdmcc_chghdr.incotermsclassification AS IncotermsClassification,
  sdmcc_chghdr.incotermstransferlocation AS IncotermsTransferLocation,
  sdmcc_chghdr.incotermslocation1 AS IncotermsLocation1,
  sdmcc_chghdr.incotermslocation2 AS IncotermsLocation2,
  sdmcc_chghdr.incotermsversion AS IncotermsVersion,
  sdmcc_chghdr.deliveryblockreason AS DeliveryBlockReason,
  sdmcc_chghdr.headerbillingblockreason AS HeaderBillingBlockReason,
  sdmcc_chghdr.salesdocumentrjcnreason AS SalesDocumentRjcnReason,
  sdmcc_chghdr.purchaseorderbycustomer AS PurchaseOrderByCustomer,
  sdmcc_chghdr.customerpurchaseorderdate AS CustomerPurchaseOrderDate,
  sdmcc_chghdr.completedeliveryisdefined AS CompleteDeliveryIsDefined,
  sdmcc_chghdr.pricingtype AS PricingType
FROM sdmcc_chghdr
LEFT OUTER JOIN I_SDMassChgCkptMassChgReqBsc AS _ChangeRequest ON SlsDocMassChangeRequestUUID = _ChangeRequest.SlsDocMassChangeRequestUUID  -- association [1..1]
LEFT OUTER JOIN I_SDMassChgCkptActionCategory AS _ChangeActionCategory ON SlsDocMassChgActionCategory = _ChangeActionCategory.SlsDocMassChgActionCategory  -- association [0..1]
LEFT OUTER JOIN I_SDMassChgCkptActionMaster AS _ChangeActionID ON SlsDocMassChgActionID = _ChangeActionID.SlsDocMassChgActionID  -- association [0..1]
LEFT OUTER JOIN I_SalesGroup AS _SalesGroup ON SalesGroup = _SalesGroup.SalesGroup  -- association [0..1]
LEFT OUTER JOIN I_SalesOffice AS _SalesOffice ON SalesOffice = _SalesOffice.SalesOffice  -- association [0..1]
LEFT OUTER JOIN I_SDDocumentReason AS _SDDocumentReason ON SDDocumentReason = _SDDocumentReason.SDDocumentReason  -- association [0..1]
LEFT OUTER JOIN I_SalesDistrict AS _SalesDistrict ON SalesDistrict = _SalesDistrict.SalesDistrict  -- association [0..1]
LEFT OUTER JOIN I_ShippingType AS _ShippingType ON ShippingType = _ShippingType.ShippingType  -- association [0..1]
LEFT OUTER JOIN I_ShippingCondition AS _ShippingCondition ON ShippingCondition = _ShippingCondition.ShippingCondition  -- association [0..1]
LEFT OUTER JOIN I_IncotermsClassification AS _IncotermsClassification ON IncotermsClassification = _IncotermsClassification.IncotermsClassification  -- association [0..1]
LEFT OUTER JOIN I_IncotermsVersion AS _IncotermsVersion ON IncotermsVersion = _IncotermsVersion.IncotermsVersion  -- association [0..1]
LEFT OUTER JOIN I_CustomerPaymentTerms AS _CustomerPaymentTerms ON CustomerPaymentTerms = _CustomerPaymentTerms.CustomerPaymentTerms  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _TransactionCurrency ON TransactionCurrency = _TransactionCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_DeliveryBlockReason AS _DeliveryBlockReason ON DeliveryBlockReason = _DeliveryBlockReason.DeliveryBlockReason  -- association [0..1]
LEFT OUTER JOIN I_BillingBlockReason AS _HeaderBillingBlockReason ON HeaderBillingBlockReason = _HeaderBillingBlockReason.BillingBlockReason  -- association [0..1]
LEFT OUTER JOIN I_SalesDocumentRjcnReason AS _SalesDocumentRjcnReason ON SalesDocumentRjcnReason = _SalesDocumentRjcnReason.SalesDocumentRjcnReason  -- association [0..1]
LEFT OUTER JOIN I_PricingType AS _PricingType ON PricingType = _PricingType.PricingType  -- association [0..1]
;