Skip to Content

Select multiple Columns from F4IF_INT_TABLE_VALUE_REQUEST

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 .

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • avatar image
    Former Member
    Apr 13, 2009 at 11:09 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 13, 2009 at 11:17 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 13, 2009 at 11:18 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 13, 2009 at 11:25 AM

    Hi ,

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

    regards

    Prabhu

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 13, 2009 at 11:26 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 13, 2009 at 11:42 AM

    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

    Add comment
    10|10000 characters needed characters exceeded