topic Adding data to Z table from a file in Application Development and Automation Discussions

Adding data to Z table from a file

Former Member — Fri, 14 Apr 2006 20:07:07 GMT

Hi All,

Is there some way I can import data from a file into Z table without creating BDC for SM30 transaction. Is there some facility in SM30 itself which will allow me to do mass data imports?

Thanks for reading

Re: Adding data to Z table from a file

Former Member — Fri, 14 Apr 2006 20:16:06 GMT

I meant an excel file

Re: Adding data to Z table from a file

Former Member — Fri, 14 Apr 2006 20:59:06 GMT

If you have LSMW , You can upload data using LSMW. But if you dont have much validations i suggest upload via BDC only.

Hope this helps.

Thanks,

Vamshi

Re: Adding data to Z table from a file

former_member181966 — Fri, 14 Apr 2006 21:35:00 GMT

I wish there can be upload utility ..But BDC is only a good option OR you can write a program which reads your file INSERT in DB .

After that You can compare the view using tr.SCMP and adjust in other clients OR Transport the entries ..

Hope this’ll give u some help!!

Don’t forget to award the points !!

Thanks

Re: Adding data to Z table from a file

Former Member — Sun, 16 Apr 2006 21:42:53 GMT

Think you are much better off writing a simple program using Insert. If you are going to use program frequently then Insert DB statement is definately better in performance then BDC.

Re: Adding data to Z table from a file

Former Member — Sun, 16 Apr 2006 23:27:00 GMT

Hi Srikrishna,

Check the link below, its a utility tool available on SDN itself and you can use this tool to upload data to any z table.

Ofcourse the best way is to write a simple piece of code but at time we need to work smarter ;-).

Hope this helps.

Cheers

Re: Adding data to Z table from a file

Former Member — Mon, 17 Apr 2006 04:14:34 GMT

Hi Srikrishna,

1. Does this Z Table have an associated

Program (MOdule Pool)

for data entry purpose ?

2. If yes, then its always better

to put data in Z Table via BDC.

<b>3. Other wise its not necessary at all !</b>

4. After uploading data in internal table,

Loop at ITAB.

MODIFY dbtab FROM itab.

Endloop.

regards,

amit m.