topic Re: Select multiple Columns from F4IF_INT_TABLE_VALUE_REQUEST in Application Development and Automation Discussions

Select multiple Columns from F4IF_INT_TABLE_VALUE_REQUEST

gayathri_narayanan — Mon, 13 Apr 2009 10:59:07 GMT

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 .

Re: Select multiple Columns from F4IF_INT_TABLE_VALUE_REQUEST

Former Member — Mon, 13 Apr 2009 11:09:25 GMT

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

Re: Select multiple Columns from F4IF_INT_TABLE_VALUE_REQUEST

Former Member — Mon, 13 Apr 2009 11:17:08 GMT

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

Re: Select multiple Columns from F4IF_INT_TABLE_VALUE_REQUEST

Former Member — Mon, 13 Apr 2009 11:18:13 GMT

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

Re: Select multiple Columns from F4IF_INT_TABLE_VALUE_REQUEST

Former Member — Mon, 13 Apr 2009 11:25:52 GMT

Hi ,

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

regards

Prabhu

Re: Select multiple Columns from F4IF_INT_TABLE_VALUE_REQUEST

Former Member — Mon, 13 Apr 2009 11:26:39 GMT

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

Re: Select multiple Columns from F4IF_INT_TABLE_VALUE_REQUEST

Former Member — Mon, 13 Apr 2009 11:42:53 GMT

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.

Regards

Krishna