SMN_I_TS_Session_R

DDL: SMN_I_TS_SESSION_R SQL: SMN_ITSSESSIONR Type: view
26 Fields 1 Data Sources 1 Associations

SMN: Tenant Single Session Data

SMN_I_TS_Session_R is a CDS View that provides data about "SMN: Tenant Single Session Data" in SAP S/4HANA. It reads from 1 data source (smn_ts_session) and exposes 26 fields with key fields Client, Instance, Tenant_Id, Logon_Hdl, Logon_Id. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
smn_ts_session smn_ts_session from

Associations (1)

CardinalityTargetAliasCondition
[1..1] KSR_I_XM_TIME_R _XTime $projection.Timestamp_Id = _XTime.TimestampId

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName SMN_ITSSESSIONR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label SMN: Tenant Single Session Data view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY Client client Workflow definition: Client
KEY Instance instance TaskCount
KEY Tenant_Id tenant_id Testplan Description
KEY Logon_Hdl logon_hdl Logon Key
KEY Logon_Id logon_id Logon ID
KEY Session_Hdl session_hdl Session Handle
Timestamp_Id timestamp_id Timestamp ID
Tenant_Group tenant_group Tenant Authorization
User_Group user_group User Group
User_Name user_name User Name
Logon_Type logon_type Type
Logon_Sub_Type logon_sub_type Type
Location location Text
Application application UI Application
Application_Info application_info Text
Extended_Memory extended_memory Value
Heap_Memory heap_memory Value
Rfc_Hdl rfc_hdl Text
Rfc_Type rfc_type Type
Trace trace Tracking level
Open_Tasks open_tasks Open Tasks
Act_Program act_program Main Program
TIME_ZONE _XTime Time_Zone TimeZone
Time_Period time_period Time Period in Month
TIME_GRANULARITY time_granularity Time Granularity
TIMESTAMP_UTC timestamp UTC Time Stamp in Short Form (YYYYMMDDhhmmss)

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_Session_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_ITSSESSIONR

CREATE VIEW SMN_I_TS_Session_R AS
SELECT
  Client,
  Instance,
  Tenant_Id,
  Logon_Hdl,
  Logon_Id,
  Session_Hdl,
  Timestamp_Id,
  Tenant_Group,
  User_Group,
  User_Name,
  Logon_Type,
  Logon_Sub_Type,
  Location,
  Application,
  Application_Info,
  Extended_Memory,
  Heap_Memory,
  Rfc_Hdl,
  Rfc_Type,
  Trace,
  Open_Tasks,
  Act_Program,
  _XTime.Time_Zone AS TIME_ZONE,
  Time_Period,
  TIME_GRANULARITY,
  timestamp AS TIMESTAMP_UTC
FROM smn_ts_session
LEFT OUTER JOIN KSR_I_XM_TIME_R AS _XTime ON Timestamp_Id = _XTime.TimestampId  -- association [1..1]
;

Learn More