query

[Former Member]

I have an order no 0000162698.

In the search criteria i have to find the orders between 000016000000 and 000016999999.

and i have a condition

SELECT * FROM /sapapo/ordkey INTO TABLE et_ordkey

CONNECTION (om_lc_name)

WHERE simid = iv_simid

AND ordno IN lr_ordno.

But this search criteria returns the order no 0000162698 which is incorrect.

please tell me how to modify the query.....

so that it des not return the order no 0000162698

[former_member583456 · Accepted solution]

Hi Rekha,

in order to answer the question I would need the exact content of lr_ordno.

I can give you some hints in advance: ORDNO is of type CHAR12, so you cannot have an order 0000162698. Either you have 000000162698 or you have 000016269800 (or __0000162698 / 0000162698__). Please check.

Best regards

Thomas