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 *  -- field list not available in parsed metadata
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]
;