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 5 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 (5)
| 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 |
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]
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