Skip to Content


This document explains  the steps on how to create a DAP in sap bw, more information on what is archiving is covered in my archiving blog

How to create data archiving process based on ADK method

Step 1 : Go to transaction RSA1 and right click on the info provider you want to archive and select “Create Data Archiving Process”

step 1.png

Step 2 : In the ‘General Settings’ tab, check the box ‘ADK-Based Archiving’. System will assign the archiving object name for the infoprovider.

STEP 2.png

STEP 3 : In the ‘Selection Profile’ tab, select the ‘Characteristic for Time Slices’ as a Time Characteristic. And here we also select the info objects based on which we want the archiving to be done, and move them from right to left. We repeat the same process in next tab “Semantic Group’” as well.

STEP 3.png

STEP 4 : In the last tab ‘ADK’, enter the newly created logical file name, maintain the ‘Archiving File Size’, select Delete Job as ‘Not Scheduled’. This will not allow system to delete the data automatically from data target.

STEP 4.png

NOTE : Logical files can be created using the transaction “FILE”.

By doing these steps, we have successfully created and maintained an archiving object for DSO/Infocube

STEP 5 :Now that we have set up the ADK DAP process and defined the logical mpath,  Next step is to archive the data.

To archive the data go to t code : SARA and give the Archiving Object name, and click on ‘Write’(which is our first step in the ADK data archiving process Creation of archive files)

STEP 5.png

STEP 6Give a variant name and click on MAINTAIN.

STEP 6.png

STEP 7 : In the pop-up window, select ‘For All Selection Screens’.

STEP 7.png

STEP 8 : In the tab ‘Primary Time Restrictions’, maintain the details with respect to your requirement :

STEP 8.png

STEP 9 : In the tab ‘Further Restrictions’, give the details like on what basis  we want to archive the data i.e on  certain selection if any. And keep the processing option as ‘Production Mode’

STEP 9.png

STEP 10 : Come back   and save.

STEP 10.png

STEP 11 : Enter the description i.e text for Variant Name

STEP 11.png

Save and come back

STEP 12 : Click on Start date  and schedule it.

STEP 12.png

STEP 13 : Click on ‘Spool Params’.

STEP 13.png

STEP 14 : Enter the ‘Output Device’ and press Enter button

STEP 14.png

STEP 15 : Click on ‘Execute’.

STEP 15.png

We can check the status of the job by clicking on JOB button

This completes our first STEP in ADK and we have hereby successfully “written” the data from our infoprovider to the archiving file.

STEP 16 : Now that we have copied that data into our archiving file, we can now “Delete’ the data from our infoprovider.

T code : SARA and select the “Delete” option


STEP 17Select “Archive Selection”


STEP 18 : Select the archived file and press Enter.


STEP 19 : Click on ‘Start Date’ and click on ‘Immediate’ and SAVE.

STEP 20 : Click on ‘Spool Parameters’, enter the Output Device name and press Enter. Click on Execute button and the data gets deleted. You can the job overview and be confirmed.

Hence we have completed our first type i.e ADK based Data Archiving Process.

2) NLS (Nearline storage)

How to create data archiving process based on NLS  method

STEP 1: Right click on the infoprovider and select “create data archiving process”

Here uncheck the type “ADK” and specify the name of the NLS connection.


STEP 2 : In the ‘Selection Profile’ tab, select the ‘Characteristic for Time Slices’ as a Time Characteristic. And here we also select the info objects based on which we want the archiving to be done, and move them from right to left. We repeat the same process in next tab “Semantic Group’” as well.


STEP 3: In the last tab “Nearline”  mention the size of the packet.


STEP 4 : Activate the Data Archiving Process .

We get a log display like the below. So we have now setup the nearline connection for this particular infoprovider.


STEP 5 : Once the activation is successful, come back to the infoprovider tree and click on Manage.


STEP 6 : We get a new tab “Archiving” and click on Archiving Requests.


STEP 7 : Fill in the details like based on what selections and conditions you would like the archiving to be done.


STEP 8 : After specifying the selections, click on Selection button in the “Primary Time Restriction” tab. Now select “Immediate ” schedule.


STEP 9 : You can use this option /wp-content/uploads/2012/08/2_9_125562.jpgfor simulation .

Once the simulation is successful, we can execute the archive run in dailog or Background mode


Select the target status as 70 under the Process flow control for deletion phase completion .

STEP 10 : Click on Yes.


STEP 11 : Once the archiving has completed, the request would appear in the Archiving tab like the below.


Hence we have successfully archived the data with respect to our selections.

We can cross check the cube content after archiving the data, where in you can see some changes in the content of the cube before and after archiving.

You must be Logged on to comment or reply to a post.
  • This is really great document.

    It gives step by step usage.

    I am looking for an answer on how the data retrieval is there from a NearLine Storage system.

    Do you have any answer on this ?    


  • Hi Manu and Vibha,

    It is implicit here, but to activate the Nearline piece you need to have a solution implemented from a nearline partner.

    I am the product manager for Informatica ILM Nearline, one certified solution in the market.

    The specific question about data retrieval: at interface level, the nearline interface has methods that partners need to implement for data retrieval. Since the backend is different for every  partner, the retrieval process also differs.

    At query level, you have the option to tell SAP to retrieve the data from the nearline system of not. It is the exteded properties of the query in BEx or query properties, if you are using transaction RSRT.

    There are other places were you can tell SAP to retrieve data from nearline as well: at Open Hub level, at loading of Infoproviders where the downstream obhecjts has been nearlined, etc.

    Remember, these options only show up if the DAP has been created.

    If you have more questions, pelase ask me.


    Ricardo Sobral

  • HI,

       Good document.

        i am doing the archiving for zcrm_prh object,and i configured like you for adk based archivng, in selection options i selected the calmonth (characteristics for timeslice),but my requirement is to do the archiving based on the posting date .

        How to get the posting date into selection-options for scheduling archiving jobs.



  • Daily we archive objects


    – BC_SBAL


    – IDOC

    which are 90 days old

    into our content-server.

    Everything is working very well.

    Is it possible to delete old *archived* objects which are 5 years old?

    (to release freespace in the content-server (MaxDB))

    Or in which SCN-topic can I ask such question?

  • Hi!

    Could you please be kind explain to me the reason why into menu context does not appear the “Create Data Archiving process” option over an infocube??

    Thaks in advance