I_TrdClassfctnNmbr

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_TrdClassfctnNmbr.
-- 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: ITRDCLSN

CREATE VIEW I_TrdClassfctnNmbr AS
SELECT
  nosct AS TrdClassfctnNmbrSchmCntnt,
  ccngn AS TrdClassfctnNmbr,
  datab AS ValidityStartDate,
  datbi AS ValidityEndDate,
  cuom1 AS CustomsUnitOfMeasure,
  cuom2 AS SecondCustomsUnitOfMeasure,
  _Content.TrdClassfctnNmbrSchmType AS TrdClassfctnNmbrSchmType,
  _Content.TrdClassfctnNmbrSchmCntntSrce AS TrdClassfctnNmbrSchmCntntSrce,
  _Content.UnitOfMeasureSystem AS UnitOfMeasureSystem,
  ernam AS CreatedByUser,
  crtsp AS CreationDateTime,
  aenam AS LastChangedByUser
FROM /sapsll/clsnr
INNER JOIN I_TrdClassfctnNmbrSchmCntnt AS _Content ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_TrdClassfctnNmbrSchmCntnt AS _TrdClassfctnNmbrSchmCntnt ON TrdClassfctnNmbrSchmCntnt = _TrdClassfctnNmbrSchmCntnt.TrdClassfctnNmbrSchmCntnt  -- association [0..1]
LEFT OUTER JOIN I_TrdClassfctnNmbrSchmCntntTxt AS _TrdClassfctnNmbrSchmCntntTxt ON TrdClassfctnNmbrSchmCntnt = _TrdClassfctnNmbrSchmCntntTxt.TrdClassfctnNmbrSchmCntnt  -- association [0..*]
LEFT OUTER JOIN I_CalendarDate AS _Date ON ValidityStartDate = _Date.CalendarDate  -- association [0..1]
LEFT OUTER JOIN I_TrdClassfctnNmbrText AS _Text ON TrdClassfctnNmbrSchmCntnt = _Text.TrdClassfctnNmbrSchmCntnt AND TrdClassfctnNmbr = _Text.TrdClassfctnNmbr AND ValidityStartDate = _Text.ValidityStartDate  -- association [0..*]
LEFT OUTER JOIN I_UnitOfMeasure AS _SupplementaryUnit ON SupplementaryUnit = _SupplementaryUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _SecondSupplementaryUnit ON SecondSupplementaryUnit = _SecondSupplementaryUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_CustomsUnitOfMeasure AS _CustomsUnitOfMeasure ON CustomsUnitOfMeasure = _CustomsUnitOfMeasure.CustomsUnitOfMeasure AND UnitOfMeasureSystem = _CustomsUnitOfMeasure.UnitOfMeasureSystem  -- association [0..1]
LEFT OUTER JOIN I_CustomsUnitOfMeasure AS _SecondCustomsUnitOfMeasure ON SecondCustomsUnitOfMeasure = _SecondCustomsUnitOfMeasure.CustomsUnitOfMeasure AND UnitOfMeasureSystem = _SecondCustomsUnitOfMeasure.UnitOfMeasureSystem  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN P_TrdClassfctnUoMMappg AS _InternalUoM ON CustomsUnitOfMeasure = _InternalUoM.CustomsUnitOfMeasure AND UnitOfMeasureSystem = _InternalUoM.UnitOfMeasureSystem  -- association [0..1]
LEFT OUTER JOIN P_TrdClassfctnUoMMappg AS _SecondInternalUoM ON SecondCustomsUnitOfMeasure = _SecondInternalUoM.CustomsUnitOfMeasure AND UnitOfMeasureSystem = _SecondInternalUoM.UnitOfMeasureSystem  -- association [0..1]
;