on 11-06-2012 4:42 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
16 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.