How to Include VAT percentage rate in the Invoice Print Output

[Former Member]

Hi All,

I have a question here. My client wants the VAT rate in percentage form to appear in the invoice print output. But, I have no idea where to pull out the vat percentage rate from or which table I should refer to.

Appreaciate all of your inputs.

Thanks a lot!

[Former Member]

Hi,

Goto SE11/SE16/SE16n.

Enter the table name as VBRK.Pass your billing document number.

Execute.

Fetch the value of "KNUMV(Number of the document condition)".

Pass the same into KONV table.

And fetch the value from "KBETR(Rate (condition amount or percentage))" for your condition type.

Get this one into your output program.Do this with the help of your ABAPer.

Regards,

Krishna.

[Former Member]

Hello,

You can fetch the VAT rate either from the Sales order or the Billing document

Getting it from Billing document is more relevant.

First goto the Table VBRK and get the KNUMV field from the vbrk

Then goto KONV table which is the pricing table for conditions and give the input values as the KNUMV and KSCHL

KNUMV is the DOCUMENT CONDITION which is independent for each document

KSCHL is the condition type ( in this case it is your VAT condition type )

You can get the Rate from the the field KBETR.

KBETR is the RATE % of the KSCHL in KONV

Hope it is clear.

Regards,

santosh