topic Re: table in Application Development and Automation Discussions

table

Former Member — Fri, 28 Nov 2008 11:26:57 GMT

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

Re: table

agnihotro_sinha2 — Fri, 28 Nov 2008 11:30:20 GMT

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.

Re: table

Former Member — Fri, 28 Nov 2008 11:53:07 GMT

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

Re: table

Former Member — Fri, 28 Nov 2008 12:04:21 GMT

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

Re: table

Former Member — Fri, 28 Nov 2008 12:23:33 GMT

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

Re: table

matt — Fri, 28 Nov 2008 15:00:59 GMT

Please use a meaningful subject for your questions