CVIEW_PROVISION_SCOPE_UI

DDL: CVIEW_PROVISION_SCOPE_UI SQL: CVPRVSCPSUISYN Type: view
8 Fields 2 Data Sources

display scope and last sync time

CVIEW_PROVISION_SCOPE_UI is a CDS View that provides data about "display scope and last sync time" in SAP S/4HANA. It reads from 2 data sources (CVIEW_PROV_SCOPE_WP_UI, CVIEW_PROV_LDATASYNC_VIEWS_UI) and exposes 8 fields with key fields ViewName, Status, TargetSystem, Version.

Data Sources (2)

SourceAliasJoin Type
CVIEW_PROV_SCOPE_WP_UI _Scope from
CVIEW_PROV_LDATASYNC_VIEWS_UI CVIEW_PROV_LDATASYNC_VIEWS_UI left_outer

Parameters (1)

NameTypeDefault
p_TargetSystem fndei_target_sys_uuid

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName CVPRVSCPSUISYN view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.dataClass #META view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label display scope and last sync time view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY ViewName CVIEW_PROV_SCOPE_WP_UI ViewName Name
KEY Status CVIEW_PROV_SCOPE_WP_UI Status Status
KEY TargetSystem CVIEW_PROV_SCOPE_WP_UI TargetSystem Target System
KEY Version CVIEW_PROV_SCOPE_WP_UI Version XML Vers.
Deleted CVIEW_PROV_SCOPE_WP_UI Deleted Truth Value
Description CVIEW_PROV_SCOPE_WP_UI Description Description
LastSyncStatus _TableLastSync LastDataSync_ViewStatus Last Sync Status
Language CVIEW_PROV_SCOPE_WP_UI Language Report Text Language

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_PROVISION_SCOPE_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: CVPRVSCPSUISYN
-- Parameters: p_TargetSystem : fndei_target_sys_uuid

CREATE VIEW CVIEW_PROVISION_SCOPE_UI AS
SELECT
  _Scope.ViewName AS ViewName,
  _Scope.Status AS Status,
  _Scope.TargetSystem AS TargetSystem,
  _Scope.Version AS Version,
  _Scope.Deleted AS Deleted,
  _Scope.Description AS Description,
  _TableLastSync.LastDataSync_ViewStatus AS LastSyncStatus,
  _Scope.Language AS Language
FROM CVIEW_PROV_SCOPE_WP_UI AS _Scope
LEFT OUTER JOIN CVIEW_PROV_LDATASYNC_VIEWS_UI ON /* join condition not captured in parsed metadata */
;

Learn More