ATO_COL_VERSIONS
Adaptation collection versions
ATO_COL_VERSIONS is an SAP database table in S/4HANA. Adaptation collection versions. It contains 23 fields. 59 CDS views read from this table.
CDS Views using this table (59)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| atov_apj_cust_trans | view | inner | Custom transports for ATO audit app | |
| atov_apj_import_timeframe | view | from | Collection Version Import Time Frame | |
| ATOV_BC_COL_VER_STATE_BASE | view | from | Basic Collection Version Status View | |
| ATOV_BC_OPEN_MANUAL_POSTPROC | view | from | BC manual postprocessing not finished | |
| ATOV_BC_OPEN_TRANSPORTS | view | left_outer | BC Transports not sucessfully imported | |
| atov_calm_release_status | view | union_all | Release status of ATO transport for CALM | |
| atov_cmn_col_ver_imp_his_base | view_entity | from | Base view for col version import history | |
| ATOV_CMN_GET_ALL_IMPORTABLE | view | from | Common Import: Get all auto. rel. SWCs | |
| ATOV_CMN_IMP_FRCST_CHNL_LOGIC | view_entity | from | Import Type Forcast | |
| ATOV_CMN_IMP_MAX_RID_4_IMP | view_entity | from | Common Import: Get import channel | |
| ATOV_CMN_IMP_NUM_PART_IMPORTS | view_entity | from | Common Import: Number of tries with status partially import | |
| ATOV_CMN_NOT_IMPORTABLE | view_entity | from | Software Collections aren | |
| ATOV_CMN_PENDING_IMPORTABALE | view | left_outer | Get pending importable transports | |
| ATOV_CMN_RID_OF_SUCESS_FORWARD | view_entity | from | Common Import: Get import channel | |
| ATOV_COL_EXPORT_STATUS | view_entity | from | Export Status of a Software Collection version | |
| atov_col_imp_version_actions | view | from | Import Actions per Collection Version | |
| ATOV_COL_USR_VH | view_entity | from | User Value Help | |
| ATOV_COL_USR_VH | view_entity | union | User Value Help | |
| atov_col_ver_action_key | view_entity | from | Keys of collection versions per action | |
| atov_col_ver_approv_allow_base | view_entity | from | Collections allowed to set QA Status | |
| atov_col_ver_approv_allow_base | view_entity | union_all | Collections allowed to set QA Status | |
| ATOV_COL_VER_COUNT_LOGS_BASE | view | from | Export Log Counter | |
| ATOV_COL_VER_HISTORY_TIMESTAMP | view_entity | from | Collection Version historical timestamp | |
| ATOV_COL_VER_IMP_BASE1 | view | from | Import-relevant Collection Base1 | |
| ATOV_COL_VER_IMP_KEY | view | inner | Collection Version Import Keys | |
| atov_col_ver_imp_latest_ballog | view_entity | inner | Latest Import Ballog_Handle | |
| ATOV_COL_VER_KEY | view | from | Keys of collection versions | |
| ATOV_COL_VER_KEY_LATEST | view | from | Latest collection version | |
| ATOV_COL_VER_KEY_MAX | view | from | Latest collection version | |
| ATOV_COL_VER_KEY_MAX_TIMESTAMP | view | from | Keys of collection versions | |
| ATOV_COL_VER_LOG_CHECK_KEY_MAX | view | from | Latest check log of collection version | |
| ATOV_COL_VER_LOG_KEY_MAX | view | from | Latest log for collection version | |
| ATOV_COL_VER_PENDING | view | from | Pending collection versions | |
| atov_col_ver_provide_discard | view_entity | from | Determine visibility of Discard button | |
| atov_col_ver_qa_reject_allowed | view_entity | from | Collection eligible for quality rejecton | |
| atov_col_ver_reject_allowed | view_entity | from | Collection eligible for quality rejecton | |
| atov_col_ver_set_as_imported | view_entity | from | Set as imported collection versions | |
| atov_col_ver_set_qa_allow_base | view_entity | from | Collections allowed to set QA Status | |
| atov_col_ver_set_qa_allow_base | view_entity | union_all | Collections allowed to set QA Status | |
| ATOV_EXPORT_LOG | view | from | Export Log | |
| atov_latest_imp_log_timestamp | view_entity | from | Timestamp of latest Import Log | |
| Atov_Latest_Imported_Item_Key | view | inner | Latest Imported Items for ATO Inventory | |
| Atov_Latest_Imported_Items | view | inner | Latest Imported Items for ATO Inventory | |
| ATOV_LOG | view | from | Log | |
| ATOV_PLUGIN_IMPORT_STATUS | view | from | Plugin Import Status | |
| ATOV_PLUGIN_OPEN_IMPORTS | view | from | Plugin Imports which are not finished | |
| atov_predecessor_same_release | view_entity | from | Predecessor of collection versions | |
| atov_predecessor_same_release | view_entity | inner | Predecessor of collection versions | |
| ATOV_ST_ACTION_MAX_TIMESTAMP | view | from | Max collection version action timestamp | |
| ATOV_ST_CURRENT_COLS | view | inner | Collections with imported items | |
| ATOV_ST_CURRENT_VERSION_ACTION | view | inner | Current collection version action | |
| atov_st_item_latest_changel | view | inner | Latest changelist of an item | |
| atov_st_late_col_ver_no_import | view | inner | Latest collection version is not imported | |
| atov_st_latest_col_version | view | from | Latest imported changelist of an item | |
| atov_status_schema_mig_incompl | view_entity | from | Collection versions not fully migrated | |
| atov_status_schema_mig_incompl | view_entity | union | Collection versions not fully migrated | |
| atov_status_schema_not_discard | view_entity | from | Not discarded collection versions | |
| atov_status_schema_not_yet_mig | view_entity | from | Collection versions not yet migrated | |
| atov_status_schema_qa_status | view_entity | from | Quality approval status |
Fields (23)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | collection_id | ATO_COLLECTION_ID | Collection ID | |||
| KEY | timestamp | TIMESTAMP | Time Stamp | |||
| KEY | version | ATO_COLLECTION_VERSION | Collection Version | |||
| resource_id | TIMESTAMPL | Time Stamp | ||||
| status | ATO_COLLECTION_STATUS | Status | ||||
| action | ATO_COLLECTION_ACTION | Collection Action | ||||
| action_variant | ATO_ACTION_VARIANT | Variant | ||||
| action_status | ATO_ACTION_STATUS | action state | ||||
| last_changed_by | AS4USER | Last Changed By | ||||
| last_changed_at | TIMESTAMP | Time Stamp | ||||
| ballog_handle | BALLOGHNDL | Handle | ||||
| product_version | BORM_VERS | Version | ||||
| action_duration | abap.int2 | |||||
| basis_release | SAPRELEASE | SAP Release | ||||
| job_name | BTCJOB | Job Name | ||||
| job_count | BTCJOBCNT | Job No. | ||||
| exec_client | abap.char | |||||
| planned_job_start | TIMESTAMP | Time Stamp | ||||
| planned_downtime_start | TIMESTAMP | Time Stamp | ||||
| manual_postprocessing_required | ABAP_BOOLEAN | Truth Value | ||||
| imported_at | TIMESTAMP | Time Stamp | ||||
| cross_release_import_allowed | SAPRELEASE | SAP Release | ||||
| count_all_items_in_col_at_exp | abap.int4 |
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 collection versions
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ATO_COL_VERSIONS (
COLLECTION_ID, -- Collection ID [ATO_COLLECTION_ID]
TIMESTAMP, -- Time Stamp [TIMESTAMP]
VERSION, -- Collection Version [ATO_COLLECTION_VERSION]
RESOURCE_ID, -- Time Stamp [TIMESTAMPL]
STATUS, -- Status [ATO_COLLECTION_STATUS]
ACTION, -- Collection Action [ATO_COLLECTION_ACTION]
ACTION_VARIANT, -- Variant [ATO_ACTION_VARIANT]
ACTION_STATUS, -- action state [ATO_ACTION_STATUS]
LAST_CHANGED_BY, -- Last Changed By [AS4USER]
LAST_CHANGED_AT, -- Time Stamp [TIMESTAMP]
BALLOG_HANDLE, -- Handle [BALLOGHNDL]
PRODUCT_VERSION, -- Version [BORM_VERS]
ACTION_DURATION, -- abap.int2
BASIS_RELEASE, -- SAP Release [SAPRELEASE]
JOB_NAME, -- Job Name [BTCJOB]
JOB_COUNT, -- Job No. [BTCJOBCNT]
EXEC_CLIENT, -- abap.char
PLANNED_JOB_START, -- Time Stamp [TIMESTAMP]
PLANNED_DOWNTIME_START, -- Time Stamp [TIMESTAMP]
MANUAL_POSTPROCESSING_REQUIRED, -- Truth Value [ABAP_BOOLEAN]
IMPORTED_AT, -- Time Stamp [TIMESTAMP]
CROSS_RELEASE_IMPORT_ALLOWED, -- SAP Release [SAPRELEASE]
COUNT_ALL_ITEMS_IN_COL_AT_EXP, -- abap.int4
PRIMARY KEY (COLLECTION_ID, TIMESTAMP, VERSION)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA