I_DeliveryDocItemAnalytics

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_DeliveryDocItemAnalytics.
-- 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: ISDDELDOCITMANA

CREATE VIEW I_DeliveryDocItemAnalytics AS
SELECT
  DDI.DeliveryDocument AS DeliveryDocument,
  DDI.DeliveryDocumentItem AS DeliveryDocumentItem,
  DDI.SDDocumentCategory AS SDDocumentCategory,
  DDI.DeliveryDocumentItemCategory AS DeliveryDocumentItemCategory,
  DDI.SalesDocumentItemType AS SalesDocumentItemType,
  DDI.CreatedByUser AS CreatedByUser,
  DDI.CreationDate AS CreationDate,
  DDI.CreationTime AS CreationTime,
  DDI.LastChangeDate AS LastChangeDate,
  DDI._DeliveryDocument.SalesOrganization AS SalesOrganization,
  DDI.DistributionChannel AS DistributionChannel,
  DDI.Division AS Division,
  DDI.SalesGroup AS SalesGroup,
  DDI.SalesOffice AS SalesOffice,
  DDI.DepartmentClassificationByCust AS DepartmentClassificationByCust,
  DDI.Material AS Material,
  DDI.Product AS Product,
  DDI.MaterialByCustomer AS MaterialByCustomer,
  DDI.OriginallyRequestedMaterial AS OriginallyRequestedMaterial,
  DDI.InternationalArticleNumber AS InternationalArticleNumber,
  DDI.Batch AS Batch,
  DDI.BatchClassification AS BatchClassification,
  DDI.BatchBySupplier AS BatchBySupplier,
  DDI.MaterialIsIntBatchManaged AS MaterialIsIntBatchManaged,
  DDI.MaterialIsBatchManaged AS MaterialIsBatchManaged,
  DDI.MaterialGroup AS MaterialGroup,
  DDI.ProductGroup AS ProductGroup,
  DDI.MaterialFreightGroup AS MaterialFreightGroup,
  DDI.AdditionalMaterialGroup1 AS AdditionalMaterialGroup1,
  DDI.AdditionalMaterialGroup2 AS AdditionalMaterialGroup2,
  DDI.AdditionalMaterialGroup3 AS AdditionalMaterialGroup3,
  DDI.AdditionalMaterialGroup4 AS AdditionalMaterialGroup4,
  DDI.AdditionalMaterialGroup5 AS AdditionalMaterialGroup5,
  DDI.Plant AS Plant,
  DDI._Plant.PlantName AS PlantName,
  DDI.StorageLocation AS StorageLocation,
  DDI._StorageLocation.StorageLocationName AS StorageLocationName,
  DDI.Warehouse AS Warehouse,
  DDI.StorageBin AS StorageBin,
  DDI.StorageType AS StorageType,
  DDI.InventorySpecialStockType AS InventorySpecialStockType,
  DDI.ShelfLifeExpirationDate AS ShelfLifeExpirationDate,
  DDI.NumberOfSerialNumbers AS NumberOfSerialNumbers,
  DDI.ProductConfiguration AS ProductConfiguration,
  DDI.ProductHierarchyNode AS ProductHierarchyNode,
  DDI.ManufactureDate AS ManufactureDate,
  DDI.DeliveryDocumentItemText AS DeliveryDocumentItemText,
  DDI.HigherLevelItem AS HigherLevelItem,
  DDI.ActualDeliveryQuantity AS ActualDeliveryQuantity,
  DDI.QuantityIsFixed AS QuantityIsFixed,
  DDI.OriginalDeliveryQuantity AS OriginalDeliveryQuantity,
  DDI.DeliveryQuantityUnit AS DeliveryQuantityUnit,
  DDI.ActualDeliveredQtyInBaseUnit AS ActualDeliveredQtyInBaseUnit,
  DDI.DeliveryToBaseQuantityDnmntr AS DeliveryToBaseQuantityDnmntr,
  DDI.DeliveryToBaseQuantityNmrtr AS DeliveryToBaseQuantityNmrtr,
  DDI.ProductAvailabilityDate AS ProductAvailabilityDate,
  DDI.ProductAvailabilityTime AS ProductAvailabilityTime,
  DDI.DeliveryGroup AS DeliveryGroup,
  DDI.ItemGrossWeight AS ItemGrossWeight,
  DDI.ItemNetWeight AS ItemNetWeight,
  DDI.ItemWeightUnit AS ItemWeightUnit,
  DDI.ItemVolume AS ItemVolume,
  DDI.ItemVolumeUnit AS ItemVolumeUnit,
  DDI.InspectionLot AS InspectionLot,
  DDI.InspectionPartialLot AS InspectionPartialLot,
  DDI.PartialDeliveryIsAllowed AS PartialDeliveryIsAllowed,
  DDI.UnlimitedOverdeliveryIsAllowed AS UnlimitedOverdeliveryIsAllowed,
  DDI.OverdelivTolrtdLmtRatioInPct AS OverdelivTolrtdLmtRatioInPct,
  DDI.UnderdelivTolrtdLmtRatioInPct AS UnderdelivTolrtdLmtRatioInPct,
  DDI.WarehouseStorageBin AS WarehouseStorageBin,
  DDI.BOMExplosion AS BOMExplosion,
  DDI.CustEngineeringChgStatus AS CustEngineeringChgStatus,
  DDI.WarehouseStagingArea AS WarehouseStagingArea,
  DDI.WarehouseStockCategory AS WarehouseStockCategory,
  DDI.IssgOrRcvgStockCategory AS IssgOrRcvgStockCategory,
  DDI.IssgOrRcvgMaterial AS IssgOrRcvgMaterial,
  DDI.IssuingOrReceivingPlant AS IssuingOrReceivingPlant,
  DDI.IssuingOrReceivingStorageLoc AS IssuingOrReceivingStorageLoc,
  DDI.IssgOrRcvgBatch AS IssgOrRcvgBatch,
  DDI.IssgOrRcvgValuationType AS IssgOrRcvgValuationType,
  DDI.IssgOrRcvgSpclStockInd AS IssgOrRcvgSpclStockInd,
  DDI.PrimaryPostingSwitch AS PrimaryPostingSwitch,
  DDI.StockType AS StockType,
  DDI.IsNotGoodsMovementsRelevant AS IsNotGoodsMovementsRelevant,
  DDI.GLAccount AS GLAccount,
  DDI.GoodsMovementReasonCode AS GoodsMovementReasonCode,
  DDI.SubsequentMovementType AS SubsequentMovementType,
  DDI.IsCompletelyDelivered AS IsCompletelyDelivered,
  DDI.AlternateProductNumber AS AlternateProductNumber,
  DDI.PickingControl AS PickingControl,
  DDI.LoadingGroup AS LoadingGroup,
  DDI.GoodsMovementType AS GoodsMovementType,
  DDI.TransportationGroup AS TransportationGroup,
  DDI.ReceivingPoint AS ReceivingPoint,
  DDI.FixedShipgProcgDurationInDays AS FixedShipgProcgDurationInDays,
  DDI.VarblShipgProcgDurationInDays AS VarblShipgProcgDurationInDays,
  DDI.ProofOfDeliveryRelevanceCode AS ProofOfDeliveryRelevanceCode,
  DDI.ItemIsBillingRelevant AS ItemIsBillingRelevant,
  DDI.ItemBillingBlockReason AS ItemBillingBlockReason,
  DDI.PaymentGuaranteeForm AS PaymentGuaranteeForm,
  DDI.IntercompanyBillingStatus AS IntercompanyBillingStatus,
  DDI.BusinessArea AS BusinessArea,
  DDI.ControllingArea AS ControllingArea,
  DDI.ProfitabilitySegment_2 AS ProfitabilitySegment,
  DDI.ProfitCenter AS ProfitCenter,
  OMFK DDI.InventoryValuationType AS InventoryValuationType,
  DDI.IsSeparateValuation AS IsSeparateValuation,
  DDI.ConsumptionPosting AS ConsumptionPosting,
  DDI.OrderID AS OrderID,
  DDI.OrderItem AS OrderItem,
  DDI.CostCenter AS CostCenter,
  DDI.ReferenceSDDocument AS ReferenceSDDocument,
  DDI.ReferenceSDDocumentItem AS ReferenceSDDocumentItem,
  DDI.ReferenceSDDocumentCategory AS ReferenceSDDocumentCategory,
  DDI.ReferenceDocumentLogicalSystem AS ReferenceDocumentLogicalSystem,
  DDI.AdditionalCustomerGroup1 AS AdditionalCustomerGroup1,
  DDI.AdditionalCustomerGroup2 AS AdditionalCustomerGroup2,
  DDI.AdditionalCustomerGroup3 AS AdditionalCustomerGroup3,
  DDI.AdditionalCustomerGroup4 AS AdditionalCustomerGroup4,
  DDI.AdditionalCustomerGroup5 AS AdditionalCustomerGroup5,
  DDI.RetailPromotion AS RetailPromotion,
  DDI.StatisticsDate AS StatisticsDate,
  DDI.SDProcessStatus AS SDProcessStatus,
  DDI.PickingConfirmationStatus AS PickingConfirmationStatus,
  DDI.PickingStatus AS PickingStatus,
  DDI.WarehouseActivityStatus AS WarehouseActivityStatus,
  DDI.PackingStatus AS PackingStatus,
  DDI.GoodsMovementStatus AS GoodsMovementStatus,
  DDI.DeliveryRelatedBillingStatus AS DeliveryRelatedBillingStatus,
  DDI.ProofOfDeliveryStatus AS ProofOfDeliveryStatus,
  DDI.ItemGeneralIncompletionStatus AS ItemGeneralIncompletionStatus,
  DDI.ItemDeliveryIncompletionStatus AS ItemDeliveryIncompletionStatus,
  DDI.ItemPickingIncompletionStatus AS ItemPickingIncompletionStatus,
  DDI.ItemGdsMvtIncompletionSts AS ItemGdsMvtIncompletionSts,
  DDI.ItemPackingIncompletionStatus AS ItemPackingIncompletionStatus,
  DDI.ItemBillingIncompletionStatus AS ItemBillingIncompletionStatus,
  DDI._DeliveryDocument.SoldToParty AS SoldToParty,
  cast(DDI._DeliveryDocument._SoldToParty.CustomerName as vdm_sold_to_name) AS SoldToPartyName,
  DDI._DeliveryDocument.CustomerGroup AS CustomerGroup,
  DDI._DeliveryDocument._SoldToParty.CustomerClassification AS SoldToPartyClassification,
  DDI._DeliveryDocument.SalesDistrict AS SalesDistrict,
  DDI._DeliveryDocument.ShippingPoint AS ShippingPoint,
  SDI.TransactionCurrency AS TransactionCurrency,
  _DeliveryDocument._SalesOrganization.SalesOrganizationCurrency AS StatisticsCurrency,
  DDI._DeliveryDocument AS _DeliveryDocument,
  DDI._Partner AS _Partner,
  DDI._SDDocumentCategory AS _SDDocumentCategory,
  DDI._ItemCategory AS _ItemCategory,
  DDI._SalesDocumentItemType AS _SalesDocumentItemType,
  DDI._CreatedByUser AS _CreatedByUser,
  DDI._DistributionChannel AS _DistributionChannel,
  DDI._Division AS _Division,
  DDI._SalesGroup AS _SalesGroup,
  DDI._SalesOffice AS _SalesOffice,
  DDI._Material AS _Material,
  DDI._Product AS _Product,
  DDI._OriginallyRequestedMaterial AS _OriginallyRequestedMaterial,
  DDI._ProductHierarchyNode AS _ProductHierarchyNode,
  DDI._MaterialGroup AS _MaterialGroup,
  DDI._ProductGroup AS _ProductGroup,
  DDI._MaterialFreightGroup AS _MaterialFreightGroup,
  DDI._AdditionalMaterialGroup1 AS _AdditionalMaterialGroup1,
  DDI._AdditionalMaterialGroup2 AS _AdditionalMaterialGroup2,
  DDI._AdditionalMaterialGroup3 AS _AdditionalMaterialGroup3,
  DDI._AdditionalMaterialGroup4 AS _AdditionalMaterialGroup4,
  DDI._AdditionalMaterialGroup5 AS _AdditionalMaterialGroup5,
  DDI._Plant AS _Plant,
  DDI._Warehouse AS _Warehouse,
  DDI._StorageLocation AS _StorageLocation,
  DDI._InventorySpecialStockType AS _InventorySpecialStockType,
  DDI._DeliveryQuantityUnit AS _DeliveryQuantityUnit,
  DDI._BaseUnit AS _BaseUnit,
  DDI._ItemWeightUnit AS _ItemWeightUnit,
  DDI._ItemVolumeUnit AS _ItemVolumeUnit,
  DDI._BOMExplosion AS _BOMExplosion,
  DDI._WarehouseStagingArea AS _WarehouseStagingArea,
  DDI._PickingControl AS _PickingControl,
  DDI._LoadingGroup AS _LoadingGroup,
  DDI._GoodsMovementType AS _GoodsMovementType,
  DDI._TransportationGroup AS _TransportationGroup,
  DDI._ItemIsBillingRelevant AS _ItemIsBillingRelevant,
  DDI._ItemBillingBlockReason AS _ItemBillingBlockReason,
  DDI._PaymentGuaranteeForm AS _PaymentGuaranteeForm,
  DDI._BusinessArea AS _BusinessArea,
  DDI._ControllingArea AS _ControllingArea,
  DDI._ProfitCenter AS _ProfitCenter,
  DDI._InventoryValuationType AS _InventoryValuationType,
  DDI._OrderID AS _OrderID,
  DDI._CostCenter AS _CostCenter,
  DDI._ReferenceSDDocument AS _ReferenceSDDocument,
  DDI._ReferenceSalesDocumentItem AS _ReferenceSalesDocumentItem,
  DDI._ReferenceSDDocumentCategory AS _ReferenceSDDocumentCategory,
  DDI._LogicalSystem AS _LogicalSystem,
  DDI._AdditionalCustomerGroup1 AS _AdditionalCustomerGroup1,
  DDI._AdditionalCustomerGroup2 AS _AdditionalCustomerGroup2,
  DDI._AdditionalCustomerGroup3 AS _AdditionalCustomerGroup3,
  DDI._AdditionalCustomerGroup4 AS _AdditionalCustomerGroup4,
  DDI._AdditionalCustomerGroup5 AS _AdditionalCustomerGroup5,
  DDI._SDProcessStatus AS _SDProcessStatus,
  DDI._PickingConfirmationStatus AS _PickingConfirmationStatus,
  DDI._PickingStatus AS _PickingStatus,
  DDI._WarehouseActivityStatus AS _WarehouseActivityStatus,
  DDI._PackingStatus AS _PackingStatus,
  DDI._GoodsMovementStatus AS _GoodsMovementStatus,
  DDI._DeliveryRelatedBillingStatus AS _DeliveryRelatedBillingStatus,
  DDI._ProofOfDeliveryStatus AS _ProofOfDeliveryStatus,
  DDI._ItemGeneralIncompletionStatus AS _ItemGeneralIncompletionStatus,
  DDI._ItemDelivIncompletionSts AS _ItemDelivIncompletionSts,
  DDI._ItemPickingIncompletionStatus AS _ItemPickingIncompletionStatus,
  DDI._ItemGdsMvtIncompletionSts AS _ItemGdsMvtIncompletionSts,
  DDI._ItemPackingIncompletionStatus AS _ItemPackingIncompletionStatus,
  DDI._ItemBillingIncompletionStatus AS _ItemBillingIncompletionStatus,
  DDI._DeliveryDocument._SalesOrganization AS _SalesOrganization,
  DDI._DeliveryDocument._CustomerGroup AS _CustomerGroup,
  DDI._DeliveryDocument._SalesDistrict AS _SalesDistrict,
  DDI._DeliveryDocument._ShippingPoint AS _ShippingPoint,
  DDI._DeliveryDocument._SoldToParty AS _SoldToParty,
  DDI._DeliveryDocument._SoldToParty._CustomerClassification AS _CustomerClassification,
  SDI._TransactionCurrency AS _TransactionCurrency
FROM I_DeliveryDocumentItem AS DDI
INNER JOIN I_SalesDocumentItem AS SDI ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Currency AS _StatisticsCurrency ON StatisticsCurrency = _StatisticsCurrency.Currency  -- association [0..1]
;