I_InboundDeliveryItem

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_InboundDeliveryItem.
-- 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: ILEINBDELIVITM

CREATE VIEW I_InboundDeliveryItem AS
SELECT
  DeliveryDocument AS InboundDelivery,
  DeliveryDocumentItem AS InboundDeliveryItem,
  HigherLvlItmOfBatSpltItm,
  DeliveryDocumentItemCategory,
  SalesDocumentItemType,
  CreatedByUser,
  CreationDate,
  CreationTime,
  LastChangeDate,
  DistributionChannel,
  Division,
  SalesGroup,
  SalesOffice,
  DepartmentClassificationByCust,
  Material,
  MaterialByCustomer,
  OriginallyRequestedMaterial,
  InternationalArticleNumber,
  Batch,
  BatchClassification,
  BatchBySupplier,
  MaterialIsIntBatchManaged,
  MaterialIsBatchManaged,
  MaterialGroup,
  MaterialFreightGroup,
  AdditionalMaterialGroup1,
  AdditionalMaterialGroup2,
  AdditionalMaterialGroup3,
  AdditionalMaterialGroup4,
  AdditionalMaterialGroup5,
  Plant,
  Warehouse,
  StorageLocation,
  StorageBin,
  StorageType,
  InventorySpecialStockType,
  ShelfLifeExpirationDate,
  NumberOfSerialNumbers,
  ProductConfiguration,
  ProductHierarchyNode,
  ManufactureDate,
  DeliveryDocumentItemText,
  HigherLevelItem,
  ActualDeliveryQuantity,
  QuantityIsFixed,
  OriginalDeliveryQuantity,
  DeliveryQuantityUnit,
  ActualDeliveredQtyInBaseUnit,
  BaseUnit,
  DeliveryToBaseQuantityDnmntr,
  DeliveryToBaseQuantityNmrtr,
  ProductAvailabilityDate,
  ProductAvailabilityTime,
  DeliveryGroup,
  ItemGrossWeight,
  ItemNetWeight,
  ItemWeightUnit,
  ItemVolume,
  ItemVolumeUnit,
  InspectionLot,
  InspectionPartialLot,
  PartialDeliveryIsAllowed,
  UnlimitedOverdeliveryIsAllowed,
  OverdelivTolrtdLmtRatioInPct,
  UnderdelivTolrtdLmtRatioInPct,
  BOMExplosion,
  WarehouseStagingArea,
  WarehouseStockCategory,
  StockType,
  GLAccount,
  GoodsMovementReasonCode,
  SubsequentMovementType,
  IsCompletelyDelivered,
  IsNotGoodsMovementsRelevant,
  PickingControl,
  LoadingGroup,
  GoodsMovementType,
  LoadingPointForDelivery,
  TransportationGroup,
  ReceivingPoint,
  FixedShipgProcgDurationInDays,
  VarblShipgProcgDurationInDays,
  ProofOfDeliveryRelevanceCode,
  ItemIsBillingRelevant,
  ItemBillingBlockReason,
  BusinessArea,
  ControllingArea,
  cast( case when ProfitabilitySegment_2 > '9999999999' then '9999999999' else lpad( ProfitabilitySegment_2, 10, '0' ) end as rkeobjnr_numc ) AS ProfitabilitySegment,
  ProfitabilitySegment_2,
  ProfitCenter,
  InventoryValuationType,
  IsSeparateValuation,
  ConsumptionPosting,
  OrderID,
  OrderItem,
  CostCenter,
  ReferenceSDDocument,
  ReferenceSDDocumentItem,
  ReferenceSDDocumentCategory,
  ReferenceDocumentLogicalSystem,
  PurchaseOrder,
  PurchaseOrderItem,
  AdditionalCustomerGroup1,
  AdditionalCustomerGroup2,
  AdditionalCustomerGroup3,
  AdditionalCustomerGroup4,
  AdditionalCustomerGroup5,
  RetailPromotion,
  SDProcessStatus,
  PickingConfirmationStatus,
  PickingStatus,
  PickingStatus AS PutawayStatus,
  WarehouseActivityStatus,
  PackingStatus,
  GoodsMovementStatus,
  DeliveryRelatedBillingStatus,
  ProofOfDeliveryStatus,
  ItemGeneralIncompletionStatus,
  ItemDeliveryIncompletionStatus,
  ItemPickingIncompletionStatus,
  ItemGdsMvtIncompletionSts,
  ItemPackingIncompletionStatus,
  ItemBillingIncompletionStatus,
  IntercompanyBillingStatus,
  TrdCmplncEmbargoSts,
  TrdCmplncSnctndListChkSts,
  TrdCmplncLegalControlSts,
  StockSegment,
  ProductSeasonYear,
  ProductSeason,
  ProductCollection,
  ProductTheme,
  ProductCharacteristic1,
  ProductCharacteristic2,
  ProductCharacteristic3,
  OriginSDDocument,
  SDDocumentItem,
  SalesSDDocumentCategory,
  MaterialTypePrimary,
  CostInDocumentCurrency,
  Subtotal1Amount,
  Subtotal2Amount,
  Subtotal3Amount,
  Subtotal4Amount,
  Subtotal5Amount,
  Subtotal6Amount,
  OrderDocument,
  PlanningMaterial,
  PlanningPlant,
  ProductGroupBaseUnit,
  ConversionFactor,
  IsReturnsItem,
  ConditionUnit,
  NetPriceAmount,
  TotalNetAmount,
  QtyInPurchaseOrderPriceUnit,
  CreditRelatedPrice,
  CreditRelatedPriceAmount,
  DeliveryToBaseUnitCnvrsnFctr,
  FunctionalArea,
  _InboundDelivery.TransactionCurrency AS TransactionCurrency,
  FldLogsStatus
FROM I_DeliveryDocumentItem
LEFT OUTER JOIN I_InboundDelivery AS _InboundDelivery ON InboundDelivery = _InboundDelivery.InboundDelivery  -- association [1..1]
LEFT OUTER JOIN I_PutawayStatus AS _PutawayStatus ON PutawayStatus = _PutawayStatus.PutawayStatus  -- association [0..1]
LEFT OUTER JOIN I_SDDocumentItemPartner AS _Partner ON InboundDelivery = _Partner.SDDocument AND InboundDeliveryItem = _Partner.SDDocumentItem  -- association [0..*]
LEFT OUTER JOIN I_FldLogsDelivRefLinkInfo AS _FldLogsDelivRefLinkInfo ON InboundDelivery = _FldLogsDelivRefLinkInfo.DeliveryDocument AND InboundDeliveryItem = _FldLogsDelivRefLinkInfo.DeliveryDocumentItem  -- association [0..1]
LEFT OUTER JOIN E_DeliveryDocumentItem AS _Extension ON InboundDelivery = _Extension.DeliveryDocument AND InboundDeliveryItem = _Extension.DeliveryDocumentItem  -- association [0..1]
;