Register Login

Step by Step processing of Extracting data Archived from SAP

1. Run transition SARJ and Press "Create" Button


2. Specify a description for the information structure, archiving object and field catalog. Afterwards, press again the “Create” button.

Field catalog: A set of fields that build the basis for the information structure. It is typically based on fields from tables that form the archiving object (we use standard field catalog SAP_BC_SBOOK01).


3. Select the fields that you want to include in your information structures. All fields picked in this step will be available for extraction.

The fields that are marked in the field catalog as key fields will be proposed by the system automatically. They cannot be removed from the information structure.

4. Press “Technical data” button. Write down the name of the structure table or copy it to the Clipboard for later use. You will need this name for the creation of the generic DataSource, which will retrieve its’ data from this transparent table.


5. Press Save Button and return Back to the SARJ screen. To populate an information structure, you have to activate it first. You do so by pressing the “Activate” button on the entry screen of the transaction SARJ

2. Creation of the generic DataSource

1. run Transaction  RSO2, specify a name for the generic of DataSource and press the “Create” button.
(Customizing for Extractors (SBIW) •Generic DataSources •Maintain Generic DataSources).

2. Give application components, the transparent table to be used for extraction, and the descriptions for the DataSource.

The name of the transparent table is the Structure Table of the information structure of the archiving object.

(See step above for the description how to determine the structure table name).


3. Save your DataSource. On the next screen, you are able to pick which fields of the DataSource should be available for selection in the InfoPackage or hidden, respectively.
The fields “Archivekey” and “Archiveofs” are technical fields of the structure table to locate the records selected in the archive files.
Complete the definition of your DataSource by pressing the “Save” button

4. Replicate the DataSources for the respective application component in the SAP NetWeaver BI system and assign it to an InfoSource. Afterwards, you are able to schedule the extraction via an InfoPackage.


3. Population of the information structure

Fill active information:
1) Automatically, when running the deletion program (only applicable for archives filled by the applications – in this case it is advisable to extract the data prior to archiving)

2) Manually by the user
In this chapter we describe the manual process of populating information structures, since the automatic process is hidden to the end user, and does not require any user interaction (except the scheduling of the deletion job for the archive object).

1. Call the transaction SARJ. Enter your information structure, and choose the option “Create structure” from the “Environment” menu.


2. Select the sessions from which you want to include data in the information structure.
Press “Set up structure” push button to schedule the population of the information structures. You can perform the population either in “Dialog” or “Background” mode. The “Background” mode is recommended by SAP.

3. The successful population of the information structure is indicated by the system by the “Green” traffic light for the respective archiving sessions.

Check the contents by using the “Archive Explorer” (push button on the transaction SARI) or by using the “Data Browser” (SE16) for the structure table of the information structure.


  • 06 Jun 2008 9:04 am Mohanraj v
    Great effort!!! Thanks very much..
    This article is very useful for my analysis..

    Thanks & Regards
    Mohanraj V