Skip to Content
0
Sep 08, 2020 at 09:53 AM

How to Drill Thorugh in BPC NW 10.1 to BW Transaction View Table Filtering by a Table Field ?

137 Views Last edit Sep 09, 2020 at 06:59 AM 3 rev

Hello experts!

I am finding the following problem in the configuration of Drill Through from BPC to BW Table View Transaction.

System Information:

BPC NW 10.1 on BW 7.4

Issue Context:

In BW there is a Table ( ZRCK_T_BRAND):

This table has a transaction view called ZRCK_X_BRAND. This Z Transaction is a SM30 Transaction of ZRCK_T_BRAND Table:

In BPC the DrillThorugh to the Transaction is working correctly;

Issue Description:

The requirement is to filter by Entity Value 002 and show only line 2 of the table where field Entity = 002. To accomplish this requirement I have added in the Drill Through configuration filter by the field Entity ( ZENT_TM1ID) and Value 002.

When the query is executed no filter is performed and all values are shown:

Questions:

1. Is it possible to filter by parameters by a transaction view of a table?

2. If yes, is there any step i am missing or doing wrongly?

Thanks in advance for your help

Attachments

1-table-name.png (39.4 kB)
2drill-through.png (10.6 kB)
4-filters.png (16.6 kB)
5issue.png (28.2 kB)
6transaction.png (155.9 kB)