/SHCM/D_SOR_KY

Transparent Table Application Table
6 Fields 1 CDS Views

System of Record Information for Employees (Employments)

/SHCM/D_SOR_KY is an SAP database table in S/4HANA. System of Record Information for Employees (Employments). It contains 6 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_EmployeeSysOfRecord view from BASIC

Fields (6)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY object_type OTYPE Object type
KEY key_value OBJEKTID Object ID
KEY start_date DATUM Date
end_date DATUM Date
system_of_record /SHCM/SYST_ID System ID

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.

-- System of Record Information for Employees (Employments)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE /SHCM/D_SOR_KY (
    CLIENT,            -- Client [MANDT]
    OBJECT_TYPE,       -- Object type [OTYPE]
    KEY_VALUE,         -- Object ID [OBJEKTID]
    START_DATE,        -- Date [DATUM]
    END_DATE,          -- Date [DATUM]
    SYSTEM_OF_RECORD,  -- System ID [/SHCM/SYST_ID]
    PRIMARY KEY (CLIENT, OBJECT_TYPE, KEY_VALUE, START_DATE)
);

Learn More