Archive Retrieval
Purpose
The Archive Retrieval utility lets you retrieve data that has already been archived from the database with the R/3 Archive Development Kit (ADK). Once you retrieve data from the archive, you can
extract and retain the data with the data extraction utility, as in the following illustration:
Prerequisites
Process Flow
The system uses ADK archive objects to locate the requested data. The system then retrieves the data from the archive and loads it into special, temporary retrieval tables.
Extract the desired data.
To include the data that had been retrieved from the archive (from the temporary retrieval tables) in the extract, set the Include data retrieved from archives indicator on the Extract Data screen.
You can do this once you have finished extracting the data you need. This deletes the data from the temporary retrieval tables.
Merging Retrieval Data Sets
You can use the retrieval tables to collect and merge data you retrieve from the archive at different times using different selection criteria. For example, you can retrieve sales data for a certain company code and period, and then retrieve delivery data for the same company code, but for a different period. If you leave the data in the retrieval tables intact after the first retrieval, then the system merges the two data sets, eliminating any redundant data.
If you use the retrieval tables to merge retrieved archive data, then remember to clear the retrieval tables after you extract the data.
Data Retention and Archival Strategy
If you need to retain data that you archive on a regular basis, it is easier to first retain the necessary data with DART, and then archive the appropriate data with ADK. This way you avoid the need to retrieve data from the archive before extracting data to be retained.
Result
Retrieval Tables
The system fills the temporary retrieval tables with the relevant data.
The retrieval tables are named using the first four characters from the name of the source table (the table in which the data resided before archiving) with the prefix TXW_S_.
The following table lists the source tables for the SAP-provided
segments and their equivalent retrieval tables:|
Source Application/Document |
Source Table |
Retrieval Table |
|
FI/Finance |
BKPF |
TXW_S_BKPF |
|
BSEG |
TXW_S_BSEG |
|
|
GLT0 |
TXW_S_GLT0 |
|
|
CO/Controlling |
COBK |
TXW_S_COBK |
|
COEP |
TXW_S_COEP |
|
|
FI/CO/Reconciliation |
COFIS |
TXW_S_COFI |
|
AM/Asset |
ANEK |
TXW_S_ANEK |
|
ANEP |
TXW_S_ANEP |
|
|
ANEA |
TXW_S_ANEA |
|
|
MM/Material |
MKPF |
TXW_S_MKPF |
|
MSEG |
TXW_S_MSEG |
|
|
MM/Purchase orders |
EKKO |
TXW_S_EKKO |
|
EKPO |
TXW_S_EKPO |
|
|
SD/Billing |
VBRK |
TXW_S_VBRK |
|
VBRP |
TXW_S_VBRP |
|
|
SD/Sales |
VBAK |
TXW_S_VBAK |
|
VBAP |
TXW_S_VBAP |
|
|
SD/Delivery |
LIKP |
TXW_S_LIKP |
|
LIPS |
TXW_S_LIPS |
Output
After a successful execution, the program displays the following statistical information: