Formatted search to auto generate Item No.

Hi,

Customer is using 2007A PL47. They had requirement to auto generate Item No based on UDF created in Item Master Data(OITM). The stock code structure is as follow:

Item No=EP(hardcode 2 char)+U_ProdRange U_ProdGroupU_ProdFamily+user defined text

The keystroke steps are:

1. Key in item description

2. Select drop down list for U_ProdRange in OITM

3. Select drop down list for U_ProdGroup in OITM

4. Select drop down list for U_ProdFamily in OITM

5. Formatted search to generate Item No based on 2,3, 4

6. User keys in user defined text in Item No

7. Fill in other relevant fields in Item Master Data

8. Add Item Master Data

May I know how to write the query in formatted search?

Regards

Thomas