Need Tax percentage table for z report ???

[Former Member]

Hi all,

my requirement is as follows

By using this field (BELNR) in the table RBKP please display the field MWSKZ1 this is from the MIRO i have taken the Tax code for example V1, for this i need the percentage.

I have checked the tables T007A where i could not find the field MWSKZ1, is there any other table please help.

Regards,

Raziq

[Former Member]

solved by myself

[Former Member]

The issue have been solved

i have linked Table T007S with field MWSKZ with table RBKP field MWSKZ1. to get the output.

Regards,

Raziq

Edited by: Raziq Fareed on Jun 21, 2011 2:11 PM

[Former Member]

Hi,

You will need to use the following logic.

Get the accounting document number from bkpf (using the awkey field)

Get the condition number from BSET (using the accounting document number,fiscal year,etc)

Get the % from konp by passing the condition number.

It is advisable to use this as if you look for the rates on the tax code they may have changed and may not reflect the percentage in the transaction.

[sanilbhandari]

Check in Table KONV or KONP based on field ALAND for your country

Regards

Sanil

[Former Member]

hi Sanil,

in the both the tables that you have mentioned i could not find the field MWSKZ1, where by means i can link this field to the tax code.

Regards,

Raziq

[Former Member]

Hi,

Please check the table : T007S.

Regards

Aparna

[Former Member]

in table T007S there is no field like MWSKZ1, i could not link the tax code to this table. please suggest

regards,

Raziq