KSR_I_TS_STMTHASH_R

DDL: KSR_I_TS_STMTHASH_R SQL: KSR_ITSSTMTHASHR Type: view
19 Fields 1 Data Sources

KSR: Tenant Single Statement Hashes

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

Data Sources (1)

SourceAliasJoin Type
ksr_ts_stmthash ksr_ts_stmthash from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName KSR_ITSSTMTHASHR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label KSR: Tenant Single Statement Hashes view
ClientHandling.type #CLIENT_DEPENDENT view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY Client ksr_ts_stmthash client Workflow definition: Client
KEY Instance ksr_ts_stmthash instance TaskCount
KEY Record_Number ksr_ts_stmthash record_number INT4
KEY Start_Time ksr_ts_stmthash start_time Time Stamp
KEY Subrecord_Number ksr_ts_stmthash subrecord_number
Connection_Name ksr_ts_stmthash connection_name ID
Statement_Hash ksr_ts_stmthash hash Statement Hash
Statement_Type ksr_ts_stmthash type Worklist Type
Execution_Count ksr_ts_stmthash execution_count Value
Record_Count ksr_ts_stmthash record_count Value
Processing_Time ksr_ts_stmthash processing_time Value
Hana_Cpu_Time ksr_ts_stmthash hana_cpu_time Value
Hana_Max_Memory ksr_ts_stmthash hana_max_mem Value
Hana_Processing_Time
Hana_Execution_Time ksr_ts_stmthash hana_processing_time Value
Hana_Preparation_Time ksr_ts_stmthash hana_preparation_time Value
Retention_Timestamp ksr_ts_stmthash 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_STMTHASH_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_ITSSTMTHASHR

CREATE VIEW KSR_I_TS_STMTHASH_R AS
SELECT
  ksr_ts_stmthash.client AS Client,
  ksr_ts_stmthash.instance AS Instance,
  ksr_ts_stmthash.record_number AS Record_Number,
  ksr_ts_stmthash.start_time AS Start_Time,
  ksr_ts_stmthash.subrecord_number AS Subrecord_Number,
  ksr_ts_stmthash.connection_name AS Connection_Name,
  ksr_ts_stmthash.hash AS Statement_Hash,
  ksr_ts_stmthash.type AS Statement_Type,
  ksr_ts_stmthash.execution_count AS Execution_Count,
  ksr_ts_stmthash.record_count AS Record_Count,
  ksr_ts_stmthash.processing_time AS Processing_Time,
  ksr_ts_stmthash.hana_cpu_time AS Hana_Cpu_Time,
  ksr_ts_stmthash.hana_max_mem AS Hana_Max_Memory,
  ( ksr_ts_stmthash.hana_processing_time + ksr_ts_stmthash.hana_preparation_time) AS Hana_Processing_Time,
  ksr_ts_stmthash.hana_processing_time AS Hana_Execution_Time,
  ksr_ts_stmthash.hana_preparation_time AS Hana_Preparation_Time,
  ksr_ts_stmthash.retention_timestamp AS Retention_Timestamp,
  ksr_ts_main.tenant_group AS Tenant_Group,
  ksr_ts_main.user_group AS User_Group
FROM ksr_ts_stmthash
;

Learn More