ztable

[Former Member]

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

[bpawanchand]

• 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

[kesavadas_thekkillath]

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

[Former Member]

Hi ,

GUI_UPLOAD ,UPLOAD ... WS_UPLOAD ...

PLease search in forums before posting !!!!

Regards

Renu ...

[Former Member]

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.

[Former Member]

[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

[Former Member]

[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

[Former Member]

Perhaps knows the answer?

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

Bye-bye,

Julius

[Former Member]

how how how did you get that??

pk