Skip to Content
Former Member
Feb 17, 2014 at 08:06 AM

Token - filtering using BP Properties


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.