EMPLOYEE_ID in SNWD_EMPLOYEES
Employee ID (DE: ID des Mitarbeiters)
EMPLOYEE_ID is a field in SAP table SNWD_EMPLOYEES (EPM: Employee Data). It represents "Employee ID". Data element: SNWD_EMPLOYEE_ID. Available in 16 CDS view(s) as employee_id, Employee, ChangedBy.
Business Meaning
| Description (EN) | Employee ID |
|---|---|
| Beschreibung (DE) | ID des Mitarbeiters |
| Data Element | SNWD_EMPLOYEE_ID |
| Key Field | No |
CDS Views & Technical Names (16)
SNWD_EMPLOYEES.EMPLOYEE_ID is exposed in CDS views under the following technical names. Views reading the table directly are listed first; "via" marks views that pass the field on through intermediate views.
employee_id
(6 views)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| AunitElemInfo_01 | direct | |||
| eTestEmployeeView | direct | Base View of HIERARCHY Model | ||
| SDDIC_TEST_DDLX_BASE | direct | Test Object for SCP/DDLX, Do not change! | ||
| sepm_sddl_employees | direct | |||
| eSDDIC_TEST_TPA_CHILD | via 2 level | TO-PARENT Association, Child | ||
| sepm_sddl_employee_j | via 2 level |
Employee
(3 views)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| SEPM_I_Employee | direct | EPM Demo: Employee | ||
| S_EPM_WF_USER | via 2 level | BASIC | EPM Demo: User/Employee | |
| SEPM_I_Employee_E | via 2 level | EPM Demo: Employee with External IDs |
ChangedBy
(2 views)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| Sadl_V_Exp_Vocan_BuPa | direct | Sales Orders | ||
| Sadl_V_Exp_Vocan_SO | direct | Sales Orders |
CreatedBy
(2 views)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| Sadl_V_Exp_Vocan_BuPa | direct | Sales Orders | ||
| Sadl_V_Exp_Vocan_SO | direct | Sales Orders |
EmployeeID
(4 views)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| REPM_Employee | via 3 levels | Employee View | ||
| Repm_Employeev2 | via 3 levels | Employee View | ||
| REPM_EmployeeTextv2 | via 4 levels | Employee Text View | ||
| REPM_EmpText | via 4 levels | Employee Text View |
changed_by_employee_id
(1 view)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| sepm_sddl_salesorder_head | via 2 level |
created_by_employee_id
(1 view)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| sepm_sddl_salesorder_head | via 2 level |
Other Tables with Field EMPLOYEE_ID (8)
| Table | Data Element | Key | Description |
|---|---|---|---|
| /CPD/D_MP_MEMBER | /CPD/PWS_WS_EMP_ID | Project Member | |
| ACMTST_DB_EMPL | ACMTST_EMPLOYEE_ID | ACMTST: Employee (DB-Table) | |
| ACMTST_EMPL_H | ACMTST_EMPLOYEE_ID | ACMTST: Hierarchy for Employee (ACMTST_DB_EMPL) | |
| CTE_D_FIN_I_EMPL | CTE_CONCUR_FIELD_VALUE | SubVal Importing table - Employee | |
| CUAND_CE_IA_RT | HPA_GENERIC_OBJECT_ID | Interaction Root Node | |
| DEMO_EMPL_HIER | ABAP.INT2 | KEY | Employee Table for testing CDS Hierarchy |
| HRFIO_D_CALSHA | PERNR_D | KEY | Team Calendar Shared Employees |
| SNWD_LR_HEADER | SNWD_EMPLOYEE_ID | EPM: Leave Request header data |
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA