ACM_DTLOGROOT
ACM: Root-Entry Log Table for Designtime-Artifacts
ACM_DTLOGROOT is an SAP database table in S/4HANA. ACM: Root-Entry Log Table for Designtime-Artifacts. It contains 25 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| ACMDT_DCL_ADDITIONAL_INFO | view | inner | ||
| Acmdt_Dcl_Last_Logas | view | from | Timestamp of the last log entry of a DCL |
Fields (25)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mainobj_tstampl | TIMESTAMPL | Time Stamp | |||
| KEY | mainobj_type | ACMDT_LOG_MAINOBJ_TYPE | Type | |||
| KEY | mainobj_name | ACMDT_LOG_MAINOBJ_NAME | Name | |||
| rootentry_hash | ACM_HASH | ACM Hash | ||||
| last_entry_for_typename | BOOLEAN | Boolean Variable (X = True, - = False, Space = Unknown) | ||||
| caller | CHAR80 | Char80 | ||||
| related_acmtst_log_tstampl | TIMESTAMPL | Time Stamp | ||||
| log_readstatus | ACMDT_LOG_READSTATUS | Read Status | ||||
| log_result | ACMDT_LOG_RESULT | Log Result | ||||
| special_flag | ACMDT_LOG_SPECIALFLAG | Special Flag | ||||
| created_by | XUBNAME | User | ||||
| mandt | CHAR3 | 3-Byte field | ||||
| dbsys | SYST_DBSYS | Database System | ||||
| opsys | SYST_OPSYS | Operating System | ||||
| host | SYST_HOST | AS | ||||
| tcode | SYST_TCODE | Transaction Code | ||||
| cprog | SYST_CPROG | Calling Program | ||||
| wpindex | WPINDEX | Number | ||||
| wppid | WPPID | Process PID | ||||
| epp_root_context_id | EPP_ROOT_CONTEXT_ID | Root ID | ||||
| epp_transaction_id | EPP_TRANSACTION_ID | Transaction | ||||
| epp_connection_id | EPP_CONNECTION_ID | Connection ID | ||||
| epp_connection_counter | EPP_CONNECTION_COUNTER | Counter | ||||
| sapbasis_release | SAPRELEASE | SAP Release | ||||
| sapbasis_patchlevel | SAPPATCHLV | SP Level |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- ACM: Root-Entry Log Table for Designtime-Artifacts
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ACM_DTLOGROOT (
MAINOBJ_TSTAMPL, -- Time Stamp [TIMESTAMPL]
MAINOBJ_TYPE, -- Type [ACMDT_LOG_MAINOBJ_TYPE]
MAINOBJ_NAME, -- Name [ACMDT_LOG_MAINOBJ_NAME]
ROOTENTRY_HASH, -- ACM Hash [ACM_HASH]
LAST_ENTRY_FOR_TYPENAME, -- Boolean Variable (X = True, - = False, Space = Unknown) [BOOLEAN]
CALLER, -- Char80 [CHAR80]
RELATED_ACMTST_LOG_TSTAMPL, -- Time Stamp [TIMESTAMPL]
LOG_READSTATUS, -- Read Status [ACMDT_LOG_READSTATUS]
LOG_RESULT, -- Log Result [ACMDT_LOG_RESULT]
SPECIAL_FLAG, -- Special Flag [ACMDT_LOG_SPECIALFLAG]
CREATED_BY, -- User [XUBNAME]
MANDT, -- 3-Byte field [CHAR3]
DBSYS, -- Database System [SYST_DBSYS]
OPSYS, -- Operating System [SYST_OPSYS]
HOST, -- AS [SYST_HOST]
TCODE, -- Transaction Code [SYST_TCODE]
CPROG, -- Calling Program [SYST_CPROG]
WPINDEX, -- Number [WPINDEX]
WPPID, -- Process PID [WPPID]
EPP_ROOT_CONTEXT_ID, -- Root ID [EPP_ROOT_CONTEXT_ID]
EPP_TRANSACTION_ID, -- Transaction [EPP_TRANSACTION_ID]
EPP_CONNECTION_ID, -- Connection ID [EPP_CONNECTION_ID]
EPP_CONNECTION_COUNTER, -- Counter [EPP_CONNECTION_COUNTER]
SAPBASIS_RELEASE, -- SAP Release [SAPRELEASE]
SAPBASIS_PATCHLEVEL, -- SP Level [SAPPATCHLV]
PRIMARY KEY (MAINOBJ_TSTAMPL, MAINOBJ_TYPE, MAINOBJ_NAME)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA