Where to get sales office description?

[former_member207873]

Hello Experts,

I need to get sales office description field. I am working on VBRP and VBRK tables. So how can I link any one of these tables  to the sales office description field.

Regards,

Marina.

[govind_tkrishnakumar]

Hi Marina,

The field VKBUR in VBRP should give you the sales office....the sales office text is stored in table TVKBT and with input VKBUR you can get the sales office text.

Thanks & Regards

Govind

[suman_sardar2]

Hi Marina,

The joining logic will be VBRP-VBRP = TVKBT-VKBUR and check the language as per your need like EN and fetch the value from Table TVKBT of the Description field BEZEI.

Hope this will help you to achieve the requirement.

Thanks,

Suman$

[jignesh_mehta3]

Hello Marina,

Sales Office is available in VKBUR field in VBRP

Now to get the Sales Description, pass the VBRP - VKBUR value in Table TVKBT & fetch BEZEI (Sales Office Description).

Thanks,

Jignesh Mehta

[former_member207873]

Hi all,

How can I combine VBRP and TVKBT?

[Former Member]

Hi Marina,

Try like this

table TVBUR-vkbur is the sales office 

table tvbur it contains a field called address number. ADRNR 

take that field(ADRNR) and compare with table ADRC-ADRNR. 

in table ADRC you will find name, description, address and all other data. 

table TVKBT -- description of sales office.

Regards,

Kishore

[praveenkumar_vantala]

Hi

Please check below thread might be helpful

http://scn.sap.com/thread/3399847

Regards

Praveen

[former_member218125]

Hello,

sales office is not available in VBRK/VBRP. You have to read the according sales order via table VBFA. Then you get the sales office in VBAK.

Best regards, BG

[former_member184065]

Dear,

Have you checked in VBRP table Field is VKBUR ? .We have Sales Office in VBRP not in VBRK .

Marina,

You can get this data from only KNVV and VBRP not by VBRK .But you are talking about Description.You can get this data from Table V_TVBUR  Field is BEZEI .I think ,we can get that data thu VBRP .

Thanks,

Naren

[former_member218125]

Hi,

yes, you are right. VKBUR is in table VBRP available. Please forget my above post. I´m just asking me, my i did not noticed this before.

Best regards, BG