atov_status_schema_qa_status

DDL: ATOV_STATUS_SCHEMA_QA_STATUS Type: view_entity
2 Fields 3 Data Sources

Quality approval status

atov_status_schema_qa_status is a CDS View that provides data about "Quality approval status" in SAP S/4HANA. It reads from 3 data sources (ato_col_versions, ATOV_STATUS_SCHEMA_QA_FEATURE, ato_col_v_status) and exposes 2 fields.

Data Sources (3)

SourceAliasJoin Type
ato_col_versions collection_version from
ATOV_STATUS_SCHEMA_QA_FEATURE qa_feature inner
ato_col_v_status status left_outer

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Quality approval status 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
version ato_col_versions version XML Vers.
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_status_schema_qa_status.
-- 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_status_schema_qa_status AS
SELECT
  collection_version.version AS version,
  coalesce( status.status, 'ON' ) AS status
FROM ato_col_versions AS collection_version
INNER JOIN ATOV_STATUS_SCHEMA_QA_FEATURE AS qa_feature ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ato_col_v_status AS status ON /* join condition not captured in parsed metadata */
;

Learn More