ATO_ITEM_HEADER
Key User Adaptation Items - Header for Collection Items
ATO_ITEM_HEADER is an SAP database table in S/4HANA. Key User Adaptation Items - Header for Collection Items. It contains 6 fields. 9 CDS views read from this table.
CDS Views using this table (9)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| ATOV_COL_ITEM_HEADER_AND_STATE | view | from | Item Header and State for COL | |
| ATOV_COL_ITEM_HEADER_FILL | view | left_outer | Fill and Verify Item Header Table COL | |
| ATOV_EXIST_ITEM_TYPES | view | union | ato item types existing current system | |
| ATOV_ITEM_LOCK | view | from | Info about Permanent Item Lock | |
| ATOV_ITEM_PREFIX_SETTINGS | view | from | Join Item Prefix and Settings | |
| ATOV_NAMESPACE_ORIGIN_BY_ITEMS | view | inner | Derive Namespace Origin from Items | |
| ATOV_NOT_INTEGRATED_ITEMS | view_entity | from | Items not integrated into mainline | |
| ATOV_ST_CURRENT_COL_ITEMS | view | inner | Current collection items | |
| EITV_EXP_ITEMS_ADD_BASE | view | from | Basic View for Add Items to Templates |
Fields (6)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | item_type | ato_item_type | Item Type | |||
| KEY | item_id | ato_item_id | Item ID | |||
| prefix | namespace | Namespace | ||||
| prefix_short | namespace | Namespace | ||||
| lock_id | guid | GUID | ||||
| last_integrated_notification | timestamp | Time Stamp |
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 - Header for Collection Items
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ATO_ITEM_HEADER (
ITEM_TYPE, -- Item Type [ato_item_type]
ITEM_ID, -- Item ID [ato_item_id]
PREFIX, -- Namespace [namespace]
PREFIX_SHORT, -- Namespace [namespace]
LOCK_ID, -- GUID [guid]
LAST_INTEGRATED_NOTIFICATION, -- Time Stamp [timestamp]
PRIMARY KEY (ITEM_TYPE, ITEM_ID)
);
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