topic Re: Selection screen range in Application Development and Automation Discussions

Selection screen range

Former Member — Tue, 11 May 2010 03:46:15 GMT

Hi Folks,

In my selection screen iam selecting range of posting period(YYYYMM).i want to fetch the document no(belnr) from bkpf, in bkpf v dnt have posting period field so v have to take year in gjahr and month in monat.so for year and month im taking range tables and the my code is as follows..

{

IF NOT s_period[] IS INITIAL.

LOOP AT s_period.

*Year

r_gjahr-sign = s_period-sign.

r_gjahr-option = s_period-option.

r_gjahr-low = s_period-low+0(4).

r_gjahr-high = s_period-high+0(4).

APPEND r_gjahr. CLEAR r_gjahr.

Month

r_monat-sign = s_period-sign.

r_monat-option = s_period-option.

r_monat-low = s_period-low+4(2).

r_monat-high = s_period-high+4(2).

APPEND r_monat. CLEAR r_monat.

CLEAR s_period.

ENDLOOP.

ENDIF.

Get the Accounting Doc

SELECT belnr FROM bkpf INTO TABLE gt_bkpf WHERE bukrs = p_bukrs AND

gjahr IN r_gjahr AND

monat IN r_monat.

}

but i want as for example in selection screen if 200904 201002

it has to fetch the document numbers between apr01 2009 to feb 28 2010.

how can i achieve this please give some inputs <removed by moderator>

Thanks

Edited by: Thomas Zloch on May 11, 2010 7:49 AM

Re: Selection screen range

Former Member — Tue, 11 May 2010 04:15:00 GMT

Hi,

I think we can get:

- First day of s_period-low

- Last day of s_period-high

so we can build a range of first day - last day for selection.

That was my suggestion, please discuss.

Thanks,

Thien

Re: Selection screen range

former_member194669 — Tue, 11 May 2010 04:18:26 GMT

Try this way


concatenate r_gjahr-low r_monat-low '01' into v_date_low.

v_month = r_monat-high + 1.

concatenate r_gjahr-high v_month '01' into v_date_high.

v_date_high = v_date_high - 1.

If user enter exclude values in your range , then your have problem

a®

Re: Selection screen range

Former Member — Tue, 11 May 2010 04:23:16 GMT

Hi,

what you told is exactly my requirement,but how to build a range of the first day-last day of selection.

Please help me it is very urgernt.

Thx.

Re: Selection screen range

Former Member — Tue, 11 May 2010 04:26:38 GMT

Hi,

Do your work as a®s said. It's what I have said.

Thank a®s for clearing code.

BR,

Thien

Re: Selection screen range

Former Member — Tue, 11 May 2010 04:42:07 GMT

Hi,

Thanks for ur replies a®s and Thien..stil i have got one doubt.i got the firstday of low value and last day of the high value.

but where can i use this dates. and in my select statement i want to use the index 002 of bkpf.where exactly i can use these low and high dates.please explain me.

Thanks.

Re: Selection screen range

Former Member — Tue, 11 May 2010 04:48:21 GMT

Hi,

To me, I think you can pass this selection to Posting date (field BUDAT), that meets your requirement above.

BR,

Thien

Re: Selection screen range

Former Member — Tue, 11 May 2010 04:51:04 GMT

HI Thein,

but which one i have to pass budat = v_date_low or v_Date_high.

Please advice.

Thanks.

Re: Selection screen range

Former Member — Tue, 11 May 2010 05:14:40 GMT

Hi,

Please can anyone help on this.

Thanks

Re: Selection screen range

Former Member — Tue, 11 May 2010 05:20:37 GMT

Hello,

If you need data between the date range and you have a range created for BUDAT, assign Low as the lower value and high with the higher value and set OPTION as BT. Now pass the range to BUDAT field in the select query.

select fields into table where budat IN r_budat.

where r_budat-low = lower value

r_budat-high = higher value

r_option = 'BT'

r_sign = 'I'.

select fields into table where budat between v_low and v_high.

Hope this helps

Regards

Sachin

Re: Selection screen range

Former Member — Tue, 11 May 2010 05:22:45 GMT

Hi swetha,

Please build a range of the v_date_low and v_date_high.

Example:


RANGE r_date for bkpf-bdat.

r_date-sign , r_date-options must meet sign and option of s_period that user enter in selection-screen. You must take care of this case if you don't want your report turn to wrong.


r_date-low = v_date_low
r_date-high = v_date_high.

This is a solution not a real correct code, your implementation must check some cases on this.

Hope this help.

BR,

Thien

Re: Selection screen range

Former Member — Tue, 11 May 2010 05:24:52 GMT

Hi,

Thanks for everyone.i got the solution.

closing.