SEPMRA_C_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_C_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_C_SalesOrderTP AS
SELECT
  SalesOrder.SalesOrder AS SalesOrder,
  SalesOrder.CustomerContact AS CustomerContact,
  SalesOrder.SoldToParty AS SoldToParty,
  SalesOrder.BillToParty AS BillToParty,
  SalesOrder.ShipToParty AS ShipToParty,
  SalesOrder.CreatedByUser AS CreatedByUser,
  SalesOrder.CreationDateTime AS CreationDateTime,
  SalesOrder.CreationDate AS CreationDate,
  SalesOrder.LastChangedByUser AS LastChangedByUser,
  SalesOrder.LastChangedDateTime AS LastChangedDateTime,
  SalesOrder.LastChangedDate AS LastChangedDate,
  SalesOrder.NetAmountInTransactionCurrency AS NetAmountInTransactionCurrency,
  SalesOrder.TransactionCurrency AS TransactionCurrency,
  SalesOrder.Quantity AS Quantity,
  SalesOrder.SalesOrderOverallStatus AS SalesOrderOverallStatus,
  SalesOrder.SalesOrderPaymentMethod AS SalesOrderPaymentMethod,
  SalesOrder.SalesOrderPaymentTerms AS SalesOrderPaymentTerms
FROM SEPMRA_I_SalesOrderTP AS SalesOrder
LEFT OUTER JOIN SEPMRA_C_SalesOrderItemTP AS _SalesOrderItem ON SalesOrder = _SalesOrderItem.SalesOrder  -- association [0..*]
LEFT OUTER JOIN SEPMRA_C_SalesOrderCustomer AS _Customer ON SoldToParty = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN SEPMRA_C_SalesOrderParty AS _BillToParty ON BillToParty = _BillToParty.Party  -- association [0..1]
LEFT OUTER JOIN SEPMRA_C_SalesOrderParty AS _ShipToParty ON ShipToParty = _ShipToParty.Party  -- association [0..1]
LEFT OUTER JOIN SEPMRA_C_SalesOrderStatus AS _OverallStatus ON SalesOrderOverallStatus = _OverallStatus.SalesOrderOverallStatus  -- association [0..1]
LEFT OUTER JOIN SEPMRA_C_SalesOrderReviser AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN SEPMRA_C_SalesOrderReviser AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN SEPMRA_C_SalesOrderCustContact AS _CustomerContact ON CustomerContact = _CustomerContact.ContactPerson  -- association [0..1]
LEFT OUTER JOIN SEPMRA_C_SalesOrderPaymentTerm AS _PaymentTerms ON SalesOrderPaymentTerms = _PaymentTerms.SalesOrderPaymentTerms  -- association [0..1]
LEFT OUTER JOIN SEPMRA_C_SalesOrderPaymentMeth AS _PaymentMethod ON SalesOrderPaymentMethod = _PaymentMethod.SalesOrderPaymentMethod  -- association [0..1]
LEFT OUTER JOIN SEPMRA_I_SalesOrderAge AS _Age ON SalesOrder = _Age.SalesOrder  -- association [0..1]
;