ksr_i_ts_dbcon_sum_r

DDL: KSR_I_TS_DBCON_SUM_R SQL: KSR_ITSDBCONSUMR Type: view
11 Fields 1 Data Sources

KSR: Tenant Single DB Connection Subrecord Summary

ksr_i_ts_dbcon_sum_r is a CDS View that provides data about "KSR: Tenant Single DB Connection Subrecord Summary" in SAP S/4HANA. It reads from 1 data source (KSR_I_TS_DBCON_R) and exposes 11 fields with key fields client, Instance, Record_Number, Start_Time, Subrecord_Number.

Data Sources (1)

SourceAliasJoin Type
KSR_I_TS_DBCON_R KSR_I_TS_DBCON_R from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName KSR_ITSDBCONSUMR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label KSR: Tenant Single DB Connection Subrecord Summary view
ClientHandling.type #CLIENT_DEPENDENT view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY client client Workflow definition: Client
KEY Instance Instance TaskCount
KEY Record_Number Record_Number INT4
KEY Start_Time Start_Time Time Stamp
KEY Subrecord_Number Subrecord_Number
Connection_Name Connection_Name ID
Hana_Cpu_Time_Consumption Hana_Cpu_Time_Consumption Value
Hana_Memory_Consumption Hana_Memory_Consumption Value
Hana_Processing_Time Hana_Processing_Time Value
User_Group User_Group User Group
Tenant_Group Tenant_Group Tenant Authorization

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_dbcon_sum_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_ITSDBCONSUMR

CREATE VIEW ksr_i_ts_dbcon_sum_r AS
SELECT
  client,
  Instance,
  Record_Number,
  Start_Time,
  Subrecord_Number,
  Connection_Name,
  Hana_Cpu_Time_Consumption,
  Hana_Memory_Consumption,
  Hana_Processing_Time,
  User_Group,
  Tenant_Group
FROM KSR_I_TS_DBCON_R
;

Learn More