topic Re: Control table F4 help in Application Development and Automation Discussions

Control table F4 help

Former Member — Mon, 11 Sep 2006 21:45:10 GMT

I have a control table with two columns (A & B) in a customised dialog program. Column A is the type and column B is the subtype. What I need is to control the F4 help for column B base on column A. I like to know how can I do that? Must I use a search help exit or can I code it directly in the Process on Request? Please advise

Regards,

Lanwu

Re: Control table F4 help

Former Member — Tue, 12 Sep 2006 05:08:11 GMT

You can do something like this on <b>Process on Value-request</b> :

tables tcurt.

DATA DYFIELDS LIKE DYNPREAD OCCURS 1 WITH HEADER LINE.

PARAMETERS: P_WAERS LIKE TCURT-WAERS, "Currency

P_LTEXT LIKE TCURT-LTEXT, "Long Text

P_KTEXT LIKE TCURT-KTEXT. "Short Text

AT SELECTION-SCREEN ON VALUE-REQUEST FOR P_WAERS.

CLEAR: DYFIELDS[], DYFIELDS.

*--- select currency

CALL FUNCTION 'HELP_VALUES_GET'

EXPORTING

fieldname = 'WAERS'

tabname = 'TCURT'

IMPORTING

SELECT_VALUE = P_WAERS.

*--- get long text for the selected currency

SELECT SINGLE LTEXT FROM TCURT

INTO DYFIELDS-FIELDVALUE

WHERE SPRAS = SY-LANGU

AND WAERS = P_WAERS.

IF SY-SUBRC <> 0.

CLEAR DYFIELDS-FIELDVALUE.

ENDIF.

*--- update another field

DYFIELDS-FIELDNAME = 'P_LTEXT'.

APPEND DYFIELDS.

CALL FUNCTION 'DYNP_VALUES_UPDATE'

EXPORTING

DYNAME = SY-CPROG

DYNUMB = SY-DYNNR

tables

dynpfields = DYFIELDS .

AT SELECTION-SCREEN ON VALUE-REQUEST FOR P_KTEXT.

*--- read another field

CLEAR: DYFIELDS[], DYFIELDS.

DYFIELDS-FIELDNAME = 'P_WAERS'.

APPEND DYFIELDS.

CALL FUNCTION 'DYNP_VALUES_READ'

EXPORTING

DYNAME = SY-CPROG

DYNUMB = SY-DYNNR

TABLES

DYNPFIELDS = DYFIELDS .

READ TABLE DYFIELDS INDEX 1.

*--- get short text and update current field

SELECT SINGLE KTEXT FROM TCURT

INTO P_KTEXT

WHERE SPRAS EQ SY-LANGU

AND WAERS EQ DYFIELDS-FIELDVALUE.

Re: Control table F4 help

Former Member — Tue, 12 Sep 2006 05:21:38 GMT

Hi lanwu,

1. For this, the following must be fulfilled,

so that it can be done automatically,

without any extra code :

a) there should be one master table, which has

all the possible combination values

of column A & B

b) create a search help on this table

c) In search help, make A as IMPORTING parameter

(This will ensure that value of A is imported

from the screen field,

and is filtered out for showing corresponding/related

B only)

2. In your dialog program,

the screen fields names should be same.

3. Thats all !

regards,

amit m.