VAT/TAX AMOUNT table name

[Former Member]

Hi friends,

Pls post me the table names which have Tax Amount details of GR doc(not PO based) which all met in invoice. (MIRO)...

Note:the konv/konp are PO based tables....which i dont need for my report and rbkp is the header one which i can't display the amount for material wise reports.

Pls advise.

thanks & regards

sankar.

Edited by: sankar babu on Mar 25, 2008 6:09 AM

[Former Member]

hi,

Check in RSEG table.

awrd points if useful

Bhupal

[Former Member]

Hi

After MIRO you will get an BELNR

Get its corresponding AWKEY from BKPF

Now for that AWKEY get the Document Number

After this go to BSET get the HWSTE or HWBAS with respect to the KSCHL types like JIP1 or JIP2 or even the Excise Details

K.NadeshKumar

[Former Member]

HI,

tax code table is A003.

MWSKZ is the tax code field.

select KNUMH (Condition number) from A003 (taxe code table) with the key fields ALAND and MWSKZ.

to get tax percentage select KBETR (tax percentage) from KONP with key KNUMH (Condition number)that you have retrived in the previous step.

please reward points if helpfull.