topic Re: Problem in where condition - with range table ? in Application Development and Automation Discussions

Problem in where condition - with range table ?

Former Member — Wed, 21 Mar 2007 13:18:43 GMT

I am writing this code in BADI....

I have problem with the bold part of coding below

( SELECT uzawe

UP TO 1 rows

FROM lfb1

INTO wa_uzawe

WHERE lifnr = i_rbkpv-lifnr " bseg-lifnr

AND bukrs IN r_bktxt.

ENDSELECT. )

Could you please correct why below bukrs IN r_bktxt has problem ?

DATA : wa_zcharval1 TYPE zkap-zcharval1,

r_bktxt TYPE RANGE OF lfb1-bukrs,

wa_bktxt LIKE LINE OF r_bktxt.

wa_bktxt-sign = 'I'.

wa_bktxt-option = 'BT'.

SELECT zcharval1 INTO wa_zcharval1

FROM zkap

WHERE zcharfld1 = 'U319'

AND zcharfld2 = 'ACTIVE_BUKRS'

AND znumfld1 = '0'

AND zseqno = '0'.

wa_bktxt-low = wa_zcharval1.

APPEND wa_bktxt TO r_bktxt.

CLEAR : wa_bktxt .

ENDSELECT.

IF r_bktxt[] IS NOT INITIAL.

SELECT uzawe

UP TO 1 rows

FROM lfb1

INTO wa_uzawe

WHERE lifnr = i_rbkpv-lifnr " bseg-lifnr

AND bukrs IN r_bktxt.

ENDSELECT.

ENDIF.

Re: Problem in where condition - with range table ?

RichHeilman — Wed, 21 Mar 2007 13:22:38 GMT

If you are not providing the HIGH side of the range, you must use the EQ as your option.


wa_bktxt-sign = 'I'.
wa_bktxt-option = 'EQ'.        "<-   RIGHT HERE
 SELECT zcharval1 INTO wa_zcharval1
FROM zkap
WHERE zcharfld1 = 'U319'
AND zcharfld2 = 'ACTIVE_BUKRS'
AND znumfld1 = '0'
AND zseqno = '0'.

wa_bktxt-low = wa_zcharval1.
APPEND wa_bktxt TO r_bktxt.
CLEAR : wa_bktxt .
ENDSELECT.

Regards,

RIch Heilman

Re: Problem in where condition - with range table ?

Former Member — Wed, 21 Mar 2007 13:23:09 GMT

Hi,

Please try this.

...

wa_bktxt-sign = 'I'.

wa_bktxt-option = 'EQ'.

...

Why don't you use ranges for r_bktxt?

ranges: r_bktxt for lfb1-bukrs.

Regards,

Ferry Lianto

Re: Problem in where condition - with range table ?

Former Member — Wed, 21 Mar 2007 13:24:30 GMT

Hi Sam,

Reason1. The type of the range r_bktxt and BUKRS may be different. Can you show how have you declared r_bktxt?

Reason2) The number of entries in the ranges table whould not be more than 1000.

You should use for all entries instead of ranges if that is the case.

Regards,

Ravi

Re: Problem in where condition - with range table ?

Former Member — Wed, 21 Mar 2007 13:28:33 GMT

HI Sam,

do this way ..


 wa_bktxt LIKE LINE OF r_bktxt.
wa_bktxt-sign = 'I'.
wa_bktxt-option = 'EQ'.

Regards,

Santosh