Line level Tax code in PO

[Former Member]

Hi,

In which table can I find the line level tax code mentioned in a PO.

Rgds,

Manju.

[peter_ruiz2]

hi,

EKPO-MWSKZ

regards,

Peter

[Former Member]

Sorry, Guess I need to reframe my question. Field MWSKZ contains the tax value like say P0 for 0% tax, P7 for 7% tax etc.. my question is where can i find the value 0 and 7 for tax codes P0 and P7 respectively.

Thanks,

Manju

[peter_ruiz2]

hi Manju,

you can find the values by doing this.

1. Retrieve the Condition Record Number (KNUMH) from A003 by giving the following values for:

a. Application (KAPPL) = 'TX' for tax

b. Condition Type (KSCHL) = 'MWVS' for input tax

c. Departure Country (ALAND)

d. Tax Code (MWSKZ) = EKPO-MWSKZ

2. Retrieve Condition Amount (KBETR) from KONP passing the Condition Record Number (KNUMH) from A003.

Note: consider the value of Calculation Type (KRECH) if you need to get the actual value.

Divide Condition Amount (KBETR) by 10 for percentage since 10% is represented as 100.00 in KBETR.

regards,

Peter

[Former Member]

Hi manju,

welcome.

it is in both ekko and ekpo.

pls see the below link.

http://help.sap.com/saphelp_nw04/helpdata/en/8d/bc383fe58d5900e10000000a114084/content.htm

thanks

nagendra.

[Former Member]

hi,

the table name is ekpo and the field is mwskz

[Former Member]

Hi,

you can find that in table T007A.

Thanks

kannu.