Apply on Header Field (in the Include and Exclude Screens)

Before checking the results of your edits, look at the Apply on header field.

Figure 94 Apply on Header Field in the Exclude Screen

----------------  CONTROL-D - EXCLUDE LINES BASED ON STRINGS  ----------(U.E.3)

COMMAND ===>                                                  Apply on header  N

STR  '  '                            COL 069 - 069 LINE     -

STR                                  COL     -     LINE     -

STR                                  COL     -     LINE     -

The Apply on header field has a default value of N. This field also appears on the Include screen.

In the Include and the Exclude screens, the Apply on Header field determines whether the specified include and exclude string criteria are applied to the header lines.

• If you specify Y (Yes) on the Exclude screen, a header line is excluded if it contains even one of the specified Exclude values.
• If you specify Y (Yes) on the Include screen, a header line is included only if it contains at least one of the specified Include values.

In most cases, you do not want to apply the criteria to a header line. Therefore, the default is N (No).

1. Press the QUICKVIEW key (PF04/PF16) to display the Report Viewing screen and check the results of the edits.

   Figure 95 Report Viewing Screen after Editing

------------- CONTROL-D/V REPORT VIEWING   NOTES    0   PAGE      1 OF        9

COMMAND ===>                                                   SCROLL ===> CRSR

USR DEMO     REP INVENTORY REPORT     JB JDEMO    04544 DT 050500 RUL DEFAULT

----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8

1DATE:   05.05.00

UPDATE: 05.05.00

                                  INVENTORY REPORT

                                  ----------------

WAREHOUSE NO: 1001       DEPARTMENT:  100  -  FINAL ASSEMBLY SHOP

               ----                    ---------------------------

                                    SHELF   QNTY   QNTY       QNTY       QNTY IN

ITEM NO.      DESCRIPTION          LIFE    UNIT   AVAIL      ORDER      PROCESS

-----------   ----------------     -----   ----   -------    -------    ------

1233-781-21   RIVET D. 0.1 ACR     NONE    KG      100.00     250.00

1233-781-25   RIVET D. 0.5 ACR     NONE    KG      500.00     500.00

1233-781-27   RIVET D. 0.7 ACR     NONE    KG      100.00     100.00

2200-700-22   RUBBER RING D. 2.2   1 MON   EA       10.00      10.00

2200-700-27   RUBBER RING D. 2.7   1 MON   EA       15.00       5.00

2201-750-00   MAIN WHEEL           8 MON   EA       85.00      15.00

2201-751-00   NOSE WHEEL           8 MON   EA       40.00      10.00

2201-800-22   METAL O RING 2.2     NONE    EA       20.00      30.00

CMDS: FIND str (PREV), EDIT, RULER on/off/name, VALUE, N n P n        11.41.08

By eliminating report lines that do not have a value in the Qnty Order field, you have eliminated blank lines as well.

If your ruler contains both Include and Exclude edits, the Include edits are performed first and the Exclude edits are performed afterward. Therefore, records that match both Include and Exclude criteria are excluded from the report.

Note: If you are not using a color monitor, you can skip the next exercise, "Additional Color Screen Edits," and proceed directly to Dynamic Extraction Parameters.