select query

[Former Member]

i want to select telephone number(usr03-telnr) from usr03 table and person name who created the billing

doc (vbrk-ernam) from vbrk table using the common field regio which is in both the tables.

dont give useless responses..hope i am inefficient but dnt prove urself.

[ThomasZloch]

have a nice day.

[matt]

>

> i want to select telephone number(usr03-telnr) from usr03 table and person name who created  the billing
> doc  (vbrk-ernam) from vbrk table using the common field regio which is in both the tables.
> 
>          dont give useless responses..hope i am inefficient but dnt prove urself.

Didn't you ask the same question here?

"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).

"

[peter_ruiz2]

hi,

use the ERNAM field in VBRK and link it with the BNAME field in USR03.

regards,

Peter

[JozsefSzikszai]

>

dont give useless responses..

"Total Questions: 69 (63 unresolved)"

looks like you got useful response 6 times only

[Former Member]

Table usr03 is obsolete and has been merged into the address management of the CUA.

> dont give useless responses..hope i am inefficient but dnt prove urself.

So your requirement is useless and you might soon become obsolete as well if you don't stop spamming us with your duplicated questions...

Please read "the rules" before posting any further!