Search Help

[Former Member]

Hello All,

I have created a search help for mm03 ( tables MARA and MARC.)

The selection method used is Database view.

The data availbel in my system is as below.

MARA:

MATNR MFRPN

mat1 mpn1

mat2 mpn2

MARC :

MATNR WERKS

mat2 p2.

The output expected out of my search help is when i give MPN1 as input, I should get 1 row

MATNR MFRPN WERKS

mat1 mpn1 (blank)

but the search help displays "No Values Found"

I tried using a HELP view but could not get the desired results.

Plz help.

[Former Member]

Hi Renuka,

Create the database view with MARA and MARC.

Keep the join condition on MARA-MATNR = MARC~MATNR in the view.

In the search help give the MPN1 as import & export and select the fields as export which you want in the output.

Thanks,

Satheesh

[Former Member]

Hi,

Select alll the records from MARA first in one internal table and than select MARC for all entries of MARA-MATNR in other internal table.

Combine both the tables and display as help list.

Regards,

Ganesh.

[Former Member]

Hi,

You can write Search Help Exit for getting values for your selection.

Try Search Help Exit.

Thanks,

Praveen

[Former Member]

Hi Renuka,

Create a Database view using the tables MARA and MARC.

Then go to Table/Join conditions tab and give the join condition as, MARA-MATNR = MARC- MATNR.

Then give the fields MATNR, MFRPN and WERKS in the view fields tab.

Hope this is useful.

Thanks.

[Former Member]

for search help

go to se11

click on search help and give ur search help nameand click on create.

now select first option

give short desc

now in selection method - double click on search button -

---

select search for database--now give ur exact table name and desc that u have given to ur table.

now give the field name for which u r using serach help in search help parameter .

and click on imp and exp and give lpos = 1 and spos = 1and give ur data element name from ur trans table.

now save and activate it.

now come to ur database table .......click on change radio button.

now click on ur field and then click on SEARCH HELP.

give ur search help name as u have created

click on continue and then click on copy

save and activate it

and if u want wheter ur search help is attach or not

click on ENTRY HELP/CHECK .

u will see ur search help name

REGARDS

NAVIN

[Former Member]

Hi,

i am hope actually there are some search helps already available in ECC for the requested combination,

you can check > Collective srch hlp MAT1 it has plant as well as MFG PN no. and try to find some others from MM03 matnr F1 help, from data element of fields you will get to know the standard search help .

so you may try with appending search helps/ copy to z and chages as per your requirement.