topic SELECT QUERY in Application Development and Automation Discussions

SELECT QUERY

Former Member — Tue, 26 Aug 2008 11:14:04 GMT

hi frnds.

i want to retrieve the name of the person who created the billing doc i.e vbrk-ernam and his telephone no

which is in USR03 table (USR03-TELNR).

how to write the query for it.

thnx daniel

kesavadas_thekkillath — Tue, 26 Aug 2008 11:16:38 GMT

Check FM

SO_USER_ADDRESS_FOR_USR03_GET

Former Member — Tue, 26 Aug 2008 11:20:13 GMT

Hi Daniel,

Check with this query.


SELECT SINGLE TELNR
    FROM USR03 AS A INNER JOIN VBRK AS B
        ON A~BNAME = B~ERNAM 
    INTO GV_TELEPH.

Thanks,

Vinay

Former Member — Tue, 26 Aug 2008 11:22:46 GMT

Hi Daniel,

Use JOIN between VBRK and USR03 and get the telephone number.


SELECT SINGLE TELNR
FROM USR03 AS A INNER JOIN VBRK AS B
ON A~BNAME =   B~ERNAM
INTO GV_TELPH.

Thanks,

Vinay

Former Member — Tue, 26 Aug 2008 11:47:27 GMT

asa