SMN_I_TS_STACK_R

DDL: SMN_I_TS_STACK_R SQL: SMN_ITSSTACKR Type: view Package: S_SMN_DS
20 Fields 1 Data Sources

SMN: Tenant Single Stack Trace Data

SMN_I_TS_STACK_R is a CDS View that provides data about "SMN: Tenant Single Stack Trace Data" in SAP S/4HANA. It reads from 1 data source (smn_ts_work_prc) and exposes 20 fields with key fields Client, Instance, Tenant_Id, Wp_Index, Nr. Part of development package S_SMN_DS.

Data Sources (1)

SourceAliasJoin Type
smn_ts_work_prc smn_ts_work_prc from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName SMN_ITSSTACKR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label SMN: Tenant Single Stack Trace Data view
ClientHandling.type #CLIENT_DEPENDENT view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY Client smn_ts_work_prc client Workflow definition: Client
KEY Instance smn_ts_work_prc instance TaskCount
KEY Tenant_Id smn_ts_work_prc tenant_id Testplan Description
KEY Wp_Index smn_ts_work_prc wp_index WP Number
KEY Nr smn_ts_stack_tr nr Number
Tenant_Group smn_ts_work_prc tenant_group Tenant Authorization
User_Group smn_ts_work_prc user_group User Group
Main_Program smn_ts_stack_tr mainprogram Program Name
Include smn_ts_stack_tr include
Line smn_ts_stack_tr line VAT Return Line Item
Event_Type smn_ts_stack_tr eventtype Event date type
Event_Name smn_ts_stack_tr eventname
Class smn_ts_stack_tr class User Group
Flag_System smn_ts_stack_tr flag_system Is System Code?
Hash smn_ts_work_prc stack_trace_hash Hash Value
Timestamp_UTC smn_ts_work_prc timestamp UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
Collection_TIMESTAMP smn_ts_work_prc timestamp UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
Time_Period smn_ts_work_prc time_period Time Period in Month
Time_Granularity smn_ts_work_prc time_granularity Time Granularity
Time_Zone KSR_I_XM_TIME_R Time_Zone TimeZone

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 SMN_I_TS_STACK_R.
-- 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: SMN_ITSSTACKR

CREATE VIEW SMN_I_TS_STACK_R AS
SELECT
  smn_ts_work_prc.client AS Client,
  smn_ts_work_prc.instance AS Instance,
  smn_ts_work_prc.tenant_id AS Tenant_Id,
  smn_ts_work_prc.wp_index AS Wp_Index,
  smn_ts_stack_tr.nr AS Nr,
  smn_ts_work_prc.tenant_group AS Tenant_Group,
  smn_ts_work_prc.user_group AS User_Group,
  smn_ts_stack_tr.mainprogram AS Main_Program,
  smn_ts_stack_tr.include AS Include,
  smn_ts_stack_tr.line AS Line,
  smn_ts_stack_tr.eventtype AS Event_Type,
  smn_ts_stack_tr.eventname AS Event_Name,
  smn_ts_stack_tr.class AS Class,
  smn_ts_stack_tr.flag_system AS Flag_System,
  smn_ts_work_prc.stack_trace_hash AS Hash,
  smn_ts_work_prc.timestamp AS Timestamp_UTC,
  smn_ts_work_prc.timestamp AS Collection_TIMESTAMP,
  smn_ts_work_prc.time_period AS Time_Period,
  smn_ts_work_prc.time_granularity AS Time_Granularity,
  KSR_I_XM_TIME_R.Time_Zone AS Time_Zone
FROM smn_ts_work_prc
;

Learn More