HRUS_D2

Transparent Table Application Table
7 Fields 2 CDS Views

User Substituted by User

HRUS_D2 is an SAP database table in S/4HANA. User Substituted by User. It contains 7 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_UserSubstitute view from BASIC User Substitutes
I_WorkflowTaskRecipient view right_outer BASIC Work item recipients

Fields (7)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY us_name XUBNAME User
KEY rep_name XUBNAME User
KEY begda BEGDATUM Start date
endda ENDDATUM End Date
reppr HR_REP_PRF Substitute Profile
active HS_REP_ACT Substitution active

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.

-- User Substituted by User
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE HRUS_D2 (
    MANDT,     -- Client [MANDT]
    US_NAME,   -- User [XUBNAME]
    REP_NAME,  -- User [XUBNAME]
    BEGDA,     -- Start date [BEGDATUM]
    ENDDA,     -- End Date [ENDDATUM]
    REPPR,     -- Substitute Profile [HR_REP_PRF]
    ACTIVE,    -- Substitution active [HS_REP_ACT]
    PRIMARY KEY (MANDT, US_NAME, REP_NAME, BEGDA)
);

Learn More