Define Sorting Orders for Maintenance Statistics

This document explains how you define your own sorting orders and selection options to be used for maintenance statistics.

Outcome

Sorting orders with up to three inquiry fields per sorting order are defined. The information is stored in the Maintenance inquiry (MMCINO) file.

The sorting order is selected in 'Equipment Statistics. Display' (MCS420/P) and defaulted when you start (MCS430). This will sort and select the information according to your needs.

Before you start

No specific starting conditions exist for this activity.

Follow These Steps

  1. Start 'Sorting order - Maintenance Stats. Open' (MCS490/B).

  2. Enter an sorting order and select New to display the E panel.

  3. Enter a description.

  4. Enter 1 to 3 inquiry fields and optional field headings.

  5. Enter 1 to 3 optional sorting fields along with operators.

  6. Enter valid values in the From and To fields. Press Enter to finish.

    Wild card searches can be entered in different ways.

    Example: *A*B*C will search on fields that contain A, B and C in the order entered. There may however be letters between A, B and C.

    *A_B_C* will search on fields with A, B and C. These must be in the order entered, but with only one letter between.

Parameters to Set

Program ID/Panel Field The field indicates …
(MCS490/B) Sorting order … the identity of a user-defined search key.
(MCS490/E) Maintenance inquiry field

… the identity of the fields that are included in the sorting order. Three fields can be selected for each sorting order.

The valid fields are:

001 = Equipment or position number

002 = Product number

003 = Structure type

004 = Service

005 = Service group

006 = Type of process

007 = Maintenance order type

008 = Maintenance responsible

009 = Error code 1

010 = Error code 2

011 = Error code 3

012 = Reason code

013 = Event type

014 = Priority

015 = Work center

016 = Department

017 = Planning area

018 = Item group

019 = Product group

020 = Accounting control object

021 = Project number

022 = Reference order number

023 = Criticality class

024 = MEL reference

025 = Work order number

026 = Lot number.

(MCS490/E) Heading … a user-defined heading to be connected to the field. The standard heading will be used if the field is left blank.
(MCS490/E) Selection field

… up to three fields per sorting order that can be used to update the key file.

The following fields can be used:

001 = Configuration position

002 = Product number

003 = Structure type

004 = Service

005 = Service group

006 = Type of process

007 = Maintenance order type

008 = Maintenance responsible

009 = Failure code

010 = Error code 2

011 = Error code 3

012 = Reason code

013 = Event type

014 = Priority

015 = Work center

016 = Department

017 = Planning area

018 = Item group

019 = Product group.

(MCS490/E) Inquiry operator

… a selection within the records in the selection field. A number of alternatives exist for how the selection is made.

The following alternatives exist:

EQ=Equal, NE=Not equal, GT=Greater than, LT=Less than, GE=Greater than or equal to, LE=Less than or equal to, SC=Wild card search (XX*, *XX, *XX*), BT=Between the values given.

Related topics