recursive formatted search
This is the scenario. there are user defined fields created in item master(all for some item properties.). the same set of fields are defined in marketing document's detail. now I have defined formatted search on changing the last field of this set (in marketing docs' detail).when all the properties are selected, the itemcode will be fetched through this search. but by the default behavior of SAP , whenever item code is selected, entire row is refreshed. so all these properties' columns become blank once again. I have defined more formatted searches on these columns to again fetch the values from OITM whenever itemcode is selected. this works well. but the last field once again becomes blank because of the effect of first formatted search (original).
I hope I have explained it well.
hope someone would help.
Former Member replied
This is the change, I would like to propose...
Change the formatted search on the ItemCode to
SELECT T0. itemcode from oitm T0 where T0.U_design = '[%0\]' and T0.U_grade = '[%1\]'
Let the users press Shift+F2 on the ItemCode and select Design and Grade ..
Let the formatted searches on the Design and Grade be as they are