ATOV_CMN_IMP_FRCST_CHNL_LOGIC

DDL: ATOV_CMN_IMP_FRCST_CHNL_LOGIC Type: view_entity Package: S_ATO_COMMON_IMPORT

Import Type Forcast

ATOV_CMN_IMP_FRCST_CHNL_LOGIC is a CDS View that provides data about "Import Type Forcast" in SAP S/4HANA. It reads from 2 data sources (ato_col_versions, ato_ta_set) and exposes 2 fields with key field version. It has 1 association to related views. Part of development package S_ATO_COMMON_IMPORT.

Data Sources (2)

SourceAliasJoin Type
ato_col_versions col_versions from
ato_ta_set TA_set left_outer

Associations (1)

CardinalityTargetAliasCondition
[0..1] ATOV_TRANS_AUTO_MODE_CUST cl cl.collection_id = col_versions.collection_id and cl.collection_version = col_versions.version

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Import Type Forcast 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
KEY version ato_col_versions version XML Vers.
status ato_col_versions status Workflow Status

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_CMN_IMP_FRCST_CHNL_LOGIC.
-- 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_CMN_IMP_FRCST_CHNL_LOGIC AS
SELECT
  col_versions.version AS version,
  col_versions.status AS status
FROM ato_col_versions AS col_versions
LEFT OUTER JOIN ato_ta_set AS TA_set ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ATOV_TRANS_AUTO_MODE_CUST AS cl ON cl.collection_id = col_versions.collection_id AND cl.collection_version = col_versions.version  -- association [0..1]
;