tax code from billing

[Former Member]

Hai gurus,

I am making a report from account assignment group of customer and material to fetch the vat/cst amount.

Here i want the user to enter tax code since iam using tax inj procedure

can any one suggest me a field name for tac code from billing.

i tried with VBRP and VBRK tables. MSKWZ is there but it is not showing the tax codes which i meant to see is there any other field

With regards

'

[Lakshmipathi]

Dear Saju

As I mentioned above, you can see the field MWSK1 in tables KONV, BSAD, BSID, BSAK, BSIK & BSEG. If you want to generate a report with the combination of billing document and tax code, you can table join in SQVI with VBRP and any of these tables listed.

thanks

G. Lakshmipathi

[Lakshmipathi]

Dear Saju Som

The tax code flowing in billing is from KOMV (Field MWSK1) which is a structure and not a table but you can see in table KONV. You can also see this field in tables BSAD, BSID, BSAK, BSIK & BSEG

thanks

G. Lakshmipathi

[Former Member]

Hai gurus

we have checked as per the reply and found out in VBRP with respect to the billing document(MWSK1) is not reflecting and it is showing blank. How can i fetch it?

With regards

[Former Member]

Hi,

Pass VBRK-VBELN (Billing no) and fetch VBRK-KNUMV(Doc Condition).

Pass VBRK-KNUMV into KONV-KNUMV and fetch KONV-MWSK1(Tax Code)

You will get item wise tax codes maintained for each condition say foreg UTXJ

Regards

Nimit

[Former Member]

hi,

Go to VBRK - take KNUMV and goto KONV - enter this number and KSCHL = 'UTXJ' and find ur tax code in MWSK1.

hope ur problem will be solved.

saravanan