SEPM_I_SalesOrderItem_E_V2

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 SEPM_I_SalesOrderItem_E_V2.
-- 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: SEPM_ISOIE2

CREATE VIEW SEPM_I_SalesOrderItem_E_V2 AS
SELECT
  SO.SalesOrder AS SalesOrder,
  SalesOrderItem,
  PROD.Product AS Product,
  SOI.TransactionCurrency AS TransactionCurrency,
  SOI.GrossAmountInTransacCurrency AS GrossAmountInTransacCurrency,
  SOI.NetAmountInTransactionCurrency AS NetAmountInTransactionCurrency,
  SOI.TaxAmountInTransactionCurrency AS TaxAmountInTransactionCurrency,
  SOI.ProductAvailabilityStatus AS ProductAvailabilityStatus,
  SOI.OpportunityItem AS OpportunityItem,
  SOI.SalesOrderItemUUID AS SalesOrderItemUUID,
  SOISL.Quantity AS Quantity,
  SOISL.QuantityUnit AS QuantityUnit,
  SOI._ProductAvailabilityStatus AS _ProductAvailabilityStatus,
  SOI._TransactionCurrency AS _TransactionCurrency,
  SOISL._QuantityUnit AS _QuantityUnit
FROM SEPM_I_SalesOrderItem AS SOI
LEFT OUTER JOIN SEPM_I_Product AS PROD ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN SEPM_I_SlsOrdItemScheduleLine AS SOISL ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN SEPM_I_SalesOrder AS SO ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN SEPM_I_SalesOrder_E AS _SalesOrder ON SalesOrder = _SalesOrder.SalesOrder  -- association [1..1]
LEFT OUTER JOIN SEPM_I_Product_E AS _Product ON Product = _Product.Product  -- association [0..1]
LEFT OUTER JOIN SEPM_I_SalesOrderItemText_E AS _Text ON SalesOrder = _Text.SalesOrder AND SalesOrderItem = _Text.SalesOrderItem  -- association [0..*]
LEFT OUTER JOIN SEPM_E_SalesOrderItem AS _Extension ON SalesOrderItemUUID = _Extension.SalesOrderItemUUID  -- association [1..1]
;