I_SalesDocumentExtdItem

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_SalesDocumentExtdItem.
-- 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_SalesDocumentExtdItem AS
SELECT
  cast ( vbap.erzet as creation_time preserving type ) AS CreationTime,
  cast (vbap.matnr as productnumber preserving type) AS Product,
  cast (vbap.matkl as productgroup preserving type ) AS ProductGroup,
  cast( vbap.cmtd_deliv_qty_su as committeddelivqtyinordqtyunit preserving type ) AS CommittedDelivQtyInOrdQtyUnit,
  cast( vbap.cmtd_deliv_creadate as committeddelivcreationdate preserving type ) AS CommittedDelivCreationDate,
  cast( vbap.cmtd_deliv_date as committeddeliverydate preserving type ) AS CommittedDeliveryDate,
  cast( case when vbap.kwmeng > 0 then vbap.kwmeng else vbap.zmeng end as reqd_qty ) as RequestedQuantity AS zmengendasreqd_qtyasRequestedQuantity,
  cast(vbkd.kursk as kursk_not_converted preserving type) AS PriceDetnExchangeRate,
  cast (vbap.kztlf as partial_delivery_allowed_flag preserving type ) AS PartialDeliveryIsAllowed,
  cast (vbap.antlf as nmbrpartialdeliv preserving type ) AS MaxNmbrOfPartialDelivery,
  cast ( vbap.ps_psp_pnr as ps_s4_pspnr preserving type ) AS WBSElementInternalID,
  cast(vbap.paobjnr as rkeobjnr_char ) AS ProfitabilitySegment_2,
  cast(vbap.lssta as delivery_block_status preserving type ) AS DeliveryBlockStatus,
  cast(vbap.pcsta as mon_tdd_pcsta preserving type ) AS ChmlCmplncStatus,
  cast(vbap.dgsta as mon_tdd_dgsta preserving type ) AS DangerousGoodsStatus,
  cast(vbap.sdssta as mon_tdd_sdssta preserving type ) AS SafetyDataSheetStatus,
  cast(vbap.emcst as embargochksts preserving type ) AS TrdCmplncEmbargoSts,
  cast(vbap.slcst as watchlistscrngchksts preserving type ) AS TrdCmplncSnctndListChkSts,
  cast(vbap.total_lccst as lglctrlchksts preserving type ) AS OvrlTrdCmplncLegalCtrlChkSts,
  cast(vbap.vdatu_ana as reqd_delivery_date preserving type) AS RequestedDeliveryDate,
  cast(vbap.perve_ana as sales_empl preserving type) AS SalesEmployeeWorkAgreement,
  cast(vbap.perzm_ana as resp_empl preserving type) AS ResponsibleEmployeeWorkAgrmt,
  vbak.kokrs AS ControllingArea,
  vbap.vbeln AS SalesDocument,
  vbap.posnr AS SalesDocumentItem,
  vbap.handle AS SalesDocumentItemUUID,
  vbap.vbtyp_ana AS SDDocumentCategory,
  vbap.pstyv AS SalesDocumentItemCategory,
  vbap.posar AS SalesDocumentItemType,
  vbap.shkzg AS IsReturnsItem,
  vbap.erlre AS CompletionRule,
  vbap.ernam AS CreatedByUser,
  vbap.erdat AS CreationDate,
  vbap.aedat AS LastChangeDate,
  vbap.spart AS Division,
  vbap.matnr AS Material,
  vbap.matwa AS OriginallyRequestedMaterial,
  vbap.kdmat AS MaterialByCustomer,
  vbap.ean11 AS InternationalArticleNumber,
  vbap.charg AS Batch,
  vbap.prodh AS ProductHierarchyNode,
  vbap.sugrd AS MaterialSubstitutionReason,
  vbap.matkl AS MaterialGroup,
  vbap.mvgr1 AS AdditionalMaterialGroup1,
  vbap.mvgr2 AS AdditionalMaterialGroup2,
  vbap.mvgr3 AS AdditionalMaterialGroup3,
  vbap.mvgr4 AS AdditionalMaterialGroup4,
  vbap.mvgr5 AS AdditionalMaterialGroup5,
  vbap.cuobj AS ProductConfiguration,
  vbap.prosa AS MaterialDeterminationType,
  vbap.berid AS MRPArea,
  vbap.stlnr AS BillOfMaterial,
  vbap.stdat AS BOMExplosionDate,
  vbap.mtvfp AS ProdAvailabilityCheckGroup,
  vbap.arktx AS SalesDocumentItemText,
  vbap.bstkd_ana AS PurchaseOrderByCustomer,
  vbap.posex AS UnderlyingPurchaseOrderItem,
  vbap.kwmeng AS OrderQuantity,
  vbap.vrkme AS OrderQuantityUnit,
  vbap.umvkn AS OrderToBaseQuantityDnmntr,
  vbap.umvkz AS OrderToBaseQuantityNmrtr,
  vbap.zmeng AS TargetQuantity,
  vbap.zieme AS TargetQuantityUnit,
  vbap.umzin AS TargetToBaseQuantityDnmntr,
  vbap.umziz AS TargetToBaseQuantityNmrtr,
  vbap.kbmeng AS ConfdDelivQtyInOrderQtyUnit,
  vbap.lsmeng AS TargetDelivQtyInOrderQtyUnit,
  vbap.klmeng AS ConfdDeliveryQtyInBaseUnit,
  vbap.meins AS BaseUnit,
  vbap.reqqty_bu AS RequestedQuantityInBaseUnit,
  vbap.brgew AS ItemGrossWeight,
  vbap.ntgew AS ItemNetWeight,
  vbap.gewei AS ItemWeightUnit,
  vbap.volum AS ItemVolume,
  vbap.voleh AS ItemVolumeUnit,
  vbap.bzirk_ana AS SalesDistrict,
  vbap.knuma_ag AS SalesDeal,
  vbap.knuma_pi AS SalesPromotion,
  vbap.kdgrp_ana AS CustomerGroup,
  vbap.abgru AS SalesDocumentRjcnReason,
  vbap.grpos AS AlternativeToItem,
  vbap.msr_ret_reason AS ReturnReason,
  vbap.msr_refund_code AS ReturnsRefundExtent,
  vbap.msr_approv_block AS RetsMgmtProcessingBlock,
  vbap.sgt_rcat AS RequirementSegment,
  vbap.fmeng AS QuantityIsFixed,
  vbap.awahr AS ItemOrderProbabilityInPercent,
  vbap.zwert AS OutlineAgreementTargetAmount,
  vbap.process_code AS SalesDocumentItemProcgCode,
  vbap.plavo AS PlngDelivSchedInstrn,
  vbap.netwr AS NetAmount,
  vbap.waerk AS TransactionCurrency,
  vbap.pmatn AS PricingReferenceMaterial,
  vbap.kondm AS MaterialPricingGroup,
  vbap.taxm1 AS ProductTaxClassification1,
  vbap.taxm2 AS ProductTaxClassification2,
  vbap.taxm3 AS ProductTaxClassification3,
  vbap.taxm4 AS ProductTaxClassification4,
  vbap.taxm5 AS ProductTaxClassification5,
  vbap.taxm6 AS ProductTaxClassification6,
  vbap.taxm7 AS ProductTaxClassification7,
  vbap.taxm8 AS ProductTaxClassification8,
  vbap.taxm9 AS ProductTaxClassification9,
  vbap.netpr AS NetPriceAmount,
  vbap.kpein AS NetPriceQuantity,
  vbap.kmein AS NetPriceQuantityUnit,
  vbap.kowrr AS StatisticalValueControl,
  vbap.mwsbp AS TaxAmount,
  vbap.wavwr AS CostAmount,
  vbap.kzwi1 AS Subtotal1Amount,
  vbap.kzwi2 AS Subtotal2Amount,
  vbap.kzwi3 AS Subtotal3Amount,
  vbap.kzwi4 AS Subtotal4Amount,
  vbap.kzwi5 AS Subtotal5Amount,
  vbap.kzwi6 AS Subtotal6Amount,
  vbap.knumv_ana AS SalesDocumentCondition,
  vbap.vstel AS ShippingPoint,
  vbap.vsart_ana AS ShippingType,
  vbap.sobkz AS InventorySpecialStockType,
  vbap.kzbws AS InventorySpecialStockValnType,
  vbap.lprio AS DeliveryPriority,
  vbap.werks AS Plant,
  vbap.original_plant AS OriginalPlant,
  vbap.lgort AS StorageLocation,
  vbap.route AS Route,
  vbap.grkor AS DeliveryGroup,
  vbap.fixmg AS DeliveryDateQuantityIsFixed,
  vbap.uebtk AS UnlimitedOverdeliveryIsAllowed,
  vbap.uebto AS OverdelivTolrtdLmtRatioInPct,
  vbap.untto AS UnderdelivTolrtdLmtRatioInPct,
  vbap.lfmng AS MinDeliveryQtyInBaseUnit,
  vbap.kzfme AS OpenDeliveryLeadingUnitCode,
  vbap.lfrel AS ItemIsDeliveryRelevant,
  vbap.fsh_season_year AS ProductSeasonYear,
  vbap.fsh_season AS ProductSeason,
  vbap.fsh_collection AS ProductCollection,
  vbap.fsh_theme AS ProductTheme,
  vbap.fsh_candate AS FashionCancelDate,
  vbap.wrf_charstc1 AS ProductCharacteristic1,
  vbap.wrf_charstc2 AS ProductCharacteristic2,
  vbap.wrf_charstc3 AS ProductCharacteristic3,
  vbap.rfm_psst_group AS ShippingGroupNumber,
  vbap.rfm_psst_rule AS ShippingGroupRule,
  vbap.fkdat_ana AS BillingDocumentDate,
  vbap.fkrel AS ItemIsBillingRelevant,
  vbap.faksp AS ItemBillingBlockReason,
  vbap.fplnr_ana AS BillingPlan,
  vbap.gsber AS BusinessArea,
  vbap.prctr AS ProfitCenter,
  vbap.ps_psp_pnr AS WBSElement,
  vbap.aufnr AS OrderID,
  vbap.objnr AS ControllingObject,
  vbap.paobjnr AS ProfitabilitySegment,
  vbap.vbelv AS OriginSDDocument,
  vbap.posnv AS OriginSDDocumentItem,
  vbap.vgbel AS ReferenceSDDocument,
  vbap.vgpos AS ReferenceSDDocumentItem,
  vbap.vgtyp AS ReferenceSDDocumentCategory,
  vbap.uepos AS HigherLevelItem,
  vbap.wktnr AS ValueContract,
  vbap.wktps AS ValueContractItem,
  vbap.solution_order_id AS BusinessSolutionOrder,
  vbap.solution_order_itm_id AS BusinessSolutionOrderItem,
  vbap.gbsta AS SDProcessStatus,
  vbap.besta AS DeliveryConfirmationStatus,
  vbap.delivery_date_type_rule AS DeliveryDateTypeRule,
  vbap.costa AS PurchaseConfirmationStatus,
  vbap.lfgsa AS TotalDeliveryStatus,
  vbap.lfsta AS DeliveryStatus,
  vbap.fksaa AS OrderRelatedBillingStatus,
  vbap.fssta AS BillingBlockStatus,
  vbap.uvall AS ItemGeneralIncompletionStatus,
  vbap.uvfak AS ItemBillingIncompletionStatus,
  vbap.uvprs AS PricingIncompletionStatus,
  vbap.uvvlk AS ItemDeliveryIncompletionStatus,
  vbap.absta AS SDDocumentRejectionStatus,
  vbap.rfgsa AS TotalSDDocReferenceStatus,
  vbap.rfsta AS SDDocReferenceStatus,
  vbap.atp_abc_substitution_status AS AltvBsdConfSubstitutionStatus,
  vbap.dp_clear_sta_itm AS ContractItemDownPaymentStatus,
  vbap.capped_net_amount AS CappedNetAmount,
  vbap.capped_net_amount_alert_thld AS CappedNetAmtAlertThldInPct,
  vbap.ifrs15_total_ssp AS TotalStandAloneSellingPrice,
  vbap.abgrs AS ResultAnalysisInternalID,
  vbap.service_doc_type AS ServiceDocumentType,
  vbap.service_doc_id AS ServiceDocument,
  vbap.service_doc_item_id AS ServiceDocumentItem,
  vbap.auart_ana AS SalesDocumentType,
  vbap.vkorg_ana AS SalesOrganization,
  vbap.vtweg_ana AS DistributionChannel,
  vbap.spart_ana AS OrganizationDivision,
  vbap.vkbur_ana AS SalesOffice,
  vbap.vkgrp_ana AS SalesGroup,
  vbap.kunnr_ana AS SoldToParty,
  vbap.kvgr1_ana AS AdditionalCustomerGroup1,
  vbap.kvgr2_ana AS AdditionalCustomerGroup2,
  vbap.kvgr3_ana AS AdditionalCustomerGroup3,
  vbap.kvgr4_ana AS AdditionalCustomerGroup4,
  vbap.kvgr5_ana AS AdditionalCustomerGroup5,
  vbap.audat_ana AS SalesDocumentDate,
  vbap.augru_ana AS SDDocumentReason,
  vbap.vsbed_ana AS ShippingCondition,
  vbap.kunwe_ana AS ShipToParty,
  vbap.kunrg_ana AS PayerParty,
  vbap.kunre_ana AS BillToParty,
  vbap.perve_ana AS SalesEmployee,
  vbap.perzm_ana AS ResponsibleEmployee,
  vbkd.wminr AS ProductCatalog,
  vbkd.bstdk AS CustomerPurchaseOrderDate,
  vbkd.fbuda AS ServicesRenderedDate,
  vbkd.waktion AS RetailPromotion,
  vbkd.prsdt AS PricingDate,
  vbkd.kursk_dat AS ExchangeRateDate,
  vbkd.dpbp_ref_fplnr AS ReferenceBillingPlan,
  vbkd.dpbp_ref_fpltr AS ReferenceBillingPlanItem,
  vbkd.incov AS IncotermsVersion,
  vbkd.inco1 AS IncotermsClassification,
  vbkd.inco2 AS IncotermsTransferLocation,
  vbkd.inco2_l AS IncotermsLocation1,
  vbkd.inco3_l AS IncotermsLocation2,
  vbkd.zterm AS CustomerPaymentTerms,
  vbkd.zlsch AS PaymentMethod,
  vbkd.valdt AS FixedValueDate,
  vbkd.valtg AS AdditionalValueDays,
  vbkd.gjahr AS FiscalYear,
  vbkd.poper AS FiscalPeriod,
  vbkd.ktgrd AS CustomerAccountAssignmentGroup,
  veda.vbegdat AS SalesContractValidityStartDate,
  veda.venddat AS SalesContractValidityEndDate,
  veda.vlaufz AS NmbrOfSalesContractValdtyPerd,
  veda.vlauez AS SalesContractValidityPerdUnit,
  veda.vlaufk AS SalesContractValidityPerdCat,
  veda.vuntdat AS SalesContractSignedDate,
  veda.vinsdat AS EquipmentInstallationDate,
  veda.vabndat AS EquipmentDeliveryAccptcDate,
  veda.vdemdat AS EquipmentDismantlingDate,
  veda.vkuesch AS SalesContractCanclnProcedure,
  veda.vwundat AS RequestedCancellationDate,
  veda.veindat AS SlsContractCanclnReqRcptDate,
  veda.vbelkue AS CanclnDocByContrPartner,
  veda.vbedkue AS ContractPartnerCanclnDocDate,
  veda.vkuepar AS SalesContractCanclnParty,
  veda.vkuegru AS SalesContractCanclnReason,
  veda.vaktsch AS SalesContractFollowUpAction,
  veda.vasda AS SlsContractFollowUpActionDate
FROM vbap
LEFT OUTER JOIN I_BusinessAreaText AS _BusinessAreaText ON BusinessArea = _BusinessAreaText.BusinessArea  -- association [0..*]
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON Material = _MaterialText.Material  -- association [0..*]
LEFT OUTER JOIN I_ProductText AS _ProductText ON Product = _ProductText.Product  -- association [0..*]
LEFT OUTER JOIN I_MaterialText AS _OrigMaterialText ON OriginallyRequestedMaterial = _OrigMaterialText.Material  -- association [0..*]
LEFT OUTER JOIN I_ShippingPointText AS _ShippingPointText ON ShippingPoint = _ShippingPointText.ShippingPoint  -- association [0..*]
LEFT OUTER JOIN I_SlsDocItemEnhancedFields AS _SlsDocItemEnhancedFields ON SalesDocument = _SlsDocItemEnhancedFields.SalesDocument AND SalesDocumentItem = _SlsDocItemEnhancedFields.SalesDocumentItem  -- association [1..1]
LEFT OUTER JOIN I_SalesDocument AS _SalesDocument ON SalesDocument = _SalesDocument.SalesDocument  -- association [1..1]
LEFT OUTER JOIN I_SalesDocumentScheduleLine AS _ScheduleLine ON SalesDocument = _ScheduleLine.SalesDocument AND SalesDocumentItem = _ScheduleLine.SalesDocumentItem  -- association [0..*]
LEFT OUTER JOIN I_SalesDocumentItemPartner AS _Partner ON SalesDocument = _Partner.SalesDocument AND SalesDocumentItem = _Partner.SalesDocumentItem  -- association [0..*]
LEFT OUTER JOIN I_SalesDocItemPricingElement AS _PricingElement ON SalesDocument = _PricingElement.SalesDocument AND SalesDocumentItem = _PricingElement.SalesDocumentItem  -- association [0..*]
LEFT OUTER JOIN I_SDDocumentMultiLevelProcFlow AS _SubsequentDocument ON SalesDocument = _SubsequentDocument.PrecedingDocument AND SalesDocumentItem = _SubsequentDocument.PrecedingDocumentItem AND SDDocumentCategory = _SubsequentDocument.PrecedingDocumentCategory  -- association [0..*]
LEFT OUTER JOIN I_SDDocumentMultiLevelProcFlow AS _PrecedingDocument ON SalesDocument = _PrecedingDocument.SubsequentDocument AND SalesDocumentItem = _PrecedingDocument.SubsequentDocumentItem AND SDDocumentCategory = _PrecedingDocument.SubsequentDocumentCategory  -- association [0..*]
LEFT OUTER JOIN I_SDDocumentCategory AS _SDDocumentCategory ON SDDocumentCategory = _SDDocumentCategory.SDDocumentCategory  -- association [0..1]
LEFT OUTER JOIN I_SalesDocumentItemCategory AS _ItemCategory ON SalesDocumentItemCategory = _ItemCategory.SalesDocumentItemCategory  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_Division AS _Division ON Division = _Division.Division  -- association [0..1]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [0..1]
LEFT OUTER JOIN I_Product AS _Product ON Product = _Product.Product  -- association [0..1]
LEFT OUTER JOIN I_Material AS _OriginallyRequestedMaterial ON OriginallyRequestedMaterial = _OriginallyRequestedMaterial.Material  -- association [0..1]
LEFT OUTER JOIN I_MaterialPlant AS _MaterialPlant ON Material = _MaterialPlant.Material AND Plant = _MaterialPlant.Plant  -- association [1..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_ProductHierarchyNode AS _ProductHierarchyNode ON ProductHierarchyNode = _ProductHierarchyNode.ProductHierarchyNode  -- association [0..1]
LEFT OUTER JOIN I_MaterialSubstitutionReason AS _MaterialSubstitutionReason ON MaterialSubstitutionReason = _MaterialSubstitutionReason.MaterialSubstitutionReason  -- association [0..1]
LEFT OUTER JOIN I_MaterialGroup AS _MaterialGroup ON MaterialGroup = _MaterialGroup.MaterialGroup  -- association [0..1]
LEFT OUTER JOIN I_ProductGroup_2 AS _ProductGroup ON ProductGroup = _ProductGroup.ProductGroup  -- association [0..1]
LEFT OUTER JOIN I_MaterialPricingGroup AS _MaterialPricingGroup ON MaterialPricingGroup = _MaterialPricingGroup.MaterialPricingGroup  -- 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_UnitOfMeasure AS _OrderQuantityUnit ON OrderQuantityUnit = _OrderQuantityUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _TargetQuantityUnit ON TargetQuantityUnit = _TargetQuantityUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BaseUnit ON BaseUnit = _BaseUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _RequestedQuantityUnit ON RequestedQuantityUnit = _RequestedQuantityUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ItemWeightUnit ON ItemWeightUnit = _ItemWeightUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ItemVolumeUnit ON ItemVolumeUnit = _ItemVolumeUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_SalesDistrict AS _SalesDistrict ON SalesDistrict = _SalesDistrict.SalesDistrict  -- association [0..1]
LEFT OUTER JOIN I_SalesDeal AS _SalesDeal ON SalesDeal = _SalesDeal.SalesDeal  -- 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_ReturnReason AS _ReturnReason ON ReturnReason = _ReturnReason.ReturnReason  -- association [0..1]
LEFT OUTER JOIN I_ReturnsRefundExtent AS _ReturnsRefundExtent ON ReturnsRefundExtent = _ReturnsRefundExtent.ReturnsRefundExtent  -- association [0..1]
LEFT OUTER JOIN I_SalesContrValdtyPerdUnit AS _SalesContractValidityPerdUnit ON SalesContractValidityPerdUnit = _SalesContractValidityPerdUnit.SalesContractValidityPerdUnit  -- association [0..1]
LEFT OUTER JOIN I_SalesContractCanclnParty AS _SalesContractCanclnParty ON SalesContractCanclnParty = _SalesContractCanclnParty.SalesContractCanclnParty  -- association [0..1]
LEFT OUTER JOIN I_SalesContractCanclnReason AS _SalesContractCanclnReason ON SalesContractCanclnReason = _SalesContractCanclnReason.SalesContractCanclnReason  -- association [0..1]
LEFT OUTER JOIN I_ContractDownPaymentStatus AS _ContractItemDownPaymentStatus ON ContractItemDownPaymentStatus = _ContractItemDownPaymentStatus.ContractDownPaymentStatus  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _NetPriceQuantityUnit ON NetPriceQuantityUnit = _NetPriceQuantityUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_StatisticalValueControl AS _StatisticalValueControl ON StatisticalValueControl = _StatisticalValueControl.StatisticalValueControl  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _TransactionCurrency ON TransactionCurrency = _TransactionCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_ShippingPoint AS _ShippingPoint ON ShippingPoint = _ShippingPoint.ShippingPoint  -- association [0..1]
LEFT OUTER JOIN I_ShippingType AS _ShippingType ON ShippingType = _ShippingType.ShippingType  -- association [0..1]
LEFT OUTER JOIN I_DeliveryPriority AS _DeliveryPriority ON DeliveryPriority = _DeliveryPriority.DeliveryPriority  -- association [0..1]
LEFT OUTER JOIN I_PartialDeliveryItem AS _PartialDeliveryItem ON PartialDeliveryIsAllowed = _PartialDeliveryItem.PartialDeliveryIsAllowed  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _OriginalPlant ON OriginalPlant = _OriginalPlant.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_Route AS _Route ON Route = _Route.Route  -- association [0..1]
LEFT OUTER JOIN I_BillingRelevanceCode AS _ItemIsBillingRelevant ON ItemIsBillingRelevant = _ItemIsBillingRelevant.BillingRelevanceCode  -- association [0..1]
LEFT OUTER JOIN I_BillingBlockReason AS _ItemBillingBlockReason ON ItemBillingBlockReason = _ItemBillingBlockReason.BillingBlockReason  -- association [0..1]
LEFT OUTER JOIN I_SlsDocItemBillingPlan AS _BillingPlan ON BillingPlan = _BillingPlan.BillingPlan  -- 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_CustomerAccountAssgmtGroup AS _CustomerAccountAssgmtGroup ON CustomerAccountAssignmentGroup = _CustomerAccountAssgmtGroup.CustomerAccountAssignmentGroup  -- association [0..1]
LEFT OUTER JOIN I_BusinessArea AS _BusinessArea ON BusinessArea = _BusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenter AS _ProfitCenter ON ProfitCenter = _ProfitCenter.ProfitCenter AND ControllingArea = _ProfitCenter.ControllingArea  -- association [0..*]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementBasicData ON WBSElement = _WBSElementBasicData.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementBasicData_2 ON WBSElementInternalID = _WBSElementBasicData_2.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_SalesDocument AS _ReferenceSDDocument ON ReferenceSDDocument = _ReferenceSDDocument.SalesDocument  -- association [0..1]
LEFT OUTER JOIN I_SalesDocumentItem AS _ReferenceSDDocumentItem ON ReferenceSDDocument = _ReferenceSDDocumentItem.SalesDocument AND ReferenceSDDocumentItem = _ReferenceSDDocumentItem.SalesDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_SDDocumentCategory AS _ReferenceSDDocumentCategory ON ReferenceSDDocumentCategory = _ReferenceSDDocumentCategory.SDDocumentCategory  -- association [0..1]
LEFT OUTER JOIN I_PlngDelivSchedInstrn AS _PlngDelivSchedInstrn ON PlngDelivSchedInstrn = _PlngDelivSchedInstrn.PlngDelivSchedInstrn  -- association [0..1]
LEFT OUTER JOIN I_SDProcessStatus AS _SDProcessStatus ON SDProcessStatus = _SDProcessStatus.SDProcessStatus  -- association [0..1]
LEFT OUTER JOIN I_PurchaseConfirmationStatus AS _PurchaseConfirmationStatus ON PurchaseConfirmationStatus = _PurchaseConfirmationStatus.PurchaseConfirmationStatus  -- association [0..1]
LEFT OUTER JOIN I_TotalDeliveryStatus AS _TotalDeliveryStatus ON TotalDeliveryStatus = _TotalDeliveryStatus.TotalDeliveryStatus  -- association [0..1]
LEFT OUTER JOIN I_DeliveryStatus AS _DeliveryStatus ON DeliveryStatus = _DeliveryStatus.DeliveryStatus  -- association [0..1]
LEFT OUTER JOIN I_DeliveryBlockStatus AS _DeliveryBlockStatus ON DeliveryBlockStatus = _DeliveryBlockStatus.DeliveryBlockStatus  -- association [0..1]
LEFT OUTER JOIN I_DeliveryConfirmationStatus AS _DeliveryConfirmationStatus ON DeliveryConfirmationStatus = _DeliveryConfirmationStatus.DeliveryConfirmationStatus  -- association [0..1]
LEFT OUTER JOIN I_DeliveryDateTypeRule AS _DeliveryDateTypeRule ON DeliveryDateTypeRule = _DeliveryDateTypeRule.DeliveryDateTypeRule  -- association [0..1]
LEFT OUTER JOIN I_OrderRelatedBillingStatus AS _OrderRelatedBillingStatus ON OrderRelatedBillingStatus = _OrderRelatedBillingStatus.OrderRelatedBillingStatus  -- association [0..1]
LEFT OUTER JOIN I_BillingBlockStatus AS _BillingBlockStatus ON BillingBlockStatus = _BillingBlockStatus.BillingBlockStatus  -- association [0..1]
LEFT OUTER JOIN I_SDDocumentRejectionStatus AS _SDDocumentRejectionStatus ON SDDocumentRejectionStatus = _SDDocumentRejectionStatus.SDDocumentRejectionStatus  -- 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_TotalSDDocReferenceStatus AS _TotalSDDocReferenceStatus ON TotalSDDocReferenceStatus = _TotalSDDocReferenceStatus.TotalSDDocReferenceStatus  -- association [0..1]
LEFT OUTER JOIN I_SDDocReferenceStatus AS _SDDocReferenceStatus ON SDDocReferenceStatus = _SDDocReferenceStatus.SDDocReferenceStatus  -- association [0..1]
LEFT OUTER JOIN I_AltvBsdConfSubstitutionSts AS _AltvBsdConfSubstitutionSts ON AltvBsdConfSubstitutionStatus = _AltvBsdConfSubstitutionSts.AltvBsdConfSubstitutionStatus  -- association [0..1]
LEFT OUTER JOIN I_ChmlCmplncStatus AS _ChmlCmplncStatus ON ChmlCmplncStatus = _ChmlCmplncStatus.ChmlCmplncStatus  -- association [0..1]
LEFT OUTER JOIN I_DangerousGoodsStatus AS _DangerousGoodsStatus ON DangerousGoodsStatus = _DangerousGoodsStatus.DangerousGoodsStatus  -- association [0..1]
LEFT OUTER JOIN I_SafetyDataSheetStatus AS _SafetyDataSheetStatus ON SafetyDataSheetStatus = _SafetyDataSheetStatus.SafetyDataSheetStatus  -- association [0..1]
LEFT OUTER JOIN I_TrdCmplncCheckStatus AS _TrdCmplncEmbargoSts ON TrdCmplncEmbargoSts = _TrdCmplncEmbargoSts.TrdCmplncCheckStatus  -- association [0..1]
LEFT OUTER JOIN I_TrdCmplncCheckStatus AS _TrdCmplncSnctndListChkSts ON TrdCmplncSnctndListChkSts = _TrdCmplncSnctndListChkSts.TrdCmplncCheckStatus  -- association [0..1]
LEFT OUTER JOIN I_OvrlTrdCmplncLegalCtrlChkSts AS _OvrlTrdCmplncLegalCtrlChkSts ON OvrlTrdCmplncLegalCtrlChkSts = _OvrlTrdCmplncLegalCtrlChkSts.OvrlTrdCmplncLegalCtrlChkSts  -- association [0..1]
LEFT OUTER JOIN I_ServiceDocumentType AS _ServiceDocumentType ON ServiceDocumentType = _ServiceDocumentType.ServiceDocumentType  -- association [0..1]
LEFT OUTER JOIN I_SalesDocumentItemProcgCode AS _SalesDocumentItemProcgCode ON SalesDocumentItemProcgCode = _SalesDocumentItemProcgCode.SalesDocumentItemProcgCode  -- association [0..1]
LEFT OUTER JOIN I_SalesDocumentType AS _SalesDocumentType ON SalesDocumentType = _SalesDocumentType.SalesDocumentType  -- 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_SalesOffice AS _SalesOffice ON SalesOffice = _SalesOffice.SalesOffice  -- association [0..1]
LEFT OUTER JOIN I_SalesGroup AS _SalesGroup ON SalesGroup = _SalesGroup.SalesGroup  -- association [0..1]
LEFT OUTER JOIN I_SDDocumentReason AS _SDDocumentReason ON SDDocumentReason = _SDDocumentReason.SDDocumentReason  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _SoldToParty ON SoldToParty = _SoldToParty.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_ShippingCondition AS _ShippingCondition ON ShippingCondition = _ShippingCondition.ShippingCondition  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _ShipToParty ON ShipToParty = _ShipToParty.Customer  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _BillToParty ON BillToParty = _BillToParty.Customer  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _PayerParty ON PayerParty = _PayerParty.Customer  -- association [0..1]
LEFT OUTER JOIN I_PersonWorkAgreement_1 AS _SalesEmployee ON SalesEmployee = _SalesEmployee.PersonWorkAgreement  -- association [0..1]
LEFT OUTER JOIN I_PersonWorkAgreement_1 AS _ResponsibleEmployee ON ResponsibleEmployee = _ResponsibleEmployee.PersonWorkAgreement  -- association [0..1]
LEFT OUTER JOIN I_ServiceDocumentEnhcd AS _SolutionOrder ON BusinessSolutionOrder = _SolutionOrder.ServiceDocument AND _SolutionOrder.ServiceObjectType = 'BUS2000172'  -- association [0..1]
LEFT OUTER JOIN I_ServiceDocumentItemEnhcd AS _SolutionOrderItem ON _SolutionOrderItem.ServiceObjectType = 'BUS2000172' AND BusinessSolutionOrder = _SolutionOrderItem.ServiceDocument AND BusinessSolutionOrderItem = _SolutionOrderItem.ServiceDocumentItem  -- association [1]
LEFT OUTER JOIN E_SalesDocumentItemBasic AS _Extension ON SalesDocument = _Extension.SalesDocument AND SalesDocumentItem = _Extension.SalesDocumentItem  -- association [0..1]
;