Configure staging table for Equipment and Functional Location master
Learn how to configure staging table for standard tables of Equipment and Functional Location master.
To configure staging table:
- In SAP ECC, run T-Code /n/INVMWO/EQ_STG.
-
Enter selection criteria and execute.
Figure 1. Equipment Selection Criteria -
Entries are shown in these tables:
- /INVMWO/EQ_HIERA
- /INVMWO/EQ_MEASU
- /INVMWO/EQ_H_SUB
- /INVMWO/EQ_LIST
- /INVMWO/EQ_HEADR
- /INVMWO/EQ_GEOLC
- /INVMWO/EQ_CLSIT
- /INVMWO/EQ_CLSHD
- /INVMWO/EQ_PRTNR
Figure 2. Equipment Hierarchy table - In SAP ECC, run T-Code /n/INVMWO/FL_STG.
-
Enter selection criteria and execute.
Figure 3. Functional Location Selection Criteria -
Entries are shown in these tables:
- /INVMWO/FL_IFLO
- /INVMWO/FL_HI_DE
- /INVMWO/FCHEADER
- /INVMWO/FL_HIER
- /INVMWO/FL_MEAS
- /INVMWO/NOTF_GEO
Figure 4. Functional Location table Note: Update the tables with background scheduled jobs regularly.- Configure these filters in RACE™, to filter and populate data in the
staging table when no value is entered for a field in the selection
screen (/INVMWO/FM_EQ_EXPAND_STG).
Master Filter Equipment EQSTG_FILTERs Functional Location FLSTG_FILTERs - Configure these when using Staging process:
Table 1. Staging Configuration Master Filter Table Name Equipment EQSTG_FILTER /INVMWO/EQ_LIST Functional Location FLSTG_FILTER /INVMWO/FCHEADER
Note: Data is filtered only for the fields in tables /INVMWO/FCHEADER and /INVMWO/EQ_LIST.