Skip to Content

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):

(see http://scn.sap.com/docs/DOC-28852)

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:

Capture1.JPG

DaRT configuration

SAP transaction FTWP

In this example we choose Financial documents and Tax data.

Capture2.JPG

Go to tab File directories and create a new one:

Capture3.JPG

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.

Capture4.JPG

Result:

Capture5.JPG

Capture6.JPG

At operating system we see that the files are created:

Capture7.JPG

DaRT logging

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

Capture8.JPG

Capture9.JPG

DaRT extract browser

SAP transaction FTWF to browse through the DaRT extract

Capture10.JPG

Capture11.JPG

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

Capture12.JPG

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.

Capture13.JPG

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

Best Regards,

Marco

To report this post you need to login first.

6 Comments

You must be Logged on to comment or reply to a post.

  1. Ashik Chollangi

    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.

    (0) 
  2. TMA SAP IWAY

    Hello,

     

    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.

    GL

    (0) 

Leave a Reply