Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Uploading data from EXCEL

Go to solution
Former Member

‎09-24-2008 11:36 PM

0 Kudos

Is any standard transaction to upload data from excel to a z table?

i mean, to avoid to make a zreport using gui_upload fm and then make the insert into the ztable?

1 ACCEPTED SOLUTION

Go to solution
Former Member

‎09-24-2008 11:40 PM

0 Kudos

Hello,

I think the only way is to create a maintenace view to your table and the create either a CATT or LSMW to upload the data to that table from the exel file....

but if you want I can submit a sample code to upload flat files to Z tables.

Bye,

Gabriel P.-

2 REPLIES 2

Go to solution
Former Member

‎09-24-2008 11:40 PM

0 Kudos

Hello,

I think the only way is to create a maintenace view to your table and the create either a CATT or LSMW to upload the data to that table from the exel file....

but if you want I can submit a sample code to upload flat files to Z tables.

Bye,

Gabriel P.-

Go to solution
Former Member

‎09-25-2008 5:08 AM

0 Kudos

hi.....

upload the excel file in your internal table and then use BDC to updated the database table.

FM's to upload Excel:

GUI_UPLOAD

KCD_EXCEL_OLE_TO_INT_CONVERT

ALSM_EXCEL_TO_INTERNALTABLE

refer to the link:

http://diocio.wordpress.com/2007/02/12/sap-upload-excel-document-into-internal-table-2/

http://www.sap-img.com/abap/learning-bdc-programming.htm

thanks

nikita