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 Test Object; Do not change!
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 EPM: CDS DDL entity view for table snwd_employees

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