ATO_XC_ITEM_HIST

Transparent Table Application Table
18 Fields 2 CDS Views

History of Multitenant ATO Items

ATO_XC_ITEM_HIST is an SAP database table in S/4HANA. History of Multitenant ATO Items. It contains 18 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
ATO_COL_XC_ITEM_KEY_LATEST view inner Keys of latest collection version items
ATOV_CL_XC_ITEM_EXP view inner Client Depend Changlist Items for Export

Fields (18)

KeyField Data ElementDescription DomainTypeLength
KEY client abap.clnt
KEY item_type ATO_ITEM_TYPE Item Type
KEY item_id ATO_ITEM_ID Item ID
KEY timestamp TIMESTAMPL Time Stamp
item_description ATO_ITEM_DESCRIPTION Item Description
item_status ATO_ITEM_STATUS Item Status
changereason ATO_XC_CHANGEREASON ChangeReason
last_notification_version ATO_COLLECTION_VERSION Collection Version
last_notification TIMESTAMP Time Stamp
last_notification_by AS4USER Last Changed By
collection_id ATO_COLLECTION_ID Collection ID
assign_collection_version ATO_COLLECTION_VERSION Collection Version
assigned_by AS4USER Last Changed By
assigned_at TIMESTAMP Time Stamp
transported_by AS4USER Last Changed By
transported_at TIMESTAMP Time Stamp
last_branch_action_at TIMESTAMP Time Stamp
last_branch_action_by AS4USER Last Changed By

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.

-- History of Multitenant ATO Items
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ATO_XC_ITEM_HIST (
    CLIENT,                     -- abap.clnt
    ITEM_TYPE,                  -- Item Type [ATO_ITEM_TYPE]
    ITEM_ID,                    -- Item ID [ATO_ITEM_ID]
    TIMESTAMP,                  -- Time Stamp [TIMESTAMPL]
    ITEM_DESCRIPTION,           -- Item Description [ATO_ITEM_DESCRIPTION]
    ITEM_STATUS,                -- Item Status [ATO_ITEM_STATUS]
    CHANGEREASON,               -- ChangeReason [ATO_XC_CHANGEREASON]
    LAST_NOTIFICATION_VERSION,  -- Collection Version [ATO_COLLECTION_VERSION]
    LAST_NOTIFICATION,          -- Time Stamp [TIMESTAMP]
    LAST_NOTIFICATION_BY,       -- Last Changed By [AS4USER]
    COLLECTION_ID,              -- Collection ID [ATO_COLLECTION_ID]
    ASSIGN_COLLECTION_VERSION,  -- Collection Version [ATO_COLLECTION_VERSION]
    ASSIGNED_BY,                -- Last Changed By [AS4USER]
    ASSIGNED_AT,                -- Time Stamp [TIMESTAMP]
    TRANSPORTED_BY,             -- Last Changed By [AS4USER]
    TRANSPORTED_AT,             -- Time Stamp [TIMESTAMP]
    LAST_BRANCH_ACTION_AT,      -- Time Stamp [TIMESTAMP]
    LAST_BRANCH_ACTION_BY,      -- Last Changed By [AS4USER]
    PRIMARY KEY (CLIENT, ITEM_TYPE, ITEM_ID, TIMESTAMP)
);

Learn More