ATO_ITEMS

Transparent Table Temporary Data
13 Fields 38 CDS Views

Key User adaptation Items

ATO_ITEMS is an SAP database table in S/4HANA. Key User adaptation Items. It contains 13 fields. 38 CDS views read from this table.

CDS Views using this table (38)

ViewTypeJoinVDMDescription
ATOV_0_ITEMS view from Latest Item State joined
ATOV_CART_COUNT_CHANGED view inner Count changed items in Hotfix
ATOV_CART_COUNT_DELETED view inner Count deleted items in Hotfix
ATOV_CART_COUNT_NEW view inner Count new items in Hotfix
ATOV_CART_COUNT_UNCHANGED view inner Count unchanged items in Hotfix
ATOV_COL_EXP_NUM_UNCHNGED_ITMS view inner Count of unchanged items in collection ver
ATOV_COL_GET_DEP_DOWN view inner Util For Dependancy Count
ATOV_COL_GET_DEP_UP view inner Util For Dependancy Count
ATOV_COL_ITEM_CONTI_INVALID view left_outer Invalid Contidep Items
Atov_Col_Item_Conti_Join view from Join Continous BOM and Collection Items
Atov_Col_Item_ContiDep_Join view from Join Continous Dep and Collection Items
ATOV_COL_ITEM_CONTIDEP_MISSING view left_outer Missing Dependencies of Contidep Items
ATOV_COL_ITEM_HEADER_AND_STATE view left_outer Item Header and State for COL
ATOV_COL_ITEM_HEADER_FILL view from Fill and Verify Item Header Table COL
ATOV_COL_LATEST_ITEM_BASE view from Base View for Latest Items
Atov_History view from Counts Dependancies On others
Atov_History view left_outer Counts Dependancies On others
ATOV_IMP_MISSING_ITEM_DEPS view inner Missing item dependencies at import
Atov_Inventory_Base view from Base View for Main ATO Inventory View
ATOV_INVENTORY_BASE_NEW view from Base View for Main ATO Inventory View
ATOV_INVENTORY_NEW view from Main View for ATO Inventory App - New
ATOV_ITEM view from Item
ATOV_ITEM_ADD_EXP view inner Collection items for Export
ATOV_ITEM_KEY view from Item Keys
Atov_Item_Min_Timestamp view from Item with minimal timestamp
ATOV_ITEM_VER_KEY view from Item version key
ATOV_ITEM_VER_KEY_LATEST view from Latest item version key by last notify
ATOV_ITEM_VER_MAX view from Latest Item version
atov_moved_item_wo_imp_confirm view inner Moved Items wo Import Confirmation
ATOV_NOT_INTEGRATED_ITEMS view_entity inner Items not integrated into mainline
atov_ppl_merge_changes_base view_entity left_outer ATO - PPL Merge Changes Base
ATOV_PPL_MERGE_STAGING_BASE view_entity left_outer ATO - PPL Merge Staging Base
ATOV_REWORK_DEMAND_ITEM_KEY view inner Key for Items with Rework Demand
ATOV_U_ITEM_BASE_DESCRIPTION view from Item-Descriptions
ATOV_U_ITEM_KEY view from All item key
EITV_EXP_FILES_ITEM view inner Template Export File Items
EITV_EXP_ITEM_CHANGE_STATUS view inner Change Status of an Item in Templates
EITV_EXP_ITEMS_ADD_BASE view inner Basic View for Add Items to Templates

Fields (13)

KeyField Data ElementDescription DomainTypeLength
KEY item_type ATO_ITEM_TYPE Item Type
KEY item_id ATO_ITEM_ID Item ID
KEY timestamp TIMESTAMP Time Stamp
original_system_type ATO_ORIGINAL_SYSTEM_ID Origin
changed_by AS4USER Last Changed By
item_description ATO_ITEM_DESCRIPTION Item Description
item_status ATO_ITEM_STATUS Item Status
changereason_i ATO_CHANGEREASON ChangeReason
last_notification TIMESTAMP Time Stamp
transportation_mode ATO_TRANSPORTATION_MODE Transportation Mode
changed_in_batch BOOLEAN Boolean Variable (X = True, - = False, Space = Unknown)
client ATO_CLIENT Client
finish_status ATO_ITEM_FINISH_STATUS Finish Status

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.

-- Key User adaptation Items
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ATO_ITEMS (
    ITEM_TYPE,             -- Item Type [ATO_ITEM_TYPE]
    ITEM_ID,               -- Item ID [ATO_ITEM_ID]
    TIMESTAMP,             -- Time Stamp [TIMESTAMP]
    ORIGINAL_SYSTEM_TYPE,  -- Origin [ATO_ORIGINAL_SYSTEM_ID]
    CHANGED_BY,            -- Last Changed By [AS4USER]
    ITEM_DESCRIPTION,      -- Item Description [ATO_ITEM_DESCRIPTION]
    ITEM_STATUS,           -- Item Status [ATO_ITEM_STATUS]
    CHANGEREASON_I,        -- ChangeReason [ATO_CHANGEREASON]
    LAST_NOTIFICATION,     -- Time Stamp [TIMESTAMP]
    TRANSPORTATION_MODE,   -- Transportation Mode [ATO_TRANSPORTATION_MODE]
    CHANGED_IN_BATCH,      -- Boolean Variable (X = True, - = False, Space = Unknown) [BOOLEAN]
    CLIENT,                -- Client [ATO_CLIENT]
    FINISH_STATUS,         -- Finish Status [ATO_ITEM_FINISH_STATUS]
    PRIMARY KEY (ITEM_TYPE, ITEM_ID, TIMESTAMP)
);

Learn More