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

select single problem

Former Member — Tue, 01 Aug 2006 18:48:07 GMT

SELECT SINGLE * FROM ADRC

INTO ws_adrc

WHERE

client = sy-mandt AND

ADDRNUMBER = ws_adrnr

AND date_from = lv_data

AND nation = ' ' .

client , addrnumber, date_from and nation are the primary keys . what is the problem in Above select stmt?

Sy-subrc is always 4 ( do not understand).

But there is an entry in table adrc fot the supplied values of select single.

Re: select single problem

Former Member — Tue, 01 Aug 2006 18:51:44 GMT

How is WS_ADRNR defined? Does it have leading zeroes?

NATION probably has a space, not a null field.

Try

AND NATION = SPACE.

Re: select single problem

Former Member — Tue, 01 Aug 2006 18:51:50 GMT

Hi sam,

*INTO ws_adrc

uncomment this!

regards,

keerthi.

Re: select single problem

RichHeilman — Tue, 01 Aug 2006 18:56:00 GMT

Need to see the values of ws_adrnr

and lv_data. If they are not formatting correctly then you will not get a hit. For example does the value for ws_adrnr have leading zeros?

Regards,

Rich Heilman

Re: select single problem

Former Member — Tue, 01 Aug 2006 18:56:01 GMT

Hai Sam Kumar

Check the following Code

SELECT SINGLE * FROM ADRC

INTO ws_adrc

WHERE ADDRNUMBER = '0000022003' and

date_from = '00010101' and

nation = space.

if sy-subrc = 0.

exit.

endif.

no need to give the condition as client = sy-mandt

Regards

Sreeni

Message was edited by: Sreenivasulu Ponnadi

Re: select single problem

Former Member — Tue, 01 Aug 2006 19:05:41 GMT

Also... the DATE_FROM line should probably be

DATE_FROM <= LV_DATA

DATE_FROM <= SY-DATUM AND

DATE_TO >= SY-DATUM

Re: select single problem

Former Member — Tue, 01 Aug 2006 19:19:57 GMT

yes the problem should be of leading Zeros. as there is a conversion routine for the Domain. You could also use the Fm: CONVERSION_EXIT_ALPHA_RANGE_I, to convert it in the proper format.