Excise data flow

Advertisement
Dear Experts,
Please explain me the flow of data in excise scenarios.
when the tables J_1IEXCDTL,J_1IEXCHRD,J_1IGRXREF,J_1PART1
got updated,how to cross check the data  theses table,please explains me.
i am confused how to cross the data,it will be great help to me.
Regards,
Varun
Advertisement

Replay

If you have capture excise during MIGO then you can check it through J_1IGRXREF by entering the Material document (MBLNR) & year (MJAHR)
In J_1IEXCHDR you can get the header detail where DOCNO= J_1IGRXREF-EXNUM & DOCYR =J_1IGRXREF- EXYEAR.
Now lets say a material document can have more than one line item...so to check the excise details of each line item check it through J_1IEXCDTL where DOCNO = J_1IGRXREF-EXNUM & DOCYR =J_1IGRXREF- EXYEAR.
Again the details of the part 1 captured can also be checked through J_1IPART1 where MBLNR = J_1IGRXREF- MBLNR & MJAHR=J_1IGRXREF-MJAHR
Regards,
Indranil