ATOV_CL_ITEM

CDS View

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)

ViewTypeJoinVDMDescription
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)

KeyField CDS FieldsUsed 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)
);