R_SalesOrderItemTP

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 R_SalesOrderItemTP.
-- 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 R_SalesOrderItemTP AS
SELECT
  SalesOrderItem.SalesOrder AS SalesOrder,
  SalesOrderItem.SalesOrderItem AS SalesOrderItem,
  SalesOrderItem.HigherLevelItem AS HigherLevelItem,
  SalesOrderItem.SalesOrderItemCategory AS SalesOrderItemCategory,
  SalesOrderItem.SalesOrderItemText AS SalesOrderItemText,
  SalesOrderItem.Product AS Product,
  SalesOrderItem.OriginallyRequestedMaterial AS OriginallyRequestedMaterial,
  SalesOrderItem.ProductGroup AS ProductGroup,
  SalesOrderItem.AdditionalMaterialGroup1 AS AdditionalMaterialGroup1,
  SalesOrderItem.AdditionalMaterialGroup2 AS AdditionalMaterialGroup2,
  SalesOrderItem.AdditionalMaterialGroup3 AS AdditionalMaterialGroup3,
  SalesOrderItem.AdditionalMaterialGroup4 AS AdditionalMaterialGroup4,
  SalesOrderItem.AdditionalMaterialGroup5 AS AdditionalMaterialGroup5,
  SalesOrderItem.MaterialByCustomer AS MaterialByCustomer,
  SalesOrderItem.InternationalArticleNumber AS InternationalArticleNumber,
  SalesOrderItem.PurchaseOrderByCustomer AS PurchaseOrderByCustomer,
  SalesOrderItem.UnderlyingPurchaseOrderItem AS UnderlyingPurchaseOrderItem,
  SalesOrderItem.UndrlgPurOrdItmByShipToParty AS UndrlgPurOrdItmByShipToParty,
  SalesOrderItem.PurchaseOrderByShipToParty AS PurchaseOrderByShipToParty,
  SalesOrderItem.CorrespncExternalReference AS CorrespncExternalReference,
  SalesOrderItem.CorrespncExtRefByShipToParty AS CorrespncExtRefByShipToParty,
  _ItemEnhancedFields._RequestedDeliveryDate.RequestedDeliveryDate AS RequestedDeliveryDate,
  _ItemEnhancedFields._ConfirmedDeliveryDate.ConfirmedDeliveryDate AS ConfirmedDeliveryDate,
  SalesOrderItem.ConfdDelivQtyInOrderQtyUnit AS ConfdDelivQtyInOrderQtyUnit,
  SalesOrderItem.OrderQuantityUnit AS OrderQuantityUnit,
  SalesOrderItem.RequestedQuantity AS RequestedQuantity,
  SalesOrderItem.RequestedQuantityUnit AS RequestedQuantityUnit,
  SalesOrderItem.ReferenceSDDocument AS ReferenceSDDocument,
  SalesOrderItem.ReferenceSDDocumentItem AS ReferenceSDDocumentItem,
  SalesOrderItem.ReferenceSDDocumentCategory AS ReferenceSDDocumentCategory,
  SalesOrderItem.ItemGrossWeight AS ItemGrossWeight,
  SalesOrderItem.ItemNetWeight AS ItemNetWeight,
  SalesOrderItem.ItemWeightUnit AS ItemWeightUnit,
  SalesOrderItem.ItemVolume AS ItemVolume,
  SalesOrderItem.ItemVolumeUnit AS ItemVolumeUnit,
  SalesOrderItem.PricingDate AS PricingDate,
  SalesOrderItem.ServicesRenderedDate AS ServicesRenderedDate,
  SalesOrderItem.BillingDocumentDate AS BillingDocumentDate,
  SalesOrderItem.FixedValueDate AS FixedValueDate,
  SalesOrderItem.BillingPlan AS BillingPlan,
  SalesOrderItem.CustomerGroup AS CustomerGroup,
  SalesOrderItem.Batch AS Batch,
  SalesOrderItem.Plant AS Plant,
  SalesOrderItem.TransitPlant AS TransitPlant,
  SalesOrderItem.StorageLocation AS StorageLocation,
  SalesOrderItem.ShippingPoint AS ShippingPoint,
  SalesOrderItem.ShippingType AS ShippingType,
  SalesOrderItem.Route AS Route,
  SalesOrderItem.DeliveryPriority AS DeliveryPriority,
  SalesOrderItem.PartialDeliveryIsAllowed AS PartialDeliveryIsAllowed,
  SalesOrderItem.MaxNmbrOfPartialDelivery AS MaxNmbrOfPartialDelivery,
  SalesOrderItem.DeliveryDateQuantityIsFixed AS DeliveryDateQuantityIsFixed,
  SalesOrderItem.DeliveryDateTypeRule AS DeliveryDateTypeRule,
  SalesOrderItem.ReceivingPoint AS ReceivingPoint,
  SalesOrderItem.DeliveryGroup AS DeliveryGroup,
  SalesOrderItem.ProductConfiguration AS ProductConfiguration,
  SalesOrderItem.IncotermsClassification AS IncotermsClassification,
  SalesOrderItem.IncotermsLocation1 AS IncotermsLocation1,
  SalesOrderItem.IncotermsLocation2 AS IncotermsLocation2,
  SalesOrderItem.OrderCombinationIsAllowed AS OrderCombinationIsAllowed,
  SalesOrderItem.IncotermsVersion AS IncotermsVersion,
  SalesOrderItem.CustomerPaymentTerms AS CustomerPaymentTerms,
  SalesOrderItem.CustomerPriceGroup AS CustomerPriceGroup,
  cast(MaterialPricingGroup as productpricinggroup preserving type) AS MaterialPricingGroup,
  SalesOrderItem.ItemIsBillingRelevant AS ItemIsBillingRelevant,
  SalesOrderItem.ItemBillingBlockReason AS ItemBillingBlockReason,
  SalesOrderItem.SalesDocumentRjcnReason AS SalesDocumentRjcnReason,
  SalesOrderItem.SalesDocItemSupplyBlockReason AS SalesDocItemSupplyBlockReason,
  SalesOrderItem.TransactionCurrency AS TransactionCurrency,
  SalesOrderItem.NetAmount AS NetAmount,
  cast(0 as sd_amount_to_be_billed ) AS EntProjTypeCustProjExpdNetAmt,
  SalesOrderItem.TransactionCurrency AS EnPrjTpCustPrjExpdNetAmtCrcy,
  SalesOrderItem.DownPaymentProcessingVariant AS DownPaymentProcessingVariant,
  SalesOrderItem.TaxAmount AS TaxAmount,
  SalesOrderItem.ProductTaxClassification1 AS ProductTaxClassification1,
  SalesOrderItem.ProductTaxClassification2 AS ProductTaxClassification2,
  SalesOrderItem.ProductTaxClassification3 AS ProductTaxClassification3,
  SalesOrderItem.ProductTaxClassification4 AS ProductTaxClassification4,
  SalesOrderItem.ProductTaxClassification5 AS ProductTaxClassification5,
  SalesOrderItem.ProductTaxClassification6 AS ProductTaxClassification6,
  SalesOrderItem.ProductTaxClassification7 AS ProductTaxClassification7,
  SalesOrderItem.ProductTaxClassification8 AS ProductTaxClassification8,
  SalesOrderItem.ProductTaxClassification9 AS ProductTaxClassification9,
  SalesOrderItem.Subtotal1Amount AS Subtotal1Amount,
  SalesOrderItem.Subtotal2Amount AS Subtotal2Amount,
  SalesOrderItem.Subtotal3Amount AS Subtotal3Amount,
  SalesOrderItem.Subtotal4Amount AS Subtotal4Amount,
  SalesOrderItem.Subtotal5Amount AS Subtotal5Amount,
  SalesOrderItem.Subtotal6Amount AS Subtotal6Amount,
  SalesOrderItem.MRPArea AS MRPArea,
  SalesOrderItem.SDProcessStatus AS SDProcessStatus,
  SalesOrderItem.PurchaseConfirmationStatus AS PurchaseConfirmationStatus,
  SalesOrderItem.SDDocumentRejectionStatus AS SDDocumentRejectionStatus,
  SalesOrderItem.DeliveryStatus AS DeliveryStatus,
  SalesOrderItem.BillingBlockStatus AS BillingBlockStatus,
  SalesOrderItem.ItemGeneralIncompletionStatus AS ItemGeneralIncompletionStatus,
  SalesOrderItem.DeliveryBlockStatus AS DeliveryBlockStatus,
  SalesOrderItem.SlsOrderItemDownPaymentStatus AS SlsOrderItemDownPaymentStatus,
  SalesOrderItem.OrderRelatedBillingStatus AS OrderRelatedBillingStatus,
  SalesOrderItem.ChmlCmplncStatus AS ChmlCmplncStatus,
  SalesOrderItem.DangerousGoodsStatus AS DangerousGoodsStatus,
  SalesOrderItem.SafetyDataSheetStatus AS SafetyDataSheetStatus,
  SalesOrderItem.TrdCmplncEmbargoSts AS TrdCmplncEmbargoSts,
  SalesOrderItem.TrdCmplncSnctndListChkSts AS TrdCmplncSnctndListChkSts,
  SalesOrderItem.OvrlTrdCmplncLegalCtrlChkSts AS OvrlTrdCmplncLegalCtrlChkSts,
  SalesOrderItem.SlsDocItmOvrlSupplyBlockStatus AS SlsDocItmOvrlSupplyBlockStatus,
  SalesOrderItem.BusinessArea AS BusinessArea,
  SalesOrderItem.ProfitCenter AS ProfitCenter,
  SalesOrderItem.ControllingArea AS ControllingArea,
  SalesOrderItem.MatlAccountAssignmentGroup AS MatlAccountAssignmentGroup,
  SalesOrderItem.WBSElementInternalID AS WBSElementInternalID,
  SalesOrderItem._WBSElementBasicData_2.WBSElementExternalID AS WBSElementExternalID,
  SalesOrderItem._SalesOrder.SDPricingProcedure AS SDPricingProcedure,
  _ItemEnhancedFields.ItemCategoryGroup AS ItemCategoryGroup,
  _ItemEnhancedFields.SDDocumentItemUsage AS SDDocumentItemUsage,
  SalesOrderItem._HigherLevelItem.SalesOrderItemCategory AS HigherLevelItemCategory,
  SalesOrderItem.BusinessSolutionOrderItem AS BusinessSolutionOrderItem,
  SalesOrderItem.BusSolnOrdItemBundleItem AS BusSolnOrdItemBundleItem,
  SalesOrderItem.SlsContrAutoAssgmtIDForSlsOrd AS SlsContrAutoAssgmtIDForSlsOrd,
  _SalesOrder.SalesOrderType AS SalesOrderType,
  _SalesOrder.OrganizationDivision AS OrganizationDivision,
  _SalesOrder.SalesOrganization AS SalesOrganization,
  _SalesOrder.DistributionChannel AS DistributionChannel,
  SalesOrderItem._HigherLevelItem AS _HigherLevelItem,
  SalesOrderItem._Product AS _Product,
  SalesOrderItem._OriginallyRequestedMaterial AS _OriginallyRequestedMaterial,
  SalesOrderItem._ProductGroup AS _ProductGroup,
  SalesOrderItem._AdditionalMaterialGroup1 AS _AdditionalMaterialGroup1,
  SalesOrderItem._AdditionalMaterialGroup2 AS _AdditionalMaterialGroup2,
  SalesOrderItem._AdditionalMaterialGroup3 AS _AdditionalMaterialGroup3,
  SalesOrderItem._AdditionalMaterialGroup4 AS _AdditionalMaterialGroup4,
  SalesOrderItem._AdditionalMaterialGroup5 AS _AdditionalMaterialGroup5,
  SalesOrderItem._RequestedQuantityUnit AS _RequestedQuantityUnit,
  SalesOrderItem._TransactionCurrency AS _TransactionCurrency,
  SalesOrderItem._DownPaymentProcessingVariant AS _DownPaymentProcessingVariant,
  SalesOrderItem._ItemCategory AS _ItemCategory,
  SalesOrderItem._ShippingPoint AS _ShippingPoint,
  SalesOrderItem._CustomerGroup AS _CustomerGroup,
  SalesOrderItem._DeliveryPriority AS _DeliveryPriority,
  SalesOrderItem._ShippingType AS _ShippingType,
  SalesOrderItem._Route AS _Route,
  SalesOrderItem._DeliveryDateTypeRule AS _DeliveryDateTypeRule,
  SalesOrderItem._ItemIsBillingRelevant AS _ItemIsBillingRelevant,
  SalesOrderItem._ItemBillingBlockReason AS _ItemBillingBlockReason,
  SalesOrderItem._SalesDocumentRjcnReason AS _SalesDocumentRjcnReason,
  SalesOrderItem._SlsDocItemSupplyBlockReason AS _SlsDocItemSupplyBlockReason,
  SalesOrderItem._IncotermsClassification AS _IncotermsClassification,
  SalesOrderItem._IncotermsVersion AS _IncotermsVersion,
  SalesOrderItem._BusinessArea AS _BusinessArea,
  SalesOrderItem._WBSElementBasicData_2 AS _WBSElementBasicData_2,
  SalesOrderItem._MRPArea AS _MRPArea,
  SalesOrderItem._ProfitCenter AS _ProfitCenter,
  SalesOrderItem._MatlAccountAssignmentGroup AS _MatlAccountAssignmentGroup,
  SalesOrderItem._CustomerPaymentTerms AS _CustomerPaymentTerms,
  SalesOrderItem._CustomerPriceGroup AS _CustomerPriceGroup,
  SalesOrderItem._StorageLocation AS _StorageLocation,
  SalesOrderItem._Plant AS _Plant,
  SalesOrderItem._TransitPlant AS _TransitPlant,
  SalesOrderItem._PartialDeliveryItem AS _PartialDeliveryItem,
  SalesOrderItem._OrderQuantityUnit AS _OrderQuantityUnit,
  SalesOrderItem._ItemWeightUnit AS _ItemWeightUnit,
  SalesOrderItem._ItemVolumeUnit AS _ItemVolumeUnit,
  SalesOrderItem._SDProcessStatus AS _SDProcessStatus,
  SalesOrderItem._PurchaseConfirmationStatus AS _PurchaseConfirmationStatus,
  SalesOrderItem._SDDocumentRejectionStatus AS _SDDocumentRejectionStatus,
  SalesOrderItem._DeliveryStatus AS _DeliveryStatus,
  SalesOrderItem._BillingBlockStatus AS _BillingBlockStatus,
  SalesOrderItem._ItemGeneralIncompletionStatus AS _ItemGeneralIncompletionStatus,
  SalesOrderItem._DeliveryBlockStatus AS _DeliveryBlockStatus,
  SalesOrderItem._ChmlCmplncStatus AS _ChmlCmplncStatus,
  SalesOrderItem._DangerousGoodsStatus AS _DangerousGoodsStatus,
  SalesOrderItem._SafetyDataSheetStatus AS _SafetyDataSheetStatus,
  SalesOrderItem._OvrlTrdCmplncLegalCtrlChkSts AS _OvrlTrdCmplncLegalCtrlChkSts,
  SalesOrderItem._TrdCmplncSnctndListChkSts AS _TrdCmplncSnctndListChkSts,
  SalesOrderItem._TrdCmplncEmbargoSts AS _TrdCmplncEmbargoSts,
  SalesOrderItem._ItemDownPaymentStatus AS _ItemDownPaymentStatus,
  SalesOrderItem._OrderRelatedBillingStatus AS _OrderRelatedBillingStatus,
  SalesOrderItem._SlsDocItmOvrlSupplyBlockSts AS _SlsDocItmOvrlSupplyBlockSts,
  SalesOrderItem._SalesOrder._SDPricingProcedure AS _SDPricingProcedure,
  SalesOrderItem._ReferenceSDDocument AS _ReferenceSDDocument,
  SalesOrderItem._ReferenceSDDocumentItem AS _ReferenceSDDocumentItem,
  SalesOrderItem._ReferenceSDDocumentCategory AS _ReferenceSDDocumentCategory,
  _ItemEnhancedFields._ItemCategoryGroup AS _ItemCategoryGroup,
  _ItemEnhancedFields._SDDocumentItemUsage AS _SDDocumentItemUsage
FROM I_SalesOrderItem AS SalesOrderItem
LEFT OUTER JOIN R_VariantConfigurationTP AS _VariantConfiguration ON VarConfigurationBusObjectType = _VariantConfiguration.VarConfigurationBusObjectType AND VarConfigurationBusObjectKey = _VariantConfiguration.VarConfigurationBusObjectKey  -- association [0..1]
LEFT OUTER JOIN I_SlsDocItemEnhancedFields AS _ItemEnhancedFields ON SalesOrder = _ItemEnhancedFields.SalesDocument AND SalesOrderItem = _ItemEnhancedFields.SalesDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_Batch AS _Batch ON Plant = _Batch.Plant AND Product = _Batch.Material AND Batch = _Batch.Batch  -- association [0..1]
LEFT OUTER JOIN I_ProductPricingGroup AS _ProductPricingGroup ON MaterialPricingGroup = _ProductPricingGroup.ProductPricingGroup  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_SalesDocumentItemCategory AS _HigherLevelItemCategory ON HigherLevelItemCategory = _HigherLevelItemCategory.SalesDocumentItemCategory  -- association [0..1]
LEFT OUTER JOIN I_WBSElementByExternalID AS _WBSElementExternalID ON WBSElementExternalID = _WBSElementExternalID.WBSElementExternalID  -- association [0..1]
LEFT OUTER JOIN E_SalesDocumentItemBasic AS _Extension ON SalesOrder = _Extension.SalesDocument AND SalesOrderItem = _Extension.SalesDocumentItem  -- association [1]
LEFT OUTER JOIN R_SalesOrderItemPartnerTP AS _ItemPartner ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SalesOrderItemTextTP AS _ItemText ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SalesOrderItemPrcgElmntTP AS _ItemPricingElement ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SalesOrderItemBillingPlanTP AS _ItemBillingPlan ON /* condition not available in parsed metadata */  -- association [0..1]
LEFT OUTER JOIN R_SalesOrderScheduleLineTP AS _ScheduleLine ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SalesOrderItmRelatedObjectTP AS _ItemRelatedObject ON /* condition not available in parsed metadata */  -- association [0..*]
;