Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Data Transfer toPresentaion layer?

Former Member
0 Kudos
122

Hello Friends,

I can anyone give me steps to transfer the data from presenation layer to application layer.

The procedure i am following is like executeing the report using function module SUB_DOWNLOAD_APP. Program is executeing and but i am unable to see the data in AL11 txcode the directory i am seeing is DIR HOME. If i am going wrong somewhere please give suggestions on this.

Thks

5 REPLIES 5

Former Member
0 Kudos
98

Hi,

Try using the function module 'GUI_UPLOAD'.

Former Member
0 Kudos
98

Venkatesh,

First of all accessible directory is DIR_GLOBAL . Check it .

If not then tell basis people to create a Dir on path '/usr/sap/EC2/SYS/global' which should have all the authorization i.e. Read Write authirization.

Then follow following code.

DATA:w_filename LIKE CFFILE-FILENAME.

**'backup' is folder on application server created by Basis people..

CONCATENATE '/usr/sap/EC2/SYS/global/backup/'SY-UNAME '.csv' INTO w_filename.

OPEN DATASET w_filename FOR OUTPUT IN TEXT MODE ENCODING DEFAULT.

IF SY-SUBRC = 0.

LOOP AT ITAB

TRANSFER ITAB TO w_filename.

ENDLOOP.

ENDIF.

CLOSE DATASET w_filename.

It should work.

Regards,

Swarup.

Former Member
0 Kudos
98

Hi ,

After uploaded u r file into internal table.

use below code.

DATA:g_path LIKE rlgrap-filename

DEFAULT 'D:\usr\sap\DM0\DVEBMGS01\work\'.

OPEN DATASET g_path IN TEXT MODE ENCODING DEFAULT FOR OUTPUT.

IF sy-subrc NE 0.

CLOSE DATASET g_path.

MESSAGE e001 WITH 'Error in Opening the Error File'.

ELSE.

LOOP AT itab.

TRANSFER itab TO g_path .

ENDLOOP.

CLOSE DATASET g_path.

ENDIF.

-


otherwise use following tcodes for direct uploading data into application server directory

There are 2 SAP Transactions where you can up/download files to the Apps server (file system) .

CG3Y = Download

CG3Z = Upload

Regards,

Vishvesh

if helpful, rewards it.

Former Member
0 Kudos
98

Hi ,

After uploaded u r file into internal table.

use below code.

DATA:g_path LIKE rlgrap-filename

VALUE 'D:\usr\sap\DM0\DVEBMGS01\work\'.

OPEN DATASET g_path IN TEXT MODE ENCODING DEFAULT FOR OUTPUT.

IF sy-subrc NE 0.

CLOSE DATASET g_path.

MESSAGE e001 WITH 'Error in Opening the Error File'.

ELSE.

LOOP AT itab.

TRANSFER itab TO g_path .

ENDLOOP.

CLOSE DATASET g_path.

ENDIF.

-


otherwise use following tcodes for direct uploading data into application server directory

There are 2 SAP Transactions where you can up/download files to the Apps server (file system) .

CG3Y = Download

CG3Z = Upload

Regards,

Vishvesh

if helpful, rewards it.

Former Member
0 Kudos
98

hi,

for transfering the data from presentation server to appilcation use the tcode CG3Z.

after transfering the data to the appilication server use the

syntaxes like Open dataset (for opening dataset)

Read dataset.

close dataset.

for uploading the data into the internal table.

use session or call transaction method for uploading into the database.

reward if useful.

thanks and regards