ATO_PK_ITEMS

Transparent Table Customizing Table
8 Fields 17 CDS Views

Key User adaptation Items (package based)

ATO_PK_ITEMS is an SAP database table in S/4HANA. Key User adaptation Items (package based). It contains 8 fields. 17 CDS views read from this table.

CDS Views using this table (17)

ViewTypeJoinVDMDescription
ATOV_EXIST_ITEM_TYPES view from ato item types existing current system
Atov_Inventory_Base view union Base View for Main ATO Inventory View
ATOV_INVENTORY_BASE_NEW view union Base View for Main ATO Inventory View
ATOV_INVENTORY_NEW view union_all Main View for ATO Inventory App - New
Atov_Item_Map view from mapping for items
ATOV_PK_INVENTORY_ITEM view from Package based item
Atov_Pk_Item view from Package based item
ATOV_PK_ITEM_CONTI_INVALID view left_outer Invalid Contidep Items
Atov_Pk_Item_Conti_Join view from Join Continouse BOM and Package Items
Atov_Pk_Item_ContiDep_Join view from Join Continouse BOM and Package Items
ATOV_PK_ITEM_NAMESPACE view from Derive Namespace Origin from Items
ATOV_U_ITEM_BASE view union_all All items / base view
ATOV_U_ITEM_BASE_DESCRIPTION view union_all Item-Descriptions
ATOV_U_ITEM_BASE_S view union_all All items / small base view
ATOV_U_ITEM_DESCRIPTION view union_all All items with latest description
ATOV_U_ITEM_KEY view union_all All item key
ATOV_U_ITEM_VERSION view union_all All item versions

Fields (8)

KeyField Data ElementDescription DomainTypeLength
KEY item_type ato_item_type Item Type
KEY item_id ato_item_id Item ID
changed_by as4user Last Changed By
change_reason ato_pk_item_change_reason ChangeReason
item_description ato_item_description Item Description
item_status ato_item_status Item Status
last_notification timestamp Time Stamp
prefix namespace Namespace

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.

-- Key User adaptation Items (package based)
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ATO_PK_ITEMS (
    ITEM_TYPE,          -- Item Type [ato_item_type]
    ITEM_ID,            -- Item ID [ato_item_id]
    CHANGED_BY,         -- Last Changed By [as4user]
    CHANGE_REASON,      -- ChangeReason [ato_pk_item_change_reason]
    ITEM_DESCRIPTION,   -- Item Description [ato_item_description]
    ITEM_STATUS,        -- Item Status [ato_item_status]
    LAST_NOTIFICATION,  -- Time Stamp [timestamp]
    PREFIX,             -- Namespace [namespace]
    PRIMARY KEY (ITEM_TYPE, ITEM_ID)
);

Learn More