FV11 condition record details from Table

[Former Member]

Hi,

Could any one suggest the table name or t code to get the details abt the FV11 cond records values?? i.e i have maintained the Excise rates for JMOP (BED ) with material/vendor/plant and tax code combination... i need to extract this info what are maintained for a particular plant??? how to get it??

[former_member229982]

In KONP table pass JMOP in the field Condition type (KSCHL) to get the tax rates maintained in the Rate (KBETR) field.

[Former Member]

.

[Former Member]

Condition record can be seen from KONP

[Former Member]

for which condition table have u maintained condition records..

i mean have u maintained for plant/material

plant/material/vendor

tax code.

[Former Member]

goto M/03

check the condition table code...

for tax code if it is 969.. then table will be A969... u should add A for the condition table no

then goto se11 and see in the table A969...

[Former Member]

I have maintained my ex rates in FV11 for BED- JMOP cond type with mat/vendor / plant and tax code combination... ok.. here my req is to get all the ex rates which are maintained for JMOP ?? how to get it

Edited by: Jayakumar Raju A.S on Dec 22, 2009 9:36 AM

[Former Member]

just go through below logic

insert ekpo-mwskz to a969(table)

get a condition types records

loop of that internal table and

from konp take a single value for BED according to JMOP

CONDITION TYPE(kschl)

REPEAT THE PROCESS FOR SEC, HSC AND VAT/CST.

YOU ALSO GET PERCENTAGE FOR EACH CONDITION TYPE

BY KONP-KBETR / 10.