on 03-05-2008 6:14 AM
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 ,
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
done
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
7 | |
7 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.