Legacy Data Transfer (SAP Library - General Information about the Transaction Manager)

Legacy Data Transfer

Purpose

If you want to repeat the implementation of the Transaction Manager (FIN-FSCM-TRM-TM) and your data (legacy data) is in a source system, you need to make sure this data is a available in the Transaction Manager for a key date.

Legacy data needs to be transferred to the system in a number of steps and can be done in various ways.

The following section describes the various processes, depending on the position type or transaction type:

● OTC Transactions (product categories: 510, 520, 530, 540, 550, 560, 600, 710, 712, 760, 780, 730, 770.)

● Securities Positions (product categories 010, 020, 030, 040, 041, 042, 060, 070, 111, 112, 113, 114, 160.)

● Futures (product categories 700, 750.)

When you transfer legacy data to the Transaction Manager you can use functions specially developed for the legacy data transfer in addition to the application functions in the Transaction Manager.

The special functions for transferring legacy data are available in Customizing for the Transaction Manager under General Settings ® Tools ® Legacy Data Transfer.

To make your Customizing settings for the Transaction Manager, on the SAP Easy Access screen, choose Tools ® Customizing ® IMG ® Execute Project ® SAP Reference IMG ® Financial Supply Chain Management ® Treasury and Risk Management ® Transaction Manager.

Prerequisites

Before you can transfer the legacy data, you must satisfy the following prerequisites:

● You need to make your settings in Customizing for the Transaction Manager.

For more information, see the implementation guide (IMG) for the Transaction Manager. Refer also to the documentation for the Transaction Manager in the SAP Library.

● In addition, to transfer legacy data you need to define update types and assign them to the usage legacy data transfer by choosing Define Update Types and Assign Usages. In the IMG activity Assign Update Types for Legacy Data Transfer you then need to assign clearing and posting update types for the individual components.

The following update types for transferring legacy data are provided in the sample Customizing delivered with the system:

○ DT_C001 Legacy data transfer: Additional flow (positive)

○ DT_C002 Legacy data transfer: Additional flow (negative)

○ DT_C011 Legacy data transfer: Post accrual/deferral (positive)

○ DT_C012 Legacy data transfer: Post accrual/deferral (negative)

○ DT_T001 Legacy data transfer: Post units/nominal (positive)

○ DT_T002 Legacy data transfer: Post units/nominal (negative)

○ DT_T003 Legacy data transfer: Post purchase value (positive)

○ DT_T004 Legacy data transfer: Post purchase value (negative)

○ DT_T005 Legacy data transfer: Post security valuation (positive)

○ DT_T006 Legacy data transfer: Post security valuation (negative)

○ DT_T007 Legacy data transfer: Post foreign currency valuation (positive)

○ DT_T008 Legacy data transfer: Post foreign currency valuation (negative)

○ DT_T011 Legacy data transfer: Post costs (positive)

○ DT_T012 Legacy data transfer: Post costs (negative)

○ DT_T017 Legacy data transfer: Post amortization (positive)

○ DT_T018 Legacy data transfer: Post amortization (negative)

Note These update types should only be used as a guide and should not be considered as complete.

You need to define additional information for some of the update types. To do this, choose Securities ® Position Management ® Securities Account Management ® Update Types ® Specify Update Types for Securities Account Management.

Examples from the Sample Customizing Settings

Update Type	Additional Information
DT_C001 Legacy data transfer: Additional flow (positive)	Calculation category TF, Flow classification: Charges
DT_C002 Legacy data transfer: Additional flow (negative)	Calculation category TF, Flow classification: Charges
DT_T001 Legacy data transfer: Post units/nominal (positive)	Calculation category AA, Effective interest calculation: calculation-relevant, +/- sign
...	...

You assign the position change categories to the update types for the valuation area-independent data by choosing General Settings ® Accounting ® Settings for Position Management ® Set the Effects of the Update Types on the Position Components.

Example from the Sample Customizing Settings

Update Type	Position Change Category
DT_T003 Legacy data transfer: Post purchase value (positive)	1011 Post purchase value
DT_T004 Legacy data transfer: Post purchase value (negative)	1010 Post negative purchase value
DT_T011 Legacy data transfer: Post costs (positive)	1015 Post costs to purchase value component
DT_T012 Legacy data transfer: Post costs (negative)	1010 Post negative purchase value

You first need to indicate the update types relevant for posting by choosing General Settings ® Accounting ® Link to Other Accounting Components ® Indicate Update Types as Relevant for Posting. You then choose Define Account Determination to determine the relevant account. You also need to indicate flows that are relevant for posting if you do not intend to post to the general ledger during the legacy data transfer.

Note

You can use the sample Customizing settings delivered as a guide.

For more information, see the documentation for the IMG activities.

Process Flow

Scenarios: Background

● You already use SAP Financial Accounting (FI) and now want to implement the Transaction Manager.

The legacy data to be transferred to the Transaction Manager is already posted in Financial Accounting. This means that no postings should be made to FI during the legacy data transfer.

● Both SAP Financial Accounting (FI) and the Transaction Manager are implemented.

In this case, you have the following options:

○ You implement both components separately (so that no postings are made to FI during the legacy data transfer to the Transaction Manager.)

Note Note:

When transferring legacy data to the Financial Accounting area you can use the functions in Customizing for Financial Accounting by choosing General Ledger Accounting ® Data Transfer Workbench.

See also: Structure link CA - Data Transfer

○ The Financial Accounting area is updated when legacy data is transferred from the Transaction Manager.

If you choose this option, you need to post the transactions using the transaction posting function [TBB1] and set the FI Update indicator during the legacy data transfer.

In this case, you should make sure that the flows usually relevant for payment are not paid. Limit the validity of the payment terms in the transactions to be transferred.

The following section assumes that the FI area is not updated when legacy data is transferred to the Transaction Manager.

Even if postings are not made to FI during the legacy data transfer, a posting log is still generated using the report Indicate Flows as Posted. You can then see the accounts in the FI area to which postings would have been made to reconcile the data. This information is required for account assignment reference transfers at a later stage. The data is also available in the posting journal (transaction TPM20.)

OTC Transactions

Preparation

● Master data entry, such as creating business partners (role: counterparty.)

See also:

Legacy Data Transfer: Process

...

Übernahme der Mengeninformationen, Kaufwert und Kosten sowie Stückzinsen (bewertungsbereichunabhängige Informationen) geschieht über die Erfassung von Geschäften.

1. Valuation area-independent information such as quantity information (units, nominal amounts,) the purchase value, costs, and accrued interest is transferred by entering transactions. Create the transactions and run through the process you selected to enter transactions. However, do not post the transactions.

2. You now need to indicate the transaction flows as posted for all valuation areas. You use a function within the legacy data transfer to do this. In Customizing for the legacy data transfer, choose Flow Data ® Indicate Flows as Posted.

The flows are indicated as being posted but are not actually posted. A posting log is generated.

3. The remaining Structure link Position Components are entered in the valuation area-dependent legacy data table (Legacy Data Transfer ® Flow Data ® Enter Valuation Area-Dependent Data for Money Market, Forex, and OTC Derivatives Transactions.)

Note:

The legacy data transfer does not support the transfer of accruals/deferrals for OTC transactions according to the difference method.

If you want to transfer these accruals/deferrals to the system, you should use the accrual/deferral function after the legacy data transfer has been completed.

4. Start the legacy data transfer (Legacy Data Transfer ® Flow Data ® Execute Data Transfer)

Securities Positions

Preparation

● Create business partners

● Create classes

● Create securities accounts

Legacy Data Transfer: Process

...

1. The subledger position indicator needs to be created for all positions that are to be transferred. You can choose from the following two options to create the subledger position indicator:

○ Create the subledger position indicator using the function Create Position Indicator in the Area Menu for the Transaction Manager by choosing Securities -> Master Data -> Position Indicator.

○ Enter the subledger position indicator in the legacy data table for positions. (In Customizing for the Transaction Manager, choose General Settings ® Tools ® Legacy Data Transfer ® Position Data ® Enter Position Information for Securities.) You then start the legacy data transfer for positions (choose Legacy Data Transfer ® Position Data ® Execute Data Transfer for Positions.)

2. To transfer valuation area-independent information such as quantity information, purchase value and costs, and accrued interest, you can choose between the following two options:

○ Enter data in the valuation area-independent legacy data table (Legacy Data Transfer ® Flow Data ® Enter Valuation Area-Independent Data for Securities.)

○ Transfer valuation area-independent information by entering transactions.

Create the transactions and run through the process you selected to enter transactions up until the Settlement status.

See also: Structure link Security Transaction

You now need to indicate the transaction flows as posted for all valuation areas. You use a function within the legacy data transfer to do this. In Customizing for the legacy data transfer, choose Flow Data ® Indicate Flows as Posted.

Note:

Special Feature: Lots for Securities

If lots have been generated, you can choose between two different procedures:

○ Valuation Area-Independent Data Using the Legacy Data Table (Securities Only)

In this case, a number must be entered in the valuation area-independent table. This number must also be defined in the corresponding entry in the valuation area-dependent table. Prior to the valuation area-dependent business transaction being distributed, the system determines the LotID of the valuation area-independent business transaction (identified by its number) that has already been distributed. The LotID is then written into the valuation area-independent business transaction.

○ Valuation Area-Independent Data Using Transactions (Securities or Futures)

In this case, no entries are made in the table with valuation area-independent data.

To identify the lot, you need to enter the transaction number of the transaction that generated the lot, in the table with valuation area-dependent information. When the corresponding business transaction is generated, it is enhanced with the LotID.

Special Feature: Accruals/Deferrals

Difference Method

If, during the legacy data transfer, you transfer accruals/deferrals according to the difference method, you must provide update types for the accrual/deferral function so that in the accrual/deferral run, the system recognizes that a portion has already been accrued/deferred.

Proceed as follows:

a. Call up transaction SM30.

b. In the Table/View field, enter TRLIC_AD_EX1.

c. Click on Maintain.

d. Make the required settings.

e. Save your entries.

Reset procedure

In the case of accruals/deferrals according to the reset procedure, you do not have to make additional settings since accruals/deferrals that are already available in the system are not included in the next accrual/deferral calculation.

4. Start the legacy data transfer (Legacy Data Transfer ® Flow Data ® Execute Data Transfer)

Futures

Preparation

● Create business partners

Legacy Data Transfer: Process

...

1. Enter the open transactions.

2. You now need to indicate the transaction flows as posted up until the start date for all valuation areas. You use a function within the legacy data transfer to do this. In Customizing for the legacy data transfer, choose Flow Data ® Indicate Flows as Posted.

4. Start the legacy data transfer (Legacy Data Transfer ® Flow Data ® Execute Data Transfer)

5. Start the initial variation margin run.

Final Tasks

● After the legacy data transfer has been completed, you should reconcile the general ledger and the subledger. To do this, you can use the Structure link Posting Journal which provides you with all the posting information.

● If you want to use regulatory reporting for the Insurance Supervisory Authority, it first needs to be activated and initialized. In Customizing for the Transaction Manager, choose General Settings ® Information System ® Regulatory Reporting Settings for the Insurance Supervisory Authority.

Result

All the legacy data is in the system.