Query in Screen programming

jothivenkatesh_m — Wed, 06 Feb 2008 08:59:24 GMT

Hi Everyone,

I've a screen which has 3 fields identical from the Progam (Report).

Now i want to get the 3 fields getting populated based on the value for one field.

Based on the value entered by the user in one field, i'll query a database table and populate the 3 fields.

Wanted to know how this can be done?

Thanks.

Re: Query in Screen programming

Former Member — Wed, 06 Feb 2008 09:17:04 GMT

If u want that based on first field , other fields value should be appear from database as f4, then look at this code.

in this code MODULE value_carrier INPUTand MODULE value_connection INPUT.are the point to notice.

here we are trying to retreive connection value on the basis of carrier value from database.

TYPES: BEGIN OF values,

carrid TYPE spfli-carrid,

connid TYPE spfli-connid,

END OF values.

DATA: carrier(3) TYPE c,

connection(4) TYPE c.

DATA: progname TYPE sy-repid,

dynnum TYPE sy-dynnr,

dynpro_values TYPE TABLE OF dynpread,

field_value LIKE LINE OF dynpro_values,

values_tab TYPE TABLE OF values.

CALL SCREEN 100.

MODULE init OUTPUT.

progname = sy-repid.

dynnum = sy-dynnr.

CLEAR: field_value, dynpro_values.

field_value-fieldname = 'CARRIER'.

APPEND field_value TO dynpro_values.

ENDMODULE.

MODULE cancel INPUT.

LEAVE PROGRAM.

ENDMODULE.

MODULE value_carrier INPUT.

CALL FUNCTION 'F4IF_FIELD_VALUE_REQUEST'

EXPORTING

tabname = 'DEMOF4HELP'

fieldname = 'CARRIER1'

dynpprog = progname

dynpnr = dynnum

dynprofield = 'CARRIER'.

ENDMODULE.

MODULE value_connection INPUT.

CALL FUNCTION 'DYNP_VALUES_READ'

EXPORTING

dyname = progname

dynumb = dynnum

translate_to_upper = 'X'

TABLES

dynpfields = dynpro_values.

READ TABLE dynpro_values INDEX 1 INTO field_value.

SELECT carrid connid

FROM spfli

INTO CORRESPONDING FIELDS OF TABLE values_tab

WHERE carrid = field_value-fieldvalue.

CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST'

EXPORTING

retfield = 'CONNID'

dynpprog = progname

dynpnr = dynnum

dynprofield = 'CONNECTION'

value_org = 'S'

TABLES

value_tab = values_tab.

ENDMODULE.

Other way is u just want that when user select first field on selection screen , other shud automatically field from database into selection screen textbox then use this logic.

instead of CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST'

EXPORTING

retfield = 'CONNID'

dynpprog = progname

dynpnr = dynnum

dynprofield = 'CONNECTION'

value_org = 'S'

TABLES

value_tab = values_tab.

in previous code.

move fetched values to selection screen fields.

rewards point if helpful

Re: Query in Screen programming

jothivenkatesh_m — Wed, 06 Feb 2008 10:29:05 GMT

Trying to solve my problem after some follow up with the code... thanks

topic Re: Query in Screen programming in Application Development and Automation Discussions

Query in Screen programming

Re: Query in Screen programming

Re: Query in Screen programming