‎2007 Dec 18 10:16 AM
Hi,
1.Is there any way to delete the files in the application server
2. and where does all the files inthe application server get stores( i.e table name)
‎2007 Dec 18 10:20 AM
Hi,
Application Server is nothing but the path of any machine on the Network. Whatever path you are looking in AL11 are the some network connected systems.
For deleting the file either go to that machine and delete the file from the respective folder or check this -
report zrich_0001.
parameters: d1 type localfile default '/usr/sap/TST/SYS/Data1.txt'.
start-of-selection.
delete dataset d1.
Thanks to Rich for this code.
Regards,
Amit
‎2007 Dec 18 10:34 AM
This is ok when you are going to delete one file in the application server, but in my case I have some 1000 of files, so what would be the better approch.
‎2007 Dec 26 7:56 AM
To delete files from Application server :
1. Contact your basis administrator and give the list of files along with directory path to delete the files.
2. If your Application server is installed on UNIX, you can delete it programatically using
system calls. (Not recommendable for one time solution - it will require UNIX command to be called).
3. Read file one by one and overwrite data with blank entries. this will leave filenames as it is, but they will not occupy much space.
Option1 will be best to delete large amount of file only once.
For you second query,
Files are stored on Application server in similar manner they are stored in directories on Windows / UNIX. Basis Administrator will be able to login to Application server and view all the files. (If you are using logical filepath, use table PATH to see it's corresponding physical filepath on Application Server)
ls -l /sapin/UP2/comparison/
‎2007 Dec 26 8:32 AM
Hai,
You can see your files which are stored on application server using Tcode: AL11.
You can delete files on application server by specifying path of the file.
For this,
Go to AL11.
Select your filename by choosing your directories.
Choose Attributes button. Here you can see your exact file path
Now write a program to delte.
Example:
REPORT ytest_eswar.
DATA: v_ucomm(1000) TYPE c.
PARAMETERS: p_fname TYPE salfile-longname DEFAULT 'C:\usr\sap\ERP\SYS\global\test.dat'.
v_ucomm = 'DEL'.
CONCATENATE v_ucomm p_fname INTO v_ucomm SEPARATED BY space.
Execute the Delete command.
CALL 'SYSTEM' ID 'COMMAND' FIELD v_ucomm.