ATO_COL_V_STATUS
Current status of ATO status schema for import systems
ATO_COL_V_STATUS is an SAP database table in S/4HANA. Current status of ATO status schema for import systems. It contains 8 fields. 25 CDS views read from this table.
CDS Views using this table (25)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| atov_cl_missing_outdated_dep | view | inner | Missing Dep On Items from Outdated CLs | |
| atov_col_import_status | view_entity | from | Import Status of a Software Collection version | |
| ATOV_COL_ITEM_IMPORT_STATUS | view_entity | inner | Item version with col import status | |
| atov_col_ver_allow_discard_fwd | view_entity | inner | ||
| atov_col_ver_allow_discard_imp | view_entity | inner | ||
| ATOV_COL_VER_ALLOW_OUTDATED | view_entity | inner | ||
| ATOV_COL_VER_ALLOW_SETIMPORTED | view_entity | inner | Importable Collections | |
| atov_col_ver_approv_allow_base | view_entity | inner | Collections allowed to set QA Status | |
| atov_col_ver_forward_scheduled | view_entity | from | Collection Versions Scheduled for Fwd | |
| ATOV_COL_VER_FORWARDABLE | view | inner | Forwardable Collections | |
| ATOV_COL_VER_FORWARDABLE_BASE | view_entity | inner | Forwardable without QA restriction | |
| atov_col_ver_forwardable_wo_qa | view_entity | left_outer | Forwardable Col Vers without QA approval | |
| ATOV_COL_VER_HISTORY_TIMESTAMP | view_entity | left_outer | Collection Version historical timestamp | |
| ATOV_COL_VER_IMP_KEY | view | left_outer | Collection Version Import Keys | |
| atov_col_ver_import_scheduled | view_entity | from | Collection Versions Scheduled for Import | |
| ATOV_COL_VER_IMPORTABLE | view_entity | inner | Importable Collections | |
| atov_col_ver_set_qa_allow_base | view_entity | inner | Collections allowed to set QA Status | |
| ATOV_COL_VER_STATUS | view | left_outer | Collection import status | |
| atov_col_ver_wo_postproc_fail | view_entity | from | All but failed postprocessing | |
| atov_status_schema_import_errs | view_entity | from | Collection Versions with import errors | |
| atov_status_schema_mig_incompl | view_entity | left_outer | Collection versions not fully migrated | |
| atov_status_schema_not_discard | view_entity | left_outer | Not discarded collection versions | |
| atov_status_schema_not_fwded | view_entity | from | Collection versions not yet forwarded | |
| atov_status_schema_not_yet_mig | view_entity | left_outer | Collection versions not yet migrated | |
| atov_status_schema_qa_status | view_entity | left_outer | Quality approval status |
Fields (8)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | collection_id | ATO_COLLECTION_ID | Collection ID | |||
| KEY | version | ATO_COLLECTION_VERSION | Collection Version | |||
| KEY | status_schema | ATO_COLLECTION_STATUS_SCHEMA | ATO Collection Status Schema | |||
| status | ATO_COLLECTION_STATUS | Status | ||||
| previous_status | ATO_COLLECTION_STATUS | Status | ||||
| transient_target_status | ATO_COLLECTION_STATUS | Status | ||||
| last_changed_at | TIMESTAMP | Time Stamp | ||||
| last_changed_by | AS4USER | Last Changed By |
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.
-- Current status of ATO status schema for import systems
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ATO_COL_V_STATUS (
COLLECTION_ID, -- Collection ID [ATO_COLLECTION_ID]
VERSION, -- Collection Version [ATO_COLLECTION_VERSION]
STATUS_SCHEMA, -- ATO Collection Status Schema [ATO_COLLECTION_STATUS_SCHEMA]
STATUS, -- Status [ATO_COLLECTION_STATUS]
PREVIOUS_STATUS, -- Status [ATO_COLLECTION_STATUS]
TRANSIENT_TARGET_STATUS, -- Status [ATO_COLLECTION_STATUS]
LAST_CHANGED_AT, -- Time Stamp [TIMESTAMP]
LAST_CHANGED_BY, -- Last Changed By [AS4USER]
PRIMARY KEY (COLLECTION_ID, VERSION, STATUS_SCHEMA)
);
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