Linking project numbers to Invoices ... guidance needed!

[Former Member]

Hi SCN,

My end goal is to gather a data dump of all invoices for 2014 with associated project numbers where applicable...

My understanding is there should be a way in ECC to export a file that has all invoices for 2014 as well as what project number the inovice was related to (if it was related to one) along with 'normal' invoice fields (posting date, clearing date, amount, line items etc.) ...

Can anyone help walk me through this process?

Thanks,

Cory R.

P.S. I am super new to SAP so any/all help is greatly appreciated

[Former Member]

Sumti,

Thanks for pointing me in the right direction... appreciate the help!

[Former Member]

Dear Cory,

Please check if the project number is being captured in the field WBS element. If yes, you can simply take a download of particular GL with WBS element in FBL3N.

Regards,

Sumti Bhadani

[Former Member]

Dear Cory,

Can you check in VF03 i.e billing document or FB03 i.e accounting document, where the project details are captured. Based on the filed we can do table extraction in SE16N and export the data. Please share the screenshot of the field which you are expecting.

Regards,

Sumti Bhadani