ATO_COLS

Transparent Table Temporary Data
28 Fields 43 CDS Views

Adaptation Collections

ATO_COLS is an SAP database table in S/4HANA. Adaptation Collections. It contains 28 fields. 43 CDS views read from this table.

CDS Views using this table (43)

ViewTypeJoinVDMDescription
ATO_V_RESTRICTED_COLLECTIONS view inner Collection ID for Customizing Transports
ATOV_ADDON_REWORK_TASK view_entity inner Rewrk task for itm in software component
atov_apj_cust_trans view inner Custom transports for ATO audit app
ATOV_BC_OPEN_MANUAL_POSTPROC view left_outer BC manual postprocessing not finished
ATOV_BC_OPEN_TRANSPORTS view left_outer BC Transports not sucessfully imported
atov_calm_release_status view inner Release status of ATO transport for CALM
ATOV_CART_COUNT view from Count Items in Hotfix
ATOV_CBC_AND_BC_REQUESTS view_entity inner All CBC and BC request
atov_changelist_minus_ignored view inner Changelists filtered for ignored lists
ATOV_Cl_FINAL view inner Final changelists (non-preliminary)
ATOV_CL_FINAL_CROSS_CLIENT view_entity inner ATOV_CL_FINAL_CROSS_CLIENT
ATOV_CL_ITEM_MERGED view_entity inner Merged Changelist Items
ATOV_CMN_COL_IMPORT_USAGES view_entity inner ATO:
ATOV_CMN_GET_ALL_IMPORTABLE view inner Common Import: Get all auto. rel. SWCs
ATOV_CMN_GET_ALL_PENDINGS view inner Get all pending collections
ATOV_CMN_GET_RUN_OR_PREPARED view_entity left_outer ATO: Get running or prepared collections
atov_cmn_import_dependencies view inner Depends of collection versions at import
ATOV_COL view from Collections
ATOV_COL_EXP view from Collections
atov_col_ver_approv_allow_base view_entity inner Collections allowed to set QA Status
atov_col_ver_discarded view_entity inner Discarded collection versions
ATOV_COL_VER_FORWARDABLE_BASE view_entity inner Forwardable without QA restriction
ATOV_COL_VER_IMP_VER_KEY view inner Collection Version Import Version Keys
ATOV_COL_VER_IMPORTABLE view_entity inner Importable Collections
ATOV_COL_VER_PENDING view inner Pending collection versions
ATOV_COL_VER_STATUS view inner Collection import status
atov_collection_type_import view_entity inner Collection type for use at import
atov_collection_type_import view_entity from Collection type for use at import
atov_cols_for_current_client view_entity from ATO_COLS filtered for current client
ATOV_CURRENT_COLLECTION_OF_ITM view inner Current Collection of Item
ATOV_EXTSIBILITY_COLLECTION view from Extensibility Collection
ATOV_ITEM_ADD_EXP view inner Collection items for Export
ATOV_NAMESPACE_ORIGIN_BY_ITEMS view left_outer Derive Namespace Origin from Items
ATOV_PLUGIN_IMPORT_STATUS view left_outer Plugin Import Status
ATOV_PLUGIN_OPEN_IMPORTS view left_outer Plugin Imports which are not finished
atov_ppl_merge_changes view_entity left_outer ATO - PLL Merge Changes
ATOV_ST_CURRENT_COLS view inner Collections with imported items
atov_st_late_col_ver_no_import view inner Latest collection version is not imported
atov_st_not_imported_items view inner Not imported items
atov_ta_import_check_relevant view_entity inner Automatic Import Check Col Versions
atov_ta_import_relevant view_entity inner Automatic Import Check Col Versions
EITV_EXP_ITEMS_ADD_BASE view inner Basic View for Add Items to Templates
EITV_EXP_TEMPL view from UI View for Export Templates

Fields (28)

KeyField Data ElementDescription DomainTypeLength
KEY collection_id ato_collection_id Collection ID
original_system_type ato_original_system_id Origin
last_changed_by as4user Last Changed By
last_changed_at timestamp Time Stamp
created_by as4user Last Changed By
created_at timestamp Time Stamp
description_text ato_collection_description Collect Description
category ato_collection_category Category
devclass devclass Package
dev_namespace namespace Namespace
ignore_cross_request_errors flag Indicator
import_check_for_release ato_release_compatibility Release Compat.
original_systname srcsystem Original System
counter abap.int2
client ato_client Client
use_tms_config ato_cols_use_tms_config
forwarding_rule ato_import_forwarding_rule Forwarding Rule
export_locked boolean Boolean Variable (X = True, - = False, Space = Unknown)
add_item_locked boolean Boolean Variable (X = True, - = False, Space = Unknown)
notify_locked boolean Boolean Variable (X = True, - = False, Space = Unknown)
lock_comment char50 c
status ato_col_status Collection Status
next_export_variant ato_action_variant Variant
collection_type ato_collection_type Collection Type
project_id tr_extpid Project ID
project_description as4text Short Description
software_component dlvunit Softw. Comp.
repository_name text132 Text

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.

-- Adaptation Collections
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ATO_COLS (
    COLLECTION_ID,                -- Collection ID [ato_collection_id]
    ORIGINAL_SYSTEM_TYPE,         -- Origin [ato_original_system_id]
    LAST_CHANGED_BY,              -- Last Changed By [as4user]
    LAST_CHANGED_AT,              -- Time Stamp [timestamp]
    CREATED_BY,                   -- Last Changed By [as4user]
    CREATED_AT,                   -- Time Stamp [timestamp]
    DESCRIPTION_TEXT,             -- Collect Description [ato_collection_description]
    CATEGORY,                     -- Category [ato_collection_category]
    DEVCLASS,                     -- Package [devclass]
    DEV_NAMESPACE,                -- Namespace [namespace]
    IGNORE_CROSS_REQUEST_ERRORS,  -- Indicator [flag]
    IMPORT_CHECK_FOR_RELEASE,     -- Release Compat. [ato_release_compatibility]
    ORIGINAL_SYSTNAME,            -- Original System [srcsystem]
    COUNTER,                      -- abap.int2
    CLIENT,                       -- Client [ato_client]
    USE_TMS_CONFIG,               -- ato_cols_use_tms_config
    FORWARDING_RULE,              -- Forwarding Rule [ato_import_forwarding_rule]
    EXPORT_LOCKED,                -- Boolean Variable (X = True, - = False, Space = Unknown) [boolean]
    ADD_ITEM_LOCKED,              -- Boolean Variable (X = True, - = False, Space = Unknown) [boolean]
    NOTIFY_LOCKED,                -- Boolean Variable (X = True, - = False, Space = Unknown) [boolean]
    LOCK_COMMENT,                 -- c [char50]
    STATUS,                       -- Collection Status [ato_col_status]
    NEXT_EXPORT_VARIANT,          -- Variant [ato_action_variant]
    COLLECTION_TYPE,              -- Collection Type [ato_collection_type]
    PROJECT_ID,                   -- Project ID [tr_extpid]
    PROJECT_DESCRIPTION,          -- Short Description [as4text]
    SOFTWARE_COMPONENT,           -- Softw. Comp. [dlvunit]
    REPOSITORY_NAME,              -- Text [text132]
    PRIMARY KEY (COLLECTION_ID)
);

Learn More