ATO_COL_V_STATUS

Transparent Table Temporary Data

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)

ViewTypeJoinVDMDescription
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)

KeyField Data ElementDescription DomainTypeLength
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)
);