Skip to Content

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

Need a FM for gettng starting & ending date based on the settlement period

Hi,

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.

Regards,

Sumanth.

Tags:
Former Member
Former Member replied

Hi Sumanth,

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:

CORRECT_OPTION +

DATE sy-datum

FACTORY_CALENDAR_ID Aq(quaterly)

For start date:

CORRECT_OPTION -

DATE sy-datum

FACTORY_CALENDAR_ID Aq(quaterly)

According to sy-datum, it will calculate the Extreme interval .

Thanx,

Zenthil.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question