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
  InboundDelivery,
  InboundDeliveryItem,
  ActualDeliveredQtyInBaseUnit,
  OrderQuantityUnit,
  ActualDeliveredQtyInOrderUnit,
  PutawayQuantityInBaseUnit,
  PutawayQuantityInOrderUnit,
  QuantityIsFixed,
  OriginalDeliveryQuantity,
  BaseUnit,
  DeliveryToBaseQuantityDnmntr,
  DeliveryToBaseQuantityNmrtr,
  ItemGrossWeight,
  ItemNetWeight,
  ItemWeightUnit,
  ItemVolume,
  ItemVolumeUnit,
  PutawayStatus,
  WarehouseActivityStatus,
  PutawayConfirmationStatus,
  PackingStatus,
  GoodsMovementStatus,
  ProofOfDeliveryStatus,
  DeliveryRelatedBillingStatus,
  IntercompanyBillingStatus,
  DeliveryItemProcessStatus,
  ItemGeneralIncompletionStatus,
  ItemDeliveryIncompletionStatus,
  ItemPutawayIncompletionStatus,
  ItemGdsMvtIncompletionSts,
  ItemPackingIncompletionStatus,
  ItemBillingIncompletionStatus,
  IsCompletelyDelivered,
  InspectionLot,
  InspectionPartialLot,
  Material,
  DeliveryDocumentItemText,
  MaterialByCustomer,
  AlternateProductNumber,
  CustEngineeringChgStatus,
  BOMExplosion,
  HigherLevelItem,
  InternationalArticleNumber,
  OriginallyRequestedMaterial,
  MaterialGroup,
  AdditionalMaterialGroup1,
  AdditionalMaterialGroup2,
  AdditionalMaterialGroup3,
  AdditionalMaterialGroup4,
  AdditionalMaterialGroup5,
  Batch,
  MaterialIsBatchManaged,
  ShelfLifeExpirationDate,
  ManufactureDate,
  BatchClassification,
  BatchBySupplier,
  HigherLvlItmOfBatSpltItm,
  NumberOfSerialNumbers,
  ProductConfiguration,
  ProductHierarchyNode,
  Plant,
  StorageLocation,
  StorageBin,
  StorageType,
  Warehouse,
  WarehouseStorageBin,
  WarehouseStagingArea,
  WarehouseStockCategory,
  ProductAvailabilityDate,
  ProductAvailabilityTime,
  LoadingGroup,
  TransportationGroup,
  MaterialFreightGroup,
  FixedShipgProcgDurationInDays,
  VarblShipgProcgDurationInDays,
  ProofOfDeliveryRelevanceCode,
  BillingRelevanceCode,
  ItemBillingBlockReason,
  PaymentGuaranteeForm,
  BusinessArea,
  ControllingArea,
  CostCenter,
  ProfitCenter,
  ManufacturingOrder,
  ManufacturingOrderItem,
  GLAccount,
  InventoryValuationType,
  IsSeparateValuation,
  DepartmentClassificationByCust,
  ReferenceSDDocument,
  ReferenceSDDocumentItem,
  ReferenceSDDocumentCategory,
  ReferenceDocumentLogicalSystem,
  PartialDeliveryIsAllowed,
  UnlimitedOverdeliveryIsAllowed,
  OverdelivTolrtdLmtRatioInPct,
  UnderdelivTolrtdLmtRatioInPct,
  SalesDocumentItemType,
  DistributionChannel,
  Division,
  DeliveryGroup,
  DeliveryDocumentItemCategory,
  GoodsMovementType,
  StockType AS InventoryUsabilityCode,
  IsNotGoodsMovementsRelevant,
  GoodsMovementReasonCode,
  InventorySpecialStockType,
  SubsequentMovementType,
  PrimaryPostingSwitch,
  ConsumptionPosting,
  StatisticsDate,
  AdditionalCustomerGroup1,
  AdditionalCustomerGroup2,
  AdditionalCustomerGroup3,
  AdditionalCustomerGroup4,
  AdditionalCustomerGroup5,
  IssgOrRcvgStockCategory,
  IssgOrRcvgMaterial,
  IssuingOrReceivingPlant,
  IssuingOrReceivingStorageLoc,
  IssgOrRcvgBatch,
  IssgOrRcvgValuationType,
  IssgOrRcvgSpclStockCode,
  cast(CreatedByUser as abp_creation_user preserving type ) AS CreatedByUser,
  cast(CreationDate as abp_creation_date preserving type ) AS CreationDate,
  cast(CreationTime as abp_creation_time preserving type ) AS CreationTime,
  cast(LastChangeDate as abp_lastchange_date preserving type ) AS LastChangeDate
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]
;