ATOV_ITEM_VER_MAX

CDS View

Latest Item version

ATOV_ITEM_VER_MAX is a CDS View in S/4HANA. Latest Item version. It contains 7 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
ATOV_U_ITEM_BASE view from All items / base view
ATOV_U_ITEM_BASE_S view from All items / small base view
ATOV_U_ITEM_DESCRIPTION view from All items with latest description

Fields (7)

KeyField CDS FieldsUsed in Views
KEY item_id item_id 3
KEY item_type item_type 3
changed_at changed_at 3
changed_by changed_by 2
item_description item_description 2
item_status change_operation 2
original_system_type original_system_type 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.

-- Latest Item version
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ATOV_ITEM_VER_MAX (
    ITEM_ID,
    ITEM_TYPE,
    CHANGED_AT,
    CHANGED_BY,
    ITEM_DESCRIPTION,
    ITEM_STATUS,
    ORIGINAL_SYSTEM_TYPE,
    PRIMARY KEY (ITEM_ID, ITEM_TYPE)
);