We have below requirement in which we are facing authorization issue.
We have a report which is called within a RFC in R/3 system using SUBMIT statement. This RFC in turn will be called by a report from BI system. I have created a authorization group with application as 'M' in 'TPGP' table which i assigned to the report in R/3 system. Similarly i have assigned one authorization group to the report in BI system.
The report from BI system will provide inputs to the RFC in R/3 system that will update a transparent table. And the report which is being called in the RFC will make use of the transparent table data and triggers a mail with excel attachment.
Eg:
In R/3 System
{
RFC1
Submit ReportR3.
}
In BI system
{
ReportBI.
call function "RFC1" destination R/3.
}
Now when i try to execute the report in BI system it is going dump saying "SUBMIT authorization Authorization name required for program program name". What could be the permanent solution for this ?
I tried removing the authorization group from the report in R/3 system. Then the error is not coming and the report is executed successfully. But to release the TP the authorization group is must.
Please provide your inputs.