topic Re: problem with select in Application Development and Automation Discussions

problem with select

Former Member — Tue, 06 Jun 2006 15:00:03 GMT

i make a query in se16 for table ESSR

and make the select in the same conditions as in se16

and get another results why???

select lblni ebeln ebelp banfn bnfpo packno

from essr

into corresponding fields of table itab

where erdat in zerdat

and loekz = ' '

and kzabn = 'X'

and frgrl = ' '

and knttp = 'F'.

and f_lock = ' '

and banfn <> ' '

and bnfpo <> ' '.

and frggr = 'CS'.

Re: problem with select

rahulkavuri — Tue, 06 Jun 2006 15:04:16 GMT

I think the Client number may be the problem...

Re: problem with select

Former Member — Tue, 06 Jun 2006 15:04:25 GMT

Hi Rani,

Are you sure that the underlying SQL passed to the database by the SAP database managment layer is identical in both cases ?

I would trace both the SE16 transaction and your own coded program using ST05 and compare the results. This may point to the difference.

Gary

Re: problem with select

Former Member — Tue, 06 Jun 2006 15:05:23 GMT

Did you also use 'Not Equal To' for BANFN and BANPO in SE16?

Re: problem with select

Former Member — Tue, 06 Jun 2006 15:06:19 GMT

yes i use not equal

Re: problem with select

former_member181966 — Tue, 06 Jun 2006 15:06:29 GMT

I think if you check the same selection in SE16 and then code it . You might be missing something . As Select statement is too long I prefer you to break it and then analyze it .

E,g

Part 1 select and also check in SE16

select lblni ebeln ebelp banfn bnfpo packno

from essr

into corresponding fields of table itab

where erdat in zerdat

and loekz = ' '

and kzabn = 'X'.

Part 2 select and also check in SE16

select lblni ebeln ebelp banfn bnfpo packno

from essr

into corresponding fields of table itab

where erdat in zerdat

and loekz = ' '

and kzabn = 'X'

and frgrl = ' '

and knttp = 'F'

and f_lock = ' '.

part 3

select lblni ebeln ebelp banfn bnfpo packno

from essr

into corresponding fields of table itab

where erdat in zerdat

and loekz = ' '

and kzabn = 'X'

and frgrl = ' '

and knttp = 'F'. ( i think you put this full stop by mistake )

and f_lock = ' '

and banfn <> ' '

and bnfpo <> ' '. ( i think you put this full stop by mistake )

and frggr = 'CS'.

Hope this’ll give you idea!!

P.S award the points.

Good luck

Thanks

Saquib Khan

"Some are wise and some are otherwise"

Re: problem with select

LeonardoAraujo — Tue, 06 Jun 2006 15:06:57 GMT

I've experienced different results when comparing null blank and non blank field contents.

Try this:

Use SE30 and run your SE16. This way you will get the runtime analysis. Go in the details and check the select single of fetch command for table ESSR. Put a breakpoint or just copy the call. The call might be structured a little different then yours, maybe using only ranges(select options).

Good luck

Message was edited by: Leonardo De Araujo