SNWD_EMPLOYEES

Transparent Table Temporary Data
24 Fields 10 CDS Views

EPM: Employee Data

SNWD_EMPLOYEES is an SAP database table in S/4HANA. EPM: Employee Data. It contains 24 fields. 10 CDS views read from this table.

CDS Views using this table (10)

ViewTypeJoinVDMDescription
AunitElemInfo_01 view from
eTestEmployeeView view from Base View of HIERARCHY Model
REPM_EmployeeV1 view from Employee View
Sadl_V_Exp_Field_Cntr view left_outer CDS View Testing Dynamic Field Control
Sadl_V_Exp_Vocan_BuPa view left_outer Sales Orders
Sadl_V_Exp_Vocan_SO view left_outer Sales Orders
SDDIC_TEST_DDLX_BASE view from Test Object for SCP/DDLX, Do not change!
SEPM_I_Employee view from EPM Demo: Employee
SEPM_I_User view from EPM Demo: User
sepm_sddl_employees view from

Fields (24)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY node_key SNWD_NODE_KEY Node Key
parent_key SNWD_NODE_KEY Node Key
employee_id SNWD_EMPLOYEE_ID Employee ID
first_name SNWD_FIRST_NAME First Name
middle_name SNWD_MIDDLE_NAME Middle Name
last_name SNWD_LAST_NAME Last Name
initials SNWD_INITIALS Initials
sex SNWD_SEX Gender
language SPRAS Language
phone_number SNWD_PHONE_NUMBER Phone
fax_number SNWD_FAX_NUMBER Fax
mobile_number SNWD_MOBILE_NUMBER Mobile Phone Number
email_address SNWD_EMAIL_ADDRESS Email
login_name SYUNAME User Name
pr_address_guid SNWD_NODE_KEY Node Key
val_start_date SNWD_VALIDITY_START_DATE Valid From
val_end_date SNWD_VALIDITY_END_DATE Valid Until
currency SNWD_CURR_CODE Currency Code
salary_amount SNWD_SALARY_AMOUNT Salary
account_number SNWD_BANK_ACCOUNT Bank Account No.
bank_id SNWD_BANK_ID Bank ID
bank_name SNWD_BANK_NAME Bank Name
employee_pic_url SNWD_EMPLOYEE_PIC_URL Pic URI

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.

-- EPM: Employee Data
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SNWD_EMPLOYEES (
    CLIENT,            -- Client [MANDT]
    NODE_KEY,          -- Node Key [SNWD_NODE_KEY]
    PARENT_KEY,        -- Node Key [SNWD_NODE_KEY]
    EMPLOYEE_ID,       -- Employee ID [SNWD_EMPLOYEE_ID]
    FIRST_NAME,        -- First Name [SNWD_FIRST_NAME]
    MIDDLE_NAME,       -- Middle Name [SNWD_MIDDLE_NAME]
    LAST_NAME,         -- Last Name [SNWD_LAST_NAME]
    INITIALS,          -- Initials [SNWD_INITIALS]
    SEX,               -- Gender [SNWD_SEX]
    LANGUAGE,          -- Language [SPRAS]
    PHONE_NUMBER,      -- Phone [SNWD_PHONE_NUMBER]
    FAX_NUMBER,        -- Fax [SNWD_FAX_NUMBER]
    MOBILE_NUMBER,     -- Mobile Phone Number [SNWD_MOBILE_NUMBER]
    EMAIL_ADDRESS,     -- Email [SNWD_EMAIL_ADDRESS]
    LOGIN_NAME,        -- User Name [SYUNAME]
    PR_ADDRESS_GUID,   -- Node Key [SNWD_NODE_KEY]
    VAL_START_DATE,    -- Valid From [SNWD_VALIDITY_START_DATE]
    VAL_END_DATE,      -- Valid Until [SNWD_VALIDITY_END_DATE]
    CURRENCY,          -- Currency Code [SNWD_CURR_CODE]
    SALARY_AMOUNT,     -- Salary [SNWD_SALARY_AMOUNT]
    ACCOUNT_NUMBER,    -- Bank Account No. [SNWD_BANK_ACCOUNT]
    BANK_ID,           -- Bank ID [SNWD_BANK_ID]
    BANK_NAME,         -- Bank Name [SNWD_BANK_NAME]
    EMPLOYEE_PIC_URL,  -- Pic URI [SNWD_EMPLOYEE_PIC_URL]
    PRIMARY KEY (CLIENT, NODE_KEY)
);

Learn More