SAP ECC/ABAP connection with R

[lejarx]

Hi Pier,

I was looking for ways to connect R with SAP (not Hana), and stumbled upon your RSAP package.
Do you any whether this is currently feasible?

Thanks!

[piersharding]

Hi - RSAP should still work for RFC calls against the ABAP NetWeaver stack.

[lejarx]

Is there any tutorial on how to make a simple select query from SAP table? Thanks

[piersharding]

Hi - there is no tutorial, but a starting place might be to look at the tests for instance https://github.com/piersharding/RSAP/blob/master/tests/7.R

Cheers,
Piers.

[lejarx]

Hi @piersharding

Apologize for the late reply.

I'm on Windows , how do I find the path for the arguments below?

Thanks

install_github('piersharding/RSAP', 
               args=c("--configure-args='--with-nwrfcsdk-include=/home/piers/code/sap/nwrfcsdk/include --with-nwrfcsdk-lib=/home/piers/code/sap/nwrfcsdk/lib' --no-clean-on-error"))

[lejarx]

Hi @piersharding

My SAP NetWeaver is currently installed in this folder

C:\Program Files (x86)\SAP\FrontEnd\SAPgui
So what I did is, I run the installation with the following argument

install_github('piersharding/RSAP', args=c("--configure-args='--with-nwrfcsdk-include=C:/Program Files (x86)/SAP/FrontEnd/SAPgui --with-nwrfcsdk-lib=C:/Program Files (x86)/SAP/FrontEnd/SAPgui' --no-clean-on-error"))

And below is the error I get

 installing *source* package 'RSAP' ...
** using staged installation
ERROR:  C:/nwrfcsdk/lib  lib directory does not exist.  You must download the NW RFC SDK and ensure that it is located in C:/nwrfcsdk. 
ERROR: configuration failed for package 'RSAP'

I tried moving the files from C:/Program Files (x86)/SAP/FrontEnd/SAPgui to C:/nwrfcsdk but apparently my installation doesn't have this lib folder.

Are you aware of any latest guide on making this work on Windows?

I followed this one https://blagrants.blogspot.com/2012/06/analytics-with-sap-and-r-windows.html

Thanks