topic Re: select option by using button. in Application Development and Automation Discussions

select option by using button.

former_member225134 — Tue, 26 Aug 2014 09:46:10 GMT

Hi,

In table maintenance screen i added one button in application toolbar ,while clickig that new button i want to display

one selection screen within that it wants to ask choose file(upload data from excel sheet).

while clicking that button,i want to show like that.

File path... ______________________(F4 option)..After select excel file from system..It updates the data in the table

maintenance generator..

Can any one suggest ????

Re: select option by using button.

former_member201275 — Tue, 26 Aug 2014 12:59:02 GMT

You can have a look at one of the sap demo programs, for example: BCALV_FULLSCREEN_DEMO. This has a button "local File" which when you click on ask you for file format, and once you select this you get a popup for the filepath.

Maybe you can cut and paste this code?

Re: select option by using button.

alisson_fragozo — Tue, 26 Aug 2014 13:29:13 GMT

Hi Anitha,

You can put a button in table maintenance wich uploads data to table.

Custom butom: http://zevolving.com/2008/09/add-custom-button-on-maintianence-view-sm30/

When button pressed, call the functions.

CALL FUNCTION 'F4_FILENAME' "get the file path

EXPORTING

program_name = syst-cprog

dynpro_number = syst-dynnr

field_name = ' '

IMPORTING

file_name = P_FILE.

CALL FUNCTION 'TEXT_CONVERT_XLS_TO_SAP'

EXPORTING

i_line_header = 'X'

i_tab_raw_data = it_raw " WORK TABLE

i_filename = p_file

TABLES

i_tab_converted_data = it_datatab[] "ACTUAL DATA

EXCEPTIONS

conversion_failed = 1

OTHERS = 2.

After, you work with ITAB, populating the fields of table.

Re: select option by using button.

Former Member — Fri, 12 Sep 2014 12:40:04 GMT

This message was moderated.