topic Re: select query in Application Development and Automation Discussions

select query

Former Member — Tue, 26 Aug 2008 12:50:22 GMT

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.

Re: select query

ThomasZloch — Tue, 26 Aug 2008 13:02:40 GMT

have a nice day.

Re: select query

matt — Tue, 26 Aug 2008 13:03:14 GMT


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

Re: select query

peter_ruiz2 — Tue, 26 Aug 2008 13:05:08 GMT

hi,

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

regards,

Peter

Re: select query

JozsefSzikszai — Tue, 26 Aug 2008 13:06:56 GMT


dont give useless responses..

"Total Questions: 69 (63 unresolved)"

looks like you got useful response 6 times only

Re: select query

Former Member — Tue, 26 Aug 2008 15:34:33 GMT

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!