I_SalesDocumentItemBasic

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_SalesDocumentItemBasic.
-- 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_SalesDocumentItemBasic AS
SELECT
  vbeln AS SalesDocument,
  posnr AS SalesDocumentItem,
  handle AS SalesDocumentItemUUID,
  pstyv AS SalesDocumentItemCategory,
  posar AS SalesDocumentItemType,
  shkzg AS IsReturnsItem,
  erlre AS CompletionRule,
  ernam AS CreatedByUser,
  erdat AS CreationDate,
  cast( erzet as creation_time preserving type ) AS CreationTime,
  aedat AS LastChangeDate,
  spart AS Division,
  matnr AS Material,
  cast (vbap.matnr as productnumber preserving type) AS Product,
  matwa AS OriginallyRequestedMaterial,
  kdmat AS MaterialByCustomer,
  ean11 AS InternationalArticleNumber,
  charg AS Batch,
  prodh AS ProductHierarchyNode,
  sugrd AS MaterialSubstitutionReason,
  matkl AS MaterialGroup,
  cast (vbap.matkl as productgroup preserving type ) AS ProductGroup,
  mvgr1 AS AdditionalMaterialGroup1,
  mvgr2 AS AdditionalMaterialGroup2,
  mvgr3 AS AdditionalMaterialGroup3,
  mvgr4 AS AdditionalMaterialGroup4,
  mvgr5 AS AdditionalMaterialGroup5,
  cuobj AS ProductConfiguration,
  prosa AS MaterialDeterminationType,
  berid AS MRPArea,
  stlnr AS BillOfMaterial,
  stdat AS BOMExplosionDate,
  mtvfp AS ProdAvailabilityCheckGroup,
  arktx AS SalesDocumentItemText,
  posex AS UnderlyingPurchaseOrderItem,
  kwmeng AS OrderQuantity,
  vrkme AS OrderQuantityUnit,
  umvkn AS OrderToBaseQuantityDnmntr,
  umvkz AS OrderToBaseQuantityNmrtr,
  zmeng AS TargetQuantity,
  zieme AS TargetQuantityUnit,
  umzin AS TargetToBaseQuantityDnmntr,
  umziz AS TargetToBaseQuantityNmrtr,
  kbmeng AS ConfdDelivQtyInOrderQtyUnit,
  lsmeng AS TargetDelivQtyInOrderQtyUnit,
  klmeng AS ConfdDeliveryQtyInBaseUnit,
  meins AS BaseUnit,
  cast( cmtd_deliv_qty_su as committeddelivqtyinordqtyunit preserving type ) AS CommittedDelivQtyInOrdQtyUnit,
  cast( cmtd_deliv_creadate as committeddelivcreationdate preserving type ) AS CommittedDelivCreationDate,
  cast( 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,
  reqqty_bu AS RequestedQuantityInBaseUnit,
  brgew AS ItemGrossWeight,
  ntgew AS ItemNetWeight,
  gewei AS ItemWeightUnit,
  volum AS ItemVolume,
  voleh AS ItemVolumeUnit,
  knuma_ag AS SalesDeal,
  knuma_pi AS SalesPromotion,
  abgru AS SalesDocumentRjcnReason,
  grpos AS AlternativeToItem,
  msr_ret_reason AS ReturnReason,
  msr_refund_code AS ReturnsRefundExtent,
  msr_approv_block AS RetsMgmtProcessingBlock,
  sgt_rcat AS RequirementSegment,
  fmeng AS QuantityIsFixed,
  awahr AS ItemOrderProbabilityInPercent,
  zwert AS OutlineAgreementTargetAmount,
  netwr AS NetAmount,
  waerk AS TransactionCurrency,
  pmatn AS PricingReferenceMaterial,
  kondm AS MaterialPricingGroup,
  taxm1 AS ProductTaxClassification1,
  taxm2 AS ProductTaxClassification2,
  taxm3 AS ProductTaxClassification3,
  taxm4 AS ProductTaxClassification4,
  taxm5 AS ProductTaxClassification5,
  taxm6 AS ProductTaxClassification6,
  taxm7 AS ProductTaxClassification7,
  taxm8 AS ProductTaxClassification8,
  taxm9 AS ProductTaxClassification9,
  ktgrm AS MatlAccountAssignmentGroup,
  netpr AS NetPriceAmount,
  kpein AS NetPriceQuantity,
  kmein AS NetPriceQuantityUnit,
  kowrr AS StatisticalValueControl,
  mwsbp AS TaxAmount,
  wavwr AS CostAmount,
  kzwi1 AS Subtotal1Amount,
  kzwi2 AS Subtotal2Amount,
  kzwi3 AS Subtotal3Amount,
  kzwi4 AS Subtotal4Amount,
  kzwi5 AS Subtotal5Amount,
  kzwi6 AS Subtotal6Amount,
  vstel AS ShippingPoint,
  sobkz AS InventorySpecialStockType,
  kzbws AS InventorySpecialStockValnType,
  lprio AS DeliveryPriority,
  werks AS Plant,
  transit_plant AS TransitPlant,
  lgort AS StorageLocation,
  Route,
  grkor AS DeliveryGroup,
  fixmg AS DeliveryDateQuantityIsFixed,
  kztlf AS PartialDeliveryIsAllowed,
  antlf AS MaxNmbrOfPartialDelivery,
  uebtk AS UnlimitedOverdeliveryIsAllowed,
  uebto AS OverdelivTolrtdLmtRatioInPct,
  untto AS UnderdelivTolrtdLmtRatioInPct,
  lfmng AS MinDeliveryQtyInBaseUnit,
  kzfme AS OpenDeliveryLeadingUnitCode,
  lfrel AS ItemIsDeliveryRelevant,
  fsh_season_year AS ProductSeasonYear,
  fsh_season AS ProductSeason,
  fsh_collection AS ProductCollection,
  fsh_theme AS ProductTheme,
  fsh_candate AS FashionCancelDate,
  wrf_charstc1 AS ProductCharacteristic1,
  wrf_charstc2 AS ProductCharacteristic2,
  wrf_charstc3 AS ProductCharacteristic3,
  rfm_psst_group AS ShippingGroupNumber,
  rfm_psst_rule AS ShippingGroupRule,
  fkrel AS ItemIsBillingRelevant,
  faksp AS ItemBillingBlockReason,
  gsber AS BusinessArea,
  prctr AS ProfitCenter,
  ps_psp_pnr AS WBSElement,
  aufnr AS OrderID,
  objnr AS ControllingObject,
  paobjnr AS ProfitabilitySegment,
  vbelv AS OriginSDDocument,
  posnv AS OriginSDDocumentItem,
  vgbel AS ReferenceSDDocument,
  vgpos AS ReferenceSDDocumentItem,
  vgtyp AS ReferenceSDDocumentCategory,
  uepos AS HigherLevelItem,
  wktnr AS ValueContract,
  wktps AS ValueContractItem,
  vbkd_posnr AS SlsDocBusinessDataItem,
  solution_order_id AS BusinessSolutionOrder,
  solution_order_itm_id AS BusinessSolutionOrderItem,
  gbsta AS SDProcessStatus,
  besta AS DeliveryConfirmationStatus,
  costa AS PurchaseConfirmationStatus,
  lfgsa AS TotalDeliveryStatus,
  lfsta AS DeliveryStatus,
  lssta AS DeliveryBlockStatus,
  fksaa AS OrderRelatedBillingStatus,
  fssta AS BillingBlockStatus,
  uvall AS ItemGeneralIncompletionStatus,
  uvfak AS ItemBillingIncompletionStatus,
  uvprs AS PricingIncompletionStatus,
  uvvlk AS ItemDeliveryIncompletionStatus,
  absta AS SDDocumentRejectionStatus,
  rfgsa AS TotalSDDocReferenceStatus,
  rfsta AS SDDocReferenceStatus,
  pcsta AS ChmlCmplncStatus,
  dgsta AS DangerousGoodsStatus,
  sdssta AS SafetyDataSheetStatus,
  emcst AS TrdCmplncEmbargoSts,
  slcst AS TrdCmplncSnctndListChkSts,
  total_lccst AS OvrlTrdCmplncLegalCtrlChkSts,
  vcm_chain_category AS ValueChainCategory,
  vbap.vbtyp_ana AS SDDocumentCategory,
  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.augru_ana AS SDDocumentReason,
  vbap.audat_ana AS SalesDocumentDate,
  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,
  cast(vbap.vdatu_ana as reqd_delivery_date preserving type) AS RequestedDeliveryDate,
  vbap.vsbed_ana AS ShippingCondition,
  vbap.kunnr_ana AS SoldToParty,
  vbap.knumv_ana AS SalesDocumentCondition,
  vbap.bzirk_ana AS SalesDistrict,
  vbap.bstkd_ana AS PurchaseOrderByCustomer,
  vbap.kdgrp_ana AS CustomerGroup,
  vbap.vsart_ana AS ShippingType,
  vbap.fkdat_ana AS BillingDocumentDate,
  vbap.fplnr_ana AS BillingPlan,
  vbap.kunwe_ana AS ShipToParty,
  vbap.kunre_ana AS BillToParty,
  vbap.perve_ana AS SalesEmployee,
  vbap.perzm_ana AS ResponsibleEmployee,
  cast(vbap.perve_ana as sales_empl preserving type) AS SalesEmployeeWorkAgreement,
  cast(vbap.perzm_ana as resp_empl preserving type) AS ResponsibleEmployeeWorkAgrmt,
  vbap.kunrg_ana AS PayerParty,
  vbap.kzvbr AS ConsumptionPosting
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_SalesDocumentBasic AS _SalesDocumentBasic ON SalesDocument = _SalesDocumentBasic.SalesDocument  -- association [1..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_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_SalesDeal AS _SalesDeal ON SalesDeal = _SalesDeal.SalesDeal  -- 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_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_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 _TransitPlant ON TransitPlant = _TransitPlant.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_BusinessArea AS _BusinessArea ON BusinessArea = _BusinessArea.BusinessArea  -- 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_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_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_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_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_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_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_ShippingType AS _ShippingType ON ShippingType = _ShippingType.ShippingType  -- 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_ConsumptionPosting AS _ConsumptionPosting ON ConsumptionPosting = _ConsumptionPosting.ConsumptionPosting  -- 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 I_SalesValueChainCategory AS _SalesValueChainCategory ON ValueChainCategory = _SalesValueChainCategory.ValueChainCategory  -- association [0..1]
;