I_DeliveryDocumentItem

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_DeliveryDocumentItem.
-- 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.
-- SQL view name: ILEDELIVDOCITEM

CREATE VIEW I_DeliveryDocumentItem AS
SELECT
  vbeln AS DeliveryDocument,
  posnr AS DeliveryDocumentItem,
  _DeliveryDocument.SDDocumentCategory AS SDDocumentCategory,
  _DeliveryDocument.TransactionCurrency AS TransactionCurrency,
  pstyv AS DeliveryDocumentItemCategory,
  posar AS SalesDocumentItemType,
  ernam AS CreatedByUser,
  erdat AS CreationDate,
  erzet AS CreationTime,
  aedat AS LastChangeDate,
  vtweg AS DistributionChannel,
  spart AS Division,
  vkgrp AS SalesGroup,
  vkbur AS SalesOffice,
  abtnr AS DepartmentClassificationByCust,
  matnr AS Material,
  cast (matnr as productnumber preserving type ) AS Product,
  kdmat AS MaterialByCustomer,
  matwa AS OriginallyRequestedMaterial,
  ean11 AS InternationalArticleNumber,
  charg AS Batch,
  cuobj_ch AS BatchClassification,
  lichn AS BatchBySupplier,
  xchar AS MaterialIsIntBatchManaged,
  xchpf AS MaterialIsBatchManaged,
  matkl AS MaterialGroup,
  cast(matkl as productgroup preserving type ) AS ProductGroup,
  mfrgr AS MaterialFreightGroup,
  mvgr1 AS AdditionalMaterialGroup1,
  mvgr2 AS AdditionalMaterialGroup2,
  mvgr3 AS AdditionalMaterialGroup3,
  mvgr4 AS AdditionalMaterialGroup4,
  mvgr5 AS AdditionalMaterialGroup5,
  werks AS Plant,
  lgnum AS Warehouse,
  lgort AS StorageLocation,
  lgpla AS StorageBin,
  lgtyp AS StorageType,
  resource_id AS DeliveryItemResourceID,
  loading_point AS LoadingPointForDelivery,
  sobkz AS InventorySpecialStockType,
  vfdat AS ShelfLifeExpirationDate,
  anzsn AS NumberOfSerialNumbers,
  cuobj AS ProductConfiguration,
  prodh AS ProductHierarchyNode,
  hsdat AS ManufactureDate,
  arktx AS DeliveryDocumentItemText,
  uepos AS HigherLevelItem,
  uecha AS HigherLvlItmOfBatSpltItm,
  lfimg AS ActualDeliveryQuantity,
  fmeng AS QuantityIsFixed,
  ormng AS OriginalDeliveryQuantity,
  vrkme AS DeliveryQuantityUnit,
  lgmng AS ActualDeliveredQtyInBaseUnit,
  meins AS BaseUnit,
  umvkn AS DeliveryToBaseQuantityDnmntr,
  umvkz AS DeliveryToBaseQuantityNmrtr,
  mbdat AS ProductAvailabilityDate,
  mbuhr AS ProductAvailabilityTime,
  grkor AS DeliveryGroup,
  brgew AS ItemGrossWeight,
  ntgew AS ItemNetWeight,
  gewei AS ItemWeightUnit,
  volum AS ItemVolume,
  voleh AS ItemVolumeUnit,
  qplos AS InspectionLot,
  qtlos AS InspectionPartialLot,
  kztlf AS PartialDeliveryIsAllowed,
  uebtk AS UnlimitedOverdeliveryIsAllowed,
  uebto AS OverdelivTolrtdLmtRatioInPct,
  untto AS UnderdelivTolrtdLmtRatioInPct,
  lgpbe AS WarehouseStorageBin,
  sernr AS BOMExplosion,
  aeskd AS CustEngineeringChgStatus,
  lgbzo AS WarehouseStagingArea,
  bestq AS WarehouseStockCategory,
  umbsq AS IssgOrRcvgStockCategory,
  ummat AS IssgOrRcvgMaterial,
  umwrk AS IssuingOrReceivingPlant,
  umlgo AS IssuingOrReceivingStorageLoc,
  umcha AS IssgOrRcvgBatch,
  umbar AS IssgOrRcvgValuationType,
  umsok AS IssgOrRcvgSpclStockInd,
  umresource_id AS IssgOrRcvgResourceID,
  shkzg_um AS PrimaryPostingSwitch,
  insmk AS StockType,
  nowab AS IsNotGoodsMovementsRelevant,
  konto AS GLAccount,
  grund AS GoodsMovementReasonCode,
  fobwa AS SubsequentMovementType,
  spe_gen_elikz AS IsCompletelyDelivered,
  spe_alternate AS AlternateProductNumber,
  kcmeng AS CumulativeBatchQtyInBaseUnit,
  komkz AS PickingControl,
  ladgr AS LoadingGroup,
  bwart AS GoodsMovementType,
  tragr AS TransportationGroup,
  empst AS ReceivingPoint,
  vbeaf AS FixedShipgProcgDurationInDays,
  vbeav AS VarblShipgProcgDurationInDays,
  podrel AS ProofOfDeliveryRelevanceCode,
  fkrel AS ItemIsBillingRelevant,
  faksp AS ItemBillingBlockReason,
  abfor AS PaymentGuaranteeForm,
  gsber AS BusinessArea,
  kokrs AS ControllingArea,
  cast( paobjnr as rkeobjnr_char ) AS ProfitabilitySegment_2,
  prctr AS ProfitCenter,
  bwtar AS InventoryValuationType,
  bwtex AS IsSeparateValuation,
  kzvbr AS ConsumptionPosting,
  aufnr AS OrderID,
  posnr_pp AS OrderItem,
  kostl AS CostCenter,
  lifexpos AS DeliveryDocumentItemBySupplier,
  vgbel AS ReferenceSDDocument,
  vgpos AS ReferenceSDDocumentItem,
  vgtyp AS ReferenceSDDocumentCategory,
  vgsys AS ReferenceDocumentLogicalSystem,
  kvgr1 AS AdditionalCustomerGroup1,
  kvgr2 AS AdditionalCustomerGroup2,
  kvgr3 AS AdditionalCustomerGroup3,
  kvgr4 AS AdditionalCustomerGroup4,
  kvgr5 AS AdditionalCustomerGroup5,
  aktnr AS RetailPromotion,
  stadat AS StatisticsDate,
  abrli AS IntDeliveryScheduleNumber,
  abart AS SchedulingAgreementReleaseType,
  gbsta AS SDProcessStatus,
  koqua AS PickingConfirmationStatus,
  kosta AS PickingStatus,
  lvsta AS WarehouseActivityStatus,
  pksta AS PackingStatus,
  wbsta AS GoodsMovementStatus,
  fksta AS DeliveryRelatedBillingStatus,
  pdsta AS ProofOfDeliveryStatus,
  uvall AS ItemGeneralIncompletionStatus,
  uvvlk AS ItemDeliveryIncompletionStatus,
  uvpik AS ItemPickingIncompletionStatus,
  uvwak AS ItemGdsMvtIncompletionSts,
  uvpak AS ItemPackingIncompletionStatus,
  uvfak AS ItemBillingIncompletionStatus,
  arc_status AS EU_DeliveryItemARCStatus,
  sgt_rcat AS RequirementSegment,
  sgt_scat AS StockSegment,
  fsh_season_year AS ProductSeasonYear,
  fsh_season AS ProductSeason,
  fsh_collection AS ProductCollection,
  fsh_theme AS ProductTheme,
  wrf_charstc1 AS ProductCharacteristic1,
  wrf_charstc2 AS ProductCharacteristic2,
  wrf_charstc3 AS ProductCharacteristic3,
  fsh_vas_rel AS ItemHasValueAddedService,
  fsh_vas_prnt_id AS ValAddedSrvcParentItmNumber,
  fsh_transaction AS ValAddedSrvcTransactionNumber,
  fsh_item_group AS ValAddedSrvcItemGroup,
  fsh_item AS ValAddedSrvcItemNumber,
  vbelv AS OriginSDDocument,
  posnv AS SDDocumentItem,
  vbtyv AS SalesSDDocumentCategory,
  mtart AS MaterialTypePrimary,
  wavwr AS CostInDocumentCurrency,
  kzwi1 AS Subtotal1Amount,
  kzwi2 AS Subtotal2Amount,
  kzwi3 AS Subtotal3Amount,
  kzwi4 AS Subtotal4Amount,
  kzwi5 AS Subtotal5Amount,
  kzwi6 AS Subtotal6Amount,
  kdauf AS OrderDocument,
  vpmat AS PlanningMaterial,
  vpwrk AS PlanningPlant,
  prbme AS ProductGroupBaseUnit,
  umref AS ConversionFactor,
  shkzg AS ReturnsDeliveryItemCode,
  kmein AS ConditionUnit,
  netpr AS NetPriceAmount,
  netwr AS TotalNetAmount,
  bpmng AS QtyInPurchaseOrderPriceUnit,
  cmpre_flt AS CreditRelatedPrice,
  cast( round( fltp_to_dec( cmpre_flt as abap.dec(31,14) ), 2 ) as cmpre ) AS CreditRelatedPriceAmount,
  umrev AS DeliveryToBaseUnitCnvrsnFctr,
  fkber AS FunctionalArea,
  fsh_rsnum AS RFMReservation,
  fsh_rspos AS RFMReservationItem,
  rsnum AS Reservation,
  rspos AS ReservationItem,
  rsart AS ReservationRecordType,
  pcsta AS ChmlCmplncStatus,
  dgsta AS DangerousGoodsStatus,
  sdssta AS SafetyDataSheetStatus,
  emcst AS TrdCmplncEmbargoSts,
  slcst AS TrdCmplncSnctndListChkSts,
  lccst AS TrdCmplncLegalControlSts,
  uepvw AS HigherLevelItemUsage,
  flpkz AS FldLogsStatus,
  knumh_ch AS BatchSearchStrategy,
  vcm_chain_uuid AS ValueChainInstanceChar32UUID,
  vcm_chain_category AS ValueChainCategory,
  ico_vgtyp AS IntcoRefSDDocumentCategory,
  ico_vgbel AS IntcoRefSDDocument,
  ico_vgpos AS IntcoRefSDDocumentItem,
  lips.service_doc_type AS ServiceDocumentType,
  lips.service_doc_id AS ServiceDocument,
  lips.service_doc_item_id AS ServiceDocumentItem,
  cast ( ps_psp_pnr as ps_s4_pspnr preserving type ) AS WBSElementInternalID
FROM lips
LEFT OUTER JOIN I_DeliveryDocument AS _DeliveryDocument ON DeliveryDocument = _DeliveryDocument.DeliveryDocument  -- association [1..1]
LEFT OUTER JOIN I_SDDocumentItemPartner AS _Partner ON DeliveryDocument = _Partner.SDDocument AND DeliveryDocumentItem = _Partner.SDDocumentItem  -- association [0..*]
LEFT OUTER JOIN I_SDDocumentCategory AS _SDDocumentCategory ON sddocumentcategory = _SDDocumentCategory.SDDocumentCategory  -- association [0..1]
LEFT OUTER JOIN I_SalesDocumentItemCategory AS _ItemCategory ON DeliveryDocumentItemCategory = _ItemCategory.SalesDocumentItemCategory  -- association [0..1]
LEFT OUTER JOIN I_SalesDocumentItemType AS _SalesDocumentItemType ON SalesDocumentItemType = _SalesDocumentItemType.SalesDocumentItemType  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_DistributionChannel AS _DistributionChannel ON DistributionChannel = _DistributionChannel.DistributionChannel  -- association [0..1]
LEFT OUTER JOIN I_Division AS _Division ON Division = _Division.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_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_ProductHierarchyNode AS _ProductHierarchyNode ON ProductHierarchyNode = _ProductHierarchyNode.ProductHierarchyNode  -- 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_MaterialFreightGroup AS _MaterialFreightGroup ON MaterialFreightGroup = _MaterialFreightGroup.MaterialFreightGroup  -- 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_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_Warehouse AS _Warehouse ON Warehouse = _Warehouse.Warehouse  -- 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_InventorySpecialStockType AS _InventorySpecialStockType ON InventorySpecialStockType = _InventorySpecialStockType.InventorySpecialStockType  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _DeliveryQuantityUnit ON DeliveryQuantityUnit = _DeliveryQuantityUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BaseUnit ON BaseUnit = _BaseUnit.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_BOMExplosionDate AS _BOMExplosion ON BOMExplosion = _BOMExplosion.BOMExplosionDateID  -- association [0..1]
LEFT OUTER JOIN I_WarehouseStagingArea AS _WarehouseStagingArea ON Warehouse = _WarehouseStagingArea.Warehouse AND WarehouseStagingArea = _WarehouseStagingArea.WarehouseStagingArea  -- association [0..1]
LEFT OUTER JOIN I_PickingControl AS _PickingControl ON PickingControl = _PickingControl.PickingControl  -- association [0..1]
LEFT OUTER JOIN I_LoadingGroup AS _LoadingGroup ON LoadingGroup = _LoadingGroup.LoadingGroup  -- association [0..1]
LEFT OUTER JOIN I_GoodsMovementType AS _GoodsMovementType ON GoodsMovementType = _GoodsMovementType.GoodsMovementType  -- association [0..1]
LEFT OUTER JOIN I_TransportationGroup AS _TransportationGroup ON TransportationGroup = _TransportationGroup.TransportationGroup  -- 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_PaymentGuaranteeForm AS _PaymentGuaranteeForm ON PaymentGuaranteeForm = _PaymentGuaranteeForm.PaymentGuaranteeForm  -- association [0..1]
LEFT OUTER JOIN I_BusinessArea AS _BusinessArea ON BusinessArea = _BusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenter AS _ProfitCenter ON ProfitCenter = _ProfitCenter.ProfitCenter AND ControllingArea = _ProfitCenter.ControllingArea AND _ProfitCenter.ValidityEndDate >= CreationDate AND _ProfitCenter.ValidityStartDate <= CreationDate  -- association [0..1]
LEFT OUTER JOIN I_InventoryValuationType AS _InventoryValuationType ON InventoryValuationType = _InventoryValuationType.InventoryValuationType  -- association [0..1]
LEFT OUTER JOIN I_MfgOrder AS _OrderID ON OrderID = _OrderID.ManufacturingOrder  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _CostCenter ON CostCenter = _CostCenter.CostCenter AND ControllingArea = _CostCenter.ControllingArea AND _CostCenter.ValidityEndDate >= CreationDate AND _CostCenter.ValidityStartDate <= CreationDate  -- association [0..1]
LEFT OUTER JOIN I_SalesDocument AS _ReferenceSDDocument ON ReferenceSDDocument = _ReferenceSDDocument.SalesDocument  -- association [0..1]
LEFT OUTER JOIN I_SalesDocumentItem AS _ReferenceSalesDocumentItem ON ReferenceSDDocument = _ReferenceSalesDocumentItem.SalesDocument AND ReferenceSDDocumentItem = _ReferenceSalesDocumentItem.SalesDocumentItem AND ( ReferenceSDDocumentCategory = 'C' OR ReferenceSDDocumentCategory = 'H' )  -- association [0..1]
LEFT OUTER JOIN I_PurchaseOrderAPI01 AS _PurchaseOrder ON PurchaseOrder = _PurchaseOrder.PurchaseOrder  -- association [0..1]
LEFT OUTER JOIN I_PurchaseOrderItemAPI01 AS _PurchaseOrderItem ON PurchaseOrder = _PurchaseOrderItem.PurchaseOrder AND PurchaseOrderItem = _PurchaseOrderItem.PurchaseOrderItem  -- association [0..1]
LEFT OUTER JOIN I_SDDocumentCategory AS _ReferenceSDDocumentCategory ON ReferenceSDDocumentCategory = _ReferenceSDDocumentCategory.SDDocumentCategory  -- association [0..1]
LEFT OUTER JOIN I_SalesDocument AS _IntcoRefSDDocument ON IntcoRefSDDocument = _IntcoRefSDDocument.SalesDocument  -- association [0..1]
LEFT OUTER JOIN I_SalesDocumentItem AS _IntcoRefSDDocumentItem ON IntcoRefSDDocument = _IntcoRefSDDocumentItem.SalesDocument AND IntcoRefSDDocumentItem = _IntcoRefSDDocumentItem.SalesDocumentItem AND ( IntcoRefSDDocumentCategory = 'C' OR IntcoRefSDDocumentCategory = 'H' )  -- association [0..1]
LEFT OUTER JOIN I_SDDocumentCategory AS _IntcoRefSDDocumentCategory ON IntcoRefSDDocumentCategory = _IntcoRefSDDocumentCategory.SDDocumentCategory  -- association [0..1]
LEFT OUTER JOIN I_LogicalSystem AS _LogicalSystem ON ReferenceDocumentLogicalSystem = _LogicalSystem.LogicalSystem  -- 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_SDProcessStatus AS _SDProcessStatus ON SDProcessStatus = _SDProcessStatus.SDProcessStatus  -- association [0..1]
LEFT OUTER JOIN I_PickingConfirmationStatus AS _PickingConfirmationStatus ON PickingConfirmationStatus = _PickingConfirmationStatus.PickingConfirmationStatus  -- association [0..1]
LEFT OUTER JOIN I_PickingStatus AS _PickingStatus ON PickingStatus = _PickingStatus.PickingStatus  -- association [0..1]
LEFT OUTER JOIN I_WarehouseActivityStatus AS _WarehouseActivityStatus ON WarehouseActivityStatus = _WarehouseActivityStatus.WarehouseActivityStatus  -- association [0..1]
LEFT OUTER JOIN I_PackingStatus AS _PackingStatus ON PackingStatus = _PackingStatus.PackingStatus  -- association [0..1]
LEFT OUTER JOIN I_GoodsMovementStatus AS _GoodsMovementStatus ON GoodsMovementStatus = _GoodsMovementStatus.GoodsMovementStatus  -- association [0..1]
LEFT OUTER JOIN I_DeliveryRelatedBillgStatus AS _DeliveryRelatedBillingStatus ON DeliveryRelatedBillingStatus = _DeliveryRelatedBillingStatus.DeliveryRelatedBillingStatus  -- association [0..1]
LEFT OUTER JOIN I_DeliveryRelatedBillgStatus AS _IntercompanyBillingStatus ON IntercompanyBillingStatus = _IntercompanyBillingStatus.DeliveryRelatedBillingStatus  -- association [0..1]
LEFT OUTER JOIN I_ProofOfDeliveryStatus AS _ProofOfDeliveryStatus ON ProofOfDeliveryStatus = _ProofOfDeliveryStatus.ProofOfDeliveryStatus  -- association [0..1]
LEFT OUTER JOIN I_ItemGenIncompletionStatus AS _ItemGeneralIncompletionStatus ON ItemGeneralIncompletionStatus = _ItemGeneralIncompletionStatus.ItemGeneralIncompletionStatus  -- association [0..1]
LEFT OUTER JOIN I_ItemDelivIncompletionSts AS _ItemDelivIncompletionSts ON ItemDeliveryIncompletionStatus = _ItemDelivIncompletionSts.ItemDeliveryIncompletionStatus  -- association [0..1]
LEFT OUTER JOIN I_ItemPickingIncompletionSts AS _ItemPickingIncompletionStatus ON ItemPickingIncompletionStatus = _ItemPickingIncompletionStatus.ItemPickingIncompletionStatus  -- association [0..1]
LEFT OUTER JOIN I_ItemGdsMvtIncompletionSts AS _ItemGdsMvtIncompletionSts ON ItemGdsMvtIncompletionSts = _ItemGdsMvtIncompletionSts.ItemGdsMvtIncompletionSts  -- association [0..1]
LEFT OUTER JOIN I_ItemPackingIncompletionSts AS _ItemPackingIncompletionStatus ON ItemPackingIncompletionStatus = _ItemPackingIncompletionStatus.ItemPackingIncompletionStatus  -- association [0..1]
LEFT OUTER JOIN I_ItemBillingIncompletionSts AS _ItemBillingIncompletionStatus ON ItemBillingIncompletionStatus = _ItemBillingIncompletionStatus.ItemBillingIncompletionStatus  -- association [0..1]
LEFT OUTER JOIN I_StockType AS _StockType ON StockType = _StockType.StockType  -- association [0..1]
LEFT OUTER JOIN I_StockType_2 AS _StockType_2 ON StockType = _StockType_2.StockType  -- association [0..1]
LEFT OUTER JOIN I_StockCategory AS _StockCategory ON WarehouseStockCategory = _StockCategory.WarehouseStockCategory  -- association [0..1]
LEFT OUTER JOIN I_DelivChmlCmplncStatus AS _ChmlCmplncStatus ON ChmlCmplncStatus = _ChmlCmplncStatus.ChmlCmplncStatus  -- association [0..1]
LEFT OUTER JOIN I_DelivDangerousGoodsStatus AS _DangerousGoodsStatus ON DangerousGoodsStatus = _DangerousGoodsStatus.DangerousGoodsStatus  -- association [0..1]
LEFT OUTER JOIN I_DelivSafetyDataSheetSts 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_TrdCmplncCheckStatus AS _TrdCmplncLegalControlSts ON TrdCmplncLegalControlSts = _TrdCmplncLegalControlSts.TrdCmplncCheckStatus  -- association [0..1]
LEFT OUTER JOIN I_ExciseTaxStatus AS _ExciseTaxStatus ON EU_DeliveryItemARCStatus = _ExciseTaxStatus.EU_ARCStatus  -- association [0..1]
LEFT OUTER JOIN I_Batch AS _Batch ON Batch = _Batch.Batch AND Material = _Batch.Material AND Plant = _Batch.Plant  -- association [0..1]
LEFT OUTER JOIN I_SchedgAgrmtRelType AS _SchedgAgrmtRelType ON SchedulingAgreementReleaseType = _SchedgAgrmtRelType.SchedulingAgreementReleaseType  -- association [0..1]
LEFT OUTER JOIN I_ValueChainCategory AS _ValueChainCategory ON ValueChainCategory = _ValueChainCategory.ValueChainCategory  -- association [0..1]
LEFT OUTER JOIN I_FieldLogisticsIndicator AS _FieldLogisticsIndicator ON FldLogsStatus = _FieldLogisticsIndicator.FldLogsStatus  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementBasicData ON WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_ServiceDocumentType AS _ServiceDocumentType ON ServiceDocumentType = _ServiceDocumentType.ServiceDocumentType  -- association [0..1]
LEFT OUTER JOIN E_DeliveryDocumentItem AS _Extension ON DeliveryDocument = _Extension.DeliveryDocument AND DeliveryDocumentItem = _Extension.DeliveryDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_HigherLevelItemUsage AS _HigherLevelItemUsage ON HigherLevelItemUsage = _HigherLevelItemUsage.HigherLevelItemUsage  -- association [0..1]
;