Printing of tax amounts in PO Smart Form

[Former Member]

Hi all,

I want to print the tax condition amounts calculated by a tax code for each line item in Purchase Order smart form. From which tables and fields can I get the data.

thanks in advance.

[Former Member · Accepted solution]

I am using taxware and my question is when i make a purchase of raw materials for production, I believe I have to use the material taxability indicator in MM03 and type of tax code (accounts payable sales tax or self assessment use tax) to calculate the use tax that would have to be paid to the govt. Now in the taxware report 030, this is actually showing up as sales tax type (S) for a purchase invoice (I1, accounts payable sales tax selected ), even though use taxes (U) should have been displayed.

What should I do so that the purchases don't show up in the TAX030 report. I believe that is showing because of calculating use taxes payable which is why its showing. Any suggestions, please.

[Former Member]

I am using taxware and my question is when i make a purchase of raw materials for production, I believe I have to use the material taxability indicator in MM03 and type of tax code (accounts payable sales tax or self assessment use tax) to calculate the use tax that would have to be paid to the govt. Now in the taxware report 030, this is actually showing up as sales tax type (S) for a purchase invoice (I1, accounts payable sales tax selected ), even though use taxes (U) should have been displayed.

What should I do so that the purchases don't show up in the TAX030 report. I believe that is showing because of calculating use taxes payable which is why its showing. Any suggestions, please.

[Former Member]

Hi,

In table: EKKO, field - KNUMV (Doc Condition), input the doc number in table - KONV in field KNUMV(Doc Condition). Here you get all the conditions values for that purchase order.

Hope this helps.

Thanks,

Viswanath

[Former Member]

Hi Viswanath,

Thank u very much for ur useful suggestion. I checked in KOMV table, but it is showing only the pricing conditions. NAVS condition is there, but it only gives non-deductible condition amount. But I need all the tax condition amounts to be printed seperately calculated by a tax code like Service Tax, Excise Duty, CST, LST, VAT etc., and not as a lumpsum of NAVS. Is there any other table to get the tax condition amounts.

[Former Member]

Hi,

Check table: KONP, application will be 'TX'. You have to use condition record number.

Hope this helps.

Thanks,

Viswanath

[Former Member]

Hi Viswa,

I checked in KONP table but it only contains the tax code details like condition types, condition rates. But what I need is say if a tax code "X1" contains two condition types Excise Duty and Ed. Cess and the rates are 16% and 2% respectively. This information is stored in KONP table as a condition record. I use this tax code "X1" in my purchase order line item, suppose the base value of the item is Rs.1000/-, it calculates Excise duty @16% and Ed.Cess@2% and the condition value comes to Rs.160/- and Rs.3.20 respectively. From which table I can get these values of Rs.160/- and Rs.3.20. KONP table doesn't have these values. I want to print these two values on PO smart form.

Please give me some solution.

[Former Member]

Hi Mallikarjun,

System is not storing the values as you said for condition types in any table, you have to take into consideration the base value and then the BED and edu. cess has to be calculated depending on the percentage. This has to be taken care in the ABAP code in the smart form.

Hope this clarifies.

Thanks,

Viswanath