topic Re: Search Help for VA01,VA02 Tcode in Application Development and Automation Discussions

Search Help for VA01,VA02 Tcode

Former Member — Thu, 11 Jun 2009 14:51:43 GMT

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

Re: Search Help for VA01,VA02 Tcode

Former Member — Thu, 11 Jun 2009 15:11:12 GMT

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...

Re: Search Help for VA01,VA02 Tcode

Former Member — Thu, 11 Jun 2009 15:16:04 GMT

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

Re: Search Help for VA01,VA02 Tcode

Former Member — Thu, 11 Jun 2009 15:46:59 GMT

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

Re: Search Help for VA01,VA02 Tcode

Former Member — Fri, 12 Jun 2009 03:24:01 GMT

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

Re: Search Help for VA01,VA02 Tcode

Former Member — Fri, 12 Jun 2009 05:58:45 GMT

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.

Re: Search Help for VA01,VA02 Tcode

Former Member — Fri, 12 Jun 2009 09:06:40 GMT

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

then it will return repeated values.

Re: Search Help for VA01,VA02 Tcode

Former Member — Fri, 12 Jun 2009 09:37:12 GMT

Hi,

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

Re: Search Help for VA01,VA02 Tcode

Former Member — Fri, 12 Jun 2009 10:07:08 GMT

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.

Re: Search Help for VA01,VA02 Tcode

Former Member — Fri, 12 Jun 2009 10:16:00 GMT

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?

Re: Search Help for VA01,VA02 Tcode

Former Member — Fri, 12 Jun 2009 10:16:01 GMT

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...

Re: Search Help for VA01,VA02 Tcode

Former Member — Mon, 15 Jun 2009 07:35:34 GMT

yes i am trying to write a program for that.

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