Skip to Content
h k

How to clear or refresh BEx char variable values?

Hi All,

I have created a BEx variable on a Nav Attribute of an Info Object which is in an InfoSet.

While testing I have run few Master Data Loads.

Later I have deleted Master Data with SID's and reloaded the Master Data after confirmation with final data.

But when I am running the BEx query, in the Variable Selection screen I am still getting old test Master Data values for this variable.

Variable is Processed by user input and it is in Characteristic Restrictions area.

Please suggest how to clear these old master data entries from Variable.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Apr 25 at 09:18 AM

    Hi,

    there is no button/option to clear those values from the frontend variable screens. This is something to be done from backend side for the respective InfoObject. This process then checks for the usage of the master data in different objects. If the master data is not used in any InfoProviders, the system can remove the unused entries. See this SAP Community Wiki entry for an example:

    https://wiki.scn.sap.com/wiki/x/l4EoGg

    Some shortcuts and helpful reports, see for details SAP note: 1370848 - New Master Data Deletion - Information

    • Transaction: RSDMD
    • Report: RSDMDD_DELETE_BATCH

    Cheers,

    Nora

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 24 at 05:47 AM

    Hi if you want to clear MD you will need to delete all transactional data in DSO/Cubes

    <having SID's> conaining those infoobjects because master data will not be deleted if contained in such a provider. So even if the DSO/Cube is not in the infoset, you will have to delete the data/indexes.

    Add comment
    10|10000 characters needed characters exceeded

    • Delete master data once again and check S table of your MD, you are sure infoobject is not used in any of your dataflows -> you can check the where used of the infoobject