ATO_TYPE_STATUS
Possible status values for collection types
ATO_TYPE_STATUS is an SAP database table in S/4HANA. Possible status values for collection types. It contains 5 fields. 15 CDS views read from this table.
CDS Views using this table (15)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| ATOV_COL_SCHEMA_FORWARD_STATUS | view | inner | Collection forward status | |
| ATOV_COL_SCHEMA_IMPORT_STATUS | view | inner | Collection import status | |
| ATOV_COL_SCHEMA_QA_STATUS | view | inner | Collection qa status | |
| atov_col_ver_allow_discard_fwd | view_entity | inner | Collections that are allowed to discard - Forward | |
| atov_col_ver_allow_discard_imp | view_entity | inner | Collections that are allowed to discard - Import | |
| ATOV_COL_VER_ALLOW_OUTDATED | view_entity | inner | Collections that are allowed to set outdated | |
| atov_col_ver_allow_postproc | view | inner | Collections allow to be post processed | |
| 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_FORWARDABLE_BASE | view_entity | inner | Forwardable without QA restriction | |
| ATOV_COL_VER_IMPORTABLE | view_entity | inner | Importable Collections | |
| atov_col_ver_qa_reject_allowed | view_entity | inner | Collection eligible for quality rejecton | |
| atov_col_ver_reject_allowed | view_entity | inner | Collection eligible for quality rejecton | |
| atov_col_ver_set_qa_allow_base | view_entity | inner | Collections allowed to set QA Status | |
| atov_col_ver_set_qa_allow_base | view_entity | left_outer | Collections allowed to set QA Status |
Fields (5)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | collection_type | ato_collection_type | Collection Type | |||
| KEY | status_schema | ato_collection_status_schema | ATO Collection Status Schema | |||
| KEY | allowed_status | ato_collection_status | Status | |||
| is_initial_status | boolean | Boolean Variable (X = True, - = False, Space = Unknown) | ||||
| is_eligible_for_next_schema | boolean | Boolean Variable (X = True, - = False, Space = Unknown) |
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.
-- Possible status values for collection types
-- Category TRANSPARENT · Delivery class S
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ATO_TYPE_STATUS (
COLLECTION_TYPE, -- Collection Type [ato_collection_type]
STATUS_SCHEMA, -- ATO Collection Status Schema [ato_collection_status_schema]
ALLOWED_STATUS, -- Status [ato_collection_status]
IS_INITIAL_STATUS, -- Boolean Variable (X = True, - = False, Space = Unknown) [boolean]
IS_ELIGIBLE_FOR_NEXT_SCHEMA, -- Boolean Variable (X = True, - = False, Space = Unknown) [boolean]
PRIMARY KEY (COLLECTION_TYPE, STATUS_SCHEMA, ALLOWED_STATUS)
);
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