Skip to Content
avatar image
Former Member

Tables to find out Vendor Invoices without refrence to a PO

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Dec 22, 2009 at 07:24 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 22, 2009 at 06:58 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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

  • avatar image
    Former Member
    Dec 22, 2009 at 07:45 AM

    HI

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

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 22, 2009 at 09:27 AM

    This message was moderated.

    Add comment
    10|10000 characters needed characters exceeded