Skip to Content
0
Former Member
Feb 23, 2006 at 05:44 AM

ranges not working

856 Views

I have doubt about ranges statement

my query is the below

SELECT * FROM t077s WHERE ktopl EQ 'NCCA' AND

ktoks IN ('CONS','CONT','INVY').

t_hkont-sign = 'I'.

t_hkont-option = 'BT'.

t_hkont-low = t077s-bisnr.

t_hkont-high = t077s-vonnr.

APPEND t_hkont.

ENDSELECT.

SELECT * FROM bseg INTO CORRESPONDING FIELDS OF table

t_bseg

WHERE

**************when removing this like its working*

hkont in t_hkont AND

**************but records there in db for this range***

gjahr EQ p_gjahr AND

bukrs EQ 'NCCP' AND

bschl IN

('89','99','86','96','40','50') AND

augbl EQ space AND

bustw EQ 'WE01'.

that t_hkont table having three rows

Kindly advise me how to handle..

prakash