topic Re: update Z Table using Z program in Application Development and Automation Discussions

update Z Table using Z program

Former Member — Wed, 04 Jun 2008 05:21:44 GMT

Can anyone send sample program to update z table using Zprogam.

i have data from excel sheet and and selection screen.

answers will be rewarded.

Former Member — Wed, 04 Jun 2008 05:29:25 GMT

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 .

Former Member — Wed, 04 Jun 2008 05:31:51 GMT

hi!

refer this,

UPDATE <Ztable name> SET <field to update>

WHERE condition.

Former Member — Wed, 04 Jun 2008 05:35:07 GMT

Abhishek,

please try to search solution of your problem before throwing the thread,

i tried to search with update Z Table using Z program and got 1955 results.

please close this thread after giving mark.

Amit.

Former Member — Wed, 04 Jun 2008 05:41:28 GMT

hi....

first upload the data from yur excel file into an internal table using ws_upload function.

CALL FUNCTION 'WS_UPLOAD'

EXPORTING

filename = p_file

filetype = 'DAT'

TABLES

data_tab = itab_final.

loop at itab_final.

MOVE-CORRESPONDING itab_final TO ztable.

endloop.

modify ztable.

clear ztable.