Skip to Content
avatar image
Former Member

Invoicelist financial data handling table

Dear all,

We are working with a third party software company.

We want our open items to be exported in to the credit system.

The hick up we got is that we have Individual invoices (vf01) and invoicelist invoices (vf21) now we also want the data from the invoicelist number (net total price, number etc etc)

Wich table do we need to extract all financial data from a invoicelist?

Thanks for your help in advance

With kind regards,

Dennis Kristoffers

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Oct 08, 2015 at 10:27 AM

    Net value (NETWR) and tax (MWSBK) are in VBRK table - both for single invoices and for invoice list billing. Factoring discount/tax (if you use them in invoice lists) are in KONV, where VBRK-KNUMV=KONV-KNUMV (you have to check KSCHL to get the values).

    Please check with the business what information exactly you need to extract.

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 08, 2015 at 10:29 AM

    Hi Dennis,

    please check out table VBRL.

    Br

    Michael

    Add comment
    10|10000 characters needed characters exceeded