cancel
Showing results for 
Search instead for 
Did you mean: 

Merge of Sales Offices?

reazuddin_md
Active Contributor
0 Kudos

Hi,

There are 2 comp's running in SAP. Now both are merged.

for this, they want to use one office as consolidated ( so far, they r using 2 sales offices in different comp codes, after merge sales office will be common for both, then as per their req, client wants to have only one sales office for both)

these sales offices maintianed in all Customer master data of both the comp's.

now if they want to consolidate we have to update all the CMR with one Sales office?

can we use BDC for this? or MASS usage?

Please let me know the table name for condition records where it will store?( they maintained some records specific to sales office, i have to find out how many condtion records exist for sales office specific)

Can any one have idea?

plz ,

Accepted Solutions (1)

Accepted Solutions (1)

ranjeetrajendra_jain
Active Contributor
0 Kudos

Here are some tables list, however i didn't quite get your requirement clearly. Condition record, do you mean pricing condition reconrds...

Just to be on safer side i am posting all relevant which came to my mind at this time.

Customer master data

KNA1 Customer master

KNB1 Customer / company

KNVV Customer sales data

KNBK Bank details

KNVH Customer hierarchy

KNVP Customer partners

KNVS Shipment data for customer

KNVK Contact persons

KNVI Customer master tax indicator

SD

TVKO Sales organisation / company code

TVTW Distribution channel

TVBUR Sales office

TVKBT Sales office text

TVKGR Sales group

TVGRT Sales group text

T171T Sales district text

TVKBZ Sales office to sales area

TVBVK Sales group to sales office

Pricing :

KONH Conditions header

KONP Conditions items

KONV Procedure ( billing doc or sales order)

KOND

Hope it helps

Regards

Answers (3)

Answers (3)

reazuddin_md
Active Contributor
0 Kudos

done

Former Member
0 Kudos

hello, friend.

please clarify... your requirement is to change all CMRs so that these now reflect the new Sales Office, correct?

if so, yes you can maintain/change the sales office values using MASS or XD99.

go to table KNVV to see the field VKBUR (sales office).

regards.

Lakshmipathi
Active Contributor
0 Kudos

Dear RMD

For information, all condition records are stored in KONV. But in KONV, you need to provide Document Condition references which is available in VBAK.

So you can first try with SE16 / VBAK so that whatever billing is generated till date, the report will display all the records. In that there is a field "Doc condition". Copy those references and again use SE16 with KONV. Now you will get all the condition types used.

thanks

G. Lakshmipathi

reazuddin_md
Active Contributor
0 Kudos

Hi Laxmipati,

but how this meets the client req?

I want retrieve only sales office specific price cond records.

I tried as you said in ur reply , i found some 80K conditon records.