Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Select multiple Columns from F4IF_INT_TABLE_VALUE_REQUEST

0 Likes
3,558

Friends,

I am trying to display a table using the FM F4IF_INT_TABLE_VALUE_REQUEST.

I would like to read the values of the entire row(or selected columns) that the user has clicked on.

Here are the input parameters i passed. In table lt_fields i specified the column that are to be read from value_tab.

CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST'

EXPORTING

retfield = 'BATCH'

dynpprog = lv_repid

dynpnr = lv_dynnr

dynprofield = lv_dynfld

value_org = 'C'

TABLES

value_tab = lt_bpo_upl

return_tab = lt_ret_status

field_tab = lt_fields.

Your inputs are appreciated.

Thank You.

Gayathri .

Friends,

I am trying to display a table using the FM F4IF_INT_TABLE_VALUE_REQUEST.

I would like to read the values of the entire row(or selected columns) that the user has clicked on.

Here are the input parameters i passed. In table lt_fields i specified the column that are to be read from value_tab.

CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST'

EXPORTING

retfield = 'BATCH'

dynpprog = lv_repid

dynpnr = lv_dynnr

dynprofield = lv_dynfld

value_org = 'C'

TABLES

value_tab = lt_bpo_upl

return_tab = lt_ret_status

field_tab = lt_fields.

Your inputs are appreciated.

Thank You.

Gayathri .

6 REPLIES 6
Read only

Former Member
0 Likes
2,064

Use the following FM with the given code..retrive the required number of fields in ur select query----

Hope it will solve ur problem....

DATA: BEGIN OF INTTAB OCCURS 10,

CODE LIKE QPCT-CODE,

KURZTEXT LIKE QPCT-KURZTEXT,

END OF INTTAB.

AT SELECTION-SCREEN ON VALUE-REQUEST FOR CODE-LOW.

SELECT CODE KURZTEXT FROM QPCT INTO TABLE INTTAB WHERE CODEGRUPPE = 'QCREMARK'.

CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST'

EXPORTING

RETFIELD = 'CODE'

DYNPPROG = SY-CPROG

DYNPNR = SY-DYNNR

DYNPROFIELD = 'CODE-LOW'

WINDOW_TITLE = 'Select Quality Remark Code'

VALUE_ORG = 'S'

TABLES

VALUE_TAB = inttab

EXCEPTIONS

PARAMETER_ERROR = 1

NO_VALUES_FOUND = 2

OTHERS = 3.

Edited by: mujib tirandaz on Apr 13, 2009 1:13 PM

Read only

Former Member
0 Likes
2,064

Hi Gayatri,

Use this function module to select or read the values of the entire row.


 CALL FUNCTION 'REUSE_ALV_POPUP_TO_SELECT'
          EXPORTING
            i_title               = w_text           "Title
            i_selection           = 'X'
            i_screen_start_column = 5
            i_screen_start_line   = 5
            i_screen_end_column   = 106
            i_screen_end_line     = 20
            i_tabname             = 'T_STO'                    "Table ame
            it_fieldcat           = gt_fieldcat_drd[]           "Field catalog
          IMPORTING
            es_selfield           = gc_selfield                  "Dummy structure returns index and lne selected
          TABLES
            t_outtab              = t_sto                          "Output Table 
          EXCEPTIONS
            program_error         = 1
            OTHERS                = 2.
        IF sy-subrc  0.
          MESSAGE e514 WITH 'wrong Selection'.
        ENDIF.

Read table T_STO index gc_selfield-index.
if sy-subrc  = 0.
"<<<<<---Move entrie row inot respected fields. 
endif.

in the dummy structure it returns index.

regards,

Prabhudas

Read only

Former Member
0 Likes
2,064

Hi

Thios FM is used to get the F4 values in selection screen for a field in selection screen

like:

at selection-screen on value request on s_matnr.

get the requreied values and pass those valuse to the FM.

Its not possible to select multiple value...

Kiran

Edited by: kiran vempati on Apr 13, 2009 1:19 PM

Read only

Former Member
2,064

Hi ,

try to pass MULTIPLE_CHOICE = 'X',see its documentations

regards

Prabhu

Read only

Former Member
0 Likes
2,064

Hi Gayatri,



use   'REUSE_ALV_POPUP_TO_SELECT'

instead of 'F4IF_INT_TABLE_VALUE_REQUEST'

the both function module acts same but the function module you used retunns only one value, the function module i mentioned returns index by capturing index you can retrice entire row values.


see the example i had given above,,

Regards,

Prabhudas

Read only

Former Member
0 Likes
2,064

Hi,

Try this FM 'POPUP_WITH_TABLE_DISPLAY'

sample code:

AT SELECTION-SCREEN ON VALUE-REQUEST FOR p_laufi.

SELECT lifnr

FROM zfamex_ibcp

INTO TABLE t_lifnr.

IF t_lifnr IS NOT INITIAL.

SELECT laufd

laufi

lifnr

FROM reguh

INTO TABLE t_laufi

FOR ALL ENTRIES IN t_lifnr

WHERE lifnr = t_lifnr-lifnr AND

xvorl NE 'X'.

SORT t_laufi BY laufd DESCENDING.

  • Function module to create F4 help for payment run date/run id

CALL FUNCTION 'POPUP_WITH_TABLE_DISPLAY'

EXPORTING

endpos_col = '63'

endpos_row = '30'

startpos_col = '40'

startpos_row = '5'

titletext = 'Payment Run Date/Payment Run Id'

IMPORTING

choise = w_tabix

TABLES

valuetab = t_laufi

EXCEPTIONS

break_off = 1

OTHERS = 2.

CHECK sy-subrc EQ 0.

READ TABLE t_laufi INTO wa_laufi INDEX w_tabix.

IF sy-subrc EQ 0.

w_laufd = wa_laufi-laufd.

w_laufi = wa_laufi-laufi.

CONCATENATE w_laufd

w_laufi

INTO p_laufi

SEPARATED BY space.

ENDIF.

ENDIF.

Regards

Krishna