HRS1000

Transparent Table System Table (transport)
9 Fields 6 CDS Views

Standard Infotype 1000 (SAP) Object Existence

HRS1000 is an SAP database table in S/4HANA. Standard Infotype 1000 (SAP) Object Existence. It contains 9 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
HRS1000_M view from Text Verticalization: Replacement View for HRS1000
I_WorkflowPDOrgObjectText view from BASIC Workflow: PD-Org object text
P_DFS_PosStdWrkflwTaskName view from BASIC
SWF_ACT_SCENARIO_SEARCHHELP view left_outer Search help for active scenarios
SWF_TASK_SPI_TASKS view from Tasks
SWF_TASK_SPI_TASKS view left_outer Tasks

Fields (9)

KeyField Data ElementDescription DomainTypeLength
KEY otype HR_SOTYPE Std.object type
KEY objid HR_SOBJID Object ID
KEY langu LANGU Language
aedtm AEDTM Changed on
uname USRNAME User Name
short SHORT_D Object abbr.
stext STEXT Name
mc_short HR_MCSHORT Object abbr.
mc_stext HR_MCSTEXT Name

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.

-- Standard Infotype 1000 (SAP) Object Existence
-- Category TRANSPARENT · Delivery class W
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE HRS1000 (
    OTYPE,     -- Std.object type [HR_SOTYPE]
    OBJID,     -- Object ID [HR_SOBJID]
    LANGU,     -- Language [LANGU]
    AEDTM,     -- Changed on [AEDTM]
    UNAME,     -- User Name [USRNAME]
    SHORT,     -- Object abbr. [SHORT_D]
    STEXT,     -- Name [STEXT]
    MC_SHORT,  -- Object abbr. [HR_MCSHORT]
    MC_STEXT,  -- Name [HR_MCSTEXT]
    PRIMARY KEY (OTYPE, OBJID, LANGU)
);

Learn More