I_Sadl_Voc_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 I_Sadl_Voc_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: ISADL_VOC_SO

CREATE VIEW I_Sadl_Voc_Salesorder AS
SELECT
  cast( node_key as sysuuid_x preserving type ) AS node_key,
  so_id AS SalesOrderId,
  created_by AS CreatedBy,
  created_at AS CreatedAt,
  changed_by AS ChangedBy,
  changed_at AS ChangedAt,
  cast( buyer_guid as sysuuid_x preserving type ) AS BusinessPartnerGuid,
  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,
  op_id AS OpportunityId,
  overall_status AS OverallStatus
FROM snwd_so
LEFT OUTER JOIN I_Sadl_Voc_Businesspartner AS _BusinessPartner ON BusinessPartnerGuid = _BusinessPartner.BusinessPartnerKey  -- association [0..1]
LEFT OUTER JOIN I_SADL_VOC_CurrencyCode_Text AS _CurrencyText ON _CurrencyText.Currency_Code = CurrencyCode  -- association [0..*]
;