KSR_C_TA_WORKLOAD_R

DDL: KSR_C_TA_WORKLOAD_R SQL: KSR_CTAWORKLOADR Type: view
32 Fields 1 Data Sources

KSR: Tenant Aggregated Workload

KSR_C_TA_WORKLOAD_R is a CDS View that provides data about "KSR: Tenant Aggregated Workload" in SAP S/4HANA. It reads from 1 data source (KSR_I_TA_WORKLOAD_R) and exposes 32 fields with key fields Tenant_Id, Instance, Timestamp_Id, User_Group, Task_Type.

Data Sources (1)

SourceAliasJoin Type
KSR_I_TA_WORKLOAD_R KSR_I_TA_WORKLOAD_R from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName KSR_CTAWORKLOADR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label KSR: Tenant Aggregated Workload view
ClientHandling.type #CLIENT_DEPENDENT view

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY Tenant_Id Tenant_Id Testplan Description
KEY Instance Instance TaskCount
KEY Timestamp_Id Timestamp_Id Timestamp ID
KEY User_Group User_Group User Group
KEY Task_Type Task_Type Task Type
KEY Program_Name Program_Name Program Name
KEY Program_Context Program_Context Type
KEY Transaction_Code Transaction_Code Transactions
Tenant_Group Tenant_Group Tenant Authorization
Number_Of_Db_Requests Number_Of_Db_Requests Value
Number_Of_Db_Rows Number_Of_Db_Rows Value
Processing_Time_Db_On_Srv Processing_Time_Db_On_Srv Value
Processing_Time_Db Processing_Time_Db Value
Network_Time_Db Network_Time_Db Value
Max_Memory_Db Max_Memory_Db Value
Number_Of_Main_Records Number_Of_Main_Records Value
Work_Process_Time Work_Process_Time Value
Work_Process_Type Work_Process_Type Work Process Type
Server_Response_Time Server_Response_Time Value
Processing_Time Processing_Time Value
Cpu_Time Cpu_Time Value
Hana_Cpu_Time Hana_Cpu_Time Value
Rfc_Time Rfc_Time Value
Roll_Wait_Time Roll_Wait_Time Value
Enqueue_Time Enqueue_Time Value
Load_Times Load_Times Value
Roll_Times Roll_Times Value
TIME_ZONE TIME_ZONE TimeZone
TIME_PERIOD TIME_PERIOD Time Period in Month
TIME_GRANULARITY TIME_GRANULARITY Time Granularity
TIMESTAMP_UTC TIMESTAMP_UTC Timestamp
_XTime _XTime

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_C_TA_WORKLOAD_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_CTAWORKLOADR

CREATE VIEW KSR_C_TA_WORKLOAD_R AS
SELECT
  Tenant_Id,
  Instance,
  Timestamp_Id,
  User_Group,
  Task_Type,
  Program_Name,
  Program_Context,
  Transaction_Code,
  Tenant_Group,
  Number_Of_Db_Requests,
  Number_Of_Db_Rows,
  Processing_Time_Db_On_Srv,
  Processing_Time_Db,
  Network_Time_Db,
  Max_Memory_Db,
  Number_Of_Main_Records,
  Work_Process_Time,
  Work_Process_Type,
  Server_Response_Time,
  Processing_Time,
  Cpu_Time,
  Hana_Cpu_Time,
  Rfc_Time,
  Roll_Wait_Time,
  Enqueue_Time,
  Load_Times,
  Roll_Times,
  TIME_ZONE,
  TIME_PERIOD,
  TIME_GRANULARITY,
  TIMESTAMP_UTC
FROM KSR_I_TA_WORKLOAD_R
;

Learn More