We are currently running 3.1 BW. What is the best way to achieve a csv file from a BW query and move that file to another non sap external system. All of the above should have very minimum manual interruption. Please advice.
You can schedule using RSCRM_BAPI transaction. This will extract file into App. Server in csv format. Go through How to document, which is available in service, for detail analysis.
Depending on the query requirement you will go for Open hub or RSCRM_BAPI. If you have straight requirement to get few fields from Data Target you can go for Open Hub. If you need to acheive query features, like Calculations, restrictions, aggregation etc, better go for RSCRM_BAPI.
I found your suggestion very useful, but have a small doubt. While extracting the Query, it is asking for Technical name of extract. Could you please guide me, what to input in that field. If you have any document, kindly pass on.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.