KSR_I_XM_TIME_R

DDL: KSR_I_XM_TIME_R SQL: KSR_IXMTIMER Type: view
12 Fields 1 Data Sources

KSR: Cross Tenant Master Time

KSR_I_XM_TIME_R is a CDS View that provides data about "KSR: Cross Tenant Master Time" in SAP S/4HANA. It reads from 1 data source (ksr_xm_time) and exposes 12 fields with key field TimestampId.

Data Sources (1)

SourceAliasJoin Type
ksr_xm_time ksr_xm_time from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName KSR_IXMTIMER view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label KSR: Cross Tenant Master Time view
ClientHandling.type #CLIENT_INDEPENDENT view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY TimestampId timestamp_id Timestamp ID
TimestampUtc timestamp_utc Timestamp
TimePeriod time_period Time Period in Month
TimeGranularity time_granularity Time Granularity
Time_Zone time_zone TimeZone
Timestamp_10Min_Granularity timestamp_10min_granularity Time Stamp
Timestamp_1H_Granularity timestamp_1h_granularity Time Stamp
Calday calday Current Date
Calweek calweek
Calmonth calmonth
Calyear calyear
Weekday weekday Weekdays

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_XM_TIME_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_IXMTIMER

CREATE VIEW KSR_I_XM_TIME_R AS
SELECT
  timestamp_id AS TimestampId,
  timestamp_utc AS TimestampUtc,
  time_period AS TimePeriod,
  time_granularity AS TimeGranularity,
  Time_Zone,
  Timestamp_10Min_Granularity,
  Timestamp_1H_Granularity,
  Calday,
  Calweek,
  Calmonth,
  Calyear,
  Weekday
FROM ksr_xm_time
;

Learn More