Bex - Use of Variable for multiple results

[Former Member]

Hello guys, I need to create a query in Bex with this structure:

Rows:

- 0FISCPER

Columns: Restricted Key Figure

- 0AMOUNT

- 0PSTN_DATE (filtered by a variable having the last day of each 0FISCPER).

I don't know how to give logic to the user exit variable to determine the last day of each 0FISCPER in the rows. I've done similar variables with only one possible value as result, but this is a new scenario for me.

Is this possible to be done?

thanks in advance,

Mariano.

[Former Member]

Hi Mariano

I think that you have tu use the Function Module 'LAST_DAY_IN_PERIOD_GET ' this module will take Fiscal Year, Fiscal Year Variant and Period as input, and it will give the last day/date of that Fiscal year period

The step by step will this:

1) create an exit variable with opcion processing by Customer Exit

2) If you need create also a variable for user input and make reference to variable with customer exit. If this is not the case forget this step.

3) Goto CMOD TCode in SAP-BW/BI and then give your Project Name and click on Change button.

4) Click on Components

5) Double Click on INCLUDE ZXRSRU01.

6) there you have to write de abap code using the CALL FUNCTION 'LAST_DAY_IN_PERIOD_GET'

If you need i can write you in spanish.

Hope this helps

Natalia.