table

[Former Member]

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

[agnihotro_sinha2]

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.

[Former Member]

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

[Former Member]

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...

[Former Member]

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

[matt]

Please use a meaningful subject for your questions