Duplicate entries in the variable for 0FISCPER
I have created a query and I have 0FISCPER as a viarable. The multiprovider integrates sales figures from 2 DSO's which have fiscal year viraints Z4 and K4 respectively. For the 0FISCPER variable when I enter into the F4 help I see that there are duplicate entries such as
007/2014 (June 2014)
007/2014 (July 2014)
These 2 entries are showing because one entry is from Z4 and the other one from K4 fiscal year variant. However, my user only want to see one of them as it is confusing the users. Is there a way to restrict them to only one per fiscal year/period. I have already tried the BADI restriction F4 help but that is not working. Please any advice would be very helpful.