You use these functions to process update data in the update determination table. In the update determination table you assign a sales area and a requesting sales organization to different combinations of request or confirmation data.
The update determination table has the following purposes:
To assign a sales area when incomplete request data is issued
If requests contain incomplete request data, the system can automatically assign the sales area required for the update and a requesting sales organization.
To assign a sales area when incomplete confirmation data is issued
If confirmations contain incomplete confirmation data, the system can automatically assign the sales area required for the update and a requesting sales organization.
If incomplete entries are made, the system automatically looks for the assigned sales area in the update determination table. Assignments in the update determination table allow the system to complete incomplete requests or confirmations with data from the update determination table and then to update it.
To search, the system proceeds according to the following logic:
The system starts by determining the assigned sales area at the level of the sales organization, the wholesaler number, the object number, the customer number, the material number.
If the system does not find a sales area under the determined key combination, it searches without material number (shortened key). If the search does not yield a result, the system searches without customer number, and so on. If the system does not find an assignment, it issues an error message.
In mass data processing, the greater the dataset, the longer it takes to access the database and the slower the program becomes. To optimize access times to the database, the information given in sales reports should be as complete as possible so that the system only has to search for a small amount of information in the update determination table.
Specifying the sales organization is sufficient for the system to determine where it has to update the sales of a particular material, even if the relevant sales report does not contain this information. In this case, the system assigns the sales area automatically.
The prerequisites for processing update data are as follows:
You have entered the necessary master data (wholesaler/customer, object, material) in the system.
You have maintained request and item data.
The following functions are available for processing update data:
Creating Update Data
Changing Update Data
Displaying Update Data
Select the wholesaler(s) whose update data you want to update. You can make further selections by entering the following additional restrictions:
Wholesaler from/to
Object from/to
Customer from/to
Material from/to
In the update determination table assign a sales area and a requesting sales organization to the keys for the following request or confirmation data:
Wholesaler
Object
Customer
Material
You can assign a combination of request or confirmation data to a sales area as follows:
Single keys
Several keys
All keys
As a result, several levels are created in which the system can search for the sales area required for the update.
Wholesaler
493
supplies object
491
from customer
492
with the materials
Beer barrel
MA0001, MA0002, MA0003, MA0004, MA0005
and
MA0006
.
In the update determination table, combined update data is assigned to a sales area as follows:
Single keys (only wholesalers)
Several keys (wholesaler and customer, wholesaler and object)
All keys (wholesaler, object, customer, material)
Requesting sales organization |
Wholesaler |
Object |
Customer |
Material |
Sales organization |
Distribution channel |
Division |
0001 |
493 |
|
|
|
0001 |
01 |
01 |
0001 |
493 |
|
492 |
|
0001 |
01 |
01 |
0001 |
493 |
491 |
|
|
0001 |
01 |
01 |
0001 |
493 |
491 |
492 |
|
0001 |
01 |
01 |
0001 |
493 |
491 |
492 |
MA0001 |
0001 |
01 |
01 |
0001 |
493 |
491 |
492 |
MA0002 |
0001 |
01 |
01 |
0001 |
493 |
491 |
492 |
MA0003 |
0001 |
01 |
01 |
0001 |
493 |
491 |
492 |
MA0004 |
0001 |
01 |
01 |
0001 |
493 |
491 |
492 |
MA0005 |
0001 |
01 |
01 |
0001 |
493 |
491 |
492 |
MA0006 |
0001 |
01 |
01 |