Sunday, May 19, 2024

SAP Table ACM_DTLOGROOT – ACM: Root-Entry Log Table for Designtime-Artifacts

ACM_DTLOGROOT is a standard SAP table in SAP ECC (or) S/4HANA which stores ACM: Root-Entry Log Table for Designtime-Artifacts data. There are total 23 fields in ACM_DTLOGROOT table.This blog post provides key technical details of SAP table ACM_DTLOGROOT, including its availability across SAP S/4HANA versions and the list of CDS views for ACM_DTLOGROOT table in SAP.

SAP HANA Table Type Column Store
Buffering Permission Buffering not allowed
Buffering Type No buffering
Package Common Objects for Access Control Management (SACM_COMMON)
Technical Component Data Control Language (DCL) (Define Authorizations for CDS) (BC-SEC-AUT-DCL)

SAP ACM_DTLOGROOT Table Fields

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

Field Description Data Element Domain Check Table Data Type
MAINOBJ_TSTAMPL UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TIMESTAMPL TZNTSTMPL DEC (21)
MAINOBJ_TYPE ACM: Main-Object Type (for Designtime-Logging) ACMDT_LOG_MAINOBJ_TYPE ACMDT_LOG_MAINOBJ_TYPE CHAR (10)
MAINOBJ_NAME ACM: Main-Object Name (for Designtime-Logging) ACMDT_LOG_MAINOBJ_NAME ACMDT_LOG_MAINOBJ_NAME CHAR (80)
ROOTENTRY_HASH ACM: Hash Value ACM_HASH CHAR40 CHAR (40)
LAST_ENTRY_FOR_TYPENAME Boolean Variable (X = True, – = False, Space = Unknown) BOOLEAN BOOLEAN CHAR (1)
CALLER Char 80 CHAR80 CHAR80 CHAR (80)
RELATED_ACMTST_LOG_TSTAMPL UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TIMESTAMPL TZNTSTMPL DEC (21)
LOG_READSTATUS ACM: Log Read-Status (for Designtime-Logging) ACMDT_LOG_READSTATUS ACMDT_LOG_READSTATUS CHAR (6)
LOG_RESULT ACM: Log Result (for Designtime-Logging) ACMDT_LOG_RESULT ACMDT_LOG_RESULT CHAR (9)
CREATED_BY User Name in User Master Record XUBNAME XUBNAME CHAR (12)
MANDT 3-Byte field CHAR3 CHAR3 CHAR (3)
DBSYS ABAP System Field: Central Database System SYST_DBSYS SYCHAR10 CHAR (10)
OPSYS ABAP System Field: Operating System of Application Server SYST_OPSYS SYOPSYS CHAR (10)
HOST ABAP System Field: Name of Current Application Server SYST_HOST HOST_ID CHAR (32)
TCODE ABAP System Field: Current Transaction Code SYST_TCODE TCODE CHAR (20)
CPROG ABAP System Field: Calling Program SYST_CPROG PROGRAMM CHAR (40)
WPINDEX Work Process Number WPINDEX WPINDEX INT4 (10)
WPPID Process Identification WPPID WPPID CHAR (8)
EPP_ROOT_CONTEXT_ID Root Context ID of Extended Passport (EPP) EPP_ROOT_CONTEXT_ID EPP_ROOT_CONTEXT_ID CHAR (32)
EPP_TRANSACTION_ID Transaction ID in Extended Passport (EPP) EPP_TRANSACTION_ID EPP_TRANSACTION_ID CHAR (32)
EPP_CONNECTION_ID Connection ID of Extended Passport (EPP) EPP_CONNECTION_ID EPP_CONNECTION_ID CHAR (32)
SAPBASIS_RELEASE SAP Release SAPRELEASE CHAR10 CHAR (10)
SAPBASIS_PATCHLEVEL Support Package Level of a Software Component SAPPATCHLV CHAR10 CHAR (10)

Availability

The SAP table ACM_DTLOGROOT 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 ACM_DTLOGROOT table

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