topic Re: ALV Report input enabled drop down list in Application Development and Automation Discussions

ALV Report input enabled drop down list

Former Member — Fri, 17 Apr 2009 09:45:34 GMT

Dear All,

I am looking for one ALV report where one of the column is input enabled with drop down list and when when user chooses a value and presses SAVE button at the top, then the value should be saved into a table for that particular line item.

Please can you help me out?

Best wishes,

Atanu

Re: ALV Report input enabled drop down list

Former Member — Fri, 17 Apr 2009 09:50:06 GMT

Hi,

This can be done.

For the input enabled column in the ALV in the fieldcat You will have to include edit = 'X' and f4availabl = 'X'.

Once this is done, you can use OO ABAP to design the ALV for F4 help. To get pointers to this see the program :

BCALV_F4

BCALV_GRID_F4_HELP_APPLICATIO

BCALV_GRID_F4_HELPM01

BCALV_TEST_GRID_F4_HELP

More options on F4 would be in the program BCALV_TEST_GRID_F4_HELP

Regards,

Mansi.

Edited by: SAP USER on Apr 17, 2009 11:51 AM

Re: ALV Report input enabled drop down list

Former Member — Fri, 17 Apr 2009 09:50:18 GMT

Hi,

Kindly refer Standard SAP Prog BCALV_EDIT_06 & BCALV_EDIT_07 for your reference.

Hope it will help you in developing,

Pratik

Re: ALV Report input enabled drop down list

I355602 — Fri, 17 Apr 2009 09:51:41 GMT

Hi,

For drop down list in alv refer:-

BCALV_EDIT_06 -- Dropdown Listbox at Column Level

BCALV_EDIT_07 -- Dropdown Listbox at Cell Level

Refer this code will reflect all the changes into the internal table that is being displayed.


  CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY'
   EXPORTING
     i_callback_program                = v_rep_id       " report id
     i_callback_pf_status_set          = 'PF'           " for PF-STATUS
     i_callback_user_command           = 'USER_COMMAND' " for User-Command
     is_layout                         = wa_layout      " for layout
     it_fieldcat                       = it_field       " field catalog
     it_sort                           = it_sort        " sort info
    TABLES
      t_outtab                          = it_final      " internal table
   EXCEPTIONS
     program_error                     = 1
     OTHERS                            = 2.

  IF sy-subrc <> 0.
    MESSAGE ID sy-msgid TYPE sy-msgty NUMBER sy-msgno
            WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.
  ENDIF.

*&---------------------------------------------------------------------*
*&      Form  pf
*&---------------------------------------------------------------------*
*       SUB-ROUTINE PF IS USED TO SET THE PF-STATUS OF THE SCREEN
*       ON WHICH THE ALV GRID IS DISPLAYED
*----------------------------------------------------------------------*
*       -->RT_EXTAB
*----------------------------------------------------------------------*
FORM pf USING rt_extab TYPE slis_t_extab.
  SET PF-STATUS 'ZTG_STAT'.
ENDFORM.                    "pf

*&---------------------------------------------------------------------*
*&      Form  USER_COMMAND
*&---------------------------------------------------------------------*
*       SUB-ROUTINE USER_COMMAND IS USED TO HANDLE THE USER ACTION
*       AND EXECUTE THE APPROPIATE CODE
*----------------------------------------------------------------------*
*      -->LV_OKCODE   used to capture the function code
*                     of the user-defined push-buttons
*      -->L_SELFIELD   text
*----------------------------------------------------------------------*
FORM user_command USING lv_okcode LIKE sy-ucomm l_selfield TYPE slis_selfield.

* assign the function code to variable v_okcode
  lv_okcode = sy-ucomm.

* handle the code execution based on the function code encountered
  CASE lv_okcode.

* when the function code is SAVE then save records into internal table
    WHEN 'SAVE'.

* to reflect the data changed into internal table
      DATA : ref_grid TYPE REF TO cl_gui_alv_grid. "new

      IF ref_grid IS INITIAL.
        CALL FUNCTION 'GET_GLOBALS_FROM_SLVC_FULLSCR'
          IMPORTING
            e_grid = ref_grid.
      ENDIF.

      IF NOT ref_grid IS INITIAL.
        CALL METHOD ref_grid->check_changed_data.
      ENDIF.

"now at this time you have modified internal table

* refresh the ALV Grid output from internal table
      l_selfield-refresh = 'X'.

"alv output is refreshed as per changes in internal table

  ENDCASE.

ENDFORM.                    "USER_COMMAND

Hope this helps you.

Regards,

Tarun

Re: ALV Report input enabled drop down list

former_member203501 — Fri, 17 Apr 2009 09:52:04 GMT

hi ,

check the report BCALV_EDIT_06 is good for drop down and selection....but u need to write the coding for save in it

Re: ALV Report input enabled drop down list

Former Member — Fri, 17 Apr 2009 09:52:17 GMT

Hi,

Try this.

Make it editable and dropdown enabled in the fieldcatalog. Along with the other data use the below two fields of the fieldcatalog structure to fulfill your requirement.

data: wa_fieldcat type lvc_s_fcat.

wa_fieldcat-edit = 'X'.

wa_fieldcat_-drdn_hndl = '1'.

data: i_dropdown TYPE lvc_t_drop,

wa_dropdown TYPE lvc_s_drop,

wa_dropdown-handle = '1'.

MOVE <required value> TO wa_dropdown-value.

APPEND wa_dropdown TO i_dropdown.

CLEAR : wa_dropdown.

<required value> -

the values you want to display in the drop down.

Regards,

Sharin.

Re: ALV Report input enabled drop down list

Former Member — Fri, 17 Apr 2009 09:53:38 GMT

Hi,

Kindly go through these links below:

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/abap/an%20easy%20reference%20for%20alv%20grid%20control.pdf

https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/b3d5e890-0201-0010-c0ac-bba85ec2ae8d

Hope it helps

Regards

Mansi

Re: ALV Report input enabled drop down list

dharma_esampalli — Sat, 12 Jan 2013 07:18:46 GMT

Hi,

I have followed the above steps. But I'm getting Drop down(same drop down table) to all the columns in my ALV output.

But my requirement is i want it only to a particular column. How to fix the Internal table that I have created as Dropdown to my single column.

Steps I followed,

1) In Field catalog, DRDN-HNDL = '1' & EDIT = 'X'

2) Defined a drop down table of type LVC_T_DROP and appended a few entries to it.

3) ref_grid -> SET_DROP_DOWN_TABLE & passed my drop down table in Exporting table.

4) then displayed the ALV, ref_grid->set_table_for_first_display.

where to give the condition.

Re: ALV Report input enabled drop down list

Former Member — Sun, 13 Jan 2013 10:10:46 GMT

Hi Sekhar,

Loop at your filedcatalog internal table.

write a case statement. This case statemnet will hold the field values for which you want the drop down. And, then append the values.

For example,

LOOP AT gt_fieldcat INTO ls_fcat.

CASE ls_fcat-fieldname.

WHEN 'FIELD1'.

ls_fcat-drdn_hndl = '1'.

MODIFY gt_fieldcat FROM ls_fcat.

WHEN 'FIELD2'.

ls_fcat-drdn_hndl = '2'.

MODIFY gt_fieldcat FROM ls_fcat.

ENDCASE.

ENDLOOP.

hope this helps.

Thanks,

Namrata