C_SlsDocItemSupplyIssue

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_SlsDocItemSupplyIssue.
-- 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: CSLSDOCITEMSO08

CREATE VIEW C_SlsDocItemSupplyIssue AS
SELECT
  Item.SalesDocument AS SalesDocument,
  cast(Item.SalesDocumentItem as sales_doc_item preserving type) AS SalesDocumentItem,
  Issue.DueDays AS DueDays,
  Item.SalesDocumentItemCategory AS SalesDocumentItemCategory,
  Item.Product AS Product,
  Item.ProductGroup AS ProductGroup,
  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,
  cast( Item.RequestedDeliveryDate as reqd_deliv_date) AS RequestedDeliveryDate,
  cast(Item.PurchaseConfirmationStatus as purchaseconfsts preserving type ) AS PurchaseConfirmationStatus,
  Item.DeliveryStatus AS DeliveryStatus,
  Item.SDProcessStatus AS SDProcessStatus,
  Item.OrderRelatedBillingStatus AS OrderRelatedBillingStatus,
  cast( case when PurchaseConfirmationStatus = '' then 9 when PurchaseConfirmationStatus <> 'C' and DueDays > 0 then 2 when PurchaseConfirmationStatus <> 'C' and DueDays <= 0 then 1 else 3 end as abap.int1 ) as PurchaseConfStatusCriticality AS int1asPurchaseConfStatusCriticality
FROM I_SalesDocumentItemBasic AS Item
INNER JOIN I_SalesOrderMisgPurgOrder 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]
;