Conversion of External material with Internal using search help
We are working on ECC 6.0 for automotive company and have following scenario.
One OE (External/Customer) material number (MARA-BISMT) with more than one internal material number (MARA-MATNR). This has been done because same customer material is sold by delar for different brands, for exmaple BMW, Ford, Opel. Therefore we have different internal materials with respective brands with same external number in material master.
Business requirement is, all correspondence with customer or vendor should be done using external/customer material number.
Whereas all internal business process should use internal SAP material number.
For example as given below
External No. --> Internal No.
BMW-1 --> 1001 (Brand - BMW)
BMW-1 --> 1002 (Brand - Ford)
BMW-1 --> 1003 (Brand - Opel)
Now the requirement is that user will create document, for example PO or SO, with external/customer material number. While
doing that user should get a pop up screen after entering external material number, if external material is attached/corresponds to multilple internal material number. Then user will selects correct internal number from pop up screen and return to document screen but material field should displayed with external material number.
For example in above case, user will enter BMW-1. Pup up screen will have three internal numbers 1001, 1002 and 1003. User selects 1003 but after material conversion material field of the document will displayed as BMW-1.
We are using Customer enhancement - "MGA00003 Material Master (Industry and Retail): Number Display" for input/ouput conversion.
Also we have created Elementary Search Help - SEARCH_OE_NUMBER with Hot Key "Q". This search help is included into
collective search help "MAT1_A" so that user can able to see multiple internal material number by entring customer material number.
We are able to convert external material number with internal material number and put the external material while creating PO. But when we add another item in PO, search help is getting called again and again for first line item even after conversion of matrial has been taken place.
How we can avoid this multiple calling of serach help?
Is there any better way to achieve this requirement?
Please help us.