KSR_XM_TIME

Transparent Table Temporary Data
12 Fields 2 CDS Views

KSR: Time

KSR_XM_TIME is an SAP database table in S/4HANA. KSR: Time. It contains 12 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
KSR_I_XM_TIME_R view from KSR: Cross Tenant Master Time
TMO_I_XM_TIME_R view from TMO: Cross Tenant Master Time

Fields (12)

KeyField Data ElementDescription DomainTypeLength
KEY timestamp_id ksr_cr_v_timestamp_id Timestamp ID
timestamp_utc timestamp Time Stamp
time_period abap.int4
time_granularity abap.int4
time_zone abap.int4
timestamp_10min_granularity timestamp Time Stamp
timestamp_1h_granularity timestamp Time Stamp
calday sydatum Current Date
calweek abap.numc
calmonth abap.numc
calyear abap.numc
weekday abap.numc

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- KSR: Time
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE KSR_XM_TIME (
    TIMESTAMP_ID,                 -- Timestamp ID [ksr_cr_v_timestamp_id]
    TIMESTAMP_UTC,                -- Time Stamp [timestamp]
    TIME_PERIOD,                  -- abap.int4
    TIME_GRANULARITY,             -- abap.int4
    TIME_ZONE,                    -- abap.int4
    TIMESTAMP_10MIN_GRANULARITY,  -- Time Stamp [timestamp]
    TIMESTAMP_1H_GRANULARITY,     -- Time Stamp [timestamp]
    CALDAY,                       -- Current Date [sydatum]
    CALWEEK,                      -- abap.numc
    CALMONTH,                     -- abap.numc
    CALYEAR,                      -- abap.numc
    WEEKDAY,                      -- abap.numc
    PRIMARY KEY (TIMESTAMP_ID)
);

Learn More