cancel
Showing results for 
Search instead for 
Did you mean: 

Token - filtering using BP Properties

Former Member
0 Kudos

Hi Experts,

I have used a Business Partner Master Data token as my parameter in the custom customer statement report, when the user uses the business partner properties as filtering options although the report will only display the records which will satisfy the property that is checked by the user but it will include those records in between.

For example: I would like to display customers wherein the BP Property 1 (QryGroup1) is checked in the Business Partner Master Data. In the BP Master Data, in the 10 customers (C1 to C10)  that are maintained, only customer  C2, C5, C8 has BP Property 1 (QryGroup1) which is checked on the master data. So when I generate the custom customer statement report, it should only display C2, C5 and C8 if the parameter that used is display all customers with BP Property 1 is equal to "Y". But the results will give the following customers: C2, C3, C4, C5, C6, C7 C8.  In short, it will display the customers with BP Property 1 which is checked but it will also include those customers in between them like C3 and C4 which is in between 2 customers which has a "Y" value in BP Property 1.

Please help me to fix this one. Thanks in advance.

Maria

Accepted Solutions (0)

Answers (1)

Answers (1)

abhilash_kumar
Active Contributor
0 Kudos

Hi Maria,

What is "Business Partner Master Data token"? What datasource is this regarding?

-Abhilash

Former Member
0 Kudos

Hi Abhilash,

here it is:

abhilash_kumar
Active Contributor
0 Kudos

Thanks.

Please repost to the SAP B1 space.

-Abhilash


Former Member
0 Kudos

Thanks, I just did..