SELECT QUERY

[Former Member]

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]

Check FM

SO_USER_ADDRESS_FOR_USR03_GET

[Former Member]

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]

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]

asa