topic Re: select statement in Application Development and Automation Discussions

select statement

Former Member — Sat, 11 Nov 2006 09:29:00 GMT

Dear abaper,

I declared one range r_wrks.

I am using that in select statement its giving DUMP

SELECT SINGLE BSART FRGKZ RESWK

FROM EBAN

INTO (W_BSART,X_FRGKZ,X_RESWK)

WHERE BANFN = EBAN-BANFN

AND BNFPO = EBAN-BNFPO

AND ( RESWK = '098' OR RESWK = '099' OR RESWK IN R_WRKS )

AND EKGRP BETWEEN '110' AND '220'.

This above select statement giving dump as

"Value table for IN itab operator has an unexpected format."

Plz lemme know how to declare

Re: select statement

Former Member — Sat, 11 Nov 2006 09:35:11 GMT

RANGES R_WRKS FOR EBAN-RESWK.

But the problem should be how you fill the range and not how you have declared it.

Post your code where you fill the range.

Max

Re: select statement

Former Member — Sat, 11 Nov 2006 09:37:28 GMT

Can u send total Code.

Murthy

Re: select statement

Former Member — Sat, 11 Nov 2006 09:41:07 GMT

hi Shakya,

Try to append the values for '098' and '099' of RESWK to R_WRKS and refine your select statement as given below:

SELECT BSART FRGKZ RESWK FROM EBAN upto 1 rows

INTO (W_BSART,X_FRGKZ,X_RESWK)

WHERE BANFN = EBAN-BANFN AND

BNFPO = EBAN-BNFPO AND

RESWK IN R_WRKS AND

EKGRP BETWEEN '110' AND '220'.

Hope this will work.

Sajan.

Re: select statement

anversha_s — Sat, 11 Nov 2006 09:43:00 GMT

Hi,

chk a sample code.

Define a range:

Ranges: r_field for <table>.

if not field1 is initial.
r_field-sign = 'I'.
r_field-option = 'EQ'.
r_field-option-low = field1.
append r_field.
endif.

if not field2 is initial.
r_field-sign = 'I'.
r_field-option = 'EQ'.
r_field-option-low = field2.
append r_field.
endif.

if field1 is initial and field2 is initial.
r_field-sign = 'I'.
r_field-option = 'EQ'.
append r_field.
endif.

select * from <table> where field1 in r_field.

regards

Anver

if hlpful pls mark points

Re: select statement

Former Member — Sat, 11 Nov 2006 09:57:39 GMT

<b>RESWK = '0098' OR RESWK = '0099' OR RESWK IN R_WRKS</b>

<b>reswk is 4 in length</b>

substitute this and see ..

vijay

a view of the code ,,

tables : eban.

data : w_bsart like eban-bsart,

w_frgkz like eban-frgkz,

w_reswk like eban-reswk.

ranges rwrks for eban-reswk.

rwrks-sign = 'I'.

rwrks-option = 'EQ'.

rwrks-low = '0098'.

rwrks-high ='0099'.

append rwrks.

SELECT SINGLE BSART FRGKZ RESWK

FROM EBAN

INTO (W_BSART, w_FRGKZ, w_RESWK)

WHERE BANFN = EBAN-BANFN

AND BNFPO = EBAN-BNFPO

AND ( RESWK = '0098' OR RESWK = '0099' OR RESWK IN RWRKS )

AND EKGRP BETWEEN '110' AND '220'.

Message was edited by:

Vijay k