topic Re: Select statement in Application Development and Automation Discussions

Select statement

Former Member — Tue, 19 Aug 2008 22:48:18 GMT

select single lifnr from lfa1 into ZZINFO-LIFNR

where sortl EQ ZINFO_COND_RECORD-LIFNR.

I am not able to get the value .

sortl value is CJ-PO issu

But If I physically looking at the DB LFA1 then I am able to get the value.

Any ideas why I am not able to find out?

Re: Select statement

Former Member — Tue, 19 Aug 2008 23:36:40 GMT

I don't suggest that you post the whole code, but if we could see the variables used being declared and assigned to values, perhaps we'll understand why it's failing.

Re: Select statement

Former Member — Tue, 19 Aug 2008 23:39:16 GMT

Check the field ZINFO_COND_RECORD-LIFNR may not be having value before passing to LFA1.

I wonder LIFNR in ZINFO_COND_RECORD is correct?

Re: Select statement

Former Member — Tue, 19 Aug 2008 23:43:28 GMT

I am checking in the debugger and there is value for it though.

Edited by: mark_yellow mark on Aug 20, 2008 1:43 AM

Re: Select statement

Former Member — Wed, 20 Aug 2008 06:50:01 GMT

Hi,

U mean the value of ZINFO_COND_RECORD-LIFNR = 'CJ-PO'.

If it is so, then check..

1. whether sy-subrc = 0.

2. If sy-subrc = 0, then check how many records are there in LFA1 table for that condition.. Because while using Select single statement, If u have more than 1 record for that condition, it will take the first record. So there might be the difference.

Regards,

Prem.

Re: Select statement

Former Member — Wed, 20 Aug 2008 06:56:38 GMT

Hi Mark,

Also cross check the value getting stored in the variable

sortl. If you are assigning the value as a constant, see to it

that the value is enclosed in quotes say, 'CJ-PO'.