topic Re: Data Upload in Application Development and Automation Discussions

Data Upload

Former Member — Fri, 25 Jul 2008 18:20:09 GMT

Guys,

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

Regards

Sonali

Re: Data Upload

Former Member — Fri, 25 Jul 2008 18:27:25 GMT

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

Re: Data Upload

Former Member — Sat, 26 Jul 2008 05:57:55 GMT

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.

Re: Data Upload

Former Member — Sat, 26 Jul 2008 10:50:00 GMT

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.

Re: Data Upload

Former Member — Tue, 29 Jul 2008 07:37:59 GMT

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

Re: Data Upload

Former Member — Tue, 29 Jul 2008 10:26:10 GMT

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

Re: Data Upload

Former Member — Tue, 29 Jul 2008 10:46:52 GMT

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