I_RFM_SalesDocumentItem

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_SalesDocumentItem.
-- 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_SalesDocumentItem AS
SELECT
  vbap.vbeln AS SalesDocument,
  vbap.posnr AS SalesDocumentItem,
  vbap.handle AS SalesDocumentItemUUID,
  vbak.vkorg AS SalesOrganization,
  vbak.vtweg AS DistributionChannel,
  vbak.spart AS OrganizationDivision,
  vbak.kunnr AS SoldToParty,
  vbak.ernam AS CreatedByUser,
  vbak.vbtyp AS SDDocumentCategory,
  vbak.gbstk AS OverallSDProcessStatus,
  vbak.lfgsk AS OverallTotalDeliveryStatus,
  vbak.spstg AS TotalBlockStatus,
  vbak.auart AS SalesDocumentType,
  vbak.vkgrp AS SalesGroup,
  vbak.vkbur AS SalesOffice,
  vbak.vsbed AS ShippingCondition,
  vbak.erdat AS CreationDate,
  vbak.augru AS SDDocumentReason,
  vbak.bstdk AS CustomerPurchaseOrderDate,
  vbap.bstkd_ana AS PurchaseOrderByCustomer,
  vbak.audat AS SalesDocumentDate,
  vbak.faksk AS HeaderBillingBlockReason,
  vbap.fksaa AS OrderRelatedBillingStatus,
  vbak.uvall AS HdrGeneralIncompletionStatus,
  vbak.uvals AS OvrlItmGeneralIncompletionSts,
  vbak.cmgst AS TotalCreditCheckStatus,
  vbak.lifsk AS DeliveryBlockReason,
  vbak.uvfak AS HeaderBillgIncompletionStatus,
  vbak.uvfas AS OvrlItmBillingIncompletionSts,
  vbak.uvprs AS OverallPricingIncompletionSts,
  vbak.uvvlk AS HeaderDelivIncompletionStatus,
  vbak.uvvls AS OvrlItmDelivIncompletionSts,
  cast(vbak.vdatu as reqd_delivery_date preserving type) AS RequestedDeliveryDate,
  vbak.guebg AS AgrmtValdtyStartDate,
  vbak.gueen AS AgrmtValdtyEndDate,
  vbkd.bsark AS CustomerPurchaseOrderType,
  vbap.kunwe_ana AS ShipToParty,
  vbap.lfsta AS DeliveryStatus,
  vbap.fsh_item AS ValAddedSrvcItemNumber,
  vbap.fsh_vas_rel AS ItemHasValueAddedService,
  vbap.matnr AS Material,
  vbap.charg AS Batch,
  vbap.sobkz AS InventorySpecialStockType,
  vbap.shkzg AS IsReturnsItem,
  vbap.arktx AS SalesDocumentItemText,
  vbap.kwmeng AS OrderQuantity,
  vbap.vrkme AS OrderQuantityUnit,
  vbap.kbmeng AS ConfdDelivQtyInOrderQtyUnit,
  vbap.umvkn AS OrderToBaseQuantityDnmntr,
  vbap.umvkz AS OrderToBaseQuantityNmrtr,
  vbap.meins AS BaseUnit,
  vbap.pstyv AS SalesDocumentItemCategory,
  vbkd.bzirk AS SalesDistrict,
  vbkd.kdgrp AS CustomerGroup,
  vbap.abgru AS SalesDocumentRjcnReason,
  vbap.sgt_rcat AS RequirementSegment
FROM vbap
LEFT OUTER JOIN I_SDDocumentCompletePartners AS _PartFuncShipToHdr ON SalesDocument = _PartFuncShipToHdr.SDDocument AND _PartFuncShipToHdr.SDDocumentItem = '000000' AND _PartFuncShipToHdr.PartnerFunction = 'WE'  -- association [0..1]
LEFT OUTER JOIN I_SDDocumentCompletePartners AS _PartFuncMarkFor ON SalesDocument = _PartFuncMarkFor.SDDocument AND SalesDocumentItem = _PartFuncMarkFor.SDDocumentItem AND _PartFuncMarkFor.PartnerFunction = 'MF'  -- association [0..1]
LEFT OUTER JOIN I_SDDocumentCompletePartners AS _PartFuncHdrMarkFor ON SalesDocument = _PartFuncHdrMarkFor.SDDocument AND _PartFuncHdrMarkFor.SDDocumentItem = '000000' AND _PartFuncHdrMarkFor.PartnerFunction = 'MF'  -- association [0..1]
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON Material = _MaterialText.Material  -- association [0..*]
LEFT OUTER JOIN I_ShippingPointText AS _ShippingPointText ON ShippingPoint = _ShippingPointText.ShippingPoint  -- association [0..*]
LEFT OUTER JOIN I_RFM_SalesDocument AS _SalesDocument ON SalesDocument = _SalesDocument.SalesDocument  -- association [1..1]
LEFT OUTER JOIN I_Product AS _Product ON Material = _Product.Product  -- association [0..1]
LEFT OUTER JOIN I_Batch AS _Batch ON Plant = _Batch.Plant AND Material = _Batch.Material AND Batch = _Batch.Batch  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _OrderQuantityUnit ON OrderQuantityUnit = _OrderQuantityUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BaseUnit ON BaseUnit = _BaseUnit.UnitOfMeasure  -- 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_SalesDocumentRjcnReason AS _SalesDocumentRjcnReason ON SalesDocumentRjcnReason = _SalesDocumentRjcnReason.SalesDocumentRjcnReason  -- association [0..1]
LEFT OUTER JOIN I_ShippingPoint AS _ShippingPoint ON ShippingPoint = _ShippingPoint.ShippingPoint  -- association [0..1]
LEFT OUTER JOIN I_DeliveryPriority AS _DeliveryPriority ON DeliveryPriority = _DeliveryPriority.DeliveryPriority  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_StorageLocation AS _StorageLocation ON Plant = _StorageLocation.Plant AND StorageLocation = _StorageLocation.StorageLocation  -- association [0..1]
LEFT OUTER JOIN I_CustomerPaymentTerms AS _CustomerPaymentTerms ON CustomerPaymentTerms = _CustomerPaymentTerms.CustomerPaymentTerms  -- association [0..1]
LEFT OUTER JOIN I_IncotermsVersion AS _IncotermsVersion ON IncotermsVersion = _IncotermsVersion.IncotermsVersion  -- association [0..1]
LEFT OUTER JOIN I_IncotermsClassification AS _IncotermsClassification ON IncotermsClassification = _IncotermsClassification.IncotermsClassification  -- association [0..1]
LEFT OUTER JOIN I_SDProcessStatus AS _SDProcessStatus ON SDProcessStatus = _SDProcessStatus.SDProcessStatus  -- association [0..1]
LEFT OUTER JOIN I_ItemGenIncompletionStatus AS _ItemGeneralIncompletionStatus ON ItemGeneralIncompletionStatus = _ItemGeneralIncompletionStatus.ItemGeneralIncompletionStatus  -- association [0..1]
LEFT OUTER JOIN I_ItemBillingIncompletionSts AS _ItemBillingIncompletionStatus ON ItemBillingIncompletionStatus = _ItemBillingIncompletionStatus.ItemBillingIncompletionStatus  -- association [0..1]
LEFT OUTER JOIN I_PricingIncompletionStatus AS _PricingIncompletionStatus ON PricingIncompletionStatus = _PricingIncompletionStatus.PricingIncompletionStatus  -- association [0..1]
LEFT OUTER JOIN I_ItemDelivIncompletionSts AS _ItemDelivIncompletionSts ON ItemDeliveryIncompletionStatus = _ItemDelivIncompletionSts.ItemDeliveryIncompletionStatus  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _TransactionCurrency ON TransactionCurrency = _TransactionCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_CustomerPriceGroup AS _CustomerPriceGroup ON CustomerPriceGroup = _CustomerPriceGroup.CustomerPriceGroup  -- association [0..1]
LEFT OUTER JOIN I_ProductGroup_2 AS _ProductGroup ON ProductGroup = _ProductGroup.ProductGroup  -- association [0..1]
LEFT OUTER JOIN I_AdditionalMaterialGroup1 AS _AdditionalMaterialGroup1 ON AdditionalMaterialGroup1 = _AdditionalMaterialGroup1.AdditionalMaterialGroup1  -- association [0..1]
LEFT OUTER JOIN I_AdditionalMaterialGroup2 AS _AdditionalMaterialGroup2 ON AdditionalMaterialGroup2 = _AdditionalMaterialGroup2.AdditionalMaterialGroup2  -- association [0..1]
LEFT OUTER JOIN I_AdditionalMaterialGroup3 AS _AdditionalMaterialGroup3 ON AdditionalMaterialGroup3 = _AdditionalMaterialGroup3.AdditionalMaterialGroup3  -- association [0..1]
LEFT OUTER JOIN I_AdditionalMaterialGroup4 AS _AdditionalMaterialGroup4 ON AdditionalMaterialGroup4 = _AdditionalMaterialGroup4.AdditionalMaterialGroup4  -- association [0..1]
LEFT OUTER JOIN I_AdditionalMaterialGroup5 AS _AdditionalMaterialGroup5 ON AdditionalMaterialGroup5 = _AdditionalMaterialGroup5.AdditionalMaterialGroup5  -- association [0..1]
LEFT OUTER JOIN I_ShippingType AS _ShippingType ON ShippingType = _ShippingType.ShippingType  -- association [0..1]
LEFT OUTER JOIN I_SalesDocumentItemCategory AS _ItemCategory ON SalesDocumentItemCategory = _ItemCategory.SalesDocumentItemCategory  -- association [0..1]
LEFT OUTER JOIN I_ContactPersonStdDepartment AS _ContactPersonStdDepartment ON DepartmentClassificationByCust = _ContactPersonStdDepartment.ContactPersonStdDepartment  -- association [0..1]
LEFT OUTER JOIN I_CustomerPurchaseOrderType AS _CustomerPurchaseOrderType ON CustomerPurchaseOrderType = _CustomerPurchaseOrderType.CustomerPurchaseOrderType  -- 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_RetailAddlCustGrp6 AS _RetailAddlCustGrp6 ON RetailAdditionalCustomerGrp6 = _RetailAddlCustGrp6.RetailAdditionalCustomerGrp6 AND SalesOrganization = _RetailAddlCustGrp6.SalesOrganization  -- association [0..1]
LEFT OUTER JOIN I_RetailAddlCustGrp7 AS _RetailAddlCustGrp7 ON RetailAdditionalCustomerGrp7 = _RetailAddlCustGrp7.RetailAdditionalCustomerGrp7 AND SalesOrganization = _RetailAddlCustGrp7.SalesOrganization  -- association [0..1]
LEFT OUTER JOIN I_RetailAddlCustGrp8 AS _RetailAddlCustGrp8 ON RetailAdditionalCustomerGrp8 = _RetailAddlCustGrp8.RetailAdditionalCustomerGrp8 AND SalesOrganization = _RetailAddlCustGrp8.SalesOrganization  -- association [0..1]
LEFT OUTER JOIN I_RetailAddlCustGrp9 AS _RetailAddlCustGrp9 ON RetailAdditionalCustomerGrp9 = _RetailAddlCustGrp9.RetailAdditionalCustomerGrp9 AND SalesOrganization = _RetailAddlCustGrp9.SalesOrganization  -- association [0..1]
LEFT OUTER JOIN I_RetailAddlCustGrp10 AS _RetailAddlCustGrp10 ON RetailAdditionalCustomerGrp10 = _RetailAddlCustGrp10.RetailAdditionalCustomerGrp10 AND SalesOrganization = _RetailAddlCustGrp10.SalesOrganization  -- association [0..1]
LEFT OUTER JOIN I_SalesOrganization AS _SalesOrganization ON SalesOrganization = _SalesOrganization.SalesOrganization  -- 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_OrderRelatedBillingStatus AS _OrderRelatedBillingStatus ON OrderRelatedBillingStatus = _OrderRelatedBillingStatus.OrderRelatedBillingStatus  -- association [0..1]
LEFT OUTER JOIN I_Route AS _Route ON Route = _Route.Route  -- association [0..1]
LEFT OUTER JOIN I_MaterialPricingGroup AS _MaterialPricingGroup ON MaterialPricingGroup = _MaterialPricingGroup.MaterialPricingGroup  -- association [0..1]
LEFT OUTER JOIN I_DeliveryBlockReason AS _DeliveryBlockReason ON DeliveryBlockReason = _DeliveryBlockReason.DeliveryBlockReason  -- 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_ShippingCondition AS _ShippingCondition ON ShippingCondition = _ShippingCondition.ShippingCondition  -- association [0..1]
LEFT OUTER JOIN I_BillingBlockReason AS _HeaderBillingBlockReason ON HeaderBillingBlockReason = _HeaderBillingBlockReason.BillingBlockReason  -- association [0..1]
LEFT OUTER JOIN I_SDDocumentReason AS _SDDocumentReason ON SDDocumentReason = _SDDocumentReason.SDDocumentReason  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _TransitPlant ON TransitPlant = _TransitPlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_SalesValueChainCategory AS _SalesValueChainCategory ON ValueChainCategory = _SalesValueChainCategory.ValueChainCategory  -- association [0..1]
;