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

select single problem t001.

Former Member — Wed, 02 Aug 2006 13:51:20 GMT

SELECT SINGLE adrnr FROM T001

CLIENT specified

INTO ws_adrnr0

WHERE mandt = sy-mandt

AND adrnr = ws_bukrs.

What is the wrong in this stmt ?

I am not getting data in to ws_adrnr0?

Re: select single problem t001.

Former Member — Wed, 02 Aug 2006 13:52:38 GMT

AND adrnr = ws_bukrs.--->

SELECT SINGLE adrnr FROM T001

CLIENT specified

INTO ws_adrnr0

WHERE mandt = sy-mandt

AND bukrs = ws_bukrs.

Re: select single problem t001.

Former Member — Wed, 02 Aug 2006 13:53:19 GMT

SELECT SINGLE adrnr FROM T001

CLIENT specified

INTO ws_adrnr0

WHERE mandt = sy-mandt

AND adrnr = ws_bukrs. --> This might be the cause for the error

Change the condition as,

AND BUKRS = ws_bukrs.

Re: select single problem t001.

Former Member — Wed, 02 Aug 2006 13:54:05 GMT

Hi,

Why dont you try this way :

SELECT SINGLE adrnr FROM T001

INTO ws_adrnr0

WHERE bukrs = ws_bukrs.

Regards,

Varun .

Re: select single problem t001.

RichHeilman — Wed, 02 Aug 2006 13:54:54 GMT

SELECT SINGLE adrnr FROM T001
CLIENT specified
INTO ws_adrnr0
WHERE mandt = sy-mandt
AND <b>BUKRS</b> = ws_bukrs.

Regards,

Rich Heilman

Re: select single problem t001.

Former Member — Wed, 02 Aug 2006 13:55:00 GMT

Hi sam,

adrnr and ws_bukrs should have the ssame data.

regards,

keerthi.

Re: select single problem t001.

Former Member — Wed, 02 Aug 2006 13:55:25 GMT

SELECT SINGLE adrnr FROM T001

CLIENT specified

INTO ws_adrnr0

WHERE mandt = sy-mandt

AND adrnr = ws_bukrs-adrnr.

oops that doesn't make any sense, nevermind.

Message was edited by: Matt Nagel

Re: select single problem t001.

Former Member — Wed, 02 Aug 2006 14:00:16 GMT

Hi Sam,

You had problem in WHERE condition.

changed the last condition to BUKRS = ws_bukrs instead of adrnr = ws_bukrs.

Change the code as below

SELECT SINGLE adrnr FROM T001

CLIENT specified

INTO ws_adrnr0

WHERE mandt = sy-mandt

AND BUKRS = ws_bukrs.

Thanks,

Vinay