ATO_COL_ITEMS
Key User adaptation Items
ATO_COL_ITEMS is an SAP database table in S/4HANA. Key User adaptation Items. It contains 12 fields. 21 CDS views read from this table.
CDS Views using this table (21)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| ATOV_0_ITEMS | view | inner | Latest Item State joined | |
| ATOV_COL_ASSIGNED_AT_MAX | view | from | Latest date of assignment for collection | |
| atov_col_deps_latest_col_ver | view | inner | Dependencies on Coll Versions at Export | |
| ATOV_COL_EXP_NUM_CHANGED_ITEMS | view | from | Count of changed items in collection ver | |
| ATOV_COL_EXP_NUM_CURRENT_ITEMS | view | from | Count of current items in collection | |
| ATOV_COL_EXP_NUM_DELETED_ITEMS | view | from | Count of deleted items in collection ver | |
| ATOV_COL_EXP_NUM_UNCHNGED_ITMS | view | from | Count of unchanged items in collection ver | |
| ATOV_COL_ITEM_MIN_TIMESTAMP | view | from | Col Item with minimal timestamp | |
| ATOV_COL_ITEMS_KEY_MAX | view | from | Keys of collection version items | |
| ATOV_COL_ITEMS_LATEST_COL | view | from | LATEST COLLECTION FOR AN GIVEN ITEM | |
| ATOV_COL_LATEST_ITEM_BASE | view | inner | Base View for Latest Items | |
| ATOV_COL_VER_COUNT_CHANGE | view | from | Count changes in collection version | |
| ATOV_COL_VER_ITEM_KEY | view | inner | Keys of collection version items | |
| ATOV_COL_VER_ITEM_KEY_LATEST | view | inner | Keys of latest collection version items | |
| ATOV_CURRENT_COLLECTION_OF_ITM | view | from | Current Collection of Item | |
| Atov_History | view | left_outer | Counts Dependancies On others | |
| Atov_History | view | union | Counts Dependancies On others | |
| ATOV_ITEM_MOVE_LATEST_EXP_COL | view | from | Latest export for moved items | |
| Atov_Latest_Imported_Item_Key | view | from | Latest Imported Items for ATO Inventory | |
| Atov_Latest_Imported_Items | view | inner | Latest Imported Items for ATO Inventory | |
| ATOV_NAMESPACE_ORIGIN_BY_ITEMS | view | from | Derive Namespace Origin from Items |
Fields (12)
| Key | Field | Data Element | Description |
|---|---|---|---|
| KEY | item_type | ATO_ITEM_TYPE | |
| KEY | item_id | ATO_ITEM_ID | |
| KEY | timestamp | TIMESTAMP | |
| KEY | collection_id | ATO_COLLECTION_ID | |
| collection_version | ATO_COLLECTION_VERSION | ||
| assigned_by | AS4USER | ||
| item_status | ATO_COL_ITEM_STATUS | ||
| changereason_c | ATO_CHANGEREASON | ||
| last_assignment | TIMESTAMP | ||
| deferred_from_version | ATO_COLLECTION_VERSION | ||
| source_collection_id | ATO_COLLECTION_ID | ||
| source_collection_version | ATO_COLLECTION_VERSION |