Data Archiving in CIN
Hello All 🙂 ,
Data Archiving means deleting huge data which is stored in database which is no longer required for Business.
Why Archiving Required?
Reasons for archiving is performance problem caused by large volumes of data which is not manageable for long term ,Cost Cutting for Data storage, System Performance Improvement Required.
Archiving in CIN DATA.
When it Comes to Data Archiving of CIN we must archive standard tables which are related to Country India versions( Like if take Goods Receipt Document which has Excise Details (MM_MATBEL Arch.Obj for Material Doc)) If Standard Tables are not archived data inconsistency will happen in system.
Below are archiving objects in CIN
1.J_1I_EXDC :- This Object will archive all Excise document data and transaction data relevant to the Excise documents.
2.J_1I_P1GRX :-Part1 registers and corresponding entries from J_1IGRXREF Table.
3.J_1I_RG23D :- RG23D register for the depot.
4.J_1I_RG1 :- Object for the finished goods RG1.
5.J_1I_EXBL :- Archiving object for the Extract and Balance tables.
In AOBJ T code you can check the above details, Below Is screenshot of J_1I_EXDC Object.
➕ You Can Check which are the tables archived in particular Object. Eg J_1I_P1GRX Object related tables J_1IPART1,J_1IGRXREF.
❗ When your Archiving Objects a particular Sequence is followed we cannot Archive directly Eg J_1IEXBL which is Excise Balances. Below Sequence is followed
4.J_1I_RG23D( For Depot)
Archiving the Data Standard procedure is used 1.Writing the data into the info catalogs.2.Deleting the data from the active database.(SARA)
If you have query/question/objection about this Blog then please write back to me.