KSR_I_TA_WP_USED_R

DDL: KSR_I_TA_WP_USED_R SQL: KSR_ITAWPUSEDR Type: view Package: S_KSR_DS
13 Fields 1 Data Sources

KSR: Tenant Aggregated Work Process Used

KSR_I_TA_WP_USED_R is a CDS View that provides data about "KSR: Tenant Aggregated Work Process Used" in SAP S/4HANA. It reads from 1 data source (KSR_I_TA_WORKLOAD_R) and exposes 13 fields with key fields Tenant_Id, Instance, Timestamp_Id, User_Group, Task_Type. Part of development package S_KSR_DS.

Data Sources (1)

SourceAliasJoin Type
KSR_I_TA_WORKLOAD_R KSR_I_TA_WORKLOAD_R from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName KSR_ITAWPUSEDR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label KSR: Tenant Aggregated Work Process Used view
ClientHandling.type #CLIENT_DEPENDENT view

Fields (13)

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
Work_Process_Time Work_Process_Time Value
Queue_Wait_Time Queue_Wait_Time Value
Work_Process_Type Work_Process_Type Work Process Type
Timestamp_UTC TIMESTAMP_UTC Timestamp

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_TA_WP_USED_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_ITAWPUSEDR

CREATE VIEW KSR_I_TA_WP_USED_R AS
SELECT
  Tenant_Id,
  Instance,
  Timestamp_Id,
  User_Group,
  Task_Type,
  Program_Name,
  Program_Context,
  Transaction_Code,
  Tenant_Group,
  Work_Process_Time,
  Queue_Wait_Time,
  Work_Process_Type,
  Timestamp_UTC
FROM KSR_I_TA_WORKLOAD_R
;

Learn More