Skip to Content
author's profile photo Former Member
Former Member

select single problem t001.

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?

Add comment
10|10000 characters needed characters exceeded

7 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Aug 02, 2006 at 01: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>

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 02, 2006 at 01: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>

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 02, 2006 at 01:54 PM

    Hi,

    Why dont you try this way :

    SELECT SINGLE adrnr FROM T001

    INTO ws_adrnr0

    WHERE bukrs = ws_bukrs.

    Regards,

    Varun .

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 02, 2006 at 01:54 PM
    SELECT SINGLE adrnr FROM T001
    CLIENT specified
    INTO ws_adrnr0
    WHERE mandt = sy-mandt
    AND <b>BUKRS</b> = ws_bukrs.

    Regards,

    Rich Heilman

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 02, 2006 at 01:55 PM

    Hi sam,

    adrnr and ws_bukrs should have the ssame data.

    regards,

    keerthi.

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 02, 2006 at 01: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

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 02, 2006 at 02: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

    Add comment
    10|10000 characters needed characters exceeded