C_InboundDeliveryItemManage

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 C_InboundDeliveryItemManage.
-- 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 C_InboundDeliveryItemManage AS
SELECT *  -- field list not available in parsed metadata
FROM R_InboundDeliveryItemTP
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_MaterialStdVH AS _Material ON Material = _Material.Material  -- association [0..1]
LEFT OUTER JOIN I_PlantStdVH 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_MaterialGroup AS _MaterialGroup ON MaterialGroup = _MaterialGroup.MaterialGroup  -- association [0..1]
LEFT OUTER JOIN I_MaterialStdVH AS _OriginallyRequestedMaterial ON OriginallyRequestedMaterial = _OriginallyRequestedMaterial.Material  -- 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 C_PutawayStatus_F7286 AS _PutawayStatus ON PutawayStatus = _PutawayStatus.PutawayStatus  -- association [0..1]
LEFT OUTER JOIN I_WarehouseActivityStatus AS _WarehouseActivityStatus ON WarehouseActivityStatus = _WarehouseActivityStatus.WarehouseActivityStatus  -- association [0..1]
LEFT OUTER JOIN I_PickingConfirmationStatus AS _PutawayConfirmationStatus ON PutawayConfirmationStatus = _PutawayConfirmationStatus.PickingConfirmationStatus  -- 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_ProofOfDeliveryStatus AS _ProofOfDeliveryStatus ON ProofOfDeliveryStatus = _ProofOfDeliveryStatus.ProofOfDeliveryStatus  -- 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_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 _ItemPutawayIncompletionStatus ON ItemPutawayIncompletionStatus = _ItemPutawayIncompletionStatus.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_WarehouseStagingArea AS _WarehouseStagingArea ON Warehouse = _WarehouseStagingArea.Warehouse AND WarehouseStagingArea = _WarehouseStagingArea.WarehouseStagingArea  -- association [0..1]
LEFT OUTER JOIN I_StockCategory AS _StockCategory ON WarehouseStockCategory = _StockCategory.WarehouseStockCategory  -- association [0..1]
LEFT OUTER JOIN I_LoadingGroup AS _LoadingGroup ON LoadingGroup = _LoadingGroup.LoadingGroup  -- association [0..1]
LEFT OUTER JOIN I_TransportationGroup AS _TransportationGroup ON TransportationGroup = _TransportationGroup.TransportationGroup  -- association [0..1]
LEFT OUTER JOIN I_MaterialFreightGroup AS _MaterialFreightGroup ON MaterialFreightGroup = _MaterialFreightGroup.MaterialFreightGroup  -- association [0..1]
LEFT OUTER JOIN I_BillingRelevanceCode AS _BillingRelevanceCode ON BillingRelevanceCode = _BillingRelevanceCode.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_MfgOrder AS _ManufacturingOrder ON ManufacturingOrder = _ManufacturingOrder.ManufacturingOrder  -- association [0..1]
LEFT OUTER JOIN I_InventoryValuationType AS _InventoryValuationType ON InventoryValuationType = _InventoryValuationType.InventoryValuationType  -- 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_SDDocumentCategory AS _ReferenceSDDocumentCategory ON ReferenceSDDocumentCategory = _ReferenceSDDocumentCategory.SDDocumentCategory  -- association [0..1]
LEFT OUTER JOIN I_PurchaseOrder AS _ReferenceSDDocument ON ReferenceSDDocument = _ReferenceSDDocument.PurchaseOrder  -- 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_LogicalSystem AS _RefDocumentLogicalSystem ON ReferenceDocumentLogicalSystem = _RefDocumentLogicalSystem.LogicalSystem  -- association [0..1]
LEFT OUTER JOIN I_SalesDocumentItemType AS _SalesDocumentItemType ON SalesDocumentItemType = _SalesDocumentItemType.SalesDocumentItemType  -- 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_SalesDocumentItemCategory AS _ItemCategory ON DeliveryDocumentItemCategory = _ItemCategory.SalesDocumentItemCategory  -- association [0..1]
LEFT OUTER JOIN I_GoodsMovementType AS _GoodsMovementType ON GoodsMovementType = _GoodsMovementType.GoodsMovementType  -- association [0..1]
LEFT OUTER JOIN I_StockType_2 AS _StockType_2 ON InventoryUsabilityCode = _StockType_2.StockType  -- association [0..1]
LEFT OUTER JOIN I_InventorySpecialStockType AS _InventorySpecialStockType ON InventorySpecialStockType = _InventorySpecialStockType.InventorySpecialStockType  -- 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 _DeliveryItemProcessStatus ON DeliveryItemProcessStatus = _DeliveryItemProcessStatus.SDProcessStatus  -- association [0..1]
LEFT OUTER JOIN I_ConsumptionPosting AS _ConsumptionPosting ON ConsumptionPosting = _ConsumptionPosting.ConsumptionPosting  -- association [0..1]
;