Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Data Archiving

Former Member
0 Likes
1,101

Hi Everybody,

I am new to data archiving, and I have problem understanding the following :

1. If we are doing archiving, and the archived files are not moved to external storage device and still in file system, with new indexs etc, the second purpose of archiving i.e reducing disk place doesnt full fill...can you please through some light on the topic.

2. Now that I have archived data in archive file system, and online data in Database, why am i loading the data into info structures at the time of deletion, and will the data in the infostructure too deleted or is it going to be saved in database...if so disk space is wasted....

3. Does infostructures are used to read only specific fields from archive files.....archive file has 10 fields and i wanted to view only 4 data fields, will I be creating info structure with 4 data fields, and if i need 8 fields , than new info structure with 8 data fields etc.....

I am sorry, I am new to Archiving and I am trying to analyse on my own, so having difficulty in understanding....

Your help would be highly appreciated.

Thanks in advance

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
1,049

Hello Syed,

Welcome to data archiving :-). I will try and help answer your questions.

1) even though the archive files are in the file system, you are saving database space as the archived data was written out in a compressed format. The delete jobs freed up space in the tables. You may not "see" the space savings until a database reorg is done.

2) filling the archive information structures is necessary if you want to be able to view the archived data. The info structures are new tables that will take up space in the database, but they are much smaller than what was archived so there is still space savings gained.

3) I would recommend customizing your archive information structures to only use the fields that you need to search on. That will reduce how big these tables get.

I hope this helps.

Best Regards,

Karin Tillotson

8 REPLIES 8
Read only

andreas_mann3
Active Contributor
0 Likes
1,049

you can use a 3d party sw like <a href="http://www.pbs-software.com/Deutschland.262.0.html?&L=1">PBS</a>

A.

Read only

Former Member
0 Likes
1,049

Hi,

Please go through the belo web link if you are new to data archiving:

[Data Archiving|http://help.sap.com/saphelp_40b/helpdata/en/8d/3e4ea8462a11d189000000e8323d3a/frameset.htm]

All the best ..

Thanks,

Shamim

Read only

0 Likes
1,049

Hi...

I found the links before, and it was beyond my understanding...I would appreciate if some one can expalin in simple scenario based format, about infostructure...fieldcatlog etc

Read only

Former Member
0 Likes
1,049

Hi

Go through the link given below :

http://help.sap.com/saphelp_nw04/helpdata/en/8d/3e4bb1462a11d189000000e8323d3a/frameset.htm

With Regards

Nikunj Shah

Read only

Former Member
0 Likes
1,050

Hello Syed,

Welcome to data archiving :-). I will try and help answer your questions.

1) even though the archive files are in the file system, you are saving database space as the archived data was written out in a compressed format. The delete jobs freed up space in the tables. You may not "see" the space savings until a database reorg is done.

2) filling the archive information structures is necessary if you want to be able to view the archived data. The info structures are new tables that will take up space in the database, but they are much smaller than what was archived so there is still space savings gained.

3) I would recommend customizing your archive information structures to only use the fields that you need to search on. That will reduce how big these tables get.

I hope this helps.

Best Regards,

Karin Tillotson

Read only

Former Member
0 Likes
1,049

Hi Syed.

I would like to suggest a few references,

[SDN - Standard Reference - Introduction to SAP Data Archiving|https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/6c2af1f6-0a01-0010-7cb5-a554afb0f03c]

[SDN - Standard Reference - PDF - Higher Performance with Data Archiving|https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/f872e090-0201-0010-48bd-c4379c98b24b]

[SDN - Standard Reference - PDF - Data Archiving in SAP Business Warehouse|https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/115b9d90-0201-0010-0f82-f4db82e82b59]

[SDN - Standard Reference for DATA ARCHIVING - FAQs|https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/d76f5301-0b01-0010-2a97-9938052ddf81]

[SDN - Standard Reference - PDF - Data Archiving Improves Performance - Myth or Reality?|https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/d0b0de48-0701-0010-fcb1-fb99d43920e3]

[SDN - Standard Reference - PDF - Data Archiving - The Fastest Access to Your business Data|https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/fd4dfe82-0c01-0010-f6a3-f16ff2987596]

Hope that's usefull.

Good Luck & Regards.

Harsh Dave

Read only

Former Member
0 Likes
1,049

Dear Archivers,

In my assignment The following Objects are Identified for Archiving 1. FI_DOCUMNT 2. MM_EBAN 3. MM_EKKO 4. MM_INVBEL.

But I have constriaint that I need to restrict archiving of documents pertaining to Particular Vendors. But I do not have list of vendors with me, instead I was provided with list of cost centers.

Now I need to Restrict FI Documents, Purchasing Docs, Invoice documents belonging to these cost centers. Please tell me how to elate the cost centers & above mentioned documents.

The Selection Screen Parameters for the Objects:

1. FI_DOCUMNT : GL Accounts / Dcoument #

2. MM_EBAN : PR#

3. MM_EKKO : Purchasing Doc #

4. MM_INVBEL : Invoicing Doc #.

It would be really helpful If I could some light on this.

Regards,

Murali Mani