Calender Calculation - Fiscal yr Variant

[Former Member]

Hello Gurus,

I am back after long time...i have query and i am wondering how to write a logic behind tat.

I have to prepare FS for sales report.

My query is...

I have a input parameter - Reporting DATE - consider a date..user can put any date...single entry. DATE - 21/12/2012

Based on the reporting date.

Get the data from VBEP to get the schedule line date EDATU.

line item 10 - schedule line date - 10/01/2013 which is for nex month.

User defined fiscal year calender .i.e based on 5 4 4... 5 months in jan etc...

from Functional module ABaper can able to get data based on the the week nos ...1st week...2nd week,   3rd week.   4th week...5th week..

say input parameter from 2nd week Jan 2012 to 5th week Jan 2012

ABaper can fetch record based on the above input parameter...

My issue is ....to

How to achieve this..

System should calculate the end of the month based on weeks defined..

say jan has 5weeks...

5th week ends on 3rd of Feb

so i need to determine tat 3rd of feb is my end of the month...

once i get a logic to find end of the month i can get my above report

Pls suggest.

Thanks in advance

Shri...

Message was edited by: Shri Yeru

[Former Member]

if you can get 5th week, your abaper should be able to get last day of the month in Jan. Then do a check if day of the week (FM DATE_COMPUTE_DAY returns not 7) is not sunday, add 1 day until 7 to get end result of 3rd Feb 2013.

[Former Member]

Hi

Shri Yeru

RP_LAST_DAY_OF_MONTHS

OIUREP_MONTH_FIRST_LAST

OIUREP_MONTH_FROM_DATE

OIL_LAST_DAY_OF_MONTH

OIL_MONTH_GET_FIRST_LAST

HR_IN_LAST_DAY_OF_MONTHS

HR_99S_MONTHS_BETWEEN_DATES

JVA_LAST_DATE_OF_MONTH

RE_ADD_MONTH_TO_DATE

RE_LAST_DAY_OF_MONTH

END_OF_MONTH_DETERMINE

FIMA_END_OF_MONTH_DETERMINE

BKK_GET_MONTH_LASTDAY

COCF_MD_GET_LAST_DAY_OF_MONTH

CACS_CALC_END_DATE_OF_MONTH

SG_PS_GET_LAST_DAY_OF_MONTH

Please check out this function module, may be this resolve your issue.

With Regards

Mohammed Khurshed

[jignesh_mehta3]

Hello Shri,

Have you spoken to your ABAPer regarding this? I feel he will have a good idea on how to achieve this automatic calculation of end week / date.

Thanks,

Jignesh Mehta