1. Home
  2. Resources
  3. SAP Tables
  4. EQUI - Equipment master data

SAP Table EQUI

Equipment master data

EQUI (Equipment master data) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link EQUI to other SAP tables.

EQUI table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
EQUNR Equipment Number EQUNR CHAR 18 0
ERDAT Date on Which Record Was Created ERDAT DATS 8 0
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
EQASP Language in Which the Piece of Equipment was Entered EQASP T002 LANG 1 0
AEDAT Changed On AEDAT DATS 8 0
AENAM Name of Person Who Changed Object AENAM CHAR 12 0
BEGRU Technical object authorization group IAUTG T370B CHAR 4 0
EQTYP Equipment category EQTYP T370T CHAR 1 0
EQART Type of Technical Object EQART T370K CHAR 10 0
LVORM SAP Development Reserve: Format CHAR, Length 1 RESERVE_CHAR_001 CHAR 1 0
INVNR Inventory number INVNR CHAR 25 0
GROES Size/dimension GROSS CHAR 18 0
BRGEW Weight of object OBJ_WEIGHT QUAN 13 3
GEWEI Unit of weight WEIGHT_UNIT T006 UNIT 3 0
ANSDT Acquisition date ANDTI DATS 8 0
ANSWT Acquisition Value ANSWT CURR 13 2
WAERS Currency Key WAERS TCURC CUKY 5 0
ELIEF Vendor number ELIEF LFA1 CHAR 10 0
GWLEN Date on which the warranty ends GWLEN DATS 8 0
GWLDT Warranty Date GWLDT DATS 8 0
WDBWT Equipment replacement value WDBWT CURR 13 2
HERST Manufacturer of asset HERST CHAR 30 0
HERLD Country of manufacture HERLD T005 CHAR 3 0
HZEIN Manufacturer drawing number HZEIN CHAR 30 0
SERGE Manufacturer serial number SERGE CHAR 30 0
TYPBZ Manufacturer model number TYPBZ CHAR 20 0
BAUJJ Year of construction BAUJJ CHAR 4 0
BAUMM Month of construction BAUMM CHAR 2 0
00
APLKZ Indicator: Task List Exists APLKZ CHAR 1 0
AULDT First delivery date of the equipment AULDT DATS 8 0
INBDT Start-up Date of the Technical Object ILOM_DATAB DATS 8 0
GERNR Serial Number GERNR CHAR 18 0
EQLFN Consecutive numbering of EquipUsagePeriods on same day EQLFN NUMC 3 0
GWLDV Warranty date for Sales and Distribution GWLDV DATS 8 0
EQDAT Date, intended for SAP internal use EQDAT DATS 8 0
EQBER Technical information, intended for SAP internal use EQBER CHAR 30 0
EQNUM Numerical field, intended for SAP internal use EQNUM NUMC 9 0
OBJNR Object number J_OBJNR CHAR 22 0
EQSNR EQSE Number EQSNR EQSE CHAR 18 0
CUOBJ Configuration (internal object number) CUOBJ NUMC 18 0
KRFKZ Referenced Configuration KRFKZ CHAR 1 0
X Yes
NULL No
KMATN Configurable Material KMATN MARA CHAR 18 0
MATNR Material Number MATNR MARA CHAR 18 0
SERNR Serial Number GERNR CHAR 18 0
WERK Plant WERKS_D T001W CHAR 4 0
LAGER Storage Location LGORT_D T001L CHAR 4 0
CHARGE Batch Number CHARG_D MCH1 CHAR 10 0
KUNDE Customer to Whom Serial Number was Delivered KUNDSE KNA1 CHAR 10 0
WARPL Maintenance Plan WARPL MPLA CHAR 12 0
IMRC_POINT Measuring Point IMRC_POINT IMPTT CHAR 12 0
REVLV Revision Level REVLV CHAR 2 0
MGANR Master warranty number MGANR BGMK CHAR 20 0
BEGRUI Data origin for authorization group field INH_BEGRUI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
S_EQUI Equipment data exists EQUIP_KNZ CHAR 1 0
X Yes
NULL No
S_SERIAL Serial data when maintaining equipment KZKSD CHAR 1 0
X Yes
NULL No
S_KONFI Configuration supported KONFKNZ CHAR 1 0
X Yes
NULL No
S_SALE Sales equipment SDKNZ CHAR 1 0
X Yes
NULL No
S_FHM Equip. category relevant to production resources and tools FHMKZ CHAR 1 0
NULL Blank
. Radio button
X Selection
S_ELSE Indicator: Other Data Active ELSE_KNZ CHAR 1 0
X Yes
NULL No
S_ISU IS-U data ISU_KNZ CHAR 1 0
X Yes
NULL No
S_EQBS EQSI Exists KZEQBS CHAR 1 0
S_FLEET Indicator: Fleet object active FLEET_KNZ CHAR 1 0
X Yes
NULL No
BSTVP Stock Check for Serial Numbers BSTVP CHAR 1 0
NULL No stock validation
1 Inconsistencies in stock data -> Warning
2 Inconsistencies in stock data -> Error
SPARTE Division SPARTE TSPA CHAR 2 0
HANDLE SAP Development Reserve: Integration of Date Segment (Key) ITOBTMP_TSEGGUID CHAR 22 0
TSEGTP SAP Development Reserve: Integration Date Segment (Tempate) ITOBTMP_TSEGTEMPLA CHAR 10 0
EMATN Material Number Corresponding to Manufacturer Part Number EMATN CHAR 18 0
ACT_CHANGE_AA Change Equipment Master when Changing Asset AAPM_ACT_CHANGE_AA CHAR 1 0
NULL No synchronization
1 Saving triggers a workflow
2 Direct synchronization after saving
3 Direct synchronization plus workflow
S_CC Configuration Control Data CCC_KNZ CHAR 1 0
X Yes
NULL No
DATLWB Date of Last Goods Movement DATLWB DATS 8 0
UII Unique Item Identifier UII_CHAR72 CHAR 72 0
IUID_TYPE Structure Type of UII IUID_TYPE TIUID_TYPE CHAR 10 0
UII_PLANT Plant Responsible for UII UII_PLANT CHAR 4 0
/GEP/PASSENGER Number of Passengers /GEP/FLEET_D_PASSENGER NUMC 2 0
/GEP/AUTOM Vehicle Equipment: Automatic Transmission /GEP/FLEET_D_AUTOM CHAR 1 0
X Yes
NULL No
/GEP/KLIMA Vehicle Equipment: Air Conditioning /GEP/FLEET_D_KLIMA CHAR 1 0
X Yes
NULL No
/GEP/DACHG Vehicle Equipment: Roof Rack /GEP/FLEET_D_DACHG CHAR 1 0
X Yes
NULL No
/GEP/SCHNEEK Vehicle Equipment: Snow Chains /GEP/FLEET_D_SCHNEEK CHAR 1 0
X Yes
NULL No
/GEP/WINTERR Vehicle Equipment: Snow Tyres /GEP/FLEET_D_WINTERR CHAR 1 0
X Yes
NULL No
/GEP/VHCAT Vehicle Type /GEP/FLEET_D_VHCAT CHAR 2 0
EQEXT_ACTIVE Backpack Table /isdfps/lmeqext Active /ISDFPS/DE_LM_DB_EQEXT_ACTIVE CHAR 1 0
X Yes
NULL No
/MRSS/ID_PROFILE Requirements Profile Was Changed Manually /MRSS/T_REQU_UPD CHAR 1 0
NULL FALSE
X TRUE
/MRSS/PROF_GUID GUID /MRSS/T_RSG_GUID RAW 16 0
/MRSS/PROF_KEY Profile Key /MRSS/T_RSG_REQUID CHAR 10 0
/MRSS/DATACHANGE Data was changed in the controls on the user screen /MRSS/T_USCREENCTL_DATACHANGED CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
EQUI_SRTYPE Shift Report Type COCF_SR_SRTYPE COCF_CU_SRTYPE CHAR 10 0
EQUI_SNTYPE Shift Note Type COCF_SN_SNTYPE TQ80 CHAR 2 0
EQLB_DUTY Logbook Duty DIACL_DUTY CHAR 1 0
NULL Blank
. Radio button
X Selection
EQLB_HIDE Hide Logbook Display DIACL_HIDE CHAR 1 0
NULL Blank
. Radio button
X Selection

EQUI foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
EQUI BEGRU EQUI MANDT T370B Technical object authorization group MANDT
EQUI BEGRU EQUI BEGRU T370B Technical object authorization group BEGRU
EQUI CHARGE EQUI MANDT MCH1 Batches (if Batch Management Cross-Plant) MANDT
EQUI CHARGE EQUI MATNR MCH1 Batches (if Batch Management Cross-Plant) MATNR
EQUI CHARGE EQUI CHARGE MCH1 Batches (if Batch Management Cross-Plant) CHARG
EQUI ELIEF EQUI ELIEF LFA1 Vendor Master (General Section) LIFNR
EQUI ELIEF EQUI MANDT LFA1 Vendor Master (General Section) MANDT
EQUI EQART EQUI MANDT T370K Type of technical object MANDT
EQUI EQART EQUI EQART T370K Type of technical object EQART
EQUI EQASP EQUI EQASP T002 Language Keys (Component BC-I18) SPRAS
EQUI EQSNR EQUI MANDT EQSE Serial Number Records MANDT
EQUI EQSNR EQUI EQSNR EQSE Serial Number Records EQSNR
EQUI EQTYP EQUI MANDT T370T Equipment categories MANDT
EQUI EQTYP EQUI EQTYP T370T Equipment categories EQTYP
EQUI EQUI_SNTYPE EQUI MANDT TQ80 Notification Types MANDT
EQUI EQUI_SNTYPE EQUI EQUI_SNTYPE TQ80 Notification Types QMART
EQUI EQUI_SRTYPE EQUI MANDT COCF_CU_SRTYPE Shift Report Type - Definition MANDT
EQUI EQUI_SRTYPE EQUI EQUI_SRTYPE COCF_CU_SRTYPE Shift Report Type - Definition SRTYPE
EQUI GEWEI EQUI MANDT T006 Units of Measurement MANDT
EQUI GEWEI EQUI GEWEI T006 Units of Measurement MSEHI
EQUI HERLD EQUI MANDT T005 Countries MANDT
EQUI HERLD EQUI HERLD T005 Countries LAND1
EQUI IMRC_POINT EQUI MANDT IMPTT Measuring Point (Table) MANDT
EQUI IMRC_POINT EQUI IMRC_POINT IMPTT Measuring Point (Table) POINT
EQUI IUID_TYPE EQUI IUID_TYPE TIUID_TYPE Item Unique Identifier Type IUID_TYPE
EQUI KMATN EQUI MANDT MARA General Material Data MANDT
EQUI KMATN EQUI KMATN MARA General Material Data MATNR
EQUI KUNDE EQUI MANDT KNA1 General Data in Customer Master MANDT
EQUI KUNDE EQUI KUNDE KNA1 General Data in Customer Master KUNNR
EQUI LAGER EQUI MANDT T001L Storage Locations MANDT
EQUI LAGER EQUI WERK T001L Storage Locations WERKS
EQUI LAGER EQUI LAGER T001L Storage Locations LGORT
EQUI MANDT EQUI MANDT T000 Clients MANDT
EQUI MATNR EQUI MANDT MARA General Material Data MANDT
EQUI MATNR EQUI MATNR MARA General Material Data MATNR
EQUI MGANR EQUI MANDT BGMK Master Warranty Header MANDT
EQUI MGANR EQUI MGANR BGMK Master Warranty Header MGANR
EQUI SPARTE EQUI MANDT TSPA Organizational Unit: Sales Divisions MANDT
EQUI SPARTE EQUI SPARTE TSPA Organizational Unit: Sales Divisions SPART
EQUI WAERS EQUI MANDT TCURC Currency Codes MANDT
EQUI WAERS EQUI WAERS TCURC Currency Codes WAERS
EQUI WARPL EQUI MANDT MPLA Maintenance plan MANDT
EQUI WARPL EQUI WARPL MPLA Maintenance plan WARPL
EQUI WERK EQUI MANDT T001W Plants/Branches MANDT
EQUI WERK EQUI WERK T001W Plants/Branches WERKS