SAP Equipment Tables
SAP Equipment Tables details the main Tables for Equipment Master Data in SAP and especially in SAP PM (Plant Maintenance).
First we will start with the main Tables List, then we will go deeper for the top SAP Equipment Tables.
Table of Contents
Let first define what Equipment in SAP.
The business object “Equipment” is an individual, physical object that is to be maintained independently. It can be installed in a technical system or part of a technical system.
You can manage all types of device as pieces of equipment (for example, production utilities, transportation utilities, test equipment, production resources/tools, buildings, PCs).
Since many of these physical objects are managed as “assets” in Asset Management, the term “piece of equipment” was chosen for objects defined from a technical perspective, in order to avoid confusion with the activated tangible assets.
You define and manage each piece of equipment in the Plant Maintenance (PM) System in a separate master record and can set up an individual maintenance history for each one. (source)
The most important Tables for SAP Equipment are:
| SAP Equipment Table | Description |
|---|---|
| EQUI | Equipment master data |
| EQKT | Multilingual equipment short texts long texts and internal remarks |
| EQUZ | Equipment time segments |
| ILOA | Location and account assignment data for the maintenance object |
| IHSG | Table of permits for Plant Maintenance with long texts |
| IHPA | Equipment Partners |
| FLEET | Fleet object-specific data for technical objects |
| T024I | Maintenance planner groups |
| T370Z | History-related fields |
| T370T | Equipment categories |
| T370U | Language-dependent texts for T370T |
Check this post for the List of SAP PM Main Tables (Plant Maintenance) grouped by PM Topics
If you want to learn more about SAP Equipment check this book
SAP EQUI Table stored the Equipment Master Data.
The Fields for EQUI Tables are:
| EQUI Field | Data Element | Description |
|---|---|---|
| MANDT | MANDT | Client |
| EQUNR | EQUNR | Equipment Number |
| ERDAT | ERDAT | Date on which the record was created |
| ERNAM | ERNAM | Name of Person who Created the Object |
| EQASP | EQASP | Language in which the piece of equipment was entered |
| AEDAT | AEDAT | Last Changed On |
| AENAM | AENAM | Name of Person Who Changed Object |
| BEGRU | IAUTG | Authorization Group for Technical Object |
| EQTYP | EQTYP | Equipment Category |
| EQART | EQART | Type of Technical Object |
| LVORM | RESERVE_CHAR_001 | SAP Development Reserve |
| INVNR | INVNR | Inventory number |
| GROES | GROSS | Size/dimension |
| BRGEW | OBJ_WEIGHT | Weight of object |
| GEWEI | WEIGHT_UNIT | Unit of weight |
| ANSDT | ANDTI | Acquisition date |
| ANSWT | ANSWT | Acquisition Value |
| WAERS | WAERS | Currency Key |
| ELIEF | ELIEF | Vendor number |
| GWLEN | GWLEN | Date on which the warranty ends |
| GWLDT | GWLDT | Guarantee date |
| WDBWT | WDBWT | Equipment replacement value |
| HERST | HERST | Manufacturer of asset |
| HERLD | HERLD | Country of manufacture |
| HZEIN | HZEIN | Manufacturer drawing number |
| SERGE | SERGE | Manufacturer serial number |
| TYPBZ | TYPBZ | Manufacturer model number |
| BAUJJ | BAUJJ | Year of construction |
| BAUMM | BAUMM | Month of construction |
| APLKZ | APLKZ | Indicator: Task List Exists |
| AULDT | AULDT | First delivery date of the equipment |
| INBDT | ILOM_DATAB | Start-up Date of the Technical Object |
| GERNR | GERNR | Serial Number |
| EQLFN | EQLFN | Consecutive numbering of EquipUsagePeriods on same day |
| GWLDV | GWLDV | Warranty date for Sales and Distribution |
| EQDAT | EQDAT | Date |
| EQBER | EQBER | Text for Notes |
| EQNUM | EQNUM | Numerical Field |
| OBJNR | J_OBJNR | Object number |
| EQSNR | EQSNR | EQSE Number |
| CUOBJ | CUOBJ | Configuration (internal object number) |
| KRFKZ | KRFKZ | Referenced Configuration |
| KMATN | KMATN | Configurable Material |
| MATNR | MATNR | Material Number |
| SERNR | GERNR | Serial Number |
| WERK | WERKS_D | Plant |
| LAGER | LGORT_D | Storage location |
| CHARGE | CHARG_D | Batch Number |
| KUNDE | KUNDSE | Customer to Whom Serial Number was Delivered |
| WARPL | WARPL | Maintenance Plan |
| IMRC_POINT | IMRC_POINT | Measuring Point |
| REVLV | REVLV | Revision level |
| MGANR | MGANR | Master warranty number |
| BEGRUI | INH_BEGRUI | Data origin for authorization group field |
| S_EQUI | EQUIP_KNZ | Equipment |
| S_SERIAL | KZKSD | Serial data when maintaining equipment |
| S_KONFI | KONFKNZ | Configuration supported |
| S_SALE | SDKNZ | Sales equipment |
| S_FHM | FHMKZ | Equip. category relevant to production resources and tools |
| S_ELSE | ELSE_KNZ | Indicator: Other Data Active |
| S_ISU | ISU_KNZ | IS-U data |
| S_EQBS | KZEQBS | EQSI Exists |
| S_FLEET | FLEET_KNZ | Indicator: Fleet object active |
| BSTVP | BSTVP | Stock Check for Serial Numbers |
| SPARTE | SPARTE | Division |
| HANDLE | ITOBTMP_TSEGGUID | SAP Development Reserve: Integration of Date Segment (Key) |
| TSEGTP | ITOBTMP_TSEGTEMPLA | SAP Development Reserve: Integration Date Segment (Template) |
| EMATN | EMATN | Material number corresponding to manufacturer part number |
| ACT_CHANGE_AA | AAPM_ACT_CHANGE_AA | Change Equipment Master when Changing Asset |
| S_CC | CCC_KNZ | Configuration Control Data |
| DATLWB | DATLWB | Date of Last Goods Movement |
| UII | UII_CHAR72 | Unique Item Identifier |
| IUID_TYPE | IUID_TYPE | Structure Type of UII |
| UII_PLANT | UII_PLANT | Plant Responsible for UII |
| EQEXT_ACTIVE | /ISDFPS/DE_LM_DB_EQEXT_ACTIVE | Backpack Table /isdfps/lmeqext Active |
The fields may vary depending on your SAP version or solution.
The Second SAP Equipment Table is EQUZ.
The SAP Table EQUZ contains all the Equipment Time Segment. The EQUZ fields are:
| EQUZ Table | Data Element | Description |
|---|---|---|
| MANDT | MANDT | Client |
| EQUNR | EQUNR | Equipment Number |
| DATBI | DATBI | Valid To Date |
| EQLFN | EQLFN | Consecutive numbering of EquipUsagePeriods on same day |
| EQUZN | EQNNR | Number of next EquipUsagePeriod on same day |
| ERDAT | ERDAT | Date on which the record was created |
| ERNAM | ERNAM | Name of Person who Created the Object |
| AEDAT | AEDAT | Last Changed On |
| AENAM | AENAM | Name of Person Who Changed Object |
| TIMBI | TIMBI | Equipment usage period time stamp |
| ESTAI | RESERVE_CHAR_001 | SAP Development Reserve |
| ESTAE | RESERVE_CHAR_004 | SAP Development reserve |
| STNAM | RESERVE_CHAR_012 | SAP Development Reserve |
| LVORM | RESERVE_CHAR_001 | SAP Development Reserve |
| DATAB | DATAB | Valid-From Date |
| IWERK | IWERK | Maintenance Planning Plant |
| IWERKI | INHER | Data origin indicator |
| SUBMT | SUBMT | Construction Type Material of the Object |
| MAPAR | MAPAR | Manufacturer part number |
| HEQUI | HEQUI | Superordinate Equipment |
| HEQNR | HEQNR | Equipment position at InstallLoc (Superior Equip./FunctLoc) |
| INGRP | INGRP | Planner Group for Customer Service and Plant Maintenance |
| INGRPI | INHER | Data origin indicator |
| PM_OBJTY | PM_OBJTY | Object Type of CIM Resources for Work Center |
| GEWRK | LGWID | Object ID of the Work Center |
| GEWRKI | INHER | Data origin indicator |
| TIDNR | TIDNR | Technical identification number |
| TIDNRI | INHER | Data origin indicator |
| ILOAN | ILOAN | Location and account assignment for technical object |
| KUND1 | KUND1 | Customer No. |
| KUND2 | KUND2 | End customer number |
| KUND3 | KUND3 | Operator |
| LIZNR | LIZNR | Equipment license number |
| RBNR | RBNR | Report layout |
| EZDAT | EQDAT | Date |
| EZBER | EQBER | Text for Notes |
| EZNUM | EQNUM | Numerical Field |
| RBNR_I | INHER | Data origin indicator |
| IBLNR | IBLNR | Physical inventory document |
| BLDAT | BLDAT | Document Date in Document |
| PVS_FOCUS | PVS_GUID_CCC | Internal Identification for PVS Objects |
| PPEGUID | PVS_GUID_CCC | Internal Identification for PVS Objects |
| TECHS | TECHS | Parameter Variant/Standard Variant |
| FUNCID | CCC_FUNCID | Function Identifier |
| FRCFIT | CCC_FRCFIT | Indicator: Forced Installation/Dismantling |
| FRCRMV | CCC_FRCRMV | Force Dismantling Flag |
SAP ISU Tables for Technical master data, for Billing Master Data, Billing and invoicing Tables?…
SAP Fiori 3 UX and Design of SAP Fiori Apps for SAP S/4HANA, SAP TechEd…
Dunning is the business practice of informing a customer of past due payment. Dunning letters…
SAP AP Tcodes & SAP AR Tcodes: House Banks Tcodes, Advance Payments or Down Payments,…
What are the main SAP Payment Terms Tables ? What are the related Tables in…
Work center consists of master data related to routing of products. It contains data related…