How Taxcode is linked to VBRK/VBRP/KNA1

[Former Member]

Hi Experts,

My existing report was developed from tables VBRK,VBRP,KNA1 but my client need to have sales taxcode(MWSKZ) in the report. I checked in VBRP but there MWSKZ was not populated for any record.

Please let me know how to merge sales tax code field with these tables.

Thanks&Regards,

narasimha.

[jignesh_mehta3 · Accepted solution]

Hello Narasimha,

Tax Codes are available in KONV (Conditions) Table.

From VBRK take Doc. condition (KNUMV)

Insert this VBRK - Doc. Condition into KONV - Doc. condition & Execute.

You will see Line item wise details of Condition Types, Amount, Tax Code & other details.

Hope this helps...

THanks,

Jignesh Mehta

[Former Member]

Hi

You can get the tax code from KONP table for any tax conditions.

Goto SE16N

From VBRK table get the values of VBRK-KNUMV and now pass this value in to table KONP into the field KONP-KNUMV

and specify the condition type for which you want to get the Tax code in the field KONP-KSCHL and execute you cab get the tax code from the field KONP-MWSK1

regards

Prashanth