S_ALR_87012004 return: "No data was selected

[Former Member]

Hi all,

User is getting error No data was selected for tcode S_ALR_87012004

When i execute the report with same inputs i get data.

ST01 Trace shows strange results

13:25:01:928 AUTH - - - S_TCODE RC=0 TCD=S_ALR_87012004;

13:25:02:11 AUTH - - - S_PROGRAM RC=4 P_GROUP=AM45;P_ACTION=VARIANT;

13:25:02:22 AUTH - - - S_PROGRAM RC=4 P_GROUP=AM45;P_ACTION=SUBMIT;

13:25:02:23 AUTH - - - S_PROGRAM RC=4 P_GROUP=AM45;P_ACTION=VARIANT;

But user has authorization to S-program P_GROUP : *

How can this happen???

Please help.

[Bernhard_SAP]

Hi Trupty,

of course you have to check also the values for the field P_ACTION....

Check table usrbf2 then, if that authroization is really in the buffer contained.

If not, start user comparison again.

b.rgds,

Bernhard

[Former Member]

Trupti,

Looks like the user doesn't have Submit for P_action. Please verify.

Thanks,

Naveen

[Former Member]

Hi,

User comparison is already done.

Also user has submit in P_ACTION

I doubt if there is any setting required from functional side for the user so as to view result of the report.

[Bernhard_SAP]

Hi Trupti,

pls make one more test:

assign full auth for A_S_ANLKL, A_S_WERK, A_S_GSBER and A_S_KOSTL to that user.

Does the result change?

(.... I am thinking about [SAP Note 141876|https://service.sap.com/sap/support/notes/141876] )

-->FI-AA-IS does not show auth-checks in ST01 as authorizations are directly used for generating the sql statements....)

b.rgds,

Bernhard

[Former Member]

Hi,

Many of the reporting transactions that deal with Asset Management objects do not throw authorization error and also the trace does not capture the required objects.

It needs some functional guidance as to what the report is about. Rather you can solve this problem through a test and trial method.

This surely is due to one of these objects:

A_M_ANLKL Asset Classes: Asset Classes

A_S_ANLKL Asset Master Data Maint: Company Code/Asset Class

A_S_GSBER Asset Master Data Maintenance: Company Code/Business Area

A_B_ANLKL Asset Postings: Company Code/Asset Class

A_B_BWART Asset Postings: Asset Class/Transaction Type

Please check for the values maintained for these objects in the role. If not add them manually.