ATO_COLS

Transparent Table Temporary Data
27 Fields 41 CDS Views

Adaptation Collections

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

CDS Views using this table (41)

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_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 (27)

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 FLAG Indicator
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.

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,               -- Indicator [FLAG]
    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]
    PRIMARY KEY (COLLECTION_ID)
);

Learn More