KSR_I_TS_GATEWAY_SUM_R

DDL: KSR_I_TS_GATEWAY_SUM_R SQL: KSR_ITSGWSUMR Type: view Package: S_KSR_DS
14 Fields 1 Data Sources

KSR: Tenant Single Gateway Subrecords

KSR_I_TS_GATEWAY_SUM_R is a CDS View that provides data about "KSR: Tenant Single Gateway Subrecords" in SAP S/4HANA. It reads from 1 data source (ksr_ts_gateway) and exposes 14 fields with key fields Client, Instance, Record_Number, Start_Time, Subrecord_Number. Part of development package S_KSR_DS.

Data Sources (1)

SourceAliasJoin Type
ksr_ts_gateway ksr_ts_gateway from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName KSR_ITSGWSUMR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label KSR: Tenant Single Gateway Subrecords view
ClientHandling.type #CLIENT_DEPENDENT view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY Client ksr_ts_gateway client Workflow definition: Client
KEY Instance ksr_ts_gateway instance TaskCount
KEY Record_Number ksr_ts_gateway record_number INT4
KEY Start_Time ksr_ts_gateway start_time Time Stamp
KEY Subrecord_Number ksr_ts_gateway subrecord_number
Service_Name ksr_ts_gateway service_name Service Name
Operation ksr_ts_gateway operation Transaction
Service_Entity_Type ksr_ts_gateway service_entity_type
Processing_Time ksr_ts_gateway processing_time Value
Framework_Total_Time
Application_Time ksr_ts_gateway app_time Value
Retention_Timestamp ksr_ts_gateway 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_GATEWAY_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_ITSGWSUMR

CREATE VIEW KSR_I_TS_GATEWAY_SUM_R AS
SELECT
  ksr_ts_gateway.client AS Client,
  ksr_ts_gateway.instance AS Instance,
  ksr_ts_gateway.record_number AS Record_Number,
  ksr_ts_gateway.start_time AS Start_Time,
  ksr_ts_gateway.subrecord_number AS Subrecord_Number,
  ksr_ts_gateway.service_name AS Service_Name,
  ksr_ts_gateway.operation AS Operation,
  ksr_ts_gateway.service_entity_type AS Service_Entity_Type,
  ksr_ts_gateway.processing_time AS Processing_Time,
  ksr_ts_gateway.framework_time + ksr_ts_gateway.non_gw_time AS Framework_Total_Time,
  ksr_ts_gateway.app_time AS Application_Time,
  ksr_ts_gateway.retention_timestamp AS Retention_Timestamp,
  ksr_ts_main.tenant_group AS Tenant_Group,
  ksr_ts_main.user_group AS User_Group
FROM ksr_ts_gateway
;

Learn More