Reporting Vendor Spend in core R/3
The answer may be simple, but I wanted to ensure that I have covered all points. We would like to do the following in core R/3 (with ABAP work) and w/o use of a data warehouse... and would like recommendations:
Some of the stipulations are:
- remove any non-MM vendors from the report (unfortunately they are using only one vendor account group for both partnered and non-partnered vendors)
- some POs are blanket POs, so the amount committed and the amount actually paid to the suppliers are two different things
Are there any core reports, within MM or within LIS that does this type of analysis, or would this be custom work?
Any input would be appreciated.
Sorry, I meant to say "without ABAP work"
Hi,
Since this is supposed to be the total spend report where spending data shall be collected from IR document which are then linked with purchasing document information, I would not think that we have had such a standard reporting tool in SAP. Of course, for a particular requirement such as list of PO being awarded to the vendors, then it is possible that you can get such standard reports available in SAP. Nevertheless, the point is that you have to run several reports and manually process/manipulate them in an effort to achieve the required result. As the result of it, only ABAP program can help.
Anyhow, if you can get back to us with your more detailed reporting requirement (report layout, for instance), then perhaps, we can recommend you of selecting the most appropriate one.
Cheers,
HT