atov_collection_type_import

DDL: ATOV_COLLECTION_TYPE_IMPORT Type: view_entity Package: S_ATO_COL_CORE
2 Fields 4 Data Sources

Collection type for use at import

atov_collection_type_import is a CDS View that provides data about "Collection type for use at import" in SAP S/4HANA. It reads from 4 data sources (atov_cbc_collections_import, atov_cbc_collections_import, ato_cols, ato_cols) and exposes 2 fields. Part of development package S_ATO_COL_CORE.

Data Sources (4)

SourceAliasJoin Type
atov_cbc_collections_import cbc left_outer
atov_cbc_collections_import cbc union_all
ato_cols col from
ato_cols col inner

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Collection type for use at import view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (2)

KeyFieldSource TableSource FieldDescription
category ato_cols category Violation Category
category ato_cols category Violation Category

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view atov_collection_type_import.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW atov_collection_type_import AS
SELECT
  col.category AS category
FROM ato_cols AS col
LEFT OUTER JOIN atov_cbc_collections_import AS cbc ON /* join condition not captured in parsed metadata */
INNER JOIN ato_cols AS col ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): atov_cbc_collections_import
;

Learn More