Skip to Content
avatar image
Former Member

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

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • May 18, 2017 at 03:38 PM

    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

    Add comment
    10|10000 characters needed characters exceeded