hello,,its regarding a updation of database tables !

[Former Member]

hello all,

i'm student in germany and my problem is as follows:

when ever im making some change the domain or data element in my tables ,

all my entries r lost,i want to write a program such that ,

i can save my entries of database table in an exel sheet and

update the same in my tables when required,

i want the steps to be followed to write this program.

thanking you,

Nisha Jagtap.

[Former Member]

It would be easier not to delete the records when you adjust the table.

Rob

[former_member156446]

first remove the number of hits for the table in se11... and execute u will get all the data in the table , save file . xls save..

gui_upload into itab_4db.

refresh DBtable[].

modify db table from itab_4db.

done.

Reward points if useful

[Former Member]

Hello ,

Can u tell me how to proceed further,,,

i have saved my entries in an exel sheet,

but how to relate a exel sheet into ABAP ,,its not recognizing,

how to save file . (xls save..what does this mean).

Can u please tell me the procedure in brief,

how to update DBtable from an exel sheet ?

Awaiting for ur responce.

Nisha Jagtap.

[former_member195698]

As written by Bob, the data will not be lost from the database table by changing the domain or the data element, unless you select the radio button "Delete Data" while adjusting the database table with Database Utilitiy.

Instead of selecting the button "delete data", select the radio button "save data" while adjusting your database table, The data will not be lost.

If you want to try your way check the blog.

/people/alvaro.tejadagalindo/blog/2006/03/16/taking-good-care-of-z-data

It can be used for Both Download and Upload of data from any database table.

Regards,

abhishek