C_DelivDocItemIncomplete

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_DelivDocItemIncomplete.
-- 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: CDELIVDOCITMDE03

CREATE VIEW C_DelivDocItemIncomplete AS
SELECT
  Item.DeliveryDocument AS DeliveryDocument,
  Item.DeliveryDocumentItem AS DeliveryDocumentItem,
  Item.DeliveryDocumentItemCategory AS DeliveryDocumentItemCategory,
  Item.DeliveryDocumentItemText AS DeliveryDocumentItemText,
  Issue.DueDays AS DueDays,
  cast(Item.Material as productnumber preserving type ) AS Material,
  Item._Material._Text[1:Language=$session.system_language].MaterialName AS MaterialName,
  Item.MaterialByCustomer AS MaterialByCustomer,
  cast(Item.MaterialGroup as productgroup preserving type ) AS MaterialGroup,
  Item.Batch AS Batch,
  Item.Plant AS Plant,
  Item.Warehouse AS Warehouse,
  Item._Warehouse._Text[1:Language=$session.system_language].WarehouseName AS WarehouseName,
  Item.StorageLocation AS StorageLocation,
  Item.ActualDeliveryQuantity AS ActualDeliveryQuantity,
  Item.DeliveryQuantityUnit AS DeliveryQuantityUnit,
  Item.ItemGrossWeight AS ItemGrossWeight,
  Item.ItemNetWeight AS ItemNetWeight,
  Item.ItemWeightUnit AS ItemWeightUnit,
  Item.ItemVolume AS ItemVolume,
  Item.ItemVolumeUnit AS ItemVolumeUnit,
  Item.LoadingGroup AS LoadingGroup,
  Item.TransportationGroup AS TransportationGroup,
  Item.GoodsMovementType AS GoodsMovementType,
  Item.InventorySpecialStockType AS InventorySpecialStockType,
  Item.StockType AS StockType,
  Item.WarehouseStagingArea AS WarehouseStagingArea,
  Item._WarehouseStagingArea._Text[1:Language=$session.system_language].WarehouseStagingAreaName AS WarehouseStagingAreaName,
  Item.OverdelivTolrtdLmtRatioInPct AS OverdelivTolrtdLmtRatioInPct,
  Item.UnderdelivTolrtdLmtRatioInPct AS UnderdelivTolrtdLmtRatioInPct,
  Item.ItemBillingBlockReason AS ItemBillingBlockReason,
  Item.PickingStatus AS PickingStatus,
  Item.DeliveryRelatedBillingStatus AS DeliveryRelatedBillingStatus,
  Item.PackingStatus AS PackingStatus,
  Item.PickingConfirmationStatus AS PickingConfirmationStatus,
  Item.WarehouseActivityStatus AS WarehouseActivityStatus,
  Item.GoodsMovementStatus AS GoodsMovementStatus,
  cast(Item.ItemGeneralIncompletionStatus as item_general_incompletion_sts preserving type) AS ItemGeneralIncompletionStatus,
  cast(Item.ItemDeliveryIncompletionStatus as itm_deliv_incompletion_status preserving type) AS ItemDeliveryIncompletionStatus,
  cast(Item.ItemPickingIncompletionStatus as itm_pickg_incompletion_status preserving type) AS ItemPickingIncompletionStatus,
  cast(Item.ItemPackingIncompletionStatus as itm_packg_incompletion_status preserving type) AS ItemPackingIncompletionStatus,
  cast(Item.ItemBillingIncompletionStatus as itms_incompltn_sts_billg preserving type) AS ItemBillingIncompletionStatus,
  cast(Item.ItemGdsMvtIncompletionSts as itm_gdsmvt_incompletion_status preserving type) AS ItemGdsMvtIncompletionSts,
  cast( case when ItemGeneralIncompletionStatus <> 'C' and DueDays > 0 then 2 when ItemGeneralIncompletionStatus <> 'C' and DueDays <= 0 then 1 else 3 end as abap.int1 ) as ItmGenIncompltnStsCriticality AS int1asItmGenIncompltnStsCriticality,
  cast( case when ItemDeliveryIncompletionStatus <> 'C' and DueDays > 0 then 2 when ItemDeliveryIncompletionStatus <> 'C' and DueDays <= 0 then 1 else 3 end as abap.int1 ) as ItmDelivIncompltnStsCritlty AS int1asItmDelivIncompltnStsCritlty,
  cast( case when ItemPickingIncompletionStatus <> 'C' and DueDays > 0 then 2 when ItemPickingIncompletionStatus <> 'C' and DueDays <= 0 then 1 else 3 end as abap.int1 ) as ItmPickingIncompltnStsCritlty AS int1asItmPickingIncompltnStsCritlty,
  cast( case when ItemPackingIncompletionStatus <> 'C' and DueDays > 0 then 2 when ItemPackingIncompletionStatus <> 'C' and DueDays <= 0 then 1 else 3 end as abap.int1 ) as ItmPackgIncompltnStsCritlty AS int1asItmPackgIncompltnStsCritlty,
  cast( case when ItemGdsMvtIncompletionSts <> 'C' and DueDays > 0 then 2 when ItemGdsMvtIncompletionSts <> 'C' and DueDays <= 0 then 1 else 3 end as abap.int1 ) as ItmGdsMvtIncompltnStsCritlty AS int1asItmGdsMvtIncompltnStsCritlty,
  cast( case when ItemBillingIncompletionStatus <> 'C' and DueDays > 0 then 2 when ItemBillingIncompletionStatus <> 'C' and DueDays <= 0 then 1 else 3 end as abap.int1 ) as ItmBillingIncompltnStsCritlty AS int1asItmBillingIncompltnStsCritlty
FROM I_DeliveryDocumentItem AS Item
INNER JOIN I_SalesOrderInDelivIncomplete AS Issue ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN E_DeliveryDocumentItem AS _Extension ON DeliveryDocument = _Extension.DeliveryDocument AND DeliveryDocumentItem = _Extension.DeliveryDocumentItem  -- association [0..1]
;