ATOV_COL_XC_ITEM_BASE_LATEST

CDS View
10 Fields 1 CDS Views

Collection version latest items base

ATOV_COL_XC_ITEM_BASE_LATEST is a CDS View in S/4HANA. Collection version latest items base. It contains 10 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
ATOV_COL_VER_EXP_XC_ITEM view from Collection version xc items for Export

Fields (10)

KeyField CDS FieldsUsed in Views
KEY collection_id collection_id 1
KEY collection_version collection_version 1
KEY item_id item_id 1
KEY item_type item_type 1
collection_item_status item_status 1
exported_at timestamp 1
item_description item_description 1
item_last_notification changed_at 1
last_notification changed_at,timestamp 1
last_notification_by changed_by 1

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.

-- Collection version latest items base
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ATOV_COL_XC_ITEM_BASE_LATEST (
    COLLECTION_ID,
    COLLECTION_VERSION,
    ITEM_ID,
    ITEM_TYPE,
    COLLECTION_ITEM_STATUS,
    EXPORTED_AT,
    ITEM_DESCRIPTION,
    ITEM_LAST_NOTIFICATION,
    LAST_NOTIFICATION,
    LAST_NOTIFICATION_BY,
    PRIMARY KEY (COLLECTION_ID, COLLECTION_VERSION, ITEM_ID, ITEM_TYPE)
);

Learn More