Show TOC

  Update Data

Definition

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.

Use

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 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.

End of the note.

Note 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.

End of the note.

Example

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