Repm_SalesOrderC

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 Repm_SalesOrderC.
-- 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: REPM_SAORC

CREATE VIEW Repm_SalesOrderC AS
SELECT
  SO.SalesOrder AS SalesOrder,
  SalesOrderItem,
  PROD.Product AS Product,
  PROD.ProductUUID AS ProductUUID,
  PROD.Weight AS ProductWeight,
  PROD.WeightUnit AS WeightUnit,
  PROD.ProductName AS ProductName,
  SOI.TransactionCurrency AS TransactionCurrency,
  SOI.GrossAmountInTransacCurrency AS GrossAmountInTransacCurrency,
  cast('EUR'as abap.cuky) AS TargetCurrency,
  SOI._TransactionCurrency AS _TransactionCurrency,
  currency_conversion ( amount => SOI.GrossAmountInTransacCurrency, source_currency => SOI.TransactionCurrency, target_currency => cast('EUR'as abap.cuky), client => cast( '000' as abap.clnt ), exchange_rate_type => 'M', exchange_rate_date => cast('20141010' as abap.dats) ) as AmountInTargetCurrency AS datsasAmountInTargetCurrency,
  SOI.NetAmountInTransactionCurrency AS NetAmountInTransactionCurrency,
  SOI.TaxAmountInTransactionCurrency AS TaxAmountInTransactionCurrency,
  SOI.ProductAvailabilityStatus AS ProductAvailabilityStatus,
  SOI._ProductAvailabilityStatus AS _ProductAvailabilityStatus,
  SOI.OpportunityItem AS OpportunityItem,
  cast(left( cast(SO.LastChangedDateTime as abap.char( 30 )), 8 ) as dats) AS DateChanged,
  prod._WeightUnit AS _WeightUnit
FROM SEPM_I_SalesOrderItem AS SOI
LEFT OUTER JOIN REPM_ProdDetails AS PROD 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 AND _Text.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN SEPM_I_SlsOrdItemSchedLine_E AS _ScheduleLine ON SalesOrder = _ScheduleLine.SalesOrder AND SalesOrderItem = _ScheduleLine.SalesOrderItem AND _ScheduleLine.ScheduleLine = '0001'  -- association [1..1]
;