topic Search help in Application Development and Automation Discussions

Search help

Former Member — Tue, 05 Dec 2006 13:13:34 GMT

Hello, I have a parameter called p_vbeln like vbak-vblen. On the selection-screen when I click on the match-code all the vblen appearing not only the vblens which belonging to table vbak. Question is: How can I get only that vbelns which are belonging to vbak table when I click on the matchbox?

Re: Search help

Former Member — Tue, 05 Dec 2006 13:15:34 GMT

hi,

you click on new selection button and give the table name as vbak

regards,

pankaj singh

Re: Search help

Former Member — Tue, 05 Dec 2006 13:19:58 GMT

in ur select-option use this as...

select-option: s_vbeln for vbak-vbeln.

or else

select-option: s_vbeln for vbuk-vbeln.

Re: Search help

Former Member — Tue, 05 Dec 2006 13:29:46 GMT

I defined as following, but it's not solved the problem.

PARAMETERS : p_vbeln LIKE vbak-vbeln.

When I click on the match code I need to display only that vbelns which belonging to vbak table. So any ideas?

Re: Search help

Former Member — Tue, 05 Dec 2006 13:31:28 GMT

Hi,

Yes, it will give all Vbelns present in VBUK table. If You want to show only VBAK vbelns then You can write code in "At Selection Screen on value-request" on P_vbeln by calling FM "F4IF_INT_TABLE_VALUE_REQUEST". write select statement getting all Vbelns of VBAK table and pass that internal table to this FM. When you click on Match box, only VBAK vbelns will be shown.

thanks,

sksingh

Re: Search help

Former Member — Tue, 05 Dec 2006 13:39:22 GMT

Hi,

at selection screen on p_vbeln.

perform help_check.

FORM HELP_CHECK.

*-- Set up fields to retrieve data

ltab_fields-tabname = 'VBAK'.

ltab_fields-fieldname = 'VBELN'.

ltab_fields-selectflag = 'X'.

APPEND ltab_fields.

SORT ltab_fields.

DELETE ADJACENT DUPLICATES FROM ltab_fields.

*-- Fill values

SELECT vbeln

INTO TABLE ltab_values

FROM vbak.

SORT ltab_values.

DELETE ADJACENT DUPLICATES FROM ltab_values.

CALL FUNCTION 'HELP_VALUES_GET_WITH_TABLE'

EXPORTING

fieldname = 'vbeln'

tabname = 'vbak'

title_in_values_list = 'Select a value'

IMPORTING

select_value = p_vbeln

TABLES

fields = ltab_fields

valuetab = ltab_values

EXCEPTIONS

field_not_in_ddic = 01

more_then_one_selectfield = 02

no_selectfield = 03.

ENDFORM. "fiscal_year

hope this helps,

keerthi

Re: Search help

Former Member — Tue, 05 Dec 2006 13:55:53 GMT

Could you tell me the type of ltab_fields?

Re: Search help

Former Member — Tue, 05 Dec 2006 16:12:17 GMT

hi,

itab_fields like help_value.

check function module documentation.

regards,

keerthi