cancel
Showing results for 
Search instead for 
Did you mean: 

List of standard BI SPM queries link, Please

former_member182467
Participant
0 Kudos

We are implementing SPM in our project and I need to identify the list of SPM standard queries to analyze the data flow. I got the overall dataflow diagram of the BC given ...which has DSO, MP, IC etc......like ...0ASA_DS05 ...etc. But I am unable to find the standard SPM query list to match my requirment as-is list.

Few of the reports in my req are given below : I neither know their technical names nor able to find the list of the SPM queries in the BI Content or SPM analytics home page.

PO Summary by Supplier

PO Summary by Category

Procurement stats report

Spend On and Off Contract

Spend by Panel Contracts

Spend by Supplier

Spend by Buyer

Spend by Category

Spend by GL Account

But some where I have seen that most/all of them were getting extracted on 0ASA_MP01 multi-provider. So the query name's should be somethign like 0ASA_MP01_something. I appreciate if anyone can provide me the technical names of all the standard SPM queries and where can I find the technical fields for those reports. That will be a great help. I appreciate it.

Thanks for your time,

Daniel

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Daniel,

There are couple of BEx queries which you can access as part of SPM Implementation.

Final Query: 0ASA_MP01_Q1002

Detail Query: 0ASA_MP04_Q0001

Spend Variance: 0ASA_MP01_Q1004

Contract Age: 0ASA_MP01_Q2002

Expiring Contract: 0ASA_MP01_Q3003

Please let me know if you require any further information.

Thank you

Best regards,

Amarnath