COACHNGLISTACTIV

Transparent Table Temporary Data
14 Fields 1 CDS Views

Chart of Accounts Change List Items

COACHNGLISTACTIV is an SAP database table in S/4HANA. Chart of Accounts Change List Items. It contains 14 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_GLAccountInOperatingCOA view from BASIC GL Account Changes in Operating COA

Fields (14)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY itemnumber ITEMUUID Item ID
ktopl KTOPL Chart of Accts
saknr SAKNR G/L Account
target_saknr TARGET_SAKNR Target G/L Acct No
target_short_description TARGET_SHORT_DESCRIPTION Targt Acct Short Txt
target_long_description TARGET_LONG_DESCRIPTION Target G/L Acct Txt
action FI_DTE_ACTION Action Worklist Item
itemstatus FI_DTE_ITEMSTATUS Status Item
check_result FI_DTE_CHECKRESULT Check Result
importuuid IMPORTUUID Import ID of File
created_by CREATEDBY Created By
created_on TIMESTAMP Time Stamp
grouping GL_ACCOUNT_CHANGE_LIST_GROUP Worklist Group

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.

-- Chart of Accounts Change List Items
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE COACHNGLISTACTIV (
    MANDT,                     -- Client [MANDT]
    ITEMNUMBER,                -- Item ID [ITEMUUID]
    KTOPL,                     -- Chart of Accts [KTOPL]
    SAKNR,                     -- G/L Account [SAKNR]
    TARGET_SAKNR,              -- Target G/L Acct No [TARGET_SAKNR]
    TARGET_SHORT_DESCRIPTION,  -- Targt Acct Short Txt [TARGET_SHORT_DESCRIPTION]
    TARGET_LONG_DESCRIPTION,   -- Target G/L Acct Txt [TARGET_LONG_DESCRIPTION]
    ACTION,                    -- Action Worklist Item [FI_DTE_ACTION]
    ITEMSTATUS,                -- Status Item [FI_DTE_ITEMSTATUS]
    CHECK_RESULT,              -- Check Result [FI_DTE_CHECKRESULT]
    IMPORTUUID,                -- Import ID of File [IMPORTUUID]
    CREATED_BY,                -- Created By [CREATEDBY]
    CREATED_ON,                -- Time Stamp [TIMESTAMP]
    GROUPING,                  -- Worklist Group [GL_ACCOUNT_CHANGE_LIST_GROUP]
    PRIMARY KEY (MANDT, ITEMNUMBER)
);

Learn More