Sales Office Address, Change and Assignment

SAP Functional ==> SD In SAP

Where to change the ADRNR field for a particular sales office?

SPRO --> Enterprise Structure --> Definition --> Sales & Distribution --> Sales Office --> Define Sales Office. Here go to the address & change the address & the new address will reflect in the output.
 

Table in which sales office data is stored. 

In which table name address of the sales office (SD ) is stored. Also tell in which table, description of the sales office is stored.

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.
 

Assignment of Single sales office to multiple sales organizations.

We have a scenario where we need to Assign single sales office to multiple sales organizations in CRM. When I am trying to assign sales office to more than one sales organization 1st assignment between Sales office and Sales Org is getting deleted, and only the 2nd assignment is available. 
At sales office level in Function tab, it is showing only the assigned sales Organization (only one sales org), how to assign one more sales org to this sales office here.

The assignments are on the lower node. Which means you will go to Sales office, go to function TAB and assign multiple sales organizations there.

In the change form click New entry and assign the new sales organization and distribution channela and division combination.

You can assign as many combinations as needed here.

1. There are 2 version in CRM Org Model.
a) SBIV (Standard Backend Integration Version)
b) EBIV (Enhanced Backend Integration Version)

2. EBIV is used to handle multiple assignments in CRM system.

3. As you know we have 3 Org Units as far as Sales is concerned i.e. Sales Org, Sales Office, Sales Group.

4. In R/3 there is a standard way to maintain multiple assignments among these org units. 
Ex: Sales Group 'X' works (assigned) for 2 Sales Offices 'North' and 'South' simultaneously.

5. But in CRM this assignment is not as common as in R/3 and is not supported thru SBIV.

6. If you would like to have these multiple assignments made in R/3 available in CRM as well you may want to go thru EBIV.

7. Once you run EBIV you cannot go back to SBIV.

8. In EBIV divisions and distribution channels can only be assigned to sales units (sales organizations, sales offices, and sales groups). If they are assigned to any other neutral Org Units (Org Units without any Org Attributes), those assignments would be deleted once you shift from SBIV to EBIV.

Get help for your SAP SD problems
SAP SD Forums - Do you have a SAP SD Question?

SAP Sales and Distribution Books
SAP SD Books  - Certification, Interview Questions and Configuration

Delivery Hints
SAP Logistics Execution

SAP Sales and Distribution Tips
SAP SD Discussion Forum and Sales/Distribution Tips

Best regards,
SAP Basis, ABAP Programming and Other IMG Stuff
http://www.erpgreat.com

All the site contents are Copyright © www.erpgreat.com and the content authors. All rights reserved.
All product names are trademarks of their respective companies.  The site www.erpgreat.com is in no way affiliated with SAP AG.
Every effort is made to ensure the content integrity.  Information used on this site is at your own risk.
 The content on this site may not be reproduced or redistributed without the express written permission of
www.erpgreat.com or the content authors.