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.

What a SAP Equipment in SAP PM ?

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)

Main SAP Equipment Tables

The most important Tables for SAP Equipment are:

SAP Equipment TableDescription
EQUIEquipment master data
EQKTMultilingual equipment short texts long texts and internal remarks
EQUZEquipment time segments
ILOALocation and account assignment data for the maintenance object
IHSGTable of permits for Plant Maintenance with long texts
IHPAEquipment Partners
FLEETFleet object-specific data for technical objects
T024IMaintenance planner groups
T370ZHistory-related fields
T370TEquipment categories
T370ULanguage-dependent texts for T370T

Check this post for the List of SAP PM Main Tables (Plant Maintenance) grouped by PM Topics

Further Reading on SAP Equipment on SAP PM

If you want to learn more about SAP Equipment check this book

Equipment Tables Details in SAP with Fields List

SAP EQUI Tables

SAP EQUI Table stored the Equipment Master Data.

The Fields for EQUI Tables are:

EQUI Field Data Element Description
MANDTMANDTClient
EQUNREQUNREquipment Number
ERDATERDATDate on which the record was created
ERNAMERNAMName of Person who Created the Object
EQASPEQASPLanguage in which the piece of equipment was entered
AEDATAEDATLast Changed On
AENAMAENAMName of Person Who Changed Object
BEGRUIAUTGAuthorization Group for Technical Object
EQTYPEQTYPEquipment Category
EQARTEQARTType of Technical Object
LVORMRESERVE_CHAR_001SAP Development Reserve
INVNRINVNRInventory number
GROESGROSSSize/dimension
BRGEWOBJ_WEIGHTWeight of object
GEWEIWEIGHT_UNITUnit of weight
ANSDTANDTIAcquisition date
ANSWTANSWTAcquisition Value
WAERSWAERSCurrency Key
ELIEFELIEFVendor number
GWLENGWLENDate on which the warranty ends
GWLDTGWLDTGuarantee date
WDBWTWDBWTEquipment replacement value
HERSTHERSTManufacturer of asset
HERLDHERLDCountry of manufacture
HZEINHZEINManufacturer drawing number
SERGESERGEManufacturer serial number
TYPBZTYPBZManufacturer model number
BAUJJBAUJJYear of construction
BAUMMBAUMMMonth of construction
APLKZAPLKZIndicator: Task List Exists
AULDTAULDTFirst delivery date of the equipment
INBDTILOM_DATABStart-up Date of the Technical Object
GERNRGERNRSerial Number
EQLFNEQLFNConsecutive numbering of EquipUsagePeriods on same day
GWLDVGWLDVWarranty date for Sales and Distribution
EQDATEQDATDate
EQBEREQBERText for Notes
EQNUMEQNUMNumerical Field
OBJNRJ_OBJNRObject number
EQSNREQSNREQSE Number
CUOBJCUOBJConfiguration (internal object number)
KRFKZKRFKZReferenced Configuration
KMATNKMATNConfigurable Material
MATNRMATNRMaterial Number
SERNRGERNRSerial Number
WERKWERKS_DPlant
LAGERLGORT_DStorage location
CHARGECHARG_DBatch Number
KUNDEKUNDSECustomer to Whom Serial Number was Delivered
WARPLWARPLMaintenance Plan
IMRC_POINTIMRC_POINTMeasuring Point
REVLVREVLVRevision level
MGANRMGANRMaster warranty number
BEGRUIINH_BEGRUIData origin for authorization group field
S_EQUIEQUIP_KNZEquipment
S_SERIALKZKSDSerial data when maintaining equipment
S_KONFIKONFKNZConfiguration supported
S_SALESDKNZSales equipment
S_FHMFHMKZEquip. category relevant to production resources and tools
S_ELSEELSE_KNZIndicator: Other Data Active
S_ISUISU_KNZIS-U data
S_EQBSKZEQBSEQSI Exists
S_FLEETFLEET_KNZIndicator: Fleet object active
BSTVPBSTVPStock Check for Serial Numbers
SPARTESPARTEDivision
HANDLEITOBTMP_TSEGGUIDSAP Development Reserve: Integration of Date Segment (Key)
TSEGTPITOBTMP_TSEGTEMPLASAP Development Reserve: Integration Date Segment (Template)
EMATNEMATNMaterial number corresponding to manufacturer part number
ACT_CHANGE_AAAAPM_ACT_CHANGE_AAChange Equipment Master when Changing Asset
S_CCCCC_KNZConfiguration Control Data
DATLWBDATLWBDate of Last Goods Movement
UIIUII_CHAR72Unique Item Identifier
IUID_TYPEIUID_TYPEStructure Type of UII
UII_PLANTUII_PLANTPlant Responsible for UII
EQEXT_ACTIVE/ISDFPS/DE_LM_DB_EQEXT_ACTIVEBackpack Table /isdfps/lmeqext Active

The fields may vary depending on your SAP version or solution.

SAP EQUZ Table (Equipment time segment)

The Second SAP Equipment Table is EQUZ.
The SAP Table EQUZ contains all the Equipment Time Segment. The EQUZ fields are:

EQUZ TableData ElementDescription
MANDTMANDTClient
EQUNREQUNREquipment Number
DATBIDATBIValid To Date
EQLFNEQLFNConsecutive numbering of EquipUsagePeriods on same day
EQUZNEQNNRNumber of next EquipUsagePeriod on same day
ERDATERDATDate on which the record was created
ERNAMERNAMName of Person who Created the Object
AEDATAEDATLast Changed On
AENAMAENAMName of Person Who Changed Object
TIMBITIMBIEquipment usage period time stamp
ESTAIRESERVE_CHAR_001SAP Development Reserve
ESTAERESERVE_CHAR_004SAP Development reserve
STNAMRESERVE_CHAR_012SAP Development Reserve
LVORMRESERVE_CHAR_001SAP Development Reserve
DATABDATABValid-From Date
IWERKIWERKMaintenance Planning Plant
IWERKIINHERData origin indicator
SUBMTSUBMTConstruction Type Material of the Object
MAPARMAPARManufacturer part number
HEQUIHEQUISuperordinate Equipment
HEQNRHEQNREquipment position at InstallLoc (Superior Equip./FunctLoc)
INGRPINGRPPlanner Group for Customer Service and Plant Maintenance
INGRPIINHERData origin indicator
PM_OBJTYPM_OBJTYObject Type of CIM Resources for Work Center
GEWRKLGWIDObject ID of the Work Center
GEWRKIINHERData origin indicator
TIDNRTIDNRTechnical identification number
TIDNRIINHERData origin indicator
ILOANILOANLocation and account assignment for technical object
KUND1KUND1Customer No.
KUND2KUND2End customer number
KUND3KUND3Operator
LIZNRLIZNREquipment license number
RBNRRBNRReport layout
EZDATEQDATDate
EZBEREQBERText for Notes
EZNUMEQNUMNumerical Field
RBNR_IINHERData origin indicator
IBLNRIBLNRPhysical inventory document
BLDATBLDATDocument Date in Document
PVS_FOCUSPVS_GUID_CCCInternal Identification for PVS Objects
PPEGUIDPVS_GUID_CCCInternal Identification for PVS Objects
TECHSTECHSParameter Variant/Standard Variant
FUNCIDCCC_FUNCIDFunction Identifier
FRCFITCCC_FRCFITIndicator: Forced Installation/Dismantling
FRCRMVCCC_FRCRMVForce Dismantling Flag