In the /nse37 transaction, were you able to open the function module? And what happens if you click on single-test and actually execute the function with no parameters? You should get an error saying that you haven’t specified parameters but I bet you get an authorization error instead.
I am able to see the function using Display.
The time when i click or use F8 to execute it.
the error comes “You donot have authorization for this function”
Thats why i was asking about the type of authorization required to access the RFC_ABAP_INSTALL_AND_RUN.
Fully agree with your Basis people, the datastore setting “generate_and_execute” is for development and needs all these permissions. For prod you use “execute_preloaded” which needs none of these permissions but the DataService provided SAP function installed.
This is something like an standard, which we can follow…is it?
Conclusion:- So because of permissions/authorizations/privileges we need not talk about generate_and_execute even for development.
Development
So, for execute_preloaded we should upload the functions and we need not required any privileges/permissions to access it (installed functions).
Production:
As your step by Step procedure suggest, for each and very job that you want it to execute, ABAP code has to be uploaded.
I am confused now. What system do you want to connect to? Development or Prod? Cause your basis team was saying
and not a word about development system. And it would be an interesting statement “We do not provide S_DEVELOP permission in development as you would be able to develop new code then”.
Scenario:-
We are doing PoC (Prrof of Concept )in hightly secured environment.
Objective:-
It has to be a common solution for Data Services user when they want data out of SAP ECC ( compatible version)
Implementation-
Trying to access/Connect to SAP ECC by configuring datastore in Data Services. Got an error msg 1
BOBI : 1112368 Error R/3 Call Recieve error <Function RFC_ABAP_INSTALL_AND_RUN: You donot have authorization for this function. The problem may go away if you change the SAP datastore property to execute in background(batch)>
Then i tried to validate my pre-requisites to connect to SAP including authorization for “Data Services”
Checked with Basis Team for same authorization, which is the concern of this discussion. Their comments are also listed.
With half authorization we tried again …Now got and error
BOBI : 1112368 Error R/3 Call Recieve error <Function RFC_ABAP_INSTALL_AND_RUN: SAP System has status 'not modifiable'.The problem may go away if you change the SAP datastore property to execute in background(batch)>.
Finally, It has conyed from you that we can got Execute_Preload approach which doesnot need any authorization to be given. So concluded because of authorization descripencies, we should go ahead and use Execute_Preload instead of Generate_and_Execute for all three Development, Test, and Production.
I guess, this is something that can make you comfortable.[/b]
Okay. Another option would be to to install the DS provided SAP functions, then the error with the “SAP system cannot be modified” will go away as well.