topic Re: Reg:Zprogram in Application Development and Automation Discussions

Reg:Zprogram

p291102 — Tue, 16 Jun 2009 08:34:03 GMT

Dear All,

I am having one Ztable with table entries. Just if i am running the zprogram i will be getting the table enteris in excel file. For that program i will be giving the input as a ztable name. After getting the excel file with table entries contents, again i will be editing the records if it is needed, then i need one another Zprogram to upload the table entries in to that corresponding ztable.

so i need 2 z programs for one is downloading the table entries and another one is uploading the table enteries excel file into same ztable.

Thanks,

Sankar M

Edited by: Vijay Babu Dudla on Jun 16, 2009 5:56 AM

Re: Reg:Zprogram

kesavadas_thekkillath — Tue, 16 Jun 2009 08:38:06 GMT

i think a single program is enough for this

Re: Reg:Zprogram

p291102 — Tue, 16 Jun 2009 08:40:22 GMT

yes of course. If it is possible. <<removed_by_moderator>>

Edited by: Vijay Babu Dudla on Jun 16, 2009 5:59 AM

Re: Reg:Zprogram

kesavadas_thekkillath — Tue, 16 Jun 2009 08:43:30 GMT

something like fetch the records .. disply in ALV ... Edit it there .. and through a user command action save it to the table

Re: Reg:Zprogram

GauthamV — Tue, 16 Jun 2009 08:44:05 GMT


> Helpful answers will be rewarded.

Don't violate forum rules with such statements

I guess you know why your first post was locked

Re: Reg:Zprogram

former_member219399 — Tue, 16 Jun 2009 08:46:54 GMT

Hi,

For this you can do one thing.

First get data into one internal table and display it in an editable ALV.

Change the entries. and on user action you can update the backend table.

Another approach would be,

Use two radio buttons, one for upload and the other for download.

If user selects the radio button import, import data from data base table to the excel file using GUI_DOWNLOAD.

If user selects radio button for upload, call GUI_UPLOAD to read data from excel file to one intrnal table and from thisinternal tbale you can update the backend table.

With regards,

Vamsi

Re: Reg:Zprogram

former_member212005 — Tue, 16 Jun 2009 08:52:24 GMT

What you can do is....

Firstly, instead of downloading you can simply put the result in ALV....and then allow the fields to be editable...

When you enter the database table name in selection-screen...you can create dynamic internal table to put the entries from the database table..

Then all you have to do is Modify the database table based on the internal table entries...

select *

from (p_dtable)

into table gt_final.

Please search in forum for creation of dynamic internal table...

Re: Reg:Zprogram

kesavadas_thekkillath — Tue, 16 Jun 2009 08:57:17 GMT

hi sankar - Forum Points: 1,712 .... and these type of Qn really surprising for me ))

Re: Reg:Zprogram

Former Member — Tue, 16 Jun 2009 09:02:17 GMT

yes it is possible with a single program.

just make two T codes to call same program. Inside the program, execute the code for uploading to or downloading from excel sheet depending on this T code.

use the FMs-

For downloading- depending on your requirement

ALSM_EXCEL_TO_INTERNAL_TABLE

EXT_CONVERT_XLS_TO_SAP

For uploading the data-

gui_upload

take the data into internal tab before updating it into z tab.

you will have decide about data manipulations as to insert update or modify.

Regards,

Sumit Nene.

Re: Reg:Zprogram

p291102 — Tue, 16 Jun 2009 09:10:38 GMT

hi,

i gone to BW / BI area before 1.5 yrs . that's y only

Re: Reg:Zprogram

kesavadas_thekkillath — Tue, 16 Jun 2009 09:16:22 GMT

: )

Re: Reg:Zprogram

p291102 — Tue, 16 Jun 2009 09:20:49 GMT

dear,

your meaning is editable alv report is there to do this issue.

Re: Reg:Zprogram

kesavadas_thekkillath — Tue, 16 Jun 2009 09:27:44 GMT

ya first pick the data using FM gui_upload ,

Then populate it in editable alv or a table control.

correct the required data,

then save it to the database