INTRO: Exchange rates are necessary to convert from one currency to another based on the translation date for financial transactions.

In ECC, t-code OB08 Currency exchange rates are  maintained. The same can be seen in ECC TCURR table.

1_590716-5372584

In BW, we will be replicating currency tables TCURR, TCURC, TCURV,.. for conversions in BW.

2_590723-1837236

This activity of replicating currencies are scheduled as Background job or using the process chain.

3_590724-7621655

The reporting requirement is to have a BEx report on TCURR table entries.

The following is one of the approach which I have followed to create TCURR BEx report.

I will be creating report on Virtual provider because the data is present in BW and I don’t want to duplicate the data by pulling into DSO/Cube again for our reporting purpose.

First step is creating the datasource in BW based on TCURR table.

4_590725-9510961

For Creating a Virtual Cube, Identify the Infoobjects. The Infoobjects we will be using is based in TCURR table fields.

Below are the table fields in TCURR table.

Below table shows the Table fields with corresponding Infoobjects (Standard and Custom).

TCURR
  Table Field
BW Infoobject Ref Currency
KURST 0RTYPE
FCURR ZTB_SRCUR
TCURR 0TB_ITXRCUR
GDATU 0GM_XCHDT
UKURS 0AB_EXCHRAT
FFACT ZFFACT ZTB_SRCUR
TFACT ZTFACT 0TB_ITXRCUR

Below is the ZFFACT Infoobject Definition. Other custom Infoobject ZTB_SRCUR is created as reference to 0TB_ITXRCUR.

7_590734-9738712

Create a Virtual cube based on DTP.

8_590738-8919885

We have Virtual cube and Datasource. Next is to Map the source and target with transformation –

When we check the data in TCURR table the ‘Valid From’ date is in Inverted date (below screen), we have to convert the Inverted date into date format.

10_590740-1508143

In the Domain of the field ‘Valid From'( GDATU ) we can see conversion routine INVDT is used for Inverted date. This Conversion routine we will use in transformation to get the Inverted date into readable format.

The conversion routine INVDT code:

11_590744-7528461

We will use this conversion routine code in 0GM_XCHDT transformation mapping

12_590730-4554555

9_590731-5795822

We are done with the modeling part.

Now create the BEx report as in below.

14_590747-6073717

To remove Units for ‘From currency’ and ‘To Currency’, use NODIM function.

15_590748-2166294

The BEx report output:

1_590845-4243557

We can see the Bex report for TCURR table entries.

New NetWeaver Information at SAP.com

Very Helpfull

 

 

User Rating: Be the first one !