topic Re: please validate my select query with offset in Application Development and Automation Discussions

please validate my select query with offset

Former Member — Wed, 27 May 2009 19:53:52 GMT

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' )

Re: please validate my select query with offset

Former Member — Wed, 27 May 2009 20:00:47 GMT

Does it pass a syntax check?

Rob

Re: please validate my select query with offset

Former Member — Wed, 27 May 2009 20:07:59 GMT

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.

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' )

Re: please validate my select query with offset

Former Member — Wed, 27 May 2009 20:15:25 GMT

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

Rob

Re: please validate my select query with offset

Former Member — Wed, 27 May 2009 20:22:48 GMT

i am sorry - I did not get you.

kadky is of 'DATS' type.

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

Re: please validate my select query with offset

Former Member — Wed, 27 May 2009 20:26:22 GMT

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

Rob

Re: please validate my select query with offset

Former Member — Wed, 27 May 2009 20:39:24 GMT

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

Re: please validate my select query with offset

Former Member — Wed, 27 May 2009 20:57:16 GMT

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

Rob

Re: please validate my select query with offset

Former Member — Thu, 28 May 2009 05:36:21 GMT

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