topic Re: Report in Application Development and Automation Discussions

Report

Former Member — Tue, 05 Dec 2006 05:38:29 GMT

I've select option in which I want first date of the current month in LOW of select option and Last date of current month in HIGH of select month.

How can i achieve that?

Re: Report

Simha_ — Tue, 05 Dec 2006 05:44:18 GMT

Hi,

U can achieve this by using the variant ,

create the variant and then u go in to the selections S, in the variant and then u go to dynamic date caluculations,

there u can able to see many options for date..

Or u can assign it manually in the <b>Initialization</b> event.

Taking the values of the select-options low and high values...

Cheers,

Simha.

Re: Report

Former Member — Tue, 05 Dec 2006 05:52:05 GMT

In the initilization write so-low = sy-datum,

so-high = sy-datum etc.

Re: Report

Former Member — Tue, 05 Dec 2006 06:00:22 GMT

U can use Fm HR_JP_MONTH_BEGIN_END_DATE to get first and last day of the month and then you can use initialization event to set these values for select options.

Try below code:

SELECT-OPTIONS: s_date FOR sy-datum.

DATA: s_date_low TYPE d, s_date_high TYPE d.

INITIALIZATION.

CALL FUNCTION 'HR_JP_MONTH_BEGIN_END_DATE'

EXPORTING

iv_date = sy-datum

IMPORTING

ev_month_begin_date = s_date_low

ev_month_end_date = s_date_high.

s_date-low = s_date_low.

s_date-high = s_date_high.

APPEND s_date.

I hope it helps.

Best Regards,

Vibha

<b>*Please mark all the helpful answers</b>

Re: Report

Former Member — Tue, 05 Dec 2006 06:17:20 GMT

Hello,

First of all use the FM , 'HR_JP_MONTH_BEGIN_END_DATE' t get the begining and ending dates of a month and then initalize the HIGH and LOW option of the SELECT-OPTIONS , like this

INITIALIZATION.

s_var-low = .. " begining date

s_var-high = .. " ending date

where S_VAR is the select-options variable declared.

Regards,

Shehryar Dahar

Re: Report

Former Member — Tue, 05 Dec 2006 09:32:13 GMT

is there any other function module because the function module 'HR_JP_MONTH_BEGIN_END_DATE' doesnt exist in my system?