ViewProvisioningDPPTables

DDL: CVIEW_PROVISIONING_GET_TAB_BL SQL: CVIEWPROVTABBL Type: view
2 Fields 2 Data Sources

Get All tables for blacklisting

ViewProvisioningDPPTables is a CDS View that provides data about "Get All tables for blacklisting" in SAP S/4HANA. It reads from 2 data sources (dd02t, dd02l) and exposes 2 fields with key field tabname.

Data Sources (2)

SourceAliasJoin Type
dd02t _getdesc inner
dd02l _gettables from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName CVIEWPROVTABBL view
ObjectModel.usageType.dataClass #META view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Get All tables for blacklisting view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY tabname dd02l tabname Table/Constant Value
ddtext dd02t ddtext Short text

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 ViewProvisioningDPPTables.
-- 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: CVIEWPROVTABBL

CREATE VIEW ViewProvisioningDPPTables AS
SELECT
  _gettables.tabname AS tabname,
  _getdesc.ddtext AS ddtext
FROM dd02l AS _gettables
INNER JOIN dd02t AS _getdesc ON /* join condition not captured in parsed metadata */
;

Learn More