Assignment of different combinations of request or report data to a sales area and to a requesting sales organization. In case of incomplete entries in sales requests or sales reports, the system uses the update determination table to find the sales area automatically. On the basis of the assignment, the system can complete and update incomplete sales reports.
In the update determination table, you assign a sales area and a requesting sales organization to the keys for the request or report data of
Wholesaler
Object
Customer
Material.
You can revise:
Single keys
Several keys
All keys
with the assigned sales area. As a result, several levels are created where the system can search for the data required for the update.
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.
Note
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.
Note
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. If this is the case, the system assigns the sales area automatically.
Req.SOrg |
Wholesaler |
Object |
Customer |
Material |
SOrg. |
Dist. Chnl |
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 |