ACM_DTLOGROOT

Transparent Table Temporary Data

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)

ViewTypeJoinVDMDescription
ACMDT_DCL_ADDITIONAL_INFO view inner
Acmdt_Dcl_Last_Logas view from Timestamp of the last log entry of a DCL

Fields (25)

KeyField Data ElementDescription DomainTypeLength
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)
);