SEPM_I_SalesOrder_E

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_SalesOrder_E.
-- 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_ISOE

CREATE VIEW SEPM_I_SalesOrder_E AS
SELECT
  SO.SalesOrder AS SalesOrder,
  cast ( CREATEDBY.UserID as sepm_created_by_user preserving type ) AS CreatedByUser,
  SO.CreationDateTime AS CreationDateTime,
  cast( CHANGEDBY.UserID as sepm_last_chg_by_user preserving type ) AS LastChangedByUser,
  SO.LastChangedDateTime AS LastChangedDateTime,
  SO.IsCreatedByBusinessPartner AS IsCreatedByBusinessPartner,
  SO.IsLastChangedByBusinessPartner AS IsLastChangedByBusinessPartner,
  cast ( BP.BusinessPartner as snwd_customer_id preserving type ) AS Customer,
  cast( CP.ContactPerson as sepm_customer_contact preserving type ) AS CustomerContact,
  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.Opportunity AS Opportunity,
  SO.SalesOrderPaymentMethod AS SalesOrderPaymentMethod,
  SO.SalesOrderPaymentTerms AS SalesOrderPaymentTerms,
  cast ( BILLTOPARTY.Party as sepm_bill_to_party preserving type ) AS BillToParty,
  BILLTOPARTY.PartyRole AS BillToPartyRole,
  cast (SHIPTOPARTY.Party as sepm_ship_to_party preserving type ) AS ShipToParty,
  SHIPTOPARTY.PartyRole AS ShipToPartyRole,
  SO._LifeCycleStatus AS _LifeCycleStatus,
  SO._BillingStatus AS _BillingStatus,
  SO._DeliveryStatus AS _DeliveryStatus,
  SO._OverallStatus AS _OverallStatus,
  SO._PaymentMethod AS _PaymentMethod,
  SO._PaymentTerms AS _PaymentTerms,
  SO._TransactionCurrency AS _TransactionCurrency
FROM SEPM_I_SalesOrder AS SO
LEFT OUTER JOIN SEPM_I_SalesOrderText_E AS _Text ON SalesOrder = _Text.SalesOrder  -- association [0..*]
LEFT OUTER JOIN SEPM_I_BusinessPartner_E AS _Customer ON Customer = _Customer.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN SEPM_I_CUSTOMER_E AS _CustomerV2 ON Customer = _CustomerV2.Customer  -- association [0..1]
LEFT OUTER JOIN SEPM_I_SalesOrderItem_E AS _Item ON SalesOrder = _Item.SalesOrder  -- association [0..*]
LEFT OUTER JOIN SEPM_I_SalesOrderItem_E_V2 AS _ItemV2 ON SalesOrder = _ItemV2.SalesOrder  -- association [0..*]
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_E_SalesOrder AS _Extension ON SO.salesorderuuid = _Extension.SalesOrderUUID  -- association [1..1]
LEFT OUTER JOIN SEPM_I_ContactPerson_E AS _CustomerContact ON CustomerContact = _CustomerContact.ContactPerson AND Customer = _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_PartyRole AS _BillToPartyRole ON BillToPartyRole = _BillToPartyRole.PartyRole  -- association [0..1]
LEFT OUTER JOIN SEPM_I_Party_E AS _ShipToParty ON ShipToParty = _ShipToParty.Party  -- association [0..1]
LEFT OUTER JOIN SEPM_I_PartyRole AS _ShipToPartyRole ON ShipToPartyRole = _ShipToPartyRole.PartyRole  -- association [0..1]
;