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

[Former Member]

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..

[Former Member]

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

[Former Member]

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.

[p604431]

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.