ViewProvisioningScopeWp

DDL: CVIEW_PROVISIONING_SCOPE_WP SQL: CVIEWPROVSCOWP Type: view

CDS View Provisioning Scope

ViewProvisioningScopeWp is a CDS View that provides data about "CDS View Provisioning Scope" in SAP S/4HANA. It reads from 2 data sources (fndei_d_v_scope, ddddlsrct) and exposes 7 fields with key fields TargetSystem, ViewName, Version.

Data Sources (2)

SourceAliasJoin Type
fndei_d_v_scope _cdsScope from
ddddlsrct _dddlsrc left_outer

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName CVIEWPROVSCOWP view
ObjectModel.usageType.dataClass #META view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
AccessControl.authorizationCheck #CHECK view
EndUserText.label CDS View Provisioning Scope view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY TargetSystem fndei_d_v_scope hcp_system TgtSysUUID
KEY ViewName fndei_d_v_scope view_name View Name
KEY Version fndei_d_v_scope view_version View Versn
Deleted fndei_d_v_scope deleted Truth Value
Status fndei_d_v_scope view_status INT2
Description ddddlsrct ddtext Short text
Language ddddlsrct ddlanguage Lang.

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 ViewProvisioningScopeWp.
-- 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: CVIEWPROVSCOWP

CREATE VIEW ViewProvisioningScopeWp AS
SELECT
  _cdsScope.hcp_system AS TargetSystem,
  _cdsScope.view_name AS ViewName,
  _cdsScope.view_version AS Version,
  _cdsScope.deleted AS Deleted,
  _cdsScope.view_status AS Status,
  _dddlsrc.ddtext AS Description,
  _dddlsrc.ddlanguage AS Language
FROM fndei_d_v_scope AS _cdsScope
LEFT OUTER JOIN ddddlsrct AS _dddlsrc ON /* join condition not captured in parsed metadata */
;