Skip to Content
Author's profile photo M. Stitselaar

Starting with the SAP Data Retention Tool (DaRT)

Starting with the SAP Data Retention Tool (DaRT)

For a company I work for there was a need for archiving data as the database was growing. But there was also the need to keep data available for future audits.

What if we delete the data from the database and it is needed for an audit? Well then we still have the archive files and we still can view the data.

See “Archiving SAP data and how to access it after the delete run

Although that is true, the customer wanted to work with DaRT extract to be able to give a future auditor exactly what they needed. And this DaRT process is normally done before the archiving project starts.

So in the below steps I will show you the steps how to configure and create a DaRT extract.

It will be shown from a technical point of view (as I’m a technical consultant).

Of course you also need a functional- or business-consultant to determine the data to be captured (for example the period and the company code).

First a small definition of DaRT, compared to ILM (information Lifecycle Management):


DaRT is a tool offered as part of the SAP Business Suite. The main purpose is to retain the relevant finance and tax data from a productive system to make it available to auditors. The data being exported (so called DaRT extracts) is not deleted within the productive database which leads to a duplication of data. As soon as the data is needed to support an audit, the exported files are imported into the “DaRT Viewer”

SAP Netweaver ILM is a total solution of which Retention Management is part of. It applies to productive systems and enhances archive files with their specific retention time, stores the files and enables automated destruction once the retention time expired. The technical foundation is the standard data archiving provided as part of the SAP Business Suite.

In this example I performed the DaRT extracts for a French company code and there were a few notes to be imported specifically:

0001906078 –  FTW1A: BADI for additional selections from BKPF

0001923322 –  DaRT: View file creation for France Legal Requirement

0001935509 –  Carry forward postings for new GL in France

Related transaction codes

First an overview of DaRT related transactions:


DaRT configuration

SAP transaction FTWP

In this example we choose Financial documents and Tax data.


Go to tab File directories and create a new one:


The 0 is placed automatically. Leave this field blank.

If your SAP system has separate application servers, make sure this directory is accessible from all systems.

The other tabs we can leave default

Create DaRT extract

We use SAP transaction FTW1A

Here we choose need the functional- or business-consultant to determine the data to be captured. In this example we choose a certain company code and a certain fiscal year.





At operating system we see that the files are created:


DaRT logging

Use SAP transaction FTWL to see the DaRT logging after the run is done:



DaRT extract browser

SAP transaction FTWF to browse through the DaRT extract



Double click on a line to see the detailed data.

DaRT data view queries

Besides the SAP transaction FTWF to browse through the DaRT extract we have transaction FTWH for the DaRT data view queries


Because we created a Tax related DaRT extract we now choose: “0SAP_BSET  Tax data document segment”.

In the next screen select the source extract and directory set and execute.


Then the data is shown which an auditor needs to see/review

Best Regards,


Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Gaurav Rana
      Gaurav Rana

      Hi Marco,

      Thanks for sharing such a nice document.


      Author's profile photo Former Member
      Former Member

      Hi Marco,

      Thanks for such a detailed document, But I have much more specific requirement in SAP DART and I am unable to get any solution to my requirements. So, Can you message me atleast or reply to this comment. I will be eagerly waiting for your response.

      Author's profile photo Brahama Kroma
      Brahama Kroma

      Hey Marco, appreciate the detail info, this is very helpful


      Author's profile photo Sathish K
      Sathish K

      Hi Ashik,

      Could you let know what questions you have?

      Author's profile photo Sathish K
      Sathish K

      For updated information refer to note 2162977!

      Author's profile photo TMA SAP IWAY



      I start when i execute FTW1A i have a dump UNCAUGHT_EXCEPTION / CX_FS_PATHS_INCOMPATIBLE .

      In FTWP i go to tab File directories and create a new one:

      The other tabs can you say me what i put ?

      Thanks for your help.


      Author's profile photo Srinivas Perala
      Srinivas Perala

      Hi Marco,


      DO you have idea on how to automate the DaRT process with SCMA and  STVARV.




      Author's profile photo Arvind Leo Pereira
      Arvind Leo Pereira

      Hi Marco,

      this Document is very good, in terms to clarity and steps.


      Arvind Leo Pereira