How to post data into table

[sreeramkumar_madisetty]

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

[Former Member]

Hello Sree,

First upload the file to an itab using GUI_UPLOAD FM.

Then use this satement.

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

Vasanth

[Former Member]

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

[Former Member]

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.

[Former Member]

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> .

[Former Member]

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