Skip to Content

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.

/wp-content/uploads/2014/11/1_590716.png

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

/wp-content/uploads/2014/11/2_590723.png

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

/wp-content/uploads/2014/11/3_590724.png

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.

/wp-content/uploads/2014/11/4_590725.png

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.

/wp-content/uploads/2014/11/6_590732.png

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.

/wp-content/uploads/2014/11/7_590734.png

Create a Virtual cube based on DTP.

/wp-content/uploads/2014/11/8_590738.png

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

/wp-content/uploads/2014/11/9_590739.png

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.

/wp-content/uploads/2014/11/10_590740.png

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:

/wp-content/uploads/2014/11/11_590744.png

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

/wp-content/uploads/2014/11/12_590730.png

/wp-content/uploads/2014/11/9_590739.png

We are done with the modeling part.

Now create the BEx report as in below.

/wp-content/uploads/2014/11/14_590747.png

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

/wp-content/uploads/2014/11/15_590748.png

The BEx report output:

/wp-content/uploads/2014/11/1_590716.png

We can see the Bex report for TCURR table entries.

To report this post you need to login first.

4 Comments

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

  1. Siti Nuramanina Hamdan

    Hi , we have created above report . However, user wanted for any public holiday, it will take previous working date rate. Any ideas for this? How, I can include public holiday date with previous working date rate? Kindly advise

     

    (0) 

Leave a Reply