SRF_REP_CAT_ACT

Transparent Table System Table (transport)

Activity Definition

SRF_REP_CAT_ACT is an SAP database table in S/4HANA. Activity Definition. It contains 14 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_StRpActivityDef view from BASIC Activity Definition

Fields (14)

KeyField Data ElementDescription DomainTypeLength
KEY rep_cat_id SRF_REP_CAT_ID Report ID
KEY rep_cat_version SRF_REP_CAT_VERSION Category Version
KEY activity_id SRF_ACTIVITY_ID Activity ID
activity_type SRF_ACTIVITY_TYPE Activity Type
activity_phase SRF_REP_CAT_PHASE Phase
valid_from SRF_VALID_FROM Valid From Dt.
valid_from_earliest SRF_VALID_FROM_EARLIEST Earliest Date
valid_to SRF_VALID_TO Valid To Date
report_id SRF_REPORT_ID Report Definition
submission_mode SRF_SUBMISSION_MODE Submission Mode
activity_predecessor SRF_ACTIVITY_ID Activity ID
can_be_reopened SRF_ACTIVITY_REOPEN Reopen
application_id SRF_APPLICATION_ID Application ID
activity_group SRF_ACTIVITY_GROUP Activity Group

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.

-- Activity Definition
-- Category TRANSPARENT · Delivery class W
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SRF_REP_CAT_ACT (
    REP_CAT_ID,            -- Report ID [SRF_REP_CAT_ID]
    REP_CAT_VERSION,       -- Category Version [SRF_REP_CAT_VERSION]
    ACTIVITY_ID,           -- Activity ID [SRF_ACTIVITY_ID]
    ACTIVITY_TYPE,         -- Activity Type [SRF_ACTIVITY_TYPE]
    ACTIVITY_PHASE,        -- Phase [SRF_REP_CAT_PHASE]
    VALID_FROM,            -- Valid From Dt. [SRF_VALID_FROM]
    VALID_FROM_EARLIEST,   -- Earliest Date [SRF_VALID_FROM_EARLIEST]
    VALID_TO,              -- Valid To Date [SRF_VALID_TO]
    REPORT_ID,             -- Report Definition [SRF_REPORT_ID]
    SUBMISSION_MODE,       -- Submission Mode [SRF_SUBMISSION_MODE]
    ACTIVITY_PREDECESSOR,  -- Activity ID [SRF_ACTIVITY_ID]
    CAN_BE_REOPENED,       -- Reopen [SRF_ACTIVITY_REOPEN]
    APPLICATION_ID,        -- Application ID [SRF_APPLICATION_ID]
    ACTIVITY_GROUP,        -- Activity Group [SRF_ACTIVITY_GROUP]
    PRIMARY KEY (REP_CAT_ID, REP_CAT_VERSION, ACTIVITY_ID)
);