topic Re: How to post data into table in Application Development and Automation Discussions

How to post data into table

sreeramkumar_madisetty — Fri, 05 Oct 2007 10:26:41 GMT

Hi folks

I have an custom table with fields:

Tcode

startdate

description

Transign

DebitG/LAccount

CreditG/LAccount

Posting key debit

Postingkey debit

I have a Excel file containing 500 records with

Tcode,startdate,description,Transsign,DebitG/LAccount,

CreditG/LAccount

Posting key debit

Postingkey debit

This table is no where ralted with any transaction.

Can you please let me know how to post data into this table other than using Table Maintanance Generator.

<b>Points are assured for correct answers.</b>

Regards,

Sree

Re: How to post data into table

Former Member — Fri, 05 Oct 2007 10:30:17 GMT

Hello Sree,

First upload the file to an itab using GUI_UPLOAD FM.

Then use this satement.

<b>MODIFY ZTABLE FROM ITAB.</b>

Vasanth

Re: How to post data into table

Former Member — Fri, 05 Oct 2007 10:30:47 GMT

hi sreeram

first create an internal table with the same fields and then use gui_upload FM to upload the data into internal table and then keep loop to internal table and use insert statement to keep the data into database table.

Regards

sandhya

Re: How to post data into table

Former Member — Fri, 05 Oct 2007 10:32:05 GMT

HI,

code a program from where u get records in internal table and then

use loop at that table , and use modify statement endloop.

regards,

Santosh Thorat.

Re: How to post data into table

Former Member — Fri, 05 Oct 2007 10:37:53 GMT

There are 2 options...

1) Create lsmw and u can upload the data into the table. This can be used any number of times and easy to use.

2) Write a zprogram in which create an internal table with the same field structure and using gui_upload upload the data into the internal table.

now, use update statement...

UPDATE <target> FROM TABLE <itab> .

Re: How to post data into table

Former Member — Fri, 05 Oct 2007 10:38:14 GMT

Hi,

Make one program in which u need to create an internal table with the structure similar to ur excel file.

Then use FM GUI_upload to get the data from file to internal tabel....

Once u have data in internal table....update the same in database table...

Make sure structures of file, internal table and database table are identical.

Message was edited by:

Dhananjay Patil