CVIEW_PROV_WHTLSTD_CDS_UI

DDL: CVIEW_PROV_WHITELISTED_CDS_UI SQL: CVIEWPROVCDSUI Type: view Package: ODATA_FNDEI_VIEW_PROVISIONING
4 Fields 2 Data Sources

CDS exposing the Released CDS Views

CVIEW_PROV_WHTLSTD_CDS_UI is a CDS View that provides data about "CDS exposing the Released CDS Views" in SAP S/4HANA. It reads from 2 data sources (fndei_d_v_scope, ViewProvWhiteListedCds) and exposes 4 fields with key field ViewName. Part of development package ODATA_FNDEI_VIEW_PROVISIONING.

Data Sources (2)

SourceAliasJoin Type
fndei_d_v_scope scope left_outer
ViewProvWhiteListedCds ViewProvWhiteListedCds from

Parameters (2)

NameTypeDefault
p_ddlanguage ddlanguage
p_TargetSystem fndei_target_sys_uuid

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName CVIEWPROVCDSUI view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label CDS exposing the Released CDS Views view
ObjectModel.usageType.dataClass #META view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY ViewName ViewName View Name
Description Description Well Code Des.
ViewAnnotation ViewAnnotation
TargetSystem hcp_system TgtSysUUID

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 CVIEW_PROV_WHTLSTD_CDS_UI.
-- 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.
-- SQL view name: CVIEWPROVCDSUI
-- Parameters: p_ddlanguage : ddlanguage, p_TargetSystem : fndei_target_sys_uuid

CREATE VIEW CVIEW_PROV_WHTLSTD_CDS_UI AS
SELECT
  ViewName,
  Description,
  ViewAnnotation,
  hcp_system AS TargetSystem
FROM ViewProvWhiteListedCds
LEFT OUTER JOIN fndei_d_v_scope AS scope ON /* join condition not captured in parsed metadata */
;

Learn More