ACMTST_DB_EMPL - ACMTST: Employee (DB-Table)
ACMTST: Employee (DB-Table) information is stored in SAP table ACMTST_DB_EMPL.
It is part of development package SACMTST in software component BC-SEC-AUT-DCL. This development package consists of objects that can be grouped under "Objects for Testing the ACM functionality".
It is part of development package SACMTST in software component BC-SEC-AUT-DCL. This development package consists of objects that can be grouped under "Objects for Testing the ACM functionality".
Fields for table ACMTST_DB_EMPL
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| CLIENT | Client | X | MANDT | CLNT | 6 | T000 |
| UUID | ACMTST: Globally unique-ID - PrimaryKey of all ACMTST-Tables | X | ACMTST_ID | RAW | 16 | |
| EMPLOYEE_ID | ACMTST: Employee ID | ACMTST_EMPLOYEE_ID | CHAR | 20 | ||
| FIRST_NAME | First Name | CHAR | 80 | |||
| LAST_NAME | Last Name | CHAR | 80 | |||
| LOGIN_NAME | User Name in User Master Record | XUBNAME | CHAR | 24 | ACMTST_DB_USR2 | |
| GENDER | ACMTST: Gender/Sex | ACMTST_GENDER | CHAR | 2 | ||
| LANGUAGE | Language Key | SPRAS | LANG | 2 | * | |
| PHONE_NUMBER | Phone Number | CHAR | 40 | |||
| EMAIL_ADDRESS | E-Mail Address | CHAR | 120 | |||
| VAL_START_DATE | Start date of Validity | DATS | 16 | |||
| VAL_END_DATE | End date of Validity | DATS | 16 | |||
| CURRENCY_CODE | Currency Code | CUKY | 10 | |||
| SALARY_AMOUNT | Yearly Salary | CURR | 8 | |||
| ACCOUNT_NUMBER | Account Number | CHAR | 20 | |||
| BANK_ID | Bank ID | CHAR | 20 | |||
| BANK_NAME | Name of a bank | CHAR | 510 |