I_OutboundDeliveryItem

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_OutboundDeliveryItem.
-- 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: ILEOUTBDELIVITM

CREATE VIEW I_OutboundDeliveryItem AS
SELECT
  cast(DeliveryDocument as outbound_delivery) AS OutboundDelivery,
  cast(DeliveryDocumentItem as outbound_delivery_item) AS OutboundDeliveryItem,
  DeliveryDocumentItemCategory,
  SalesDocumentItemType,
  CreatedByUser,
  CreationDate,
  CreationTime,
  LastChangeDate,
  DistributionChannel,
  Division,
  SalesGroup,
  SalesOffice,
  DepartmentClassificationByCust,
  Material,
  Product,
  MaterialByCustomer,
  OriginallyRequestedMaterial,
  InternationalArticleNumber,
  Batch,
  BatchClassification,
  BatchBySupplier,
  MaterialIsIntBatchManaged,
  MaterialIsBatchManaged,
  MaterialGroup,
  ProductGroup,
  MaterialFreightGroup,
  AdditionalMaterialGroup1,
  AdditionalMaterialGroup2,
  AdditionalMaterialGroup3,
  AdditionalMaterialGroup4,
  AdditionalMaterialGroup5,
  Plant,
  Warehouse,
  StorageLocation,
  StorageBin,
  StorageType,
  DeliveryItemResourceID,
  InventorySpecialStockType,
  ShelfLifeExpirationDate,
  NumberOfSerialNumbers,
  ProductConfiguration,
  ProductHierarchyNode,
  ManufactureDate,
  TransactionCurrency,
  DeliveryDocumentItemText,
  HigherLevelItem,
  HigherLvlItmOfBatSpltItm,
  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,
  WarehouseActivityStatus,
  PackingStatus,
  GoodsMovementStatus,
  DeliveryRelatedBillingStatus,
  ProofOfDeliveryStatus,
  ItemGeneralIncompletionStatus,
  ItemDeliveryIncompletionStatus,
  ItemPickingIncompletionStatus,
  ItemGdsMvtIncompletionSts,
  ItemPackingIncompletionStatus,
  ItemBillingIncompletionStatus,
  IntercompanyBillingStatus,
  ChmlCmplncStatus,
  DangerousGoodsStatus,
  SafetyDataSheetStatus,
  I_DeliveryDocumentItem.TrdCmplncLegalControlSts AS TrdCmplncLegalControlSts,
  I_DeliveryDocumentItem.TrdCmplncEmbargoSts AS TrdCmplncEmbargoSts,
  I_DeliveryDocumentItem.TrdCmplncSnctndListChkSts AS TrdCmplncSnctndListChkSts,
  RequirementSegment,
  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,
  Reservation,
  ReservationItem,
  EU_DeliveryItemARCStatus,
  FldLogsStatus,
  ValueChainInstanceChar32UUID,
  ValueChainCategory,
  IntcoRefSDDocumentCategory,
  IntcoRefSDDocument,
  IntcoRefSDDocumentItem,
  WBSElementInternalID
FROM I_DeliveryDocumentItem
LEFT OUTER JOIN I_OutboundDelivery AS _OutboundDelivery ON OutboundDelivery = _OutboundDelivery.OutboundDelivery  -- association [1..1]
LEFT OUTER JOIN I_SDDocumentItemPartner AS _Partner ON OutboundDelivery = _Partner.SDDocument AND OutboundDeliveryItem = _Partner.SDDocumentItem  -- association [0..*]
LEFT OUTER JOIN I_FldLogsDelivRefLinkInfo AS _FldLogsDelivRefLinkInfo ON OutboundDelivery = _FldLogsDelivRefLinkInfo.DeliveryDocument AND OutboundDeliveryItem = _FldLogsDelivRefLinkInfo.DeliveryDocumentItem  -- association [0..1]
LEFT OUTER JOIN E_DeliveryDocumentItem AS _Extension ON OutboundDelivery = _Extension.DeliveryDocument AND OutboundDeliveryItem = _Extension.DeliveryDocumentItem  -- association [0..1]
;