Purchase Register with VAT or CST

[Former Member]

Dear Experts,

I'm new to CIN concept and I don't know much about the scencarios but now my client requirement is to have a purchase register for 'Excise duty + Vat or CST'.

Some how I've managed to find excise duties in table J_1IEXCDTL but how do I find VAT or CST for the same, please help me to achieve this since it is very critical.

Thanks & Regards,

Triplen

[Former Member · Accepted solution]

Hi Narayana,

VAT and CST value is in Tax procedure. You will never find it's value in KON* tables.

Only pricing condition types are stored in KONV table.

You may refer the below process:

a) If you want the VAT/ CST value after PO is placed and before MIRO is posted, the use FM :CALCULATE_TAX_FROM_NET_AMOUNT for calculating the same.

b)  If you want actual values of VAT/ CST posted at the time of MIRO,then you can list out the same via standard report J1I2 .

There are some input selections for the report. But, the main input criteria in your case is the VAT/ CST condition type under the heading "GENERAL SELECTIONS".

The output of this report may be cross-referenced with table BSET.

You can differentiate whether PO has VAT or CST based on your condition types in tax procedure for VAT and CST or tax codes used in PO for VAT or CST.

[Former Member · Accepted solution]

Dear Shobhit,

Thanks for your reply. I was looking for the VAT/CST amount after the MIRO and as you have mentioned that I've got the value in BSET tabel.

Thanks & Regards,

Triplen

[Former Member]

Have you tried my logic. We can pull all the taxes and values forvat and cst using this . Seat with abaper and look into the tables. This will help you definitely.In th epast I pulled cst and vat using same.

[Former Member]

Hi Narayana,

Pls find below logic for puling various values for purchase registers.

take PO number from EKKO and for PO no ,from EKKO-KNUMVConnect to (KONV-KWERT)  for various conditions such as JOFP,JINS,JLDC,JCDB,JEDB,JSDB,JCFA,JFR1,JFR2,P&F1,P&F2,P&F3,FRC1,FRB1,JOCM,PFP1,PFP2,JFR1

This convers most of the duties such as CST and VAT along with most of delivery cost conditions.

[Former Member]

Hi,

For finding Vat and Cst Values.Check in FV12 in which combination u are maintaining the taxes(Ex : Material/Vendor/plant), Go to that combination and find the table (By using F1 key). U will get list of taxes for that tax code with condition type .

Non deductible tax : Tax amount will add to the material cost (Inventory).

Deductible: Tax amount will not add to the material cost (Inventory).

Regards,

Narendra

[Former Member]

Dear Shiva,

My actual problem is I'll get the tax value in KONV table but I need to know the exact value for VAT or CST, since it contains all the tax amount.

Since I can get the Excise duty through table I just need VAT /  CST amount, so one of my colleague advised me to use FM: CALCULATE_TAX_FROM_NET_AMOUNT for calculating VAT amount and FM: CALCULATE_TAX_FROM_GROSSAMOUNT for calculating CST amout. Now my question is how do I differentiate whether PO has VAT or CST.

Please help me ASAP.

Thanks & Regards,

Triplen

[Former Member]

Dear Narendra,

Thanks for your reply but sorry I couldn't able to follow u. Kindly let me know if you have solution for the below problem.

My actual problem is I'll get the tax value in KONV table but I need to know the exact value for VAT or CST, since it contains all the tax amount.

Since I can get the Excise duty through table I just need VAT /  CST amount, so one of my colleague advised me to use FM: CALCULATE_TAX_FROM_NET_AMOUNT for calculating VAT amount and FM: CALCULATE_TAX_FROM_GROSSAMOUNT for calculating CST amout. Now my question is how do I differentiate whether PO has VAT or CST.

Please help me ASAP.

Thanks & Regards,

Triplen

[Former Member]

Hi,

1.Gross price of the material = Price * quantity.

2.Excise will calculate on Gross price (1) , we can get excise values based on material document in table J_1IEXCHDR (Header level ),J_1IEXCDTL (item level).

3.Vat/Cst will calculate on 1+2 . Vat/Cst percentage u will get in KONP table.Vat / Cst value will not store in any standard table.

Ex : Gross price = 10000

        Excise       =   1236 (12.36%)

        _________________________

                            =11236

        Vat / Cst       =   224.72 (2%)

____________________________

Total amount       =11460.72

Cst is non - deductible it will add to the stock account = 10224.72 (Accounting document will create for 10224.72).

Vat is deductible it will add to the stock account = 10000. ( Accounting document will create for 10000).

u can differentiate between VAT and CST by using the condition record ,tax code.

Regards,

Narendra

[Former Member]

Since you are giving all the tax codes you need to ask your abaper to write an function module based on countries.

These are not visible in KONV/KONP Tables normally.

Thanks,

Shiva

[Former Member]

Dear Shiva Thanks for your reply,

My problem is in KONV table i'll get the total value (Excise Duty + VAT/CST) of the tax amount which will not tell that whether it includes VAT or CST.

I can find the excise duty amount in table J_1IEXCDTL but how do I get the VAT / CST amount?

Please help me to fulfil the requirement.

Thanks & Regards,

triplen