finding address

[Former Member]

Hi experts,

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

thanks

kaki

[former_member221770]

Kaki,

VKBUR is sourced from TVBUR. ADRNR is in TVBUR.

Hope this helps.

Pat.

[Former Member]

Hi patrick

thanks a lot

full points alloted

cheers

kaki

[former_member221770]

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.

[Former Member]

Hi Patrick,

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

kaki