cancel
Showing results for 
Search instead for 
Did you mean: 

Tables to find out Vendor Invoices without refrence to a PO

Former Member
0 Kudos

Hi All,

I need to extract all the invoices for a time period which have been raised without refrence to PO and with refrence to a GL account.

If possible I need to get a table from where I can get all these invoices which have been raised with refrence to a GL by giving certain selection parameters.

Awaiting an early reply

Pratiksha

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

HI

You can find out the vendor invoices with the tables BSIK (Vendor Open items and BSAK(Vendor cleaed items)..with the document type..

If you want the vendor invoices without PO then you have to extract all the vendor invoices open items and cleared items from the above table and give the same document numbers in the table BSEG by mentioning with the not equal to option in the Purchasing Doc field with the blank details.

Try the above solution and let me know if you have any queries...

Thanks

Answers (3)

Answers (3)

Former Member
0 Kudos

This message was moderated.

Former Member
0 Kudos

HI

You can join the two tables with the T.code "Sq01"

Thanks

Former Member
0 Kudos

Hi,

Usually when invoice posting take place without reference to PO document , invoice document type is KR.

from t.code FB03 or table BKPF, BSEG details could be extracted.

regards,

Neha Duseja

Former Member
0 Kudos

Thnaks Neha,

But the point is in our case even if it is a Invoice without PO, the document Types is RE.

So there is no way I can differntiate these items from Vendor Invoices with PO as both will be stored in BSIK, BSEG tables on the basis of document types.

Regards

Pratiksha

Former Member
0 Kudos

Hi,

Table RBKP and RSEG are the tables which stores the MMFI incvoice details.

If the required details are not avialable in the above that you can go for BSAK, BSIK and BSEG tables.

Regards,

Narasimha Rao