KSR_SIZ_C_TS_MAIN_R

DDL: KSR_SIZ_C_TS_MAIN_R Type: view_entity Package: S_KSR_SIZ
20 Fields 1 Data Sources 1 OData Services

KSR: Tenant Single Main Records and Tags

KSR_SIZ_C_TS_MAIN_R is a CDS View that provides data about "KSR: Tenant Single Main Records and Tags" in SAP S/4HANA. It reads from 1 data source (KSR_SIZ_I_TS_MAIN_R) and exposes 20 fields with key fields TenantId, Instance, RecordNumber, StartTime, ProfileId. It is exposed through 1 OData service (KSR_UI_SIZ_PROFILES_R). Part of development package S_KSR_SIZ.

Data Sources (1)

SourceAliasJoin Type
KSR_SIZ_I_TS_MAIN_R KSR_SIZ_I_TS_MAIN_R from

Annotations (2)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label KSR: Tenant Single Main Records and Tags view

OData Services (1)

ServiceBindingVersionContractRelease
KSR_UI_SIZ_PROFILES_R KSR_UI_SIZ_PROFILES_O2 V2 C1 NOT_RELEASED

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY TenantId TenantId Tenant ID
KEY Instance Instance TaskCount
KEY RecordNumber RecordNumber INT4
KEY StartTime StartTime Time Stamp
KEY ProfileId ProfileId Profile
EndTime EndTime Time Stamp
UserId UserId User Name
TenantGroup TenantGroup Tenant Authorization
UserGroup UserGroup User Group
ProgramName ProgramName Program Name
ProgramContext ProgramContext Type
RequestEntryName RequestEntryName Request Entry Name
RequestEntryType RequestEntryType Request Entry Type
TransactionCode TransactionCode Transaction Code
MaxMemoryDb MaxMemoryDb
WorkProcessTime WorkProcessTime
CpuTime CpuTime Time
TotalMemory TotalMemory
CpuTimeDb CpuTimeDb
MaxMemorySt MaxMemorySt

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_SIZ_C_TS_MAIN_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.

CREATE VIEW KSR_SIZ_C_TS_MAIN_R AS
SELECT
  TenantId,
  Instance,
  RecordNumber,
  StartTime,
  ProfileId,
  EndTime,
  UserId,
  TenantGroup,
  UserGroup,
  ProgramName,
  ProgramContext,
  RequestEntryName,
  RequestEntryType,
  TransactionCode,
  MaxMemoryDb,
  WorkProcessTime,
  CpuTime,
  TotalMemory,
  CpuTimeDb,
  MaxMemorySt
FROM KSR_SIZ_I_TS_MAIN_R
;

Learn More