Need a FM for gettng starting & ending date based on the settlement period
I have to filter a database table based on the settlement period( IDENT3 ) and the field available is of date field. Can anyone give me a function module by which can calculate the starting date and ending date by providing the settlement period ( eg. AM- Monthly, AQ- Quarterly, AJ- Annually, etc ) and date.
Thanx in advance.
senthil kumar replied
Please use the function module 'DATE_CONVERT_TO_FACTORYDATE' to get the start date and end date for the particular factory calender.
For end date:
For start date:
According to sy-datum, it will calculate the Extreme interval .