topic Re: a month selection in Application Development and Automation Discussions

a month selection

Former Member — Fri, 12 Sep 2008 09:06:16 GMT

hello everyone,

i need to make a selection of a number of a mounth ( Mounth 6 or 7 or 8 ) but the problem is that in the database table (bkpf) we have an entire date (DD/MM/YYYY) , how to do to make a select and the parameter of month selection is the number of the mounth.

thank you.

Re: a month selection

JozsefSzikszai — Fri, 12 Sep 2008 09:09:29 GMT

hi,

there are two ways to go:

1. convert the month to dates (I hope you have year as well), you can use FMs FIRST_DAY_IN_PERIOD_GET and LAST_DAY_IN_PERIOD_GET.

2. use field MONAT (which stands for month) form table BKPF

hope this helps

Re: a month selection

Former Member — Fri, 12 Sep 2008 09:10:31 GMT

IN PARAMETERS TAKE 2 CHAR..

THEN WHILE VALIDATING TAKE ENTIRE DATE

THEN USE LIKE THIS TO GET MONTH

DATE3(2)

Re: a month selection

prasanth_kasturi — Fri, 12 Sep 2008 09:10:33 GMT

hi,

bring the date from database and use the OFFSET to get the month

month = date+4(2).

and you have the number of the month

regards

prasanth

Re: a month selection

Former Member — Fri, 12 Sep 2008 09:10:47 GMT

Hi,

Try this way

Parameters:p_month(2) type c.

Data:w_date type sy-datum.

Concatenate '%' p_month '%' into w_date.

Select * from BKPF into table itab where date like w_date.

Regards,

Sujit

Re: a month selection

Former Member — Fri, 12 Sep 2008 09:12:35 GMT

for each month selected put de first date of the month and the last day of the month in a range with BETWEEN. Use the range in the where clause of the select.

Best Regards

Guido

Edited by: G. Bouman on Sep 12, 2008 11:12 AM

Re: a month selection

Former Member — Fri, 12 Sep 2008 09:14:03 GMT

Hi,

Just select all by other criteria as "fetch".

LOOP AT itab.

IF itab-date+4(2) NE parameter_date.

DELETE itab.

ENDIF.

ENDLOOP.

Regards,

Alin.

Re: a month selection

Former Member — Fri, 12 Sep 2008 09:14:32 GMT

Hi,

we ca use the offset concept to find the month and store in some other variable.

example:

date is dd/mm/yyyy.

then var1 = date+0(3).

this will give month.

thanx.

Re: a month selection

Former Member — Wed, 05 Nov 2008 16:24:41 GMT

Re: a month selection

JozsefSzikszai — Wed, 05 Nov 2008 16:37:59 GMT

what is ok after two months?

Re: a month selection

Former Member — Wed, 05 Nov 2008 16:41:07 GMT

no answer.

i've received no response

Re: a month selection

JozsefSzikszai — Wed, 05 Nov 2008 16:44:58 GMT


> no answer.
> i've received no response

I think this is the joke of the year... you got eigth answers...

Re: a month selection

Former Member — Wed, 05 Nov 2008 16:56:37 GMT

Actually he meant :

i've received no(Nine in hindi) response

I think this is the joke for the seconds... he got no(Nine) answers now(including mine)...;-)

Cheers