07-02-2008 12:10 PM
I am trying to run S_ALR_87011990 with a report This report is the ASSET HISTORY SHEET. When I run it, it gives me an error saying " No Data was selected" when i running same with SAP_ALL authorization its working fine. I have check with SU53... its showing The last authorization was successful.Could someone please explain to me what thi means, or how I cam make this report run?
Regards
Anil
07-02-2008 12:14 PM
The auth checks in many S_ALR_* reports are in logical databases and won't be reported via SU53.
Use ST01 to run an auth trace to pick up what is checked when you run the report with an ID with wide access
07-02-2008 12:14 PM
The auth checks in many S_ALR_* reports are in logical databases and won't be reported via SU53.
Use ST01 to run an auth trace to pick up what is checked when you run the report with an ID with wide access
07-02-2008 12:35 PM
Hi Alex,
FI-AA (and some others) use performance optimized coding. So the verification for authorizations will not even be visible in ST01.
Based on the available authorizations the system creates appropriate SQL-statemtents.
So there are no authority-checks (as we know them) executed, but only SQL-selects.
For further information pls refer to [SAP Note 141876|https://service.sap.com/sap/support/notes/141876] .
So the applicaiton/authorization admin has to know, which objects are necessary and assign them. analizing missing auths. is nearly impossible (or you analyze the SQL-trace for missing selects)...
So as per the a.m. note for FI-AA the following objects are relevant:
A_S_ANLKL, A_S_WERK, A_S_GSBER und A_S_KOSTL
b.rgds,
Bernhard
07-03-2008 8:26 AM
07-03-2008 10:34 AM
Hi Bernhard,
Thanks for clarifying that. I remember when the S_ALR reports were first delivered, we spent weeks tracing or going through the LDB code to pick up the checks prior to the various OSS updates to SU24. Obviously not the Assets ones!
Cheers
Alex
07-02-2008 12:15 PM
Hi
Put ST01 trace on and then execute report.
After you get no data was selected, check the trace
hope this helps
10-09-2014 11:53 AM