insert records in the database table

[Former Member]

i have the records in the file (and the file is in .XML format).

i need to these insert the records in the database table.

i have to methods

1. to insert the by writing the code (xml to text file later into the application

server and then opening the file and we can update the database.

2. we can update manually.

i need other method other than this two methods.

can i use directly xml file to update database table.

is their any function module.

is their any to method to update database table directly by using flat file.

[Former Member]

Hi Raju..

U must upload data from flat file using <b>GUI_UPLOAD</b> into an <b>ITAB</b>

and then insert records into ur dbtab..using insert..

[Former Member]

hi

u can use following function modules

GUI_upload

WS_uplooad

upload

regards

ravish

<b>dont forget to reward points if helpful</b>

[Former Member]

ok

but i should not use these methods. (ws_upload)

what is the use of table maintenace genarator for the database table.

but i am working on 3.1H version.

when i am selecting the TABLE MAINTANENCE GENERATOR for the database table i am getting this error " No control folder entry for table/view YBMTEXEMPT".

i need the solution for this .

that is i want to avoid these error and how can i do this.

and how can i insert data into the database table by using TABLE MAINTANENCE GENERATOR .

[Former Member]

Hi,

Table maintainance generator is used to create or change or delete the entries from table. after creating table maintenance u can able to create or change in transaction sm30. If there is any error in table maintenance its better to delete and recreate the table maintenance.

[Former Member]

thanks

but how can i delete and recreate table maintainence genereator.

can u give me the steps for doing that.

[Former Member]

Hi,

You can upload your flat file into the database using BDC.

For this, you can convert the file to .dat or .txt or to an excel file format.

Refer to the link:-

http://aspalliance.com/471

Once the file is in the required format, you can upload it into the database.

For this, you can do the recording of the transaction which is required, and then use either of the call transaction or session method to upload data into the database.

Thanks and regards,

Prerna