Search Help for VA01,VA02 Tcode

[Former Member]

I need to develop a new search help in the VA01 and VA02 Transaction Code.

For the below mentioned fields :

Sales Organization, Old Material Number, Material Description, Material type, Plant and Product Hierarchy.

I have created the search help.

But iam not sure about the VIEW.

Please let me know how to write a view for this search help.

Edited by: vinay raj on Jun 11, 2009 4:59 PM

[Former Member]

I need to develop a new search help in the VA01 and VA02 Transaction Code.

For the below mentioned fields :

Sales Organization, Old Material Number, Material Description, Material type, Plant and Product Hierarchy.

I have created the search help.

But iam not sure about the VIEW.

Please let me know how to write a view for this search help.

Edited by: vinay raj on Jun 11, 2009 4:59 PM

[Former Member]

go to se11 and create the view

In fields you mention all the fields in your searchhelp.

in table/join conditions ..you mention the relations

example.

kna1 kunnr = knb1 kunnr.

kna1 adrnr = adrc ADDRNUMBER

then activate the view and check the data .

then go to your search help ..

definition tab...in selection method give your view name..then activate...

[Former Member]

yes i have cread the those are all but my query is

what is the selection criteria that i need to put in the view.please let me know what are hot key's

and Lpo's .

Edited by: vinay raj on Jun 11, 2009 5:29 PM

[Former Member]

please refer these 2 links..

for hotkeys

http://help.sap.com/saphelp_47x200/helpdata/en/cf/21ee6c446011d189700000e8322d00/frameset.htm

for LPos ans SPos.

http://help.sap.com/saphelp_47x200/helpdata/en/cf/21ee5f446011d189700000e8322d00/content.htm

[Former Member]

thankyou suresh.

As i have created this search help and in the view i have given the join conditions as

MARA-MATNR = MARC-MATNR

MARA-MATNR = MAKT-MATNR

MARA-MATNR=MVKE-MATNR

and in search help parameters :

VKORG

MATNR

BISMT

MAKTX

MTART

WERKS

PRODH

I took the Hotkey as 1.

Please guide me what are selection conditions that i need to give in my VIEW.

Here iam using 4 tables.

MARA

MAKT

MVKE

Edited by: vinay raj on Jun 12, 2009 6:42 AM

Edited by: vinay raj on Jun 12, 2009 7:18 AM

[Former Member]

Hi,

I dont think in your case the Selection condition is required.. Sine you will need all the combinations it is not needed.. Moreover, selection conditions are not mandatory...

Please let me know if your problem is not solved.

[Former Member]

thanku sneha if i will not give the selection conditions data ,

then it will return repeated values.

[Former Member]

Hi,

Can you let me know on which field values it is giving duplicate entries...

[Former Member]

let me explain my requirement clearly.

i have created the search help for VA01.

i took the parameters WERKS VKORG BISMT PRODH MATNR MTART

here i have written the view for the above mentioned four tables.

but the user is asking if he chooses only plant it should bring plant level data.

if the user chooses sales organization and plant then the search help should look for sales organization and plant.

[Former Member]

Please check your view that its fulfilling all the selection fields!

please clarify more as we are not getting the clear idea.

Are u getting the exact values from view after checking the contents?

Is it following the selection criteria?

[Former Member]

Hi,

In this case I think you have to do it in your program... because in the selection condition you can specify only some definite value.. You you want that the search help should work for any run time values of plant or other data entered it has to be controlled in the program...

[Former Member]

yes i am trying to write a program for that.

But outer join is not allowing to me for this requirement,