ATOV_CL_ITEM
Changelist items
ATOV_CL_ITEM is a CDS View in S/4HANA. Changelist items. It contains 16 fields. 3 CDS views read from this table.
CDS Views using this table (3)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| ATOV_COL_VER_IMP_ITEM | view | inner | Import-relevant collection version items | |
| ATOV_COL_VER_IMP_ITEM_CNT_BASE | view | inner | Base for counter of Import Items | |
| Atov_Import_Forecast | view | inner | Import Forecast for ATO Inventory |
Fields (16)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | item_id | item_id,ItemID | 3 |
| KEY | item_type | item_type,ItemType | 3 |
| Adaptation_Type_Texts | Adaptation_Type_Texts | 1 | |
| Change_List | Change_List | 1 | |
| changelist_id | changelist_id | 1 | |
| changelist_item_import_status | changelist_item_import_status | 1 | |
| img_activity | img_activity | 1 | |
| ImgActivityDescription | ImgActivityDescription | 1 | |
| Import_Status_Texts | Import_Status_Texts | 1 | |
| item_counter | item_counter | 1 | |
| item_description | item_description,ItemDescription | 2 | |
| item_exists | item_exists,ItemExists | 2 | |
| item_last_notification | item_last_notification,ItemChangedAt | 2 | |
| item_last_notification_by | item_last_notification_by,ItemChangedBy | 2 | |
| item_lifecycle_action | item_lifecycle_action | 1 | |
| status | ItemStatus,status | 2 |
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.
-- Changelist items
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ATOV_CL_ITEM (
ITEM_ID,
ITEM_TYPE,
ADAPTATION_TYPE_TEXTS,
CHANGE_LIST,
CHANGELIST_ID,
CHANGELIST_ITEM_IMPORT_STATUS,
IMG_ACTIVITY,
IMGACTIVITYDESCRIPTION,
IMPORT_STATUS_TEXTS,
ITEM_COUNTER,
ITEM_DESCRIPTION,
ITEM_EXISTS,
ITEM_LAST_NOTIFICATION,
ITEM_LAST_NOTIFICATION_BY,
ITEM_LIFECYCLE_ACTION,
STATUS,
PRIMARY KEY (ITEM_ID, ITEM_TYPE)
);
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