08-02-2006 2:51 PM
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?
08-02-2006 2:52 PM
<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>
08-02-2006 2:52 PM
<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>
08-02-2006 2:53 PM
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>
08-02-2006 2:54 PM
Hi,
Why dont you try this way :
SELECT SINGLE adrnr FROM T001
INTO ws_adrnr0
WHERE bukrs = ws_bukrs.
Regards,
Varun .
08-02-2006 2:54 PM
08-02-2006 2:55 PM
Hi sam,
adrnr and ws_bukrs should have the ssame data.
regards,
keerthi.
08-02-2006 2:55 PM
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
08-02-2006 3:00 PM
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