Skip to Content
Author's profile photo Former Member

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?

icon_EraseData.jpg

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.

/wp-content/uploads/2014/01/132456_361481.jpg

➕ 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


1.J_1I_EXDC

2.J_1I_RG1

3.J_1I_P1GRX

4.J_1I_RG23D( For Depot)

5.J_1IEXBL


Archiving the Data Standard procedure is used 1.Writing the data into the info catalogs.2.Deleting the data from the active database.(SARA)

SAP Notes:-

850902 – Data Archiving of CIN related data


If you have query/question/objection about this Blog then please write back to me.

Regards

Shiva


Assigned Tags

      3 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Very basic document, all the information is available in help.sap.

      Try to mention some more information like process of CIN Archiving, pre requisites..etc.

      you could have mentioned list of SAP notes related for CIN Archiving too.

      Eg: 850902 - Data Archiving of CIN related data

      Author's profile photo ßhģ Ġǿwdâ
      ßhģ Ġǿwdâ

      Basic but use-full info Shiva

      Author's profile photo Santanu Samantroy
      Santanu Samantroy

      Hi Shiva,

      Thank You for your info.

      Do you have list of standard Archiv Enabled Reports for CIN  Data.

      with Regards,

      Santanu