Sap equipment master tables

Sap equipment master tables DEFAULT

SAP PM Equipment Master Data, Tables &#; Tcodes

Equipment is a physical & individual object in an organization which needs independent maintenance, for example, computers & laptops. SAP Equipment master contains the information about each piece of equipment and their maintenance in Plant Maintenance Module. In this tutorial you can refer about tcodes, tables and function modules dealing with SAP PM Equipment.

IE01 is the SAP transaction code to add new equipment in the SAP system. Remember, all physical objects are not classified as equipment. Some will be coming under assets. Thus it is not mandatory that all equipment are to be under the head assets, rather it can be mere physical objects that has to be maintained independently.

SAP Equipment Master Structure

Each SAP Equipment master record contains following data. Each such data can be understood from its head itself.

  • Equipment General data: The general specifications come under the general data.
  • Equipment Maintenance, location & sales Data: All data pertaining to maintenance, location and sales shall be discussed here.
  • Equipment Serial Number: The serial number shall be explicitly listed.
  • Equipment Configuration: All data on configuration of the specific equipment will be clearly listed.
  • Equipment Partner Data: Partner Data in Equipment master indicate who is responsible for that piece of equipment.

what is SAP equipments in PM

SAP PM Equipment Transaction Codes

Important transaction codes dealing with Equipment in SAP.

SAP Equipment Tables

Some of the important tables associated with Equipment in SAP PM Module.

SAP Equipment Function Modules

Here is some function modules used for Equipment in SAP.

  • GET_SERNR_VIA_IQ09 : Reads Equipment in Serial No. Interval with Mat. No. from Equipment Table
  • GET_EQUIS_SERNR_INTERVAL_MATNR : Reads Equipment in Serial No. Interval with Mat. No. from Equipment Table
  • EAMS_VB_BTE_PM_EQUI : DFPS &#; BTE &#; Equipment
  • EQUIPMENT_POST : Update equipment
  • EQUIPMENT_COLLECT_DATA : BTE: Update of Equipment
  • GRRM_CTX_SH_EQUIPMENT : Search help exit for equipment
  • ECP_SRV_PARTNERS_QMEL : Read equipment partners
  • ECP_SRV_PARTNERS_IHPA : Read equipment partners
  • ECP_SRV_PARTNERS_EQUI : Read equipment partners
  • ECP_SRV_PARTNERS_BUS : Read equipment partners
  • ECP_PORTAL_ALV_CONFIGURATION : Read configuration for equipment
  • EQUIPMENT_VERWENDUNG_TEST : Where-used List for Equipment in DB Objects
  • HEAL_F4IF_SHLP_EQUI : Equipment Search Help Heal Exit
  • GCFB_EVENT_HANDLER : GBC: Event Processing for Equipment Created
  • EQUI_CHECK_ASSET : Check whether an asset is still being used in a piece of equipment
  • EAM_MES_CREATE_CP_EQUI : Equipment: Create Change Pointers
  • HEAL_F4IF_SHLP_FL : Equipment Search Help Heal Exit
  • GET_EQUIS_WITH_SERNR_INTERVAL : Selects All Equipment in a Serial Number Interval
  • EHFND_SHLP_EXIT_SM_EQUI : Search Help Exit for Safety Measure Equipment
  • EHFND_SHLP_EXIT_CMP_EQUIPMENT : Search Help Exit for Safety Measure Equipment
  • EHFND_SHLP_EXIT_CMP_MATERIAL : Search Help Exit for Safety Measure Equipment
  • DPWTY_F4_EQUI_T : Search help exit for Equipment Master Data and Texts
  • EXIT_SAPMIEQ0_ : Check of Customer-Defined Rules Before Equipment Update
  • ICLC_ICL_PAI_ICLS95 : Screen : Edit personal equipment (named items)
  • EHFND_SHLP_EXIT_EQART_TK : Asset Search Help Exit for Equipment Type Code
  • EHFND_SHLP_EXIT_EQU_TYPE_CODE : Asset Search Help Exit for Equipment Type Code
  • EHFND_SHLP_EXIT_SM_TYPE_CODE : Asset Search Help Exit for Equipment Type Code
  • EXIT_SAPLIEL2_ : Check of User-Defined Rules When Defining the Equipment Hierarchy
  • EXIT_SAPLAAPM_ : User Exit for Deriving Equipment Category from Fields of Asset Accounting
  • EHFND_SHLP_EXIT_LOCATION : Asset Search Help Exit for Equipment ID Search Help
  • EHFND_SHLP_EXIT_EQU_ID : Asset Search Help Exit for Equipment ID Search Help
  • FILTER_MATNR_SERNR_INTERVAL : Selects Material Table from Equipment Table
  • DPWTY_SERIAL_NUMBER_EQUI_GET : RFC to get the equipment number of a serial number

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
TIMaintenance planner groups
TZHistory-related fields
TTEquipment categories
TULanguage-dependent texts for TT

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 Table stored the Equipment Master Data.

The Fields for EQUI Tables are:

EQUI Field Data Element Description
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
AENAMAENAMName of Person Who Changed Object
BEGRUIAUTGAuthorization Group for Technical Object
EQTYPEQTYPEquipment Category
EQARTEQARTType of Technical Object
INVNRINVNRInventory number
BRGEWOBJ_WEIGHTWeight of object
ANSDTANDTIAcquisition date
ANSWTANSWTAcquisition Value
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
EQLFNEQLFNConsecutive numbering of EquipUsagePeriods on same day
GWLDVGWLDVWarranty date for Sales and Distribution
EQBEREQBERText for Notes
EQNUMEQNUMNumerical Field
OBJNRJ_OBJNRObject number
CUOBJCUOBJConfiguration (internal object number)
KRFKZKRFKZReferenced Configuration
KMATNKMATNConfigurable Material
MATNRMATNRMaterial Number
LAGERLGORT_DStorage location
KUNDEKUNDSECustomer to Whom Serial Number was Delivered
WARPLWARPLMaintenance Plan
REVLVREVLVRevision level
MGANRMGANRMaster warranty number
BEGRUIINH_BEGRUIData origin for authorization group field
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_FLEETFLEET_KNZIndicator: Fleet object active
BSTVPBSTVPStock Check for Serial Numbers
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
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
EQUNREQUNREquipment Number
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
AENAMAENAMName of Person Who Changed Object
TIMBITIMBIEquipment usage period time stamp
ESTAERESERVE_CHAR_SAP Development reserve
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
LIZNRLIZNREquipment license number
RBNRRBNRReport layout
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
  1. How to install directv receiver
  2. Livin lite
  3. Spray paint dress
  4. Casio cash register troubleshooting

Top Tables overview for the Plant Maintenance Module PM in SAP

View table content with transaction SE16, SE16N or SE16H (with HANA-Database) and tablestructure with SE11


TableTable - NameS/4HANA -Table and general Notes
AFIH Maintenance order header In Logical Database PSJ. AFVC Operation within an order In Logical Database BTM. AFVU DB structure of the user fields of the operation AFVV DB structure of the quantities/dates/values in the operationAUFK Order master data In Logical Database ODK PSJ. CAUFV View Order Headers PP/CO In Logical Database BTM POH. EQKT Equipment Short Texts EQUI Equipment master data In Logical Database WTY. EQUZ Equipment time segment IFLO Functional Location (View) IFLOSFunctional Location LabelsIFLOT Functional Location (Table) In Logical Database WTY. IHPA Plant Maintenance: Partners ILOA PM Object Location and Account Assignment ITOB PM technical objects (EQUI, funcational location) OBJKPlant Maintenance Object List

Fixed Assets    go to all Fixed Assets Tables

TableTable - NameS/4HANA -Table and general Notes
ANLA Asset Master Record Segment ANLB Depreciation terms In Logical Database ADA.

Transactional Data    

TableTable - NameS/4HANA -Table and general Notes
AFFL Work order sequence In Logical Database POH PSJ. AFRU Order Confirmations In Logical Database ODC OFC OHC OPC POH.

Enterprise Structure    Part of the Customizing

TableTable - NameS/4HANA -Table and general Notes
TKValuation areaTLStorage LocationsTW Plants/Branches TSLocationTSPAOrganizational Unit: Sales Divisions


TableTable - NameS/4HANA -Table and general Notes
TO Order Types TMaintenance Control Parameters: Client/Order TypeTICombination of order type and PM activity type allowedTWMaintenance control parameters: Order type plantTCORUParameters for Order ConfirmationTCX00Scheduling: Planning Levels and Control Parameters

Report here a missing table

Additional tables for the following modules:

FI          FI-GL          FI-AR          FI-AP          FI-BL          FI-AA          CO          CO-OM-CEL          CO-OM-CCA          CO-OM-OPA          CO-PC          EC-PCA          RE-FX          RE-FX-LA           SD          MM          MM-PUR          QM          PP          PP-PI          PS          PA          ABAP          Basis          Cross Module          Business Partner          

How to get Asset wise equipment list in SAP PM using T code IH08/ Equipment analysis in any PM Plant


Tables sap equipment master




Now discussing:


1032 1033 1034 1035 1036