Search help for KUNNR?

[Former Member]

Hi friends,

I am having a screen with input/output field name as KUNNR. I have to keep search help for this can i know how ?

If i am implementing the KNA1-KUNNR (as my input/output field) then the search help is coming automatically but the thing is i want to store the KUNNR number in my own table so please can anyone share me the solution.

Thks

[Former Member]

Hi Venkat,

Double click the field customer in the layout.In the attributes .Specify the search help as DEBI.

You can also use the function module F4IF_INT_TABLE_VALUE_REQUEST to give dynamic search help.

Regards,

Charumathi.B

[Former Member]

Hi friends,

Thanks for your help and can i know the search helps for "COST CENTER", "PROFIT CENTER", "SALES ORGANIZATION", "BUSSINESS AREA" too its very urgent.

Thks

[vinod_vemuru2]

Hi Venkateswar,

Find below the search help names:

Cost center: KOST

sales org: H_TVKO, Value table TVKO

Profit center: Value table IMCEPC

Business area: value table.TGSBK

U can specify the value table if search help doesn't exist. Or else u can create ur own search helps to the fields u want from the value tables above.

Thanks,

Vinod.

Edited by: Vinod Kumar Vemuru on May 2, 2008 12:39 PM

[Former Member]

Hi Vinod,

How to find out search help for a standard sap field.

Thks

[vinod_vemuru2]

Hi Venkateswar,

U can get in 2 ways.

1. Through data element

2. Through search help button.

Open the table for that field. eg. VBAK for sales org.

1.Double click on data element. In the further characteristics tab u can find one field called search help. here u can find.

2. Place ur cursor on the field vkorg. Press push button search help(version 4.7 and above) or menu->goto->search help->for field(in 4.6C). Here also u can find.

If there is no explicit search help then F4 values will come from Value table specified in domain of that field.

If u dont know the table then place the cursor in transaction input field and press F1. Here go to technical information. Here also u can get the domain of that field.

Go to domain of that field and press value range tab. Here in bottom u will have value table. If not just above there will be one table control fixed values. These values will come in F4 help.

Hope this is clear for u.

Thanks,

Vinod.

[Former Member]

Hi Venkat,

To find the search help for standard SAP field,place the cursor in the field,press f1,you can see the table,field name,data element.

Just go to se11.give the table name . search for the field name.click the tab Entry help / Check.You can now see the column Srch help.Copy the search help name.You can give this in the layout attributes.

You can also create z search helps and attach your fields.restrictive helps will be very useful.

Regards,

Charumathi.B

Edited by: Charumathi Balachandran on May 2, 2008 12:46 PM

[Former Member]

Hi,

Better u can use

at selection-screen on value-request for s_kunnr-low. " (or p_kunnr)

DATA: t_return1 LIKE ddshretval OCCURS 0 WITH HEADER LINE.

select kunnr name1 from kna1 into table i_kna1.

CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST'

EXPORTING

retfield = 'KUNNR'

value_org = 'S'

TABLES

value_tab = i_KNA!

return_tab = t_return1.

s_kunnr-low = t_return1-fieldval.

Or if u want to use search help.

u can use search help H_KNA1.

Regards

Srimanta

[Former Member]

Hi,

Can i know how to create a search help programatically?

THks

[Former Member]

Hi How to create search help programatically...my code is like..

tables: KNA1.

DATA ITAB LIKE KNA1 OCCURS 0 .

DATA: t_return1 LIKE ddshretval OCCURS 0 WITH HEADER LINE.

parameters: a type kna1-kunnr.

CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST'

EXPORTING

retfield = 'KUNNR'

value_org = 'S'

TABLES

value_tab = ITAB

return_tab = t_return1.

s_kunnr-low = t_return1-fieldval.

[vinod_vemuru2]

HI Venkateswar,

Check belo code. Just copy paste in some sample program see.

SELECT-OPTIONS: po_kunnr(10) TYPE c.

TYPES: BEGIN OF t_kna1,

kunnr TYPE kna1-kunnr,

END OF t_kna1.

DATA: t_return1 LIKE ddshretval OCCURS 0 WITH HEADER LINE,

itab TYPE STANDARD TABLE OF t_kna1.

AT SELECTION-SCREEN ON VALUE-REQUEST FOR po_kunnr.

SELECT kunnr FROM KNA1 INTO TABLE itab.

CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST'

EXPORTING

retfield = 'KUNNR'

value_org = 'S'

TABLES

value_tab = ITAB

return_tab = t_return1.

po_kunnr = t_return1-fieldval.

What u missed is simple select:-). Also avoid using header lines.

Thanks,

Vinod.