cancel
Showing results for 
Search instead for 
Did you mean: 

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

manuel_medina1
Explorer
0 Kudos

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

former_member186338
Active Contributor
0 Kudos

Sorry, but look on your post results - no images!

Use "Insert Image" selecting saved image file....

manuel_medina1
Explorer
0 Kudos

Hi vadim.kalinin

Thanks for the advice. Photos are correctly uploaded now. Please let me know if the question is clear

former_member186338
Active Contributor

Sorry, but:

"This table has a transaction view called ZRCK_X_BRAND" - no details about Z transaction...

manuel_medina1
Explorer
0 Kudos

Hi vadim.kalinin,

Thanks for the help. The Z Transaction has been attached in the original question. Please let me know if it is clear.

Thanks again

Accepted Solutions (0)

Answers (0)