Sunday, May 19, 2024

SAP Table ACMTST_DB_EMPL – ACMTST: Employee (DB-Table)

ACMTST_DB_EMPL is a standard SAP table in SAP ECC (or) S/4HANA which stores ACMTST: Employee (DB-Table) data. There are total 5 fields in ACMTST_DB_EMPL table.This blog post provides key technical details of SAP table ACMTST_DB_EMPL, including its availability across SAP S/4HANA versions and the list of CDS views for ACMTST_DB_EMPL table in SAP.

SAP HANA Table Type Column Store
Buffering Permission Buffering not allowed
Buffering Type No buffering
Package Objects for Testing the ACM functionality (SACMTST)
Technical Component Data Control Language (DCL) (Define Authorizations for CDS) (BC-SEC-AUT-DCL)

SAP ACMTST_DB_EMPL Table Fields

The following is the list of fields that are available in SAP ACMTST_DB_EMPL table. The key fields of the table are highlighted in color.

Field Description Data Element Domain Check Table Data Type
CLIENT Client MANDT MANDT T000 CLNT (3)
UUID ACMTST: Globally unique-ID – PrimaryKey of all ACMTST-Tables ACMTST_ID ACM_ID RAW (16)
LOGIN_NAME User Name in User Master Record XUBNAME XUBNAME ACMTST_DB_USR2 CHAR (12)
GENDER ACMTST: Gender/Sex ACMTST_GENDER ACMTST_GENDER CHAR (1)
LANGUAGE Language Key SPRAS SPRAS * LANG (1)

Availability

The SAP table ACMTST_DB_EMPL is available within SAP S/4HANA On-premise and SAP S/4HANA Cloud systems depending on the version and release level.

SAP S/4HANA Version Available?
1909 Yes
2020 Yes
2021 Yes
2022 Yes
2023 Yes

CDS Views for ACMTST_DB_EMPL table

There are no CDS views available in the system. We’re updating the content all the time, so check back regularly.