I_RFM_SalesDocument

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_RFM_SalesDocument.
-- 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_RFM_SalesDocument AS
SELECT
  vbak.vbeln AS SalesDocument,
  vbak.vbtyp AS SDDocumentCategory,
  vbak.auart AS SalesDocumentType,
  vbak.kunnr AS SoldToParty,
  vbpa.kunnr AS ShipToParty,
  vbak.vkorg AS SalesOrganization,
  vbak.vtweg AS DistributionChannel,
  vbak.spart AS OrganizationDivision,
  vbak.vkgrp AS SalesGroup,
  vbak.vkbur AS SalesOffice,
  vbkd.bzirk AS SalesDistrict,
  cast(vbak.vdatu as reqd_delivery_date preserving type) AS RequestedDeliveryDate,
  vbkd.vsart AS ShippingType,
  vbak.vsbed AS ShippingCondition,
  vbkd.inco1 AS IncotermsClassification,
  vbkd.inco2_l AS IncotermsLocation1,
  vbak.ernam AS CreatedByUser,
  vbak.erdat AS CreationDate,
  vbak.fsh_candate AS FashionCancelDate,
  vbkd.kdgrp AS CustomerGroup,
  vbak.kvgr1 AS AdditionalCustomerGroup1,
  vbak.kvgr2 AS AdditionalCustomerGroup2,
  vbak.kvgr3 AS AdditionalCustomerGroup3,
  vbak.kvgr4 AS AdditionalCustomerGroup4,
  vbak.kvgr5 AS AdditionalCustomerGroup5,
  fsh_kvgr6 AS RetailAdditionalCustomerGrp6,
  fsh_kvgr7 AS RetailAdditionalCustomerGrp7,
  fsh_kvgr8 AS RetailAdditionalCustomerGrp8,
  fsh_kvgr9 AS RetailAdditionalCustomerGrp9,
  fsh_kvgr10 AS RetailAdditionalCustomerGrp10,
  vbkd.kdkg1 AS CustomerConditionGroup1,
  vbkd.kdkg2 AS CustomerConditionGroup2,
  vbkd.kdkg3 AS CustomerConditionGroup3,
  vbkd.kdkg4 AS CustomerConditionGroup4,
  vbkd.kdkg5 AS CustomerConditionGroup5,
  vbkd.abtnr AS DepartmentClassificationByCust,
  vbak.audat AS SalesDocumentDate,
  vbak.kkber AS CreditControlArea,
  vbak.lifsk AS DeliveryBlockReason,
  vbak.faksk AS HeaderBillingBlockReason,
  vbak.fksak AS OverallOrdReltdBillgStatus,
  vbkd.fkdat AS BillingDocumentDate,
  vbak.netwr AS TotalNetAmount,
  vbak.waerk AS TransactionCurrency,
  vbkd.prsdt AS PricingDate,
  vbkd.konda AS CustomerPriceGroup,
  vbak.augru AS SDDocumentReason,
  vbak.bsark AS CustomerPurchaseOrderType,
  vbak.bstdk AS CustomerPurchaseOrderDate,
  vbkd.bstkd AS PurchaseOrderByCustomer,
  vbkd.zterm AS CustomerPaymentTerms,
  vbak.gbstk AS OverallSDProcessStatus,
  vbak.uvall AS HdrGeneralIncompletionStatus,
  vbak.uvals AS OvrlItmGeneralIncompletionSts,
  vbak.abstk AS OverallSDDocumentRejectionSts,
  vbak.lfgsk AS OverallTotalDeliveryStatus,
  vbak.cmgst AS TotalCreditCheckStatus,
  vbak.spstg AS TotalBlockStatus,
  vbak.uvfak AS HeaderBillgIncompletionStatus,
  vbak.uvfas AS OvrlItmBillingIncompletionSts,
  vbak.uvprs AS OverallPricingIncompletionSts,
  vbak.uvvlk AS HeaderDelivIncompletionStatus,
  vbak.uvvls AS OvrlItmDelivIncompletionSts,
  vbak.guebg AS AgrmtValdtyStartDate,
  vbak.gueen AS AgrmtValdtyEndDate
FROM vbak
LEFT OUTER JOIN I_SDDocumentCompletePartners AS _PartFuncMarkFor ON SalesDocument = _PartFuncMarkFor.SDDocument AND _PartFuncMarkFor.SDDocumentItem = '000000' AND _PartFuncMarkFor.PartnerFunction = 'MF'  -- association [0..1]
LEFT OUTER JOIN I_RFM_SalesDocumentItem AS _ItemBasic ON SalesDocument = _ItemBasic.SalesDocument  -- association [0..*]
LEFT OUTER JOIN I_SDDocumentCategory AS _SDDocumentCategory ON SDDocumentCategory = _SDDocumentCategory.SDDocumentCategory  -- association [0..1]
LEFT OUTER JOIN I_SalesDocumentType AS _SalesDocumentType ON SalesDocumentType = _SalesDocumentType.SalesDocumentType  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_SalesOrganization AS _SalesOrganization ON SalesOrganization = _SalesOrganization.SalesOrganization  -- association [0..1]
LEFT OUTER JOIN I_DistributionChannel AS _DistributionChannel ON DistributionChannel = _DistributionChannel.DistributionChannel  -- association [0..1]
LEFT OUTER JOIN I_Division AS _OrganizationDivision ON OrganizationDivision = _OrganizationDivision.Division  -- 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_Customer AS _SoldToParty ON SoldToParty = _SoldToParty.Customer  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _ShipToParty ON ShipToParty = _ShipToParty.Customer  -- association [0..1]
LEFT OUTER JOIN I_AdditionalCustomerGroup1 AS _AdditionalCustomerGroup1 ON AdditionalCustomerGroup1 = _AdditionalCustomerGroup1.AdditionalCustomerGroup1  -- association [0..1]
LEFT OUTER JOIN I_AdditionalCustomerGroup2 AS _AdditionalCustomerGroup2 ON AdditionalCustomerGroup2 = _AdditionalCustomerGroup2.AdditionalCustomerGroup2  -- association [0..1]
LEFT OUTER JOIN I_AdditionalCustomerGroup3 AS _AdditionalCustomerGroup3 ON AdditionalCustomerGroup3 = _AdditionalCustomerGroup3.AdditionalCustomerGroup3  -- association [0..1]
LEFT OUTER JOIN I_AdditionalCustomerGroup4 AS _AdditionalCustomerGroup4 ON AdditionalCustomerGroup4 = _AdditionalCustomerGroup4.AdditionalCustomerGroup4  -- association [0..1]
LEFT OUTER JOIN I_AdditionalCustomerGroup5 AS _AdditionalCustomerGroup5 ON AdditionalCustomerGroup5 = _AdditionalCustomerGroup5.AdditionalCustomerGroup5  -- association [0..1]
LEFT OUTER JOIN I_SDDocumentReason AS _SDDocumentReason ON SDDocumentReason = _SDDocumentReason.SDDocumentReason  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _TransactionCurrency ON TransactionCurrency = _TransactionCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_ShippingCondition AS _ShippingCondition ON ShippingCondition = _ShippingCondition.ShippingCondition  -- 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_EngagementProjectItem AS _EngagementProjectItem ON SalesDocument = _EngagementProjectItem.EngagementProjectItem AND _EngagementProjectItem.EngagementProjectItemType = '0SOH'  -- association [0..*]
LEFT OUTER JOIN I_SalesArea AS _SalesArea ON SalesOrganization = _SalesArea.SalesOrganization AND DistributionChannel = _SalesArea.DistributionChannel AND OrganizationDivision = _SalesArea.Division  -- association [0..1]
LEFT OUTER JOIN I_OverallSDDocumentRjcnStatus AS _OverallSDDocumentRejectionSts ON OverallSDDocumentRejectionSts = _OverallSDDocumentRejectionSts.OverallSDDocumentRejectionSts  -- association [0..1]
LEFT OUTER JOIN I_TotalBlockStatus AS _TotalBlockStatus ON TotalBlockStatus = _TotalBlockStatus.TotalBlockStatus  -- association [0..1]
LEFT OUTER JOIN I_OverallTotalDeliveryStatus AS _OverallTotalDeliveryStatus ON OverallTotalDeliveryStatus = _OverallTotalDeliveryStatus.OverallTotalDeliveryStatus  -- association [0..1]
LEFT OUTER JOIN I_TotalCreditCheckStatus AS _TotalCreditCheckStatus ON TotalCreditCheckStatus = _TotalCreditCheckStatus.TotalCreditCheckStatus  -- association [0..1]
LEFT OUTER JOIN I_OverallSDProcessStatus AS _OverallSDProcessStatus ON OverallSDProcessStatus = _OverallSDProcessStatus.OverallSDProcessStatus  -- association [0..1]
LEFT OUTER JOIN I_HdrGenIncompletionStatus AS _HdrGeneralIncompletionStatus ON HdrGeneralIncompletionStatus = _HdrGeneralIncompletionStatus.HdrGeneralIncompletionStatus  -- association [0..1]
LEFT OUTER JOIN I_OvrlItmGenIncompletionSts AS _OvrlItmGeneralIncompletionSts ON OvrlItmGeneralIncompletionSts = _OvrlItmGeneralIncompletionSts.OvrlItmGeneralIncompletionSts  -- association [0..1]
LEFT OUTER JOIN I_SalesDistrict AS _SalesDistrict ON SalesDistrict = _SalesDistrict.SalesDistrict  -- association [0..1]
LEFT OUTER JOIN I_CustomerGroup AS _CustomerGroup ON CustomerGroup = _CustomerGroup.CustomerGroup  -- association [0..1]
LEFT OUTER JOIN I_CustomerPaymentTerms AS _CustomerPaymentTerms ON CustomerPaymentTerms = _CustomerPaymentTerms.CustomerPaymentTerms  -- association [0..1]
LEFT OUTER JOIN I_IncotermsClassification AS _IncotermsClassification ON IncotermsClassification = _IncotermsClassification.IncotermsClassification  -- association [0..1]
LEFT OUTER JOIN I_CreditControlAreaText AS _CreditControlAreaText ON CreditControlArea = _CreditControlAreaText.CreditControlArea  -- association [0..*]
LEFT OUTER JOIN I_CreditControlArea AS _CreditControlArea ON CreditControlArea = _CreditControlArea.CreditControlArea  -- association [0..1]
LEFT OUTER JOIN I_ShippingType AS _ShippingType ON ShippingType = _ShippingType.ShippingType  -- association [0..1]
LEFT OUTER JOIN I_CustomerPurchaseOrderType AS _CustomerPurchaseOrderType ON CustomerPurchaseOrderType = _CustomerPurchaseOrderType.CustomerPurchaseOrderType  -- association [0..1]
LEFT OUTER JOIN I_HdrBillgIncompletionStatus AS _HeaderBillgIncompletionStatus ON HeaderBillgIncompletionStatus = _HeaderBillgIncompletionStatus.HeaderBillgIncompletionStatus  -- association [0..1]
LEFT OUTER JOIN I_OvrlItmBillgIncompltnSts AS _OvrlItmBillingIncompletionSts ON OvrlItmBillingIncompletionSts = _OvrlItmBillingIncompletionSts.OvrlItmBillingIncompletionSts  -- association [0..1]
LEFT OUTER JOIN I_OvrlItmDelivIncompletionSts AS _OvrlItmDelivIncompletionSts ON OvrlItmDelivIncompletionSts = _OvrlItmDelivIncompletionSts.OvrlItmDelivIncompletionSts  -- association [0..1]
LEFT OUTER JOIN I_OverallPrcIncompletionSts AS _OverallPricingIncompletionSts ON OverallPricingIncompletionSts = _OverallPricingIncompletionSts.OverallPricingIncompletionSts  -- association [0..1]
LEFT OUTER JOIN I_HdrDelivIncompletionStatus AS _HeaderDelivIncompletionStatus ON HeaderDelivIncompletionStatus = _HeaderDelivIncompletionStatus.HeaderDelivIncompletionStatus  -- association [0..1]
LEFT OUTER JOIN I_CustomerPriceGroup AS _CustomerPriceGroup ON CustomerPriceGroup = _CustomerPriceGroup.CustomerPriceGroup  -- association [0..1]
LEFT OUTER JOIN I_ContactPersonStdDepartment AS _ContactPersonStdDepartment ON DepartmentClassificationByCust = _ContactPersonStdDepartment.ContactPersonStdDepartment association[0..1] to I_RetailAddlCustGrp6 as _RetailAddlCustGrp6 on RetailAdditionalCustomerGrp6 = _RetailAddlCustGrp6.RetailAdditionalCustomerGrp6 AND SalesOrganization = _RetailAddlCustGrp6.SalesOrganization association[0..1] to I_RetailAddlCustGrp7 as _RetailAddlCustGrp7 on RetailAdditionalCustomerGrp7 = _RetailAddlCustGrp7.RetailAdditionalCustomerGrp7 AND SalesOrganization = _RetailAddlCustGrp7.SalesOrganization association[0..1] to I_RetailAddlCustGrp8 as _RetailAddlCustGrp8 on RetailAdditionalCustomerGrp8 = _RetailAddlCustGrp8.RetailAdditionalCustomerGrp8 AND SalesOrganization = _RetailAddlCustGrp8.SalesOrganization association[0..1] to I_RetailAddlCustGrp9 as _RetailAddlCustGrp9 on RetailAdditionalCustomerGrp9 = _RetailAddlCustGrp9.RetailAdditionalCustomerGrp9 AND SalesOrganization = _RetailAddlCustGrp9.SalesOrganization association[0..1] to I_RetailAddlCustGrp10 as _RetailAddlCustGrp10 on RetailAdditionalCustomerGrp10 = _RetailAddlCustGrp10.RetailAdditionalCustomerGrp10 AND SalesOrganization = _RetailAddlCustGrp10.SalesOrganization  -- association [0..1]
LEFT OUTER JOIN I_OverallOrdReltdBillgStatus AS _OverallOrdReltdBillgStatus ON OverallOrdReltdBillgStatus = _OverallOrdReltdBillgStatus.OverallOrdReltdBillgStatus  -- association [0..1]
;