C_DrvtnStrgyTraceStepChange

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 C_DrvtnStrgyTraceStepChange.
-- 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.

CREATE VIEW C_DrvtnStrgyTraceStepChange AS
SELECT
  UserName,
  DrvtnStrategyApplicationClass,
  DrvtnStrategyApplSubclass,
  DerivationStrategyIdentifier,
  DerivationStrategyEnvironment,
  DerivationStrgyTraceUUID,
  DerivationStrategyStepNumber,
  DerivationStrategyFieldName,
  DerivationStrategyName,
  DrvtnStrategyOldFieldValue,
  DrvtnStrategyNewFieldValue,
  DerivationStrategyStepText,
  DerivationStrgyStepMethodType
FROM I_DrvtnStrgyTraceStepChange
LEFT OUTER JOIN I_DrvtnStrategyApplClass AS _ApplicationClass ON DrvtnStrategyApplicationClass = _ApplicationClass.DrvtnStrategyApplicationClass  -- association [1..1]
LEFT OUTER JOIN I_DrvtnStrategyApplSubclass AS _Subclass ON DrvtnStrategyApplicationClass = _Subclass.DrvtnStrategyApplicationClass AND DrvtnStrategyApplSubclass = _Subclass.DrvtnStrategyApplSubclass  -- association [1..1]
LEFT OUTER JOIN I_DerivationStrategyIdComplete AS _StrategyId ON DrvtnStrategyApplicationClass = _StrategyId.DrvtnStrategyApplicationClass AND DrvtnStrategyApplSubclass = _StrategyId.DrvtnStrategyApplSubclass AND DerivationStrategyIdentifier = _StrategyId.DerivationStrategyIdentifier  -- association [1..1]
LEFT OUTER JOIN I_DrvtnStrategyEnvironment AS _Environment ON DrvtnStrategyApplicationClass = _Environment.DrvtnStrategyApplicationClass AND DrvtnStrategyApplSubclass = _Environment.DrvtnStrategyApplSubclass AND DerivationStrategyIdentifier = _Environment.DerivationStrategyIdentifier AND DerivationStrategyEnvironment = _Environment.DerivationStrategyEnvironment  -- association [0..1]
;