a month selection

[Former Member]

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.

[JozsefSzikszai]

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

ec

[Former Member]

IN PARAMETERS TAKE 2 CHAR..

THEN WHILE VALIDATING TAKE ENTIRE DATE

THEN USE LIKE THIS TO GET MONTH

DATE3(2)

[prasanth_kasturi]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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.

[Former Member]

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.

[Former Member]

ok

[JozsefSzikszai]

what is ok after two months?

[Former Member]

no answer.

i've received no response

[JozsefSzikszai]

>

> no answer.
> i've received no response

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

[Former Member]

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