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 |