Skip to Content
avatar image
Former Member

which table is used in er1 cenvat credit taken and utilized report?

hii guru

i have want to know about where is store the value of opening balance's ecs value in details of cenvat credit taken and utilized report of er1?

give me briefly description of er1 cenvet credit updation cycle..

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Apr 12, 2010 at 09:01 PM

    Run ST05, it should help you trace the table name.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 13, 2010 at 04:55 AM

    Hi,

    You can use an SQL Trace ( Tcode : ST05 ) to get a trace of all the Database Tables that were accessed during a transaction execution. You will get a lot of Database Tables, but you can filter out the SAP System Tables from the Application tables from the Name space.

    Have a look at the following link for a complete details on the SQL Trace and the Way you can further analyze it for the proper extraction of the application tables [SQL Trace|http://help.sap.com/saphelp_47x200/helpdata/en/d1/801f89454211d189710000e8322d00/frameset.htm]

    Hope this helps.

    Thanks,

    Samantak.

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 13, 2010 at 05:20 AM

    Hi,

    Check these tables j_1iexchdr (header data) & j_1iexcdtl (item data) for excise tax details. Apart this you have standard t.code for ER1 report j2ier1.

    Add comment
    10|10000 characters needed characters exceeded