ViewProvisioningDPPTables

DDL: CVIEW_PROVISIONING_GET_TAB_BL SQL: CVIEWPROVTABBL Type: view

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.

2 data source(s) 2 fields

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
ddtext dd02t ddtext 
@AbapCatalog.sqlViewName: 'CVIEWPROVTABBL'
@ObjectModel.usageType.dataClass: #META
@ObjectModel.usageType.serviceQuality:  #C
@ObjectModel.usageType.sizeCategory:  #L
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Get All tables for blacklisting'
define view ViewProvisioningDPPTables as select from dd02l 
                                      as _gettables inner join dd02t 
                                      as _getdesc on _gettables.tabname = _getdesc.tabname
{
  key _gettables.tabname as tabname,
      _getdesc.ddtext
   
} where _gettables.tabclass = 'TRANSP' 
  and _gettables.as4local = 'A' 
  and _getdesc.as4local = 'A' 
  and _getdesc.ddlanguage = 'E'

Learn More