ViewReplGetDppTables

DDL: CVIEW_PROVISIONING_DPP_TABLES SQL: CVIEWDPPTABLES Type: view
3 Fields 2 Data Sources

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.

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 Table/Constant Value
KEY ReplicationId fndei_d_v_b_tabl replicationid TgtSysUUID
Description 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 ViewReplGetDppTables.
-- 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: CVIEWDPPTABLES

CREATE VIEW ViewReplGetDppTables AS
SELECT
  _dpptabl.tabname AS Tablename,
  _dpptabl.replicationid AS ReplicationId,
  _dppdesc.ddtext AS Description
FROM fndei_d_v_b_tabl AS _dpptabl
INNER JOIN dd02t AS _dppdesc ON /* join condition not captured in parsed metadata */
;

Learn More