on 07-06-2011 6:52 AM
Hi,
Our company wanna to use SPM to realize AP reporting requirement? Is it possbile?
The AP reporting requirement contains these fields:
company code--from invoice data
cost center---from invoice data
GL account----from invoice data
PO number----from invoice data
vendor---from invoice data
Invoice number-----from invoice data
invoice amount-----from invoice data
invoice paid amount----from AP data
payment term -
from AP data
invoice status----from GL data
invoice date------from invoice data
invoice paid date-----from AP data
So basiclly, the datasource cover AP and invoice. I wanna to know can SPM realize this requirement? There are some questions related:
Will SPM data management tool just use some specific standard datasources? For example, 2LIS_06 for invoices, 2LIS_02 for purchase ordersu2026Per SPM documents I found on web, no AP SPM BI content mentioned. Can 0FI_AP_4 datasource be used by SPM?
Shall we use customized DSO in SPM? Not standard ones---0ASA_DSXX
Can datasource be enhanced in SPM?
Thanks,
Jack
Hi Jack,
Looking at your requirement we cover the Invoice portion of your requirement and lot more. SPM has its own set of extractors that we used to pull data from ERP, we do not use any standard BW datasource. But if you are already pulling all the requirement information [Invoice, AP] using the standard BW datasource you can load that data into the SPM data model [it will be your responsibility to map the necessary fields and load].
As part of the standard SPM extractors and data model we do not have AP data, so you can either build a new set of objects [DSO and Cube] or reuse 0FI* objects to hold this data and add the necessary fields to the final SPM multiprovider in the reporting area.
SPM application has functionality where you can introduce new data model [like mentioned above] and expose additional content in the SPM UI based on your needs. You can also modify the SPM extractors to bring in additional information such as AP or any other master data that is necessary.
Hope this answers your question.
Regards,
Rohit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
6 | |
5 | |
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.