topic Re: Data Transfer toPresentaion layer? in Application Development and Automation Discussions

Data Transfer toPresentaion layer?

Former Member — Wed, 21 May 2008 05:13:54 GMT

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

Re: Data Transfer toPresentaion layer?

Former Member — Wed, 21 May 2008 05:17:51 GMT

Hi,

Try using the function module 'GUI_UPLOAD'.

Re: Data Transfer toPresentaion layer?

Former Member — Wed, 21 May 2008 06:38:50 GMT

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.

Re: Data Transfer toPresentaion layer?

Former Member — Wed, 21 May 2008 07:04:35 GMT

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.

Re: Data Transfer toPresentaion layer?

Former Member — Wed, 21 May 2008 07:06:53 GMT

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.

Re: Data Transfer toPresentaion layer?

Former Member — Wed, 21 May 2008 08:29:58 GMT

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