SADL_V_EXP_Anno

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_Anno.
-- 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_ANNO

CREATE VIEW SADL_V_EXP_Anno AS
SELECT
  node_key AS salesOrderItemKey,
  parent_key AS salesOrderKey,
  so_item_pos,
  Product.measureUnit AS QuantityUnitCode,
  Product.weightUnit AS WeightUnitCode,
  item_atp_status AS ItemAtpStatus,
  product_guid AS productGuid,
  Product
FROM snwd_so_i
LEFT OUTER JOIN SADL_V_CurrencyCode_valueHelp AS _CurrencyCode ON currency_code = _CurrencyCode.waers  -- association [0..1]
LEFT OUTER JOIN Sadl_V_Unit_Of_Measure AS _QuantityUnit ON QuantityUnitCode = _QuantityUnit.UnitOfMeasure  -- association [0..1]
;