KSR_I_TS_EPP_R

DDL: KSR_I_TS_EPP_R SQL: KSR_ITSEPPR Type: view
19 Fields 1 Data Sources

KSR: Tenant Single EPP Subrecord

KSR_I_TS_EPP_R is a CDS View that provides data about "KSR: Tenant Single EPP Subrecord" in SAP S/4HANA. It reads from 1 data source (ksr_ts_epp) and exposes 19 fields with key fields Client, Instance, Record_Number, Start_Time, Subrecord_Number.

Data Sources (1)

SourceAliasJoin Type
ksr_ts_epp ksr_ts_epp from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName KSR_ITSEPPR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label KSR: Tenant Single EPP Subrecord view
ClientHandling.type #CLIENT_DEPENDENT view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY Client ksr_ts_epp client Workflow definition: Client
KEY Instance ksr_ts_epp instance TaskCount
KEY Record_Number ksr_ts_epp record_number INT4
KEY Start_Time ksr_ts_epp start_time Time Stamp
KEY Subrecord_Number ksr_ts_epp subrecord_number
Root_Context_Id ksr_ts_epp root_context_id Tran.ID
Connection_Id ksr_ts_epp connection_id Connection Id
Connection_Count ksr_ts_epp connection_count Value
Creator ksr_ts_epp creator User ID
User_Id_Epp ksr_ts_epp user_id_epp User ID
Initial_Action ksr_ts_epp initial_action
Initial_Action_Type ksr_ts_epp initial_action_type
Initial_Component_Id ksr_ts_epp initial_component_id
Initial_Component_Type ksr_ts_epp initial_component_type
Initial_Service_Type ksr_ts_epp initial_service_type
Previous_Component_Id ksr_ts_epp previous_component_id
Retention_Timestamp ksr_ts_epp retention_timestamp Time Stamp
Tenant_Group ksr_ts_main tenant_group Tenant Authorization
User_Group ksr_ts_main user_group User Group

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 KSR_I_TS_EPP_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: KSR_ITSEPPR

CREATE VIEW KSR_I_TS_EPP_R AS
SELECT
  ksr_ts_epp.client AS Client,
  ksr_ts_epp.instance AS Instance,
  ksr_ts_epp.record_number AS Record_Number,
  ksr_ts_epp.start_time AS Start_Time,
  ksr_ts_epp.subrecord_number AS Subrecord_Number,
  ksr_ts_epp.root_context_id AS Root_Context_Id,
  ksr_ts_epp.connection_id AS Connection_Id,
  ksr_ts_epp.connection_count AS Connection_Count,
  ksr_ts_epp.creator AS Creator,
  ksr_ts_epp.user_id_epp AS User_Id_Epp,
  ksr_ts_epp.initial_action AS Initial_Action,
  ksr_ts_epp.initial_action_type AS Initial_Action_Type,
  ksr_ts_epp.initial_component_id AS Initial_Component_Id,
  ksr_ts_epp.initial_component_type AS Initial_Component_Type,
  ksr_ts_epp.initial_service_type AS Initial_Service_Type,
  ksr_ts_epp.previous_component_id AS Previous_Component_Id,
  ksr_ts_epp.retention_timestamp AS Retention_Timestamp,
  ksr_ts_main.tenant_group AS Tenant_Group,
  ksr_ts_main.user_group AS User_Group
FROM ksr_ts_epp
;

Learn More