topic Re: finding address in Application Development and Automation Discussions

finding address

Former Member — Tue, 28 Feb 2006 02:23:34 GMT

Hi experts,

How can i findout sales office address(ADRNR) using VKBUR?

thanks

kaki

Re: finding address

former_member221770 — Tue, 28 Feb 2006 02:32:47 GMT

Kaki,

VKBUR is sourced from TVBUR. ADRNR is in TVBUR.

Hope this helps.

Pat.

Re: finding address

Former Member — Tue, 28 Feb 2006 02:38:15 GMT

Hi patrick

thanks a lot

full points alloted

cheers

kaki

Re: finding address

former_member221770 — Tue, 28 Feb 2006 02:51:59 GMT

No problem Kaki,

Just for next time, you can find this by going to transaction SE11. Enter in 'VKBUR' into the "Data Type" field (or "Data Element" field for versions below 4.7) and hit Display. This will show you the Data Element "VKBUR". You willalso see that the Domain is "VKBUR". Double click in this and choose the "Value Range" Tab. At the bottom you will see that the "Value Table" is TVBUR. This means TVBUR is the source table for the field VKBUR. This is a characteristic of the Relational DB design which SAP uses.

Cheers,

Pat.

Re: finding address

Former Member — Tue, 28 Feb 2006 03:05:29 GMT

Hi Patrick,

Many thanks for valueble suggestion.Next time i will follow this..

kaki