select single problem t001.

[Former Member]

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?

[Former Member]

<b>AND adrnr = ws_bukrs</b>.--->

SELECT SINGLE adrnr FROM T001

CLIENT specified

INTO ws_adrnr0

WHERE mandt = sy-mandt

<b>AND bukrs = ws_bukrs.</b>

[Former Member]

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,

<b>AND BUKRS = ws_bukrs.</b>

[Former Member]

Hi,

Why dont you try this way :

SELECT SINGLE adrnr FROM T001

INTO ws_adrnr0

WHERE bukrs = ws_bukrs.

Regards,

Varun .

[RichHeilman]

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

Regards,

Rich Heilman

[Former Member]

Hi sam,

adrnr and ws_bukrs should have the ssame data.

regards,

keerthi.

[Former Member]

SELECT SINGLE adrnr FROM T001

CLIENT specified

INTO ws_adrnr0

WHERE mandt = sy-mandt

<b>AND adrnr = ws_bukrs-adrnr.</b>

oops that doesn't make any sense, nevermind.

Message was edited by: Matt Nagel

[Former Member]

Hi Sam,

You had problem in WHERE condition.

changed the last condition to <b>BUKRS = ws_bukrs</b> instead of <b>adrnr = ws_bukrs</b>.

Change the code as below

SELECT SINGLE adrnr FROM T001

CLIENT specified

INTO ws_adrnr0

WHERE mandt = sy-mandt

<b>AND BUKRS = ws_bukrs.</b>

Thanks,

Vinay