need to generate a report

[Former Member]

Hi SAP Experts,

We need a report which can identify

invoices that were paid against specific purchase orders. This

report must include the following fields:

Purchasing document number

Vendor account

Vendor name

PO Item

Invoice reference of the purchase order

Invoice value

Document number

Invoice amount

Withholding tax

Payment method

Clearing document

Clearing date

Year

Net clearing amount

Check number

I am planning to make a SQVI report but i am not sure in which table i can find this fields. could any one please provide me the information. It would be very helpful.

Warm Regards

Leoni

[Former Member]

HI

EKBE MSEG EKKO EKPO in this table we can get all Po realted data,

but inovice amout, wihtholding tax , clearing document, date it will store in another table, like bseg, bkpf

regards

lakshmi

[Former Member]

HI,

keep the cusor on particulat field and press F1 and then go to Technical information there you can find the field name and table name.