I_DrvtnStrgyTraceCallStack

DDL: I_DRVTNSTRGYTRACECALLSTACK Type: view_entity COMPOSITE
19 Fields 1 Data Sources 4 Associations

Call Stack of Derivation Trace

I_DrvtnStrgyTraceCallStack is a Composite CDS View that provides data about "Call Stack of Derivation Trace" in SAP S/4HANA. It reads from 1 data source (I_DrvtnStrgyTraceCallStackBsc) and exposes 19 fields with key fields UserName, DrvtnStrategyApplicationClass, DrvtnStrategyApplSubclass, DerivationStrategyIdentifier, DerivationStrategyEnvironment. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_DrvtnStrgyTraceCallStackBsc I_DrvtnStrgyTraceCallStackBsc from

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 (6)

NameValueLevelField
EndUserText.label Call Stack of Derivation Trace view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY UserName UserName User who owns item
KEY DrvtnStrategyApplicationClass DrvtnStrategyApplicationClass Applicatn Class
KEY DrvtnStrategyApplSubclass DrvtnStrategyApplSubclass Subclass
KEY DerivationStrategyIdentifier DerivationStrategyIdentifier Strategy ID
KEY DerivationStrategyEnvironment DerivationStrategyEnvironment Environment strat.
KEY DerivationStrgyTraceUUID DerivationStrgyTraceUUID UUID
KEY ABAPCallStackLevelValue ABAPCallStackLevelValue Stack Level
DerivationStrategyName _StrategyId DerivationStrategyName
ABAPCallStackMainProgramName ABAPCallStackMainProgramName Program Name
ABAPCallStackPgmIncludeName ABAPCallStackPgmIncludeName
ABAPCallStackProgramLineNumber ABAPCallStackProgramLineNumber VAT Return Line Item
ABAPCallStackProgramBlockType ABAPCallStackProgramBlockType Block Type
ABAPCallStackProgramBlockName ABAPCallStackProgramBlockName Block Name
ABAPCallStackIsSystemProgram ABAPCallStackIsSystemProgram Is System Code?
_TraceResult _TraceResult
_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 I_DrvtnStrgyTraceCallStack.
-- 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 I_DrvtnStrgyTraceCallStack AS
SELECT
  UserName,
  DrvtnStrategyApplicationClass,
  DrvtnStrategyApplSubclass,
  DerivationStrategyIdentifier,
  DerivationStrategyEnvironment,
  DerivationStrgyTraceUUID,
  ABAPCallStackLevelValue,
  _StrategyId.DerivationStrategyName AS DerivationStrategyName,
  ABAPCallStackMainProgramName,
  ABAPCallStackPgmIncludeName,
  ABAPCallStackProgramLineNumber,
  ABAPCallStackProgramBlockType,
  ABAPCallStackProgramBlockName,
  ABAPCallStackIsSystemProgram
FROM I_DrvtnStrgyTraceCallStackBsc
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