Skip to Content
0

HOW TO SUPPRESS # IN MASTER DATA MATCH CODE (HELP INPUT READY QUERY ) AFO

May 17, 2017 at 12:24 PM

51

avatar image
Former Member

Hi Experts,

I want to suppress # in the match code in AFO.

In my EXCEL AFO i have in the help of the key figure the values of the master data ( #, 1,2,3,4,5) I want to suppres #.

This is KEY FIGURE NOT VARIANT OR CHARACTERISTICcapture.png

Thank you

capture.png (22.5 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Gregor Dieckmann
May 18, 2017 at 03:38 PM
0

Hi Javier,

because of the terminology you use it is unclear what you are talking about. It seems that you use the 'characteristics as key figure' feature, the key figure then has an F4 help (value help) based on the characteristic values contained in the master data table. Since '#' (not assigned) is always valid the F4 help also contains this value. You cannot restrict the F4 help since the characteristic used as key figure is not restricted in the query.

Workaround:

Create another data source in AO and use the VBA API to implement F4 help; this new data source can be the characteristic as InfoProvider restricted to values <> #. Check the VBA API in the documentation, e.g. SAPCallMemberSelector.

Regards,

Gregor

Share
10 |10000 characters needed characters left characters exceeded