topic Re: insert records in the database table in Application Development and Automation Discussions

insert records in the database table

Former Member — Wed, 18 Apr 2007 05:06:59 GMT

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.

Re: insert records in the database table

Former Member — Wed, 18 Apr 2007 05:25:40 GMT

Hi Raju..

U must upload data from flat file using GUI_UPLOAD into an ITAB

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

Re: insert records in the database table

Former Member — Wed, 18 Apr 2007 05:27:44 GMT

u can use following function modules

GUI_upload

WS_uplooad

upload

regards

ravish

dont forget to reward points if helpful

Re: insert records in the database table

Former Member — Wed, 18 Apr 2007 18:17:17 GMT

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 .

Re: insert records in the database table

Former Member — Wed, 18 Apr 2007 19:20:42 GMT

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.

Re: insert records in the database table

Former Member — Thu, 19 Apr 2007 04:26:26 GMT

thanks

but how can i delete and recreate table maintainence genereator.

can u give me the steps for doing that.

Re: insert records in the database table

Former Member — Thu, 19 Apr 2007 04:51:00 GMT

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