SEPM_I_SalesOrder

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

CREATE VIEW SEPM_I_SalesOrder AS
SELECT
  cast ( node_key as sepm_so_uuid preserving type ) AS SalesOrderUUID,
  so_id AS SalesOrder,
  created_by AS CreatedByUser,
  created_at AS CreationDateTime,
  changed_by AS LastChangedByUser,
  changed_at AS LastChangedDateTime,
  created_by_bp AS IsCreatedByBusinessPartner,
  changed_by_bp AS IsLastChangedByBusinessPartner,
  note_guid AS ShortTextGroupUUID,
  buyer_guid AS CustomerUUID,
  currency_code AS TransactionCurrency,
  gross_amount AS GrossAmountInTransacCurrency,
  net_amount AS NetAmountInTransactionCurrency,
  tax_amount AS TaxAmountInTransactionCurrency,
  lifecycle_status AS SalesOrderLifeCycleStatus,
  billing_status AS SalesOrderBillingStatus,
  delivery_status AS SalesOrderDeliveryStatus,
  overall_status AS SalesOrderOverallStatus,
  op_id AS Opportunity,
  buy_contact_guid AS CustomerContactUUID,
  ship_to_adr_guid AS ShipToPartyAddressUUID,
  bill_to_adr_guid AS BillToPartyAddressUUID,
  payment_method AS SalesOrderPaymentMethod,
  payment_terms AS SalesOrderPaymentTerms
FROM snwd_so
LEFT OUTER JOIN SEPM_I_Currency AS _TransactionCurrency ON TransactionCurrency = _TransactionCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN SEPM_I_ShortTextGroup AS _ShortTextGroup ON ShortTextGroupUUID = _ShortTextGroup.ShortTextGroupUUID  -- association [0..1]
LEFT OUTER JOIN SEPM_I_BusinessPartner AS _Customer ON CustomerUUID = _Customer.BusinessPartnerUUID  -- association [0..1]
LEFT OUTER JOIN SEPM_I_CUSTOMER AS _CustomerV2 ON CustomerUUID = _CustomerV2.CustomerUUID  -- 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_SalesOrderItem AS _Item ON SalesOrderUUID = _Item.SalesOrderUUID  -- association [0..*]
LEFT OUTER JOIN SEPM_I_Employee AS _CreatedByUser ON CreatedByUser = _CreatedByUser.EmployeeUUID  -- association [0..1]
LEFT OUTER JOIN SEPM_I_Employee AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.EmployeeUUID  -- association [0..1]
LEFT OUTER JOIN SEPM_E_SalesOrder AS _Extension ON snwd_so.node_key = _Extension.SalesOrderUUID  -- association [1..1]
LEFT OUTER JOIN SEPM_I_ContactPerson AS _CustomerContact ON CustomerContactUUID = _CustomerContact.ContactPersonUUID  -- association [0..1]
LEFT OUTER JOIN SEPM_I_PartyAddress AS _ShipToPartyAddress ON ShipToPartyAddressUUID = _ShipToPartyAddress.PartyAddressUUID  -- association [0..1]
LEFT OUTER JOIN SEPM_I_PartyAddress AS _BillToPartyAddress ON BillToPartyAddressUUID = _BillToPartyAddress.PartyAddressUUID  -- association [0..1]
;