Skip to Content

In this blog I have attempted to explain the text variable issue with Time Characteristics in Bex Query after the BW system upgraded to 7.3 version

Issue

After the BW system gets upgraded to BW7.3 version, then during the execution of the BW query the Time Characteristics with text variable does not dynamicaly display its text instead it would display its technical name as depicted in below screen shot.

/wp-content/uploads/2013/11/f1_334159.png

Rootcause

In Bw7.3 version, for time characteristics like 0CALDAY textxs will not be maintained in RSD1 and also for time characteristics “TEXTS” option would be unchecked in the Master Data/Text tab of characteristics. While in lower versions 3.x/7.0 for time characteristics texts would be internally maintained in RSD1 hence the text variable works fine in 3.5/7.0 versions.

In general before the BW upgradation to BW7.3 version, variable setting maintained in Bex Query Designer is depicted below, setting maintained for Replace Variable with is “Name Text”

/wp-content/uploads/2013/11/f1_334159.png

Solution

Change the setting for “Replace Variable with” in text variable from Name to “External Characteristics Value(Key)”, then the BW report would display correct texts for the text variable used in the Time Characteristics.

/wp-content/uploads/2013/11/f1_334159.png

To report this post you need to login first.

2 Comments

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

  1. Javier Caycho

    Hi Antony, 

      With that change (SAP Note 1693785) the problem is not solved properly, for example if in the past I had as result of the text variable Jul 2013 for 0CALMONTH, now I have 07.2013. The only way to fix it is changing the infoobject flagging the Text Master Data and adding this manually?

    Kind Regards,

    Javier

    (0) 

Leave a Reply