ViewProvisioningCdsTab

DDL: CVIEW_PROVISIONING_CDS_TAB SQL: CVIEWPROVCDSTABL Type: view
4 Fields 2 Data Sources

CDS view and corresponding tables

ViewProvisioningCdsTab is a CDS View that provides data about "CDS view and corresponding tables" in SAP S/4HANA. It reads from 2 data sources (fndei_d_v_cdstab, fndei_d_v_datblk) and exposes 4 fields with key fields CdsViewName, TargetSystem, TableName.

Data Sources (2)

SourceAliasJoin Type
fndei_d_v_cdstab _cdsTab from
fndei_d_v_datblk _datBlk left_outer

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName CVIEWPROVCDSTABL view
ObjectModel.usageType.dataClass #META view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
AccessControl.authorizationCheck #CHECK view
EndUserText.label CDS view and corresponding tables view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY CdsViewName fndei_d_v_cdstab cds_view_name STOB Name
KEY TargetSystem fndei_d_v_cdstab hcp_system TgtSysUUID
KEY TableName fndei_d_v_cdstab table_name Table Name
SqlViewName fndei_d_v_datblk block_view_name Filter View

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 ViewProvisioningCdsTab.
-- 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: CVIEWPROVCDSTABL

CREATE VIEW ViewProvisioningCdsTab AS
SELECT
  _cdsTab.cds_view_name AS CdsViewName,
  _cdsTab.hcp_system AS TargetSystem,
  _cdsTab.table_name AS TableName,
  _datBlk.block_view_name AS SqlViewName
FROM fndei_d_v_cdstab AS _cdsTab
LEFT OUTER JOIN fndei_d_v_datblk AS _datBlk ON /* join condition not captured in parsed metadata */
;

Learn More