please validate my select query with offset

[Former Member]

Could you please validate my select query below :

AND kadky+0(4) IN s_gjahr is correct ?

=====================================

SELECT-options:

s_gjahr FOR ckhs-gjahr NO-EXTENSION NO INTERVALS OBLIGATORY DEFAULT sy-datum+0(4).

SELECT bzobj

kalnr

kalka

kadky

tvers

bwvar

kkzma

matnr

werks

feh_sta

FROM keko

INTO TABLE i_keko

FOR ALL ENTRIES IN i_mackw

WHERE matnr = i_mackw-matnr

AND werks = i_mackw-werks

AND kadky+0(4) IN s_gjahr <==

AND ( feh_sta = 'FR'

OR feh_sta = 'VO' )

[Former Member]

Not passed syntax check.

My intention is to select records from keko table based on the year entered and also previous to the year entered on the selection screen.

Like

s_gjahr_1 = s_jahr -1.

*-KEKO

SELECT bzobj

kalnr

kalka

kadky

tvers

bwvar

kkzma

matnr

werks

feh_sta

FROM keko

INTO TABLE i_keko

FOR ALL ENTRIES IN i_mackw

WHERE matnr = i_mackw-matnr

AND werks = i_mackw-werks

AND ( kadky+0(4) IN s_gjahr

OR kadky+0(4) IN s_gjahr_1 )

AND ( feh_sta = 'FR'

OR feh_sta = 'VO' )

[Former Member]

Does it pass a syntax check?

Rob

[Former Member]

Not passed syntax check.

My intention is to select records from keko table based on the year entered and also previous to the year entered on the selection screen.

Like

s_gjahr_1 = s_jahr -1.

*-KEKO

SELECT bzobj

kalnr

kalka

kadky

tvers

bwvar

kkzma

matnr

werks

feh_sta

FROM keko

INTO TABLE i_keko

FOR ALL ENTRIES IN i_mackw

WHERE matnr = i_mackw-matnr

AND werks = i_mackw-werks

AND ( kadky+0(4) IN s_gjahr

OR kadky+0(4) IN s_gjahr_1 )

AND ( feh_sta = 'FR'

OR feh_sta = 'VO' )

[Former Member]

Replace the values in s_gjahr_1 with wildcard characters (single character wildcard) and take the offset off of kadky.

Rob

[Former Member]

i am sorry - I did not get you.

kadky is of 'DATS' type.

and I am using year to select records from KEKO-kadky.

[Former Member]

Well then, make your SELECT OPTION a date range rather than a year range.

Rob

[Former Member]

the requirement is not date range .

Functional requirement is year range in selection options

like this

s_gjahr FOR ckhs-gjahr NO-EXTENSION NO INTERVALS OBLIGATORY

[Former Member]

You can easily build a date range table from the year SELECT OPTION.

Rob

[Former Member]

Hi,

Use the below code.

ranges: r_gjahr for ckhs-gjahr.

r_gjahr-low = s_gjahr-low.

r_gjahr-sign = 'I'.

r_gjahr-option = 'EQ'.

append r_gjahr.

r_gjahr-low = s_gjahr-low - 1.

r_gjahr-sign = 'I'.

r_gjahr-option = 'EQ'.

append r_gjahr.

SELECT bzobj

kalnr

kalka

kadky

tvers

bwvar

kkzma

matnr

werks

feh_sta

FROM keko

INTO TABLE i_keko

FOR ALL ENTRIES IN i_mackw

WHERE matnr = i_mackw-matnr

AND werks = i_mackw-werks

AND ( feh_sta = 'FR'

OR feh_sta = 'VO' ).

if sy-subrc = 0.

delete i_keko where not kadky+0(4) IN r_gjahr.

endif.

Regards,

Kumar Bandanadham

Edited by: Velangini Showry Maria Kumar Bandanadham on May 28, 2009 7:37 AM