SNWD_EMPLOYEES - EPM: Employee Data
EPM: Employee Data information is stored in SAP table SNWD_EMPLOYEES.
It is part of development package S_NWDEMO_MODEL_DDIC in software component BC-SRV-NWD. This development package consists of objects that can be grouped under "Common Data Dictionary Objects (only) for EPM and NWDEMO".
It is part of development package S_NWDEMO_MODEL_DDIC in software component BC-SRV-NWD. This development package consists of objects that can be grouped under "Common Data Dictionary Objects (only) for EPM and NWDEMO".
Fields for table SNWD_EMPLOYEES
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| CLIENT | Client | X | MANDT | CLNT | 6 | T000 |
| NODE_KEY | EPM: Generic Node Key | X | SNWD_NODE_KEY | RAW | 16 | |
| PARENT_KEY | EPM: Generic Node Key | SNWD_NODE_KEY | RAW | 16 | SNWD_COMPANY | |
| EMPLOYEE_ID | EPM: Employee ID | SNWD_EMPLOYEE_ID | CHAR | 20 | ||
| FIRST_NAME | EPM: First Name | SNWD_FIRST_NAME | CHAR | 80 | ||
| MIDDLE_NAME | EPM: Middle Name | SNWD_MIDDLE_NAME | CHAR | 80 | ||
| LAST_NAME | EPM: Last Name | SNWD_LAST_NAME | CHAR | 80 | ||
| INITIALS | EPM: Initials | SNWD_INITIALS | CHAR | 20 | ||
| SEX | EPM: Gender | SNWD_SEX | CHAR | 2 | ||
| LANGUAGE | Language Key | SPRAS | LANG | 2 | * | |
| PHONE_NUMBER | EPM: Phone Number | SNWD_PHONE_NUMBER | CHAR | 60 | ||
| FAX_NUMBER | EPM: Fax Number | SNWD_FAX_NUMBER | CHAR | 60 | ||
| MOBILE_NUMBER | EPM: Mobile Phone Number | SNWD_MOBILE_NUMBER | CHAR | 60 | ||
| EMAIL_ADDRESS | EPM: E-Mail Address | SNWD_EMAIL_ADDRESS | CHAR | 510 | ||
| LOGIN_NAME | User Name | SYUNAME | CHAR | 24 | ||
| PR_ADDRESS_GUID | EPM: Generic Node Key | SNWD_NODE_KEY | RAW | 16 | SNWD_AD | |
| VAL_START_DATE | EPM: Start date of Validity | SNWD_VALIDITY_START_DATE | DATS | 16 | ||
| VAL_END_DATE | EPM: End date of Validity | SNWD_VALIDITY_END_DATE | DATS | 16 | ||
| CURRENCY | EPM: Currency Code | SNWD_CURR_CODE | CUKY | 10 | ||
| SALARY_AMOUNT | EPM: Salary | SNWD_SALARY_AMOUNT | CURR | 8 | ||
| ACCOUNT_NUMBER | EPM: Account of a bank | SNWD_BANK_ACCOUNT | CHAR | 20 | ||
| BANK_ID | EPM: ID of a bank | SNWD_BANK_ID | CHAR | 20 | ||
| BANK_NAME | EPM: Name of a bank | SNWD_BANK_NAME | CHAR | 510 | ||
| EMPLOYEE_PIC_URL | EPM: URL of Product Image | SNWD_EMPLOYEE_PIC_URL | CHAR | 510 |