Applies to:

SAP BI 7.0.For more information, visit the Business Intelligence homepage.

Summary

This article demystify on how to do the logical mapping of source systems and how to transfer the global settings of currencies/units/fiscal variants in order to avoid the general failures of the data loads.

Author(s):     Venu Babu Janjanam

Company:    Cognizant Technology Solutions

Created on:  18 May 2012

Author Bio

Venu Babu Janjanam is a senior SAP BI 7.0 Certified Professional and currently working with Cognizant Technology solutions. He has extensive cross functional experience and has been with end to end SAP implementation projects across manufacturing & logistics domain. He has solid potential experience in SAP BI, ABAP, BO and other DWH tool space.

Table of Contents

Applies to: 1

1. Summary. 1

Author Bio. 1

Table of Contents. 2

Related Content 10

Disclaimer and Liability Notice. 11

Overview

To maintain the mappings as global settings in BW, logical mappings of the source system ID’s and its descriptions should be maintained. So that, its applicable in the entire BW system and populate the source system id/description.

The below mentioned tables will contain the information regarding the currency/unit/fiscal variants.

T000     Clients

T002     Language Keys

TCURR Exchange Rates

TCURC Currency Codes

TCURV Exchange Rate types for currency translations

T009     Fiscal Year Variants

T006     Units of Measurement

Step by Step Process to maintain the logical mapping

1. 1.Call the transaction RSA1 and choose Asgmt of SCE Syst. To Srce Syst ID from the Tools menu bar as shown in the below screen.

1. 2.Using the create option (F5), a new source system Name and ID can be entered. Once the source system is defined, save it (Ctrl+S) as shown in the below screen.

1. While creating the transformation for the source system. We need to map a constant for the source system without any value.

1. Once the entire flow is designed, we can load the data and the source system ID is automatically populated by the system from the logical mapping.

Transferring the global settings

1. 1.inorder to transfer all the fiscal variants/currencies/units the transfer global settings need to be used as shown in the below screens.

1. Execute it directly using (F8) the button. This job can be also executed in the background on a regular basis. Schedule the RSIMPCUST program in back ground using variants.

1. 3.Once its executed successfully, all the values which are maintained in the corresponding source system will be transferred to the BW system. We can see all the new entries in the respective tables.

1. In the similar fashion we can also transfer all the currency exchange rates.

1. Common errors like No SID found for any variant or currency will be solved as shown in the below screens.

1. Once all the settings are transferred to BW (based on the error..fiscal variants/units/currencies). The process chain/load will be completed successfully.