2008 May 21 6:13 AM
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
2008 May 21 6:17 AM
2008 May 21 7:38 AM
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.
2008 May 21 8:04 AM
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.
2008 May 21 8:06 AM
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.
2008 May 21 9:29 AM
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