Data Upload

[Former Member]

Guys,

I want to upload some 20000 entries into a custom Z table. Can you tell me which approach wud be better.

Regards

Sonali

[Former Member]

Hi,

Append the entries into an internal table with proper primary key fields.

Use INSERT ZTABLE from table itab.

If you think there might be duplicates in primary keys,better use MODIFY ZTABLE from table itab.

Regards,

Subramanian

Edited by: Subramanian PL on Jul 25, 2008 11:27 AM

[Former Member]

Hi,

if it is ztable and if it is not associated with any field checks then directly fetch the data into the internal table and use INSERT stmt and update the database table.

Thanks and regards.

[Former Member]

hi do like this....

loop at itab .

ztable-field1 = itab-field1.

ztable-field2 = itab-field2.

ztable-field3 = itab-field3.

ztable-field4 = itab-field4.

insert ztable .

endloop.

[Former Member]

hi sonali

first fetch the data using BDC and LSMW from a flat file to your internal table and then u can use the update, insert and modify statements. to update ztable.

thanks & regards

pardeep kumar

[Former Member]

hi sonali

you can use Insert or update to load the ztable, if you find that there may be replicates of data may occurs then use MODIFY.

note : if the solution satisfies you just reward some points.

regards

Balaji.G

[Former Member]

Hi ,

Create TMG for that table then U can use BDC program to uplaod the data into sap database..... U can uplaod the data .. for Ztable ...

Reward Points if useful

Raghunath.S

9986076729