How show 0FISCPER3 and 0FISCYEAR description in title of BPS data columns?

[Former Member]

I have a layout with 24 months and each month have 3 columns (Volume, Price and Faturament). I'm using 0FISCYEAR and 0FISCPER3 in data columns with variables and off-set. In title of columns, just display the year. How to do to show the month and the year in the title of columns? (like 001/2006, 002/2006...)

[former_member190508]

Hi Vision,

If the requiremnet is to plan for 24 months starting from the current month, then the easiest way would be to have client enter the current period/year on the screen instead of just the year.

Or the administrator can maintain the current period/year every month in that variable and the user need not enter anything.

Or alternatively, can you have your exit derive the current period/year.

Mohit

[former_member190508]

I am not very clear about the user requirement.

But if it is to show 24 months starting from the beginning of the year, then one way is:

1) use fiscper variable

2) User provides value to this variable

3) Possible values of this variable should be 001/2006, 001/2007 etc.

4) Derive other 23 periods by using offset

5) The text will have month/year

6) use the exit function to also derive year and period.

[Former Member]

Hi Mohit Tripathi.

I can't use 0FISCPER variable because the 24 months start in actual month and not in beginning of the year, to do this I use the 0FISCPER3 and 0FISCYEAR with EXIT variables to take the actual month and make an off-set 24 months. My problem is because the user will select just the year to plan.

[cynara_kidwell]

Hi Vision,

Regardless of how you get you start year/month combinations (0FISCYEAR , 0FISCPER, 0FISCPER3..). These variable values can be read in a user exit function to populate a user exit variable for 0FISCPER, that generates a 24 month range for 0FISCPER, starting from the start month. This 0FISCPER variable can be used in your layout.

Cynara

[Former Member]

Hello all. ((Shade Adekoya, Cynara Kidwell, Mohit Tripathi)

I made an EXIT function and solv the problem, wasn't right because my FM was wrong, I was using a variable type n with (2) (data month(2) type n), but fiscper3 is with 3, so, the value never would show in columns. Now is working.

Thank all you.

With regards.

Fábio P. Copetti

Consultor BI S.A.P

BI-One - Brazil

[cynara_kidwell]

I would recommend using the infoObject 0FISCPER, it automatically displays in the format PPP/YYYY. If you need to also fill 0FISCPER3 and 0FISCYEAR, do it through the a characteristic combination using the included exit functions UPF_TIME_EXIT_FISC*.

[Former Member]

Hi Cynara Kidwell.

Thanks for your reply.

But the user select in the dropdown just the year, and through EXIT variables in the data columns I make the columns that I need, put 0FISCYEAR with 24 variables and 0FISCPER3 with off-set. I need a way to concatenate the descriptions of the 0FISCYEAR and 0FISCPER3 in the title of the data columns, like 001/2006.