topic Re: ztable in Application Development and Automation Discussions

ztable

Former Member — Thu, 13 Nov 2008 06:35:27 GMT

Hello All Experts,

I need to update one Ztable with the data from a flat file as Excell,

Which is the best method for this insertion of data ,

Please explain in detail ,

thanks in advance

please mention a best executable code for this .

Edited by: Alan Rarya on Nov 13, 2008 7:37 AM

Re: ztable

bpawanchand — Thu, 13 Nov 2008 06:37:57 GMT

First declare a internal table of the Ztable type in the ABAP program.
By using the FM GUI_UPLOAD upload the data into the internal table that you created in the first step
By using open SQL statement ( Modify) update the Z table .

Simple and Sweet

Re: ztable

kesavadas_thekkillath — Thu, 13 Nov 2008 06:38:16 GMT

upload using Excel upload functional module.

for this make a search in the forum...u will get it there.

Then process that itab and insert it into Ztable...

Re: ztable

Former Member — Thu, 13 Nov 2008 06:40:26 GMT

Hi ,

GUI_UPLOAD ,UPLOAD ... WS_UPLOAD ...

PLease search in forums before posting !!!!

Regards

Renu ...

Re: ztable

Former Member — Thu, 13 Nov 2008 06:41:13 GMT

Hi Alan,

Use the following code:

data: ztable_t type ztable.

Upload your excel table into abap pgm using cl_gui_frontendservices=>gui_upload into table itab.

loop at itab.

Move-corresponding itab to wa_ztable.

append wa_ztable to ztable_t.

endloop.

insert ztable from ztable_t .

Hope this will help.

Regards,

Nitin.

Re: ztable

Former Member — Thu, 13 Nov 2008 06:42:50 GMT

[link|;

see response by rich.

instead of displaying the data you use a modify statement to write the data in itab to the ztable.

Regards,

Srinivas

Re: ztable

Former Member — Thu, 13 Nov 2008 06:46:25 GMT

[link|;

see response by rich.

instead of displaying the data you use a modify statement to write the data in itab to the ztable.

Regards,

Srinivas

Re: ztable

Former Member — Thu, 13 Nov 2008 10:00:58 GMT

Perhaps knows the answer?

Ahh... sorry, he only asks you the questions......

Bye-bye,

Julius

Re: ztable

Former Member — Thu, 13 Nov 2008 10:03:11 GMT

how how how did you get that??