Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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.

Tags:
Former Member
replied

Hi Derrick,

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'

  EXPORTING

  day_in = temp_date

  IMPORTING

  last_day_of_month = VAR_CD

  "EXCEPTIONS

  "DAY_IN_NOT_VALID = 1

Just post here if you have query regarding my post..

Regards,

Loed

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question