Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

recursive formatted search

Hi All,

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.

regards,

Binita

replied

Binita,

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

Suda

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question