C_SlsDocItemIncomplete

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_SlsDocItemIncomplete.
-- 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: CSLSDOCITEMSO01

CREATE VIEW C_SlsDocItemIncomplete AS
SELECT
  Item.SalesDocument AS SalesDocument,
  cast(Item.SalesDocumentItem as sales_doc_item preserving type) AS SalesDocumentItem,
  cast(Issue.DueDays as due_days) AS DueDays,
  Item.SalesDocumentItemCategory AS SalesDocumentItemCategory,
  cast(Item.Material as productnumber preserving type ) AS Material,
  Item._MaterialText[1:Language=$session.system_language].MaterialName AS MaterialName,
  cast(Item.MaterialGroup as productgroup preserving type ) AS MaterialGroup,
  Item.Batch AS Batch,
  Item.Plant AS Plant,
  Item.MaterialByCustomer AS MaterialByCustomer,
  Item.SalesDocumentItemText AS SalesDocumentItemText,
  Item.RequestedQuantity AS RequestedQuantity,
  Item.RequestedQuantityUnit AS RequestedQuantityUnit,
  Item.ConfdDelivQtyInOrderQtyUnit AS ConfdDelivQtyInOrderQtyUnit,
  Item.OrderQuantityUnit AS OrderQuantityUnit,
  Item.NetAmount AS NetAmount,
  Item.TransactionCurrency AS TransactionCurrency,
  Item.ShippingPoint AS ShippingPoint,
  Item._ShippingPointText[1:Language=$session.system_language].ShippingPointName AS ShippingPointName,
  Item.StorageLocation AS StorageLocation,
  cast( Item._SlsDocItemEnhancedFields._RequestedDeliveryDate.RequestedDeliveryDate as reqd_deliv_date) AS RequestedDeliveryDate,
  Item.DeliveryStatus AS DeliveryStatus,
  Item.SDProcessStatus AS SDProcessStatus,
  Item.OrderRelatedBillingStatus AS OrderRelatedBillingStatus,
  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.PricingIncompletionStatus as pricing_incompletion_status preserving type) AS PricingIncompletionStatus,
  cast(Item.ItemBillingIncompletionStatus as itms_incompltn_sts_billg preserving type) AS ItemBillingIncompletionStatus,
  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 PricingIncompletionStatus <> 'C' and DueDays > 0 then 2 when PricingIncompletionStatus <> 'C' and DueDays <= 0 then 1 else 3 end as abap.int1 ) as PricingIncompltnStsCriticality AS int1asPricingIncompltnStsCriticality,
  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_SalesDocumentItem AS Item
INNER JOIN I_SalesOrderIncomplete AS Issue ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN E_SalesDocumentItemBasic AS _Extension ON SalesDocument = _Extension.SalesDocument AND SalesDocumentItem = _Extension.SalesDocumentItem  -- association [0..1]
;