Spend Analysis Query

[Former Member]

Hello Team,

We have done with the SPM Installations & Configuration with the client BI system. The following Queries buit on the Multiprovider 0ASA_MP01 is not running in BEx(Opens with error) and RSRT.

0ASA_MP01_Q1002 Spend Analysis Final

0ASA_MP01_Q0002 Contract Age

0ASA_MP01_Q0003 Expiring Contracts

When executing the quereis the Varaible screen appears, then screen proceed to program error. I tried checking with and without variables while executing the queries.

The error messages are as follows,

For Spend Analysis Final

I>> Row: 82 Inc: LRRMSU13 Prog: SAPLRRMS

ASystem error in program SAPLRRI2 and form CUDIM_FUELLEN_GEN-03- (see long

For Contract Age

I>> Row: 82 Inc: LRRMSU13 Prog: SAPLRRMS

ASystem error in program CL_RSR_RRK0_ATTR_C and form CREATE_PARTITION-01-

ASystem error in program SAPLRRK0 and form INITIALIZE_DATA_ACCESS-01- (see

For Expiring Contracts

I>> Row: 82 Inc: LRRMSU13 Prog: SAPLRRMS

ASystem error in program CL_RSR_RRK0_ATTR_C and form CREATE_PARTITION-01-

ASystem error in program SAPLRRK0 and form INITIALIZE_DATA_ACCESS-01- (see

The Other SPM standard queries built on 0ASA_MP04 & 0ASA_C13 are running fine.

Please guide me to sort this issue.

Thanks..

Santhosh Kumar N

[Former Member · Accepted solution]

Hi Santosh

Yes, it is critical to get all the Spend related queries in an excutable state before you are able to launch the application.

This seems to be some issue on the BW side, pls have your BW Basis administrator check it out. Maybe your BW server is not properly patched.

I did a quick search on the term "CREATE_PARTITION-01" AND "CL_RSR_RRK0_ATTR_C " in Svc Market Place and foudn these three BW notes: 1489975, 1340340, 1412925. Pls see if they apply. Also feel free to do additional note searches for yourself.

Once the BW issues are resolved the SPM queries shoudl work.

Do write back and confirm what helped fix the problem.

Regards

Rajesh

[Former Member · Accepted solution]

Hi Rajesh,

Apologies for the delay.

The issue has got resolved after installing the support package as mentioned in the note.

Thank you very much for your valuable guidance. please find below the current system details

SAP_ABA 701 0008 SAPKA70108

SAP_BASIS 701 0008 SAPKB70108

PI_BASIS 701 0008 SAPK-70108INPIBASIS

ST-PI 2008_1_700 0003 SAPKITLRD3

SAP_BW 701 0008 SAPKW70108

ANAXSA 210 0005 SAPK-21005INANAXSA

BI_CONT 704 0009 SAPK-70409INBICONT

OPMFND 210 0005 SAPK-21005INOPMFND

ST-A/PI 01M_BCO700 0001 SAPKITAB7F

Regards

Santhosh Kumar N