I_DeliveryDocumentItemCube

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_DeliveryDocumentItemCube.
-- 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: ILEDELIVDOCITEMC
-- Parameters: P_ExchangeRateType : kurst, P_DisplayCurrency : vdm_v_display_currency

CREATE VIEW I_DeliveryDocumentItemCube AS
SELECT
  DeliveryDocument,
  DeliveryDocumentItem,
  _DeliveryDocument.DeliveryDocumentType AS DeliveryDocumentType,
  _DeliveryDocument._DeliveryDocumentType AS _DeliveryDocumentType,
  DeliveryDocumentItemCategory,
  SalesDocumentItemType,
  CreatedByUser,
  _CreatedByUser.UserDescription AS CreatedByUserName,
  CreationDate,
  CreationTime,
  LastChangeDate,
  SalesOrganization,
  DistributionChannel,
  Division,
  SalesGroup,
  SalesOffice,
  Material,
  MaterialByCustomer,
  OriginallyRequestedMaterial,
  InternationalArticleNumber,
  Batch,
  BatchClassification,
  BatchBySupplier,
  MaterialIsIntBatchManaged,
  MaterialIsBatchManaged,
  MaterialGroup,
  Plant,
  _Plant.PlantName AS PlantName,
  StorageLocation,
  _StorageLocation.StorageLocationName AS StorageLocationName,
  Warehouse,
  StorageBin,
  StorageType,
  InventorySpecialStockType,
  ShelfLifeExpirationDate,
  NumberOfSerialNumbers,
  ProductConfiguration,
  ProductHierarchyNode,
  ManufactureDate,
  _DeliveryDocument.SoldToParty AS SoldToParty,
  _DeliveryDocument._SoldToParty AS _SoldToParty,
  cast(_DeliveryDocument._SoldToParty.CustomerName as vdm_sold_to_name) AS SoldToPartyName,
  _DeliveryDocument.ShipToParty AS ShipToParty,
  _DeliveryDocument._ShipToParty AS _ShipToParty,
  cast(_DeliveryDocument._ShipToParty.CustomerName as ship_to_name) AS ShipToPartyName,
  _DeliveryDocument.CustomerGroup AS CustomerGroup,
  _DeliveryDocument._CustomerGroup AS _CustomerGroup,
  _DeliveryDocument._SoldToParty.CustomerClassification AS SoldToPartyClassification,
  DeliveryDocumentItemText,
  ActualDeliveryQuantity,
  OriginalDeliveryQuantity,
  DeliveryQuantityUnit,
  ActualDeliveredQtyInBaseUnit,
  ProductAvailabilityDate,
  ProductAvailabilityTime,
  DeliveryGroup,
  _DeliveryDocument.DeliveryDate AS DeliveryDate,
  _DeliveryDocument.DeliveryBlockReason AS DeliveryBlockReason,
  _DeliveryDocument.PlannedGoodsIssueDate AS PlannedGoodsIssueDate,
  _DeliveryDocument.GoodsIssueTime AS GoodsIssueTime,
  _DeliveryDocument.ActualGoodsMovementDate AS ActualGoodsMovementDate,
  _DeliveryDocument.ActualGoodsMovementTime AS ActualGoodsMovementTime,
  ItemGrossWeight,
  ItemNetWeight,
  ItemWeightUnit,
  ItemVolume,
  ItemVolumeUnit,
  InspectionLot,
  InspectionPartialLot,
  PartialDeliveryIsAllowed,
  UnlimitedOverdeliveryIsAllowed,
  OverdelivTolrtdLmtRatioInPct,
  UnderdelivTolrtdLmtRatioInPct,
  WarehouseStorageBin,
  TransactionCurrency,
  OpnOutbDelivsForInvcNetAmt,
  cast(:P_DisplayCurrency as vdm_v_display_currency) AS DisplayCurrency,
  OpnOutbDelivsForInvcQty,
  BaseUnit,
  PickingControl,
  LoadingGroup,
  GoodsMovementType,
  TransportationGroup,
  ReceivingPoint,
  FixedShipgProcgDurationInDays,
  VarblShipgProcgDurationInDays,
  ProofOfDeliveryRelevanceCode,
  _DeliveryDocument.ShippingPoint AS ShippingPoint,
  _DeliveryDocument._ShippingPoint AS _ShippingPoint,
  ItemIsBillingRelevant,
  cast(ItemBillingBlockReason as billing_block_reason_item preserving type) AS ItemBillingBlockReason,
  PaymentGuaranteeForm,
  IntercompanyBillingStatus,
  BusinessArea,
  ControllingArea,
  ProfitabilitySegment,
  ProfitCenter,
  InventoryValuationType,
  IsSeparateValuation,
  ConsumptionPosting,
  OrderID,
  OrderItem,
  CostCenter,
  ReferenceSDDocument,
  ReferenceSDDocumentItem,
  ReferenceSDDocumentCategory,
  ReferenceDocumentLogicalSystem,
  cast(SDProcessStatus as sd_doc_process_status preserving type) AS SDProcessStatus,
  PickingConfirmationStatus,
  PickingStatus,
  WarehouseActivityStatus,
  PackingStatus,
  GoodsMovementStatus,
  DeliveryRelatedBillingStatus,
  ProofOfDeliveryStatus,
  ItemGeneralIncompletionStatus,
  ItemDeliveryIncompletionStatus,
  ItemPickingIncompletionStatus,
  ItemGdsMvtIncompletionSts,
  ItemPackingIncompletionStatus,
  ItemBillingIncompletionStatus
FROM I_DeliveryDocItemAnalytics AS DDIA
LEFT OUTER JOIN I_DeliveryDocument AS _DeliveryDocument ON DeliveryDocument = _DeliveryDocument.DeliveryDocument  -- association [1..1]
;