C_DrvtnStrgyTraceStepChange

DDL: C_DRVTNSTRGYTRACESTEPCHANGE Type: view_entity CONSUMPTION
17 Fields 1 Data Sources 4 Associations

Derivation Trace Step Changes

C_DrvtnStrgyTraceStepChange is a Consumption CDS View that provides data about "Derivation Trace Step Changes" in SAP S/4HANA. It reads from 1 data source (I_DrvtnStrgyTraceStepChange) and exposes 17 fields with key fields UserName, DrvtnStrategyApplicationClass, DrvtnStrategyApplSubclass, DerivationStrategyIdentifier, DerivationStrategyEnvironment. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_DrvtnStrgyTraceStepChange I_DrvtnStrgyTraceStepChange projection

Associations (4)

CardinalityTargetAliasCondition
[1..1] I_DrvtnStrategyApplClass _ApplicationClass $projection.DrvtnStrategyApplicationClass = _ApplicationClass.DrvtnStrategyApplicationClass
[1..1] I_DrvtnStrategyApplSubclass _Subclass $projection.DrvtnStrategyApplicationClass = _Subclass.DrvtnStrategyApplicationClass and $projection.DrvtnStrategyApplSubclass = _Subclass.DrvtnStrategyApplSubclass
[1..1] I_DerivationStrategyIdComplete _StrategyId $projection.DrvtnStrategyApplicationClass = _StrategyId.DrvtnStrategyApplicationClass and $projection.DrvtnStrategyApplSubclass = _StrategyId.DrvtnStrategyApplSubclass and $projection.DerivationStrategyIdentifier = _StrategyId.DerivationStrategyIdentifier
[0..1] I_DrvtnStrategyEnvironment _Environment $projection.DrvtnStrategyApplicationClass = _Environment.DrvtnStrategyApplicationClass and $projection.DrvtnStrategyApplSubclass = _Environment.DrvtnStrategyApplSubclass and $projection.DerivationStrategyIdentifier = _Environment.DerivationStrategyIdentifier and $projection.DerivationStrategyEnvironment = _Environment.DerivationStrategyEnvironment

Annotations (8)

NameValueLevelField
EndUserText.label Derivation Trace Step Changes view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
Consumption.semanticObject DerivationTraceStepChange view
VDM.viewType #CONSUMPTION view
Metadata.allowExtensions true view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY UserName UserName User who owns item
KEY DrvtnStrategyApplicationClass DrvtnStrategyApplicationClass
KEY DrvtnStrategyApplSubclass DrvtnStrategyApplSubclass
KEY DerivationStrategyIdentifier DerivationStrategyIdentifier
KEY DerivationStrategyEnvironment DerivationStrategyEnvironment
KEY DerivationStrgyTraceUUID DerivationStrgyTraceUUID
KEY DerivationStrategyStepNumber DerivationStrategyStepNumber
KEY DerivationStrategyFieldName DerivationStrategyFieldName
DerivationStrategyName DerivationStrategyName
DrvtnStrategyOldFieldValue DrvtnStrategyOldFieldValue
DrvtnStrategyNewFieldValue DrvtnStrategyNewFieldValue
DerivationStrategyStepText DerivationStrategyStepText
DerivationStrgyStepMethodType DerivationStrgyStepMethodType
_ApplicationClass _ApplicationClass
_Subclass _Subclass
_StrategyId _StrategyId
_Environment _Environment

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]
;

Learn More