Vendor wise/Invoice wise consumption for each WBS element

[Former Member]

Any standard report from SAP, which provide details of Vendor Purchase order / Contract, details of SES with WBS no. and details of Vendor invoice in columnar form.

SAP system can not generate standard reports giving vendor wise/Invoice wise consumption for each WBS element of particular asset.

Please help me to get this report.

Thanks in Advance.

[ajaycwa1981]

Hi

You can download reports like FBL3N / FAGLL03 and Table EKBE for PO history AND CJI3 and do a VLOOKUP in excel

Else, you can also develop abap report to avoid manual work

br, Ajay M

[Former Member]

Dear Ajay,

Thanks for your prompt reply. I tried FBL3N tcode and change the layout for puchasing document. I am not getting purchasing document and vendor in this report. So how to vlookup the field.

I need to generate report giving vendor wise/Invoice wise consumption for each WBS element of particular asset.

Thanks in advance.

[ajaycwa1981]

Hi

Your starting point should be CJI3 report or any PS report... Here you get the FI Doc no

If this FI Doc No is generated from MM, check the Header segment of the document.. It would have MM Doc NO + Fisc Yr populated in the ref key... This gives you the link between FI & MM

From here on, you can take it forward... You can look up this doc no in MSEG Table and find the PO no... Then go to EKBE table for other PO details....

br, Ajay M