Search Help for transaction code KE53

[Former Member]

Hi Experts,

I want to add one more elementary search help in already existing search help PRCT for tcode KE53.

This is a collective search help. I am trying to create an elem. searh help which includes 3 input fields

Profit Center (PRCTR), Text desc. of Profit Center (LTEXT), and Company Code (BUKRS). But the problem is PRCTR & BUKRS are in table CEPC_BUKRS and PRCTR & LTEXT in table CEPC. Then how do i club the 3 in a single elem help. Do i have to use Search Help Exit. I have created a FM in which i have written a select query as follows:

SELECT A_{PRCTR A}LTEXT B~BUKRS

FROM CEPCT AS A

INNER JOIN CEPC_BUKRS AS B

ON A_{PRCTR = B}PRCTR

INTO CORRESPONDING FIELDS OF TABLE ITAB.

ITAB is the table in FM. The FM also includes the changing parameters :SHLP & CALLCONTROL and tables SHLP_TAB & RECORD_TAB (but i dont know the use of the parameters). How do i proceed.

I dont have any idea about search help exits. Also there is no table which includes PRCTR, BUKRS and LTEXT.

[Former Member]

Hi Experts,

I want to add one more elementary search help in already existing search help PRCT for tcode KE53.

This is a collective search help. I am trying to create an elem. searh help which includes 3 input fields

Profit Center (PRCTR), Text desc. of Profit Center (LTEXT), and Company Code (BUKRS). But the problem is PRCTR & BUKRS are in table CEPC_BUKRS and PRCTR & LTEXT in table CEPC. Then how do i club the 3 in a single elem help. Do i have to use Search Help Exit. I have created a FM in which i have written a select query as follows:

SELECT A_{PRCTR A}LTEXT B~BUKRS

FROM CEPCT AS A

INNER JOIN CEPC_BUKRS AS B

ON A_{PRCTR = B}PRCTR

INTO CORRESPONDING FIELDS OF TABLE ITAB.

ITAB is the table in FM. The FM also includes the changing parameters :SHLP & CALLCONTROL and tables SHLP_TAB & RECORD_TAB (but i dont know the use of the parameters). How do i proceed.

I dont have any idea about search help exits. Also there is no table which includes PRCTR, BUKRS and LTEXT.

[Former Member]

Can anybody give some soln

[Former Member]

Hi,

No need to write a search help exit. You can instead give a database view in the selection method. This database view can be a join on the tables CEPC and CEPC_BUKRS.

Refer to the search help PRCTN which uses a database view as the selection method.

Since this is a standard search help, you will have to use append search help technique. Refer to this link for [enhancing the standard search help|http://help.sap.com/erp2005_ehp_04/helpdata/EN/1f/29ef5777df11d2959800a0c929b3c3/frameset.htm].

regards,

Advait

Edited by: Advait Gode on Dec 30, 2008 9:45 AM

[Former Member]

thanks a lot

[Former Member]

Hi ,

But now when i enter the company code, then i get the corresponding list of Profit Centers, but when i double click on any one profit center to select it, it does not get selected, it just shows blank value in the profit center field

[Former Member]

Still a problem

[Former Member]

Have you defined the PRCTR field in the search help as a EXPORT parameter ?

regards,

Advait

[Former Member]

Yes i have ticked the check box for export parameter of the elementary search help i created

[Former Member]

That is strange then. Can you paste your code here ?

Also did you test the search help PRCT ? Does if get the value in test mode ?

Edited by: Advait Gode on Dec 30, 2008 11:50 AM

[Former Member]

When i test it in test mode also , it is giving me the same problem. I have created elem search help PRCTC and included in collec. search PRCT. In PRCTC, i have used selection method as database view

YV_CEPC_TXT which i have created (as a local object in dev. client). Then in the search help parameters, I have given 3 fields PRCTR, BUKRS, LTEXT of which i have ticked the check box of PRCTR export parameter. Dialog type is " C Dialog with value restriction", and Hot key i have just given as C.

[Former Member]

Its working now

[Former Member]

Now when this company code input is displayed in the search help, i also want to pop up a message saying "Please enter company code in this field". Is it possoible to display an info msg. in Search help