SADL_V_EXP_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 SADL_V_EXP_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: SADL_V_E_SO

CREATE VIEW SADL_V_EXP_SalesOrder AS
SELECT
  node_key AS salesOrderKey,
  so_id AS salesOrderId,
  created_by AS createdBy,
  created_at AS createdAt,
  changed_by AS changedBy,
  changed_at AS changedAt,
  currency_code AS currencyCode,
  gross_amount AS grossAmount,
  net_amount AS netAmount,
  tax_amount AS taxAmount,
  lifecycle_status AS lifecycleStatus,
  billing_status AS billingStatus,
  delivery_status AS deliveryStatus,
  Items,
  buyer_guid AS buyerGuid,
  Customer,
  customer.businessPartnerId AS businessPartnerId,
  customer.company_name AS companyName,
  customer.email_address AS companyEmailAddress,
  customer.web_address AS companyWebAddress
FROM snwd_so
LEFT OUTER JOIN SADL_V_EXP_SalesOrderItem AS items ON node_key = items.salesOrderItemKey  -- association [0..*]
LEFT OUTER JOIN Sadl_V_Exp_Currency_Text AS _currencyText ON currencyCode = _currencyText.Currency  -- association [0..*]
;