I_CCV_NOT_MIGRATED

DDL: I_CCV_NOT_MIGRATED Type: view_entity Package: SAPS_CCV_REWORK

View for not migrated Custom CDS Views

I_CCV_NOT_MIGRATED is a CDS View that provides data about "View for not migrated Custom CDS Views" in SAP S/4HANA. It reads from 6 data sources and exposes 1 field with key field ddl_name. It has 2 associations to related views. Part of development package SAPS_CCV_REWORK.

Data Sources (6)

SourceAliasJoin Type
aps_ccv_d_root _active_new_version left_outer
aps_ccv_d_root_d _draft_new_version left_outer
APS_V_GKE_DDL_MAX_DATE _j_maxdate_released left_outer
aps_ccv_d_root _non_del_draft_new_v left_outer
ARS_APIS_RELEASED_C1_OR_GROUPS _released_for_c1_or_group inner
ddddlsrc _src_released inner

Associations (2)

CardinalityTargetAliasCondition
[0..1] ATOV_U_ITEMS_EXPORTED_AT _a_ato_exported _a_ato_exported.item_type = 'CKE' and _a_ato_exported.item_id = stob.ddlname
[0..1] dd02b _a_dd02b _a_dd02b.strucobjn = stob.objectname and _a_dd02b.as4local = _j_maxdate_released.min_ddl_state

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label View for not migrated Custom CDS Views view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (1)

KeyFieldSource TableSource FieldDescription
KEY ddl_name ddddlsrc ddlname DDL Source Name

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 I_CCV_NOT_MIGRATED.
-- 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 I_CCV_NOT_MIGRATED AS
SELECT
  _src_released.ddlname AS ddl_name
INNER JOIN ddddlsrc AS _src_released ON /* join condition not captured in parsed metadata */
INNER JOIN ARS_APIS_RELEASED_C1_OR_GROUPS AS _released_for_c1_or_group ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN APS_V_GKE_DDL_MAX_DATE AS _j_maxdate_released ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN aps_ccv_d_root AS _active_new_version ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN aps_ccv_d_root AS _non_del_draft_new_v ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN aps_ccv_d_root_d AS _draft_new_version ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ATOV_U_ITEMS_EXPORTED_AT AS _a_ato_exported ON _a_ato_exported.item_type = 'CKE' AND _a_ato_exported.item_id = stob.ddlname  -- association [0..1]
LEFT OUTER JOIN dd02b AS _a_dd02b ON _a_dd02b.strucobjn = stob.objectname AND _a_dd02b.as4local = _j_maxdate_released.min_ddl_state  -- association [0..1]
;