topic Re: BDC Selection screen in module pool screen in Application Development and Automation Discussions

BDC Selection screen in module pool screen

Former Member — Thu, 20 Dec 2012 06:22:16 GMT

Dear Friends,

There is an requirement It is like this I created screen in that screen I have to keep two Buttons(Upload & Post). When I click on Upload it should give a popup to select a file from desktop or computer once it is selected it should display on the screen and when i click on Post It should insert the records in ZTABLE. Can any one help on this Requirement. Thank you

Moderator message: please do more research before posting.

Message was edited by: Thomas Zloch

Re: BDC Selection screen in module pool screen

vinoth_aruldass — Thu, 20 Dec 2012 06:35:01 GMT

hi,

Its very simple . under usercommand of update you write a logic for getting a file

using fm

f4_filename.

after getting file transfer it to internal table.

under post command .

write a logic for updating the table.

Hope it helps,

Vinoth

Re: BDC Selection screen in module pool screen

Former Member — Thu, 20 Dec 2012 07:02:02 GMT

hi sandeep ,

assuming your data file is excel.

use this fm for pop up to select file :

WS_FILENAME_GET or file_save_dialog

use this FM to read data from file to internal table.

CALL FUNCTION 'TEXT_CONVERT_XLS_TO_SAP'

EXPORTING

i_field_seperator = 'X'

i_line_header = 'X'

i_tab_raw_data = i_tab_raw_data

i_filename = filename

TABLES

i_tab_converted_data = i_tab_converted_data

EXCEPTIONS

conversion_failed = 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.

and once your records are in internal table you can insert or append them in database table.

regards

vaibhav

Re: BDC Selection screen in module pool screen

Former Member — Thu, 20 Dec 2012 08:03:28 GMT

Thank you vaibhav did the same got it

Re: BDC Selection screen in module pool screen

Former Member — Thu, 20 Dec 2012 08:04:57 GMT

Thank you vinoth for ur reply