SADL_V_AUnit_Prod

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_AUnit_Prod.
-- 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: SADLVPROD

CREATE VIEW SADL_V_AUnit_Prod AS
SELECT
  snwd_pd.node_key AS node_key,
  snwd_pd.product_id AS ProductID,
  snwd_pd.type_code AS type_code,
  snwd_pd.category AS category,
  snwd_pd.created_by AS created_by,
  snwd_pd.created_at AS created_at,
  snwd_pd.changed_by AS changed_by,
  snwd_pd.changed_at AS changed_at,
  snwd_pd.name_guid AS name_guid,
  snwd_pd.desc_guid AS desc_guid,
  snwd_pd.currency_code AS currency,
  snwd_pd.measure_unit AS measure_unit,
  snwd_pd.measure_unit AS UnitOfMeasure,
  snwd_pd.weight_unit AS weight_unit,
  snwd_pd.price AS price,
  snwd_pd.width AS width,
  snwd_pd.depth AS depth,
  snwd_pd.height AS height,
  snwd_pd.dim_unit AS dim_unit
FROM snwd_pd
LEFT OUTER JOIN SADL_V_AUnit_Currency AS _Currency ON _Currency.waers = snwd_pd.currency_code  -- association [0..*]
LEFT OUTER JOIN SADL_V_AUnit_Unit_Of_Measure AS _MeasureUnit ON measure_unit = _MeasureUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN Sadl_V_Aunit_Uom_Special AS _MeasureUnitSpecial ON UnitOfMeasure = _MeasureUnitSpecial.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN SADL_V_AUnit_Unit_Of_Measure AS _WeightUnit ON weight_unit = _WeightUnit.UnitOfMeasure  -- association [0..1]
;