11-28-2008 11:26 AM
Moderator message: in future please use a meaningful subject for your questions
Hii
i want
month,
year,
number of days in month
there is a table 'T009B' but joining is not possible in this..
can anyone suggest me any other table for the same
thanks
Edited by: aks on Nov 28, 2008 6:27 AM
Edited by: Matt on Nov 28, 2008 3:59 PM
11-28-2008 11:30 AM
try FM 'FIRST_DAY_IN_PERIOD_GET'
you can also do a daymon* and F4 help in SE37...
you will get many FM...
pick according to requirement.
ags.
11-28-2008 11:53 AM
HI
use table T247 to get months
for dates of a month you need to use a FM search for it SE37
Hope this will be useful for you
Regards
Ramchander Rao.K
11-28-2008 12:04 PM
HI...
Try this FM to get the required data....
CALL FUNCTION 'LAST_DAY_OF_MONTHS' "#EC
EXPORTING
day_in = p_period
IMPORTING
last_day_of_month = p_period_out
EXCEPTIONS
day_in_no_date = 1
OTHERS = 2.
CALL FUNCTION 'HR_SGPBS_YRS_MTHS_DAYS'
EXPORTING
beg_da = p_begda
end_da = p_stat_date
IMPORTING
NO_DAY =
NO_MONTH =
NO_YEAR =
no_cal_day = p_no_day
EXCEPTIONS
dateint_error = 1
OTHERS = 2
Use T247 table to get the Month text...
11-28-2008 12:23 PM
These FMs may help
HR_SGPBS_YRS_MTHS_DAYS
DATE_COMPUTE_DAY: Returns weekday for a date
MONTH_NAMES_GET: Get the names of the month
Regards,
Prashant
11-28-2008 3:00 PM