Wednesday, April 22, 2015

How to find corresponding ABAP report to SAP BW Query

Every SAP BW query or BEx query is associated with ABAP report. The report basically represents what the query does in SAP BW backend. For example there is BEx’s report selection screen in form of ABAP statements, all the data variables declarations, calls to BW data manager etc. Sometimes it is useful to have a look into the report to see things like these. The report is generated whenever the query is saved in BEx Query Designer. Also whenever the query is regenerated in tcode like RSRT the new report is generated. The report has naming convention GP*. The hash followed after GP is generated string. Every time generation happens the old GP* replaced by new one.

Now how to find the GP* report. There are following ways that I’m aware of:

1. tcode RSRT -> button Technical Information -> OLAP-Relevant Data:

2. table RSRREPDIR: find the query entry by field COMPID and OBJVERS = A and the report name is in field RNAME:

No comments: