SEPMRA_I_SalesOrderTP

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 SEPMRA_I_SalesOrderTP.
-- 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.

CREATE VIEW SEPMRA_I_SalesOrderTP AS
SELECT
  so.SalesOrder AS SalesOrder,
  so.CreationDateTime AS CreationDateTime,
  so.LastChangedDateTime AS LastChangedDateTime,
  and use them on these UIs. Calculation in CDS AS datsasCreationDate,
  cast(left(cast(LastChangedDateTime as abap.char(23)), 8) as abap.dats) AS LastChangedDate,
  so.Customer AS SoldToParty,
  so.TransactionCurrency AS TransactionCurrency,
  so.GrossAmountInTransacCurrency AS GrossAmountInTransacCurrency,
  so.NetAmountInTransactionCurrency AS NetAmountInTransactionCurrency,
  so.TaxAmountInTransactionCurrency AS TaxAmountInTransactionCurrency,
  so.SalesOrderLifeCycleStatus AS SalesOrderLifeCycleStatus,
  so.SalesOrderBillingStatus AS SalesOrderBillingStatus,
  so.SalesOrderDeliveryStatus AS SalesOrderDeliveryStatus,
  so.SalesOrderOverallStatus AS SalesOrderOverallStatus,
  so.CreatedByUser AS CreatedByUser,
  so.LastChangedByUser AS LastChangedByUser,
  so.CustomerContact AS CustomerContact,
  so.SalesOrderPaymentMethod AS SalesOrderPaymentMethod,
  so.SalesOrderPaymentTerms AS SalesOrderPaymentTerms,
  so.BillToParty AS BillToParty,
  so.ShipToParty AS ShipToParty,
  cast ( 'EA' as snwd_quantity_unit ) AS QuantityUnit,
  _Quantity.Quantity AS Quantity
FROM SEPM_I_SalesOrder_E AS so
LEFT OUTER JOIN SEPMRA_P_SalesOrderQuantity AS _Quantity ON SalesOrder = _Quantity.SalesOrder  -- association [0..1]
LEFT OUTER JOIN SEPMRA_I_SalesOrderItemTP AS _SalesOrderItem ON SalesOrder = _SalesOrderItem.SalesOrder  -- association [0..*]
LEFT OUTER JOIN I_Currency AS _TransactionCurrency ON TransactionCurrency = _TransactionCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN SEPM_I_CUSTOMER_E AS _Customer ON SoldToParty = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN SEPM_I_SlsOrdLifeCycleStatus AS _LifeCycleStatus ON SalesOrderLifeCycleStatus = _LifeCycleStatus.SalesOrderLifeCycleStatus  -- association [0..1]
LEFT OUTER JOIN SEPM_I_SalesOrderBillingStatus AS _BillingStatus ON SalesOrderBillingStatus = _BillingStatus.SalesOrderBillingStatus  -- association [0..1]
LEFT OUTER JOIN SEPM_I_SlsOrdDeliveryStatus AS _DeliveryStatus ON SalesOrderDeliveryStatus = _DeliveryStatus.SalesOrderDeliveryStatus  -- association [0..1]
LEFT OUTER JOIN Sepm_I_SalesOrdOverallStatus AS _OverallStatus ON SalesOrderOverallStatus = _OverallStatus.SalesOrderOverallStatus  -- association [0..1]
LEFT OUTER JOIN Sepm_I_SlsordPaymentMethod AS _PaymentMethod ON SalesOrderPaymentMethod = _PaymentMethod.SalesOrderPaymentMethod  -- association [0..1]
LEFT OUTER JOIN Sepm_I_SlsordPaymentTerms AS _PaymentTerms ON SalesOrderPaymentTerms = _PaymentTerms.SalesOrderPaymentTerms  -- association [0..1]
LEFT OUTER JOIN SEPM_I_User_E AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN SEPM_I_User_E AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN SEPM_I_ContactPerson_E AS _CustomerContact ON CustomerContact = _CustomerContact.ContactPerson AND SoldToParty = _CustomerContact.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN SEPM_I_Party_E AS _BillToParty ON BillToParty = _BillToParty.Party  -- association [0..1]
LEFT OUTER JOIN SEPM_I_Party_E AS _ShipToParty ON ShipToParty = _ShipToParty.Party  -- association [0..1]
LEFT OUTER JOIN SEPM_E_SalesOrder AS _Extension ON SalesOrder = _Extension.SalesOrder  -- association [0..1]
;