BEx Query - Time characteristic Description problem

[Former Member]

Hi Guys,

In one of the queries, I have '0I_FPER' as the time-characteristic in the columns section. I have few key figures in my rows section. When i executed the query (filter char. - Fiscal year variant restricted to July - June, 4 special periods i.e. V6), i get separate columns for each month as required. But, the descriptions for the months are July 2005, August 2005 ... June 2005.

They should get displayed as

July, 2004 August 2004 ... June 2005

How do i get the description in the desired format.

Any help will be greatly appreciated.

[Former Member · Accepted solution]

I'd first check to see if the descriptions for the months in BEX are being filled from a variable other than what you are expecting.

[Former Member · Accepted solution]

Hi guys,

I am awaiting a solution. The values are not being filled by any variable. As mentioned before, 0FISCPER has been restricted on 0I_FPER variable. The Fiscal Variant is V6. On execution, the following output appears (with user-entry values for 0FISCPER being 001/2005 - 012/2005):

July 2005 August 2005 ..... June 2005

I am expecting something like

July 2004 August 2004 ..... June 2005

I have problem only with the column description. The data appears correctly. i.e. Data for July 2004 appears correctly but with heading July 2005 instead of July 2004. I created text variables on 0FISCPER for all the months of 2004. But no help.

Any help will be greatly appreciated.

[Former Member]

Hi Govind,

Check the texts for the time characteristic '0I_FPER' in the backend. The table would be /BI0/TI_FPER.

Bye

Dinesh