Hello All,
As per the requirement I have created an InfoSet with Inner Join on InfoObject 0MATERIAL and a DSO.
DSO has InfoObject 0MATERIAL as a key.
We have created a Query on this InfoSet and a variable on 0MATERIAL from DSO.
We have huge Master data for 0MATERIAL where as DSO has only fewer records compare to Master data.
We need Input help for the variable which should fetch records that are available in DSO.
But When I execute the Query, in F4 help for the variable, the data is coming from Master Data not from the DSO.
I made BEx setting u201COnly values in InfoProvideru201D in 0MATERIAL in RSD1 and also in BEx query Advanced Tab but no luck.
We suggested a solution to our client to create a Customer Exit Variable which calls a standard SAP function Module to provide input help values from DSO.
But due to huge data volumes and Performance issues in Production box we are looking for other work around.
Any help would be appreciated.
Regards,
Jonn