How to download query to application server (SAP directory ) ?

[Former Member]

All expert,

How to download query to application server (SAP directory ) ?

Currently , we generate query to spool list then try use RSTXPDFT5 (GUI download of a spool request )download to app server but fail.

Error 'Can not open file on server' and this RSTXPDFT5 do not have parameter created by,we must fill in spool request no.

Do we able to download query direct to application server without go through spool ?

Rgds,

felice

AO SG

[emjay · Accepted solution]

Try TCode RSCRM_BAPI, this can be used to download a BW query to appserver

Hope this helps

[Former Member · Accepted solution]

Thanks for reply. but BW is out of scope of my project so i could not use Query in BI.

Is that other way ?

[Former Member]

Scenario : Output file in excel format from SAP directory to local access DB automatically.

We convert the query to ABAP program and add code output file to sap directory.

IF down_app <> space. %diact = 'Z'. ENDIF.

Initial plan, we would schedule batch job download output excel file from ABAP program to unix server, local SFTP trigger GET file from unix server then system schedule in destination server (Acess database) get file from SFTP server and upload into table Access DB.

With ABAP program, we able to schedule batch mode to output excel file to unix server. However,

batch mode it's not possible to create a real excel file, as here is not possible to first open the file in Excel before saving it. The best we could do is to create this similar file with .xls extension.

However, file with .xls extension would cause leading zero problem E.g. 0401 become 401.

The normal way of working in batch mode, would have been to create for example .csv or .txt files, and then the conversion into Excel would have been done when opening the file in Excel.

Solution: Access DB customize program to accept file in csv format instead of xls. SAP output csv file in batch mode.