BW-Delta Extraction for Treasury

[Former Member]

BW-Delta Extraction for Treasury

Andreas Martin

April 2, 2006

Abstract

This guide gives an introduction to the extraction of treasury data to the business warehouse with the extractors

• 0CFM INIT POSITIONS

• 0CFM DELTA POSITIONS.

The text assumes that the reader is accustomed to the SAP business warehouse on the level of course SAP BW 310 and knows how to work

with transaction RSA1 the Administrator Workbench. We concentrate on the data source system and on the first set up.

This text is still a draft. Please send remarks and comments to Andreas Martin by andreas.martin@sap.com.

1 Treasury Transaction Manager

The position management in the treasury transaction manager manages the creation and change of the business positions. The main information is the set of position values at key dates and the flows which create these values. These position values are not saved at certain key dates, but are always calculated dynamically. Therefore the information system has the duty to report for requested key dates the set of position values, the flows which correspond to them and enhance this information with additional attributes.

The information system of the position management has three different levels:

1. The set of position values for a single position or a limited amount of positions can be reported by transactions TPM12 and TPM13 in R3.

2. Position values and additional attributes of a medium and large amount of business positions can be reported by the standard reports of the information system and the logical database of the treasury via the reporting tools queries and drill down reports. This is still in R3.

E-mail: andreas.martin@sap.com. Adress: SAP AG, Dietmar-Hopp-Allee 16, 69190 Walldorf, Germany.

3. Position values and additional attributes of a large scale of business positions in combination with other data can be reported in the SAP

business warehouse.

The extraction of data from the treasury position management to the business warehouse is done mainly by the extractors

• 0CFM INIT POSITIONS

• 0CFM DELTA POSITIONS.

In the business warehouse there is the standard content 0CFM POSITIONS which refers to these extractors. The extractors work only on the key date reference valuta date. Extraction for the key date reference posting date is in development. Reports with key date reference posting date are available on the first two levels of the information system.

2 The First Set Up

Before the periodic extraction to the business warehouse is in process, both the R3 source system which carries the treasury transaction manager and the business warehouse system have to be prepared.

2.1 Business Warehouse

In the business warehouse the business content you want to use has to be activated. You can use the standard business content 0CFM POSITIONS, copy this content and enhance it or even create your own business content.

Important! The treasury position management extractors are designed to pull data for a position cube like the info cubes given in the standard

content 0CFM POSITIONS. This is essential when you create your own content. Moreover, the treasury position cube uses an initial extraction and a periodic delta extraction.

When the business content is active you can extract the basic data and texts for the info objects which carry the characteristics. This is a common extraction process from the source system to the business warehouse like described in detail in course BW310 or any literature on the SAP business warehouse.

2.2 The Logical Database of Treasury

The CFMposition extractors and the logical database of the treasury work on the same set of functions to pull the position values and common attributes from the position management. In detail

• 0CFM INIT POSITIONS corresponds to FTI TR POSITIONS

• 0CFM DELTA POSITIONS corresponds to FTI TR PERIODS

both with key date reference valuta.

To get used to the data pulled by the initialization, the messages and errors for the extraction of the data and to determine the key date for the

initialization tests with reports on the logical database FTI TR POSITIONS should be performed. The extraction structure of 0CFM INIT POSITIONS can be displayed with transaction RSA2. We recommend to use queries as reporting tool. Similar you should get used to 0CFM DELTA POSITIONS with reports on FTI TR PERIODS.

While performing the tests the warnings and errors should be investigated carefully, because they would later cause the extraction to finish with warnings or errors, respectively.

2.3 Multitasking

The CFM position extraction as well as the logical databases can use multitasking to pull data. We recommend to use this functionality when large amounts of data is pulled. The customizing is done with transaction SM30 in table FTIC MTASKING.

2.4 Customizing of the Source System

The customizing for the business warehouse extraction in the source system which carries the treasury transaction manager has to be created and  checked. Please start transaction SPRO and navigate to

Corporate Finance Management -> Transaction Manager -> General Settings

-> Information System -> Business Information Warehouse.

At item Define InfoSources for Position Initialization the following customizing has to be given:

• InfoSource for Position Initialization 0CFM INIT POSITIONS; This is the table key and determines the info source for which the settings

are valid.

• Date of Position Initialization This is the key date for which the set of position values is calculated with key date reference valuta.

• InfoSource for Delta Position 0CFM DELTA POSITIONS; This is the info source which is used for the delta extraction after the initial extraction

was done.

• DataSource for Position Initialization 0CFM INIT POSITIONS; This is the data source which is used by the info source.

The date of position initialization is the key date with whom the initial load is done to the business warehouse. In the following process the delta extraction loads in update mode C Initialization for the delta transfer flows up to this key date and in the first run in update mode D Transfer of the Delta since the last Request flows with valuta date at and after this key date.

At item Define InfoSources for Delta Position the customizing for the periodic delta extraction has to be entered. For 0CFM DELTA POSITIONS

the following setting has to be given and checked:

• InfoSource for Delta Position 0CFM DELTA POSITIONS; This is the table key and determines the info source for which the settings are

valid.

• Technical Date From This key figure is not used and should remain empty.

• Pure Delta InfoSource This must not be set. The this delta extractor is not a pure info source and uses 0CFM INIT POSITIONS for

initialization. Please confer the F1-help for more information.

When the information above is given, the customizing is complete. The BWExtraction Log contains the list of extractions done from the source system.The last item Delete Time Stamp for InfoSource is needed when for a key date or time period the extraction has to be done again, for example if you want to delete an extraction with 0CFM INIT POSITIONS and do it again.

We come back to this example later.

2.5 Extractor Checker

Before the extraction to the business warehouse is done, the extraction process should be checked with the extractor checker transaction RSA3. However, you should have worked through subsection 2.2 carefully and completed the customizing in subsection 2.4. The extractor checker pulls and displays only a sample of the data extracted to the business warehouse. It is mainly used to check if the technical process for extraction works. The data should have been check before via reports on the logical database of the treasury.

Extractor 0CFM INIT POSITIONS is checked in update mode I Transfer of an opening balance for non-cumulative values. This check must be

done before the check of the delta info source.

Extractor 0CFM DELTA POSITIONS can only be checked when the initial load to the business warehouse is done. It is checked in update modes

C Initialization for the delta transfer and D Transfer of the Delta since the last Request. Update mode pulls flows with valuta data up to the initialization key data and update mode D pulls flows with valuta data at and after the key date.

Please check in every case the log which contains informations for the extraction check.

2.6 Extraction to the Business Warehouse

Finally we can change to the business warehouse system. Most of the work can be done with transaction RSA1 the administrator work bench. With the scheduler requests for info packages are created and scheduled. With the monitor the loading process is monitored.

The first task is to load the initial position data in update model with extractor 0CFM INIT POSITIONS. Then with the delta extractor

0CFM DELTA POSITIONS the initial delta with update mode C can be pulled. Now we are prepared to do the periodic delta extraction in update

mode D.

3 Deleting an Initial Extraction

In the process of testing the extraction it can be necessary to delete an initial extraction which was done by 0CFM INIT POSITIONS. To do that,

you have to the three steps:

1. Delete with the Infoprovider all requests belonging to the extraction. This deletes the data from the basis cubes where the data is extracted

to.

2. Delete with the scheduler the time stamp for the info package at drop down list · drop down list.

3. Delete in the source system at item Delete Time Stamp for InfoSource the time stamp for the info source for the position initialization

0CFM INIT POSITIONS. Flag the time stamps you want to delete and press save.

The similar action you have to perform when deleting an extraction with 0CFM DELTA POSITIONS.

4 Error Handling

Please inform us at andreas.martin@sap.com at errors and questions which were experienced during the process to set up the extraction for the CFM position extractor. We will add information on the error handling and answers to these questions to this text.

Source : Document on Treasury by Andreas.Martin@sap.com All Credits to Andreas.

Since such a detailed explanation on this data sources are not available , posting it here for knowledge sharing purpose.