topic Re: need function module in Application Development and Automation Discussions

need function module

Former Member — Mon, 29 Jan 2007 04:42:19 GMT

is there any function module that gives previous month and year? for eg. if the input is 01.2007 (monyr), 12.2006 should be exported..thanks

Re: need function module

Former Member — Mon, 29 Jan 2007 04:48:21 GMT

RS_VARI_V_L_LAST_MONTH Returns last day of last month.

RS_VARI_V_1_LAST_MONTH Returns first day of the last month.

Re: need function module

Former Member — Mon, 29 Jan 2007 04:49:56 GMT

Hi sathish,

u just have to give the date from which u have to go back and the number of months..in th follwing fm

CCM_GO_BACK_MONTHS

from the exported value u can take the year or month or both

hope this helps,

all the best,

sampath

award points if helpful

Re: need function module

Former Member — Mon, 29 Jan 2007 04:52:41 GMT

Hi Sathish,

U can use BKK_ADD_MONTH_TO_DATE.

Pass the old date and months to be added as '-1'. Suppose if u pass old date as 01.01.2007 and months as '-1', then ur output will be 01.12.2006. Take only the month and year.

-Satya Priya

Re: need function module

learnsap — Mon, 29 Jan 2007 04:54:01 GMT

Hi Satish,

Try these function modules.

RS_VARI_V_1_LAST_MONTH

RS_VARI_V_LAST_MONTH

RS_VARI_V_L_LAST_MONTH

Regards,

Ramesh

*If reply is helpful award the points

Re: need function module

Former Member — Mon, 29 Jan 2007 04:58:57 GMT

Hi,

Use this FM.

CALCULATE_DATE.

CALL FUNCTION 'CALCULATE_DATE'

EXPORTING

DAYS = '0'

MONTHS = '-1'

START_DATE = SY-DATUM

IMPORTING

RESULT_DATE = lv_date.

write lv_date+0(4).

write lv_date+4(2).

Rgds,

Prakash

Re: need function module

Former Member — Mon, 29 Jan 2007 05:06:53 GMT

hi sathish,

the function module RS_VARI_V_LAST_MONTH will give u the previous month

Re: need function module

Former Member — Mon, 29 Jan 2007 05:15:52 GMT

hi,

this does it without a FM.

Try out.

DATA: fdate TYPE sy-datum.

parameter: ldate TYPE sy-datum.

WRITE:/ 'Current Date - ', ldate.

ldate+6(2) = '01'.

ldate = ldate - 1.

fdate = ldate.

fdate+6(2) = '01'.

WRITE:/ 'First Date - ' , fdate.

WRITE:/ 'Last Date - ' , ldate.

Reward points if helpful,

Bijal

Re: need function module

anversha_s — Mon, 29 Jan 2007 05:16:37 GMT

hi,

just try this.

data: wa_date like sy-datum.
data: month(2),      
year(4).
call function 'RP_CALC_DATE_IN_INTERVAL'
exportingdate = sy-datum
days = 0
months = 1
signum = '-'
years = 0
importing
calc_date = wa_date.

month = wa_date+4(2).
year = wa_date+0(4).

Regards

Anver

Re: need function module

anversha_s — Mon, 29 Jan 2007 05:16:41 GMT

hi,

just try this.

data: wa_date like sy-datum.
data: month(2),      
year(4).
call function 'RP_CALC_DATE_IN_INTERVAL'
exportingdate = sy-datum
days = 0
months = 1
signum = '-'
years = 0
importing
calc_date = wa_date.

month = wa_date+4(2).
year = wa_date+0(4).

Regards

Anver

Re: need function module

Former Member — Mon, 29 Jan 2007 05:18:04 GMT

Hi Sathish,

check out these fm:

CCM_GO_BACK_MONTHS

RS_VARI_V_LAST_MONTH

CALCULATE_DATE

this will give you the previous month.

Re: need function module

Former Member — Mon, 29 Jan 2007 05:25:20 GMT

friends,

thanks for your answers...i was expecting a fm that would only return previous monyr (200612 if i give 200701)..but anyway, i can use any of your fms and get the result..BKK_ADD_MONTH_TO_DATE seems to be simple as there are only 2 import parameters