Skip to Content
avatar image
Former Member

Purchase Register with VAT or CST

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Dec 27, 2012 at 12:00 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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

  • Dec 27, 2012 at 07:06 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • avatar image
    Former Member
    Dec 27, 2012 at 09:20 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member 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

  • avatar image
    Former Member
    Dec 27, 2012 at 11:18 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded