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

[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

[gregor_dieckmann]

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