Sort/Group Fields in the Tree 

Use

You can define that the materials in the tree are sorted.

You require the system to display materials with red traffic lights or materials for which you have not yet processed the MRP list at the top.

You can also define grouping.

You want to display material with red traffic lights first and to group by traffic light values. You then have a hierarchy in which you can expand and collapse the substructure with the appropriate materials for each of the three traffic light values. The display in the tree is thus clearer and more flexible.

You can carry out grouping and sorting of the fields independently of each other in the following applications:

Prerequisites

Procedure

  1. Choose .
  2. The system displays the Group/sort dialog box.

  3. Enter the sequence number by which you want to sort the materials in the material tree next to each field.
  4. You want to sort the Processed MRP lists, Traffic light, Material, MRP area and Material description fields in this sequence. Enter:

    Processed MRP lists

    1

    Traffic light

    2

    Material

    3

    MRP area

    4

    Material description

    5

    You want to change the defined sequence so that the traffic light is first. Enter the following change:

    Traffic light

    1

    The remaining fields are resorted automatically when you confirm the entry with Enter.

  5. Select the Descending field if you want to sort in descending order.
  6. A descending sort is only recommended for the following fields:

    Traffic light

    Materials with red traffic lights, which means those whose processing has priority, are displayed first (red is the highest value, green the lowest).

    List created (only stock/requirements lists)

    Materials for which a list has been created are displayed first (list created is the highest value, list not created is the lowest value).

    Range of coverage

    Materials with the highest days' supply, which means those with high stock levels, are displayed first (highest days' supply is the highest value, lowest days' supply the lowest).

    Exception group

    Materials with the most exception messages in this group are displayed first (the most exception messages per group is the highest value, the least exception messages the lowest).

  7. Select the Group field when materials in the material tree that have the same value in a particular field, a red traffic light for example, are to be grouped and arranged in that order.
  8. Group and sort are coactive. Fields that you want to group must be at the top of the sort.

    You want to sort as follows:

    Field

    Priority (sort)

    Planning plant

    1

    Material type

    2

    ABC indicator

    3

    You want to group by material type within the sort. For this sort, you can not set the group indicator for material type alone. You must either group additionally by planning plant or change the sort so that the material type has the highest priority within the sort.

    The correct setting is:

    Field

    Group

    Priority (sort)

    Planning plant

    X

    1

    Material type

    X

    2

    ABC indicator

     

    3

    or

    Field

    Group

    Priority (sort)

    Material type

    X

    1

    Planning plant

     

    2

    ABC indicator

     

    3

  9. Choose Execute sort to activate the settings for the current display, or to save them permanently.

Result

The materials in the material tree are sorted and grouped by the selected fields.