How do I filter Calendar Date by Fiscal Period?
I have a BEx query which I need to filter. The query has a ready for input variable for Fiscal Period and contains records with a Calendar Date. Our Fiscal Year variant is K0 and matches the calendar year. The requirement is for the Calendar Date records to be filtered by the Fiscal Period variable. For example, if the user selects Fiscal Period 009/2014, the query should return only records with a Calendar Date greater than 09/30/2014, which is the last day of the period. I am familiar with the function module LAST_DAY_IN_PERIOD_GET but am not sure how I could leverage that in my case.
Loed Despuig replied
Create a customer exit for the filter of your CALENDAR DATE..Let's say, the variable used were VAR_FP and VAR_CD for FISCAL PERIOD and CALENDAR DATE, respectively..This will be your user exit..
*there is a code here something like this.....WHERE VARIABLE = 'VAR_FP'
*sorry, i'm at home so I can't remember exactly the codes
*just check the user exit in your system to know what i'm talking
data: temp_date like sy-datum.
CONCATENATE your_variable_low(4) your_variable_low+5(2) '01' into temp_date.
CALL FUNCTION 'SLS_MISC_GET_LAST_DAY_OF_MONTH'
day_in = temp_date
last_day_of_month = VAR_CD
"DAY_IN_NOT_VALID = 1
Just post here if you have query regarding my post..