The ACMTST_DB_EMPL table in SAP ERP or S/4HANA stores ACMTST: Employee (DB-Table) data. There are total 5 fields in ACMTST_DB_EMPL table. The ACMTST: Employee (DB-Table) table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of ACMTST_DB_EMPL table. It is in Objects for Testing the ACM functionality (SACMTST) ABAP package and is part of the Data Control Language (DCL) (Define Authorizations for CDS) (BC-SEC-AUT-DCL) module.
SAP ACMTST_DB_EMPL Table Fields
Following is the list of fields that are available in SAP ACMTST_DB_EMPL table. The primary key fields of the table are CLIENT (Client), UUID (ACMTST: Globally unique-ID – PrimaryKey of all ACMTST-Tables).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| CLIENT | Client | MANDT | T000 | CLNT (3) |
| UUID | ACMTST: Globally unique-ID – PrimaryKey of all ACMTST-Tables | ACMTST_ID | RAW (16) | |
| LOGIN_NAME | User Name in User Master Record | XUBNAME | ACMTST_DB_USR2 | CHAR (12) |
| GENDER | ACMTST: Gender/Sex | ACMTST_GENDER | CHAR (1) | |
| LANGUAGE | Language Key | SPRAS | * | LANG (1) |
