ViewReplGetDppTables

DDL: CVIEW_PROVISIONING_DPP_TABLES SQL: CVIEWDPPTABLES Type: view

Get All Blacklisted Tables

ViewReplGetDppTables is a CDS View that provides data about "Get All Blacklisted Tables" in SAP S/4HANA. It reads from 2 data sources (dd02t, fndei_d_v_b_tabl) and exposes 3 fields with key fields Tablename, ReplicationId.

2 data source(s) 3 fields

Data Sources (2)

SourceAliasJoin Type
dd02t _dppdesc inner
fndei_d_v_b_tabl _dpptabl from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName CVIEWDPPTABLES view
ObjectModel.usageType.dataClass #META view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Get All Blacklisted Tables view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY Tablename fndei_d_v_b_tabl tabname
KEY ReplicationId fndei_d_v_b_tabl replicationid
Description dd02t ddtext 
@AbapCatalog.sqlViewName: 'CVIEWDPPTABLES'
@ObjectModel.usageType.dataClass: #META
@ObjectModel.usageType.serviceQuality:  #C
@ObjectModel.usageType.sizeCategory:  #L
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Get All Blacklisted Tables'
define view ViewReplGetDppTables as select from fndei_d_v_b_tabl 
                                 as _dpptabl inner join dd02t as _dppdesc 
                                 on _dpptabl.tabname = _dppdesc.tabname {

key _dpptabl.tabname       as  Tablename,
key _dpptabl.replicationid as ReplicationId,
    _dppdesc.ddtext        as Description
  
} where _dppdesc.as4local = 'A'
  and _dppdesc.ddlanguage = 'E'

  
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DD02T",
"FNDEI_D_V_B_TABL"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More