SQ01 - table query - invoices by vendor with tax

[Former Member]

Hi guys,

Apologies if this is too basic though am new to SQ01 and whilst grasp the general concept struggle to find tables that I need.

I'm looking to report on vendor invoices for a given period, ideally showing gross and net invoice ammount.

What tables do I need to link?

Also will I be able to get the two ammounts or will it be simpler to grab the gross ammount and the tax code? and then play with in excel

Any help much appreciated as usual, many thanks

[raymond_giuseppi]

Take a look at [SAP Tables -> MM|http://www.erpgenie.com/abap/tables_mm.htm]

Take also a look at logical database on purchasing. (call transaction SE36 and search database using table EKPO, EKKO)

Regards