I_DrvtnStrategyEnvironment

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_DrvtnStrategyEnvironment.
-- 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: IDERTSTRENV

CREATE VIEW I_DrvtnStrategyEnvironment AS
SELECT
  DrvtnStrategyApplicationClass,
  DrvtnStrategyApplSubclass,
  DerivationStrategyIdentifier,
  DerivationStrategyEnvironment,
  DrvtnStrgyEnvironmentVersion,
  DrvtnStrgyEnvrmtLastChgdByName,
  DrvtnStrgyEnvrmtLastChangeDate,
  DrvtnStrategyDefTableName
FROM I_DrvtnStrategyEnvironmentBsc
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]
;