/SRMSMC/D_ACT_RT

Transparent Table Application Table
16 Fields 1 CDS Views

/SRMSMC/D_ACT_RT is an SAP database table in S/4HANA. It contains 16 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_SupplierActivity view from BASIC Procurement-Related Activity

Fields (16)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY db_key /BOBF/CONF_KEY NodeID
id /SRMSMC/OBJECT_ID SLC Object ID
name /SRMSMC/MEDIUM_NAME Name
name_upper /SRMSMC/MEDIUM_NAME_UPPER Name
crea_date_time TIMESTAMPL Time Stamp
crea_uname UNAME User Name
lchg_date_time TIMESTAMPL Time Stamp
lchg_uname UNAME User Name
language_code /SRMSMC/LANGUAGE_CODE Language
lifecycle_stcd /SRMSMC/ACT_LIFECYCLE_STAT_CD Lifecycle Status
puc_key /BOBF/CONF_KEY NodeID
start_date /SRMSMC/DATE Date
end_date /SRMSMC/DATE Date
priority /SRMSMC/ACT_PRIORITY Priority
type /SRMSMC/ACT_TYPE Activity Type

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.

-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE /SRMSMC/D_ACT_RT (
    MANDT,           -- Client [MANDT]
    DB_KEY,          -- NodeID [/BOBF/CONF_KEY]
    ID,              -- SLC Object ID [/SRMSMC/OBJECT_ID]
    NAME,            -- Name [/SRMSMC/MEDIUM_NAME]
    NAME_UPPER,      -- Name [/SRMSMC/MEDIUM_NAME_UPPER]
    CREA_DATE_TIME,  -- Time Stamp [TIMESTAMPL]
    CREA_UNAME,      -- User Name [UNAME]
    LCHG_DATE_TIME,  -- Time Stamp [TIMESTAMPL]
    LCHG_UNAME,      -- User Name [UNAME]
    LANGUAGE_CODE,   -- Language [/SRMSMC/LANGUAGE_CODE]
    LIFECYCLE_STCD,  -- Lifecycle Status [/SRMSMC/ACT_LIFECYCLE_STAT_CD]
    PUC_KEY,         -- NodeID [/BOBF/CONF_KEY]
    START_DATE,      -- Date [/SRMSMC/DATE]
    END_DATE,        -- Date [/SRMSMC/DATE]
    PRIORITY,        -- Priority [/SRMSMC/ACT_PRIORITY]
    TYPE,            -- Activity Type [/SRMSMC/ACT_TYPE]
    PRIMARY KEY (MANDT, DB_KEY)
);

Learn More