SAP table EQUI (Equipment master data)

SAP table EQUI has 2 primary key fields being MANDT,EQUNR.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
EQUNR Equipment Number CHAR 18 0 EQUNR
ERDAT Date on which the record was created DATS 8 0 ERDAT
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
EQASP Language in Which the Piece of Equipment was Entered LANG 1 0 T002 EQASP
AEDAT Last Changed On DATS 8 0 AEDAT
AENAM Name of Person Who Changed Object CHAR 12 0 AENAM
BEGRU Technical Object Authorization Group CHAR 4 0 T370B IAUTG
EQTYP Equipment category CHAR 1 0 T370T EQTYP
EQART Type of Technical Object CHAR 10 0 T370K EQART
LVORM SAP Development Reserve: Format CHAR, Length 1 CHAR 1 0 RESERVE_CHAR_001
INVNR Inventory number CHAR 25 0 INVNR
GROES Size/dimension CHAR 18 0 GROSS
BRGEW Weight of object QUAN 13 3 OBJ_WEIGHT
GEWEI Unit of weight UNIT 3 0 T006 WEIGHT_UNIT
ANSDT Acquisition date DATS 8 0 ANDTI
ANSWT Acquisition Value CURR 13 2 ANSWT
WAERS Currency Key CUKY 5 0 TCURC WAERS
ELIEF Vendor number CHAR 10 0 LFA1 ELIEF
GWLEN Date on which the warranty ends DATS 8 0 GWLEN
GWLDT Guarantee date DATS 8 0 GWLDT
WDBWT Equipment replacement value CURR 13 2 WDBWT
HERST Manufacturer of Asset CHAR 30 0 HERST
HERLD Country/Region of Manufacture CHAR 3 0 T005 HERLD
HZEIN Manufacturer drawing number CHAR 30 0 HZEIN
SERGE Manufacturer's Serial Number CHAR 30 0 SERGE
TYPBZ Manufacturer model number CHAR 20 0 TYPBZ
BAUJJ Year of construction CHAR 4 0 BAUJJ
BAUMM Month of construction CHAR 2 0 BAUMM
00
APLKZ Indicator: Task List Exists CHAR 1 0 APLKZ
AULDT First delivery date of the equipment DATS 8 0 AULDT
INBDT Start-up Date of the Technical Object DATS 8 0 ILOM_DATAB
GERNR Serial Number CHAR 18 0 GERNR
EQLFN Consecutive numbering of EquipUsagePeriods on same day NUMC 3 0 EQLFN
GWLDV Warranty date for Sales and Distribution DATS 8 0 GWLDV
EQDAT Date, intended for SAP internal use DATS 8 0 EQDAT
EQBER Technical information, intended for SAP internal use CHAR 30 0 EQBER
EQNUM Numerical field, intended for SAP internal use NUMC 9 0 EQNUM
OBJNR Object number CHAR 22 0 J_OBJNR
EQSNR EQSE Number CHAR 18 0 EQSE EQSNR
CUOBJ Configuration (internal object number) NUMC 18 0 CUOBJ
KRFKZ Referenced Configuration CHAR 1 0 KRFKZ
KMATN Configurable Material CHAR 40 0 MARA KMATN
MATNR Material Number CHAR 40 0 MARA MATNR
SERNR Serial Number CHAR 18 0 GERNR
WERK Plant CHAR 4 0 T001W WERKS_D
LAGER Storage location CHAR 4 0 T001L LGORT_D
CHARGE Batch Number CHAR 10 0 MCH1 CHARG_D
KUNDE Customer to Whom Serial Number was Delivered CHAR 10 0 KNA1 KUNDSE
WARPL Maintenance Plan CHAR 12 0 MPLA WARPL
IMRC_POINT Measuring Point CHAR 12 0 IMPTT IMRC_POINT
REVLV Revision Level CHAR 2 0 REVLV
MGANR Master warranty number CHAR 20 0 BGMK MGANR
BEGRUI Data origin for authorization group field CHAR 1 0 INH_BEGRUI
S_EQUI Equipment data exists CHAR 1 0 EQUIP_KNZ
S_SERIAL Serial data when maintaining equipment CHAR 1 0 KZKSD
S_KONFI Configuration supported CHAR 1 0 KONFKNZ
S_SALE Sales equipment CHAR 1 0 SDKNZ
S_FHM Equip. category relevant to production resources and tools CHAR 1 0 FHMKZ
S_ELSE Indicator: Other Data Active CHAR 1 0 ELSE_KNZ
S_ISU IS-U data CHAR 1 0 ISU_KNZ
S_EQBS EQSI Exists CHAR 1 0 KZEQBS
S_FLEET Indicator: Fleet object active CHAR 1 0 FLEET_KNZ
BSTVP Stock Check for Serial Numbers CHAR 1 0 BSTVP
No stock validation
1 Inconsistencies in stock data -> Warning
2 Inconsistencies in stock data -> Error
SPARTE Division CHAR 2 0 TSPA SPARTE
HANDLE SAP Development Reserve: Integration of Date Segment (Key) CHAR 22 0 ITOBTMP_TSEGGUID
TSEGTP SAP Development Reserve: Integration Date Segment (Tempate) CHAR 10 0 ITOBTMP_TSEGTEMPLA
EMATN Material number corresponding to manufacturer part number CHAR 40 0 EMATN
ACT_CHANGE_AA Change Equipment Master when Changing Asset CHAR 1 0 AAPM_ACT_CHANGE_AA
S_CC Configuration Control Data CHAR 1 0 CCC_KNZ
DATLWB Date of Last Goods Movement DATS 8 0 DATLWB
UII Unique Item Identifier CHAR 72 0 UII_CHAR72
IUID_TYPE Structure Type of UII CHAR 10 0 TIUID_TYPE IUID_TYPE
UII_PLANT Plant Responsible for UII CHAR 4 0 UII_PLANT
CHANGEDDATETIME UTC Time Stamp in Short Form (YYYYMMDDhhmmss) DEC 15 0 TZNTSTMPS
ENDOFUSE End-of-Use Date of the Technical Object DATS 8 0 ENDOFUSE_DATE
DUMMY_EQUI_INCL_EEW_PS Custom Fields: Dummy for Use in Extension Includes CHAR 1 0 CFD_DUMMY
EQEXT_ACTIVE Backpack Table /isdfps/lmeqext Active CHAR 1 0 /ISDFPS/DE_LM_DB_EQEXT_ACTIVE
EQUI_SRTYPE Shift Report Type CHAR 10 0 COCF_CU_SRTYPE COCF_SR_SRTYPE
EQUI_SNTYPE Shift Note Type CHAR 2 0 TQ80 COCF_SN_SNTYPE
EQLB_DUTY Logbook Duty CHAR 1 0 DIACL_DUTY
EQLB_HIDE Hide Logbook Display CHAR 1 0 DIACL_HIDE
J_3GDISPO Planning Indicator CHAR 1 0 J_3GDISPO
Can be planned
1 Cannot be planned
J_3GZDEQUI Indicator for Central-Decentral Equipment CHAR 1 0 J_3GZDEQUI
1 Central (equipment)
2 Decentral (equipment)
J_3GEQART Procurement Type for External Equipment CHAR 10 0 J_3GFEQUI J_3GEQART
J_3GKZMENG Item/Multipart Indicator CHAR 1 0 J_3GKZMENG
1 Equipment item
2 Multipart equipment
J_3GKONDE Material Price Group CHAR 2 0 T178 KONDM
J_3GFIKTIV Fictitious Indicator CHAR 1 0 J_3GFIKTIV
J_3GBELTYP Document Categories Allowed CHAR 15 0 J_3GBELTYP
MEINS Base Unit of Measure UNIT 3 0 T006 MEINS
J_3GKZLADG Indicator: Relevancy to Loading Costs CHAR 1 0 J_3GLADEKE J_3GKZLADG
J_3GKZBERG Indicator for Provision Fees CHAR 1 0 J_3GKZBERG
None
1 Internal
2 External
3 Internal/External
J_3GEIFR Indicator for Own/External Equipment CHAR 1 0 J_3GEIFR
1 Own
2 External
J_3GVERMEIN Unit of Measure for Settlement UNIT 3 0 T006 J_3GVERMEIN
J_3GZULNR License Plate Number CHAR 15 0 J_3GLICENCE_NUM
/SAPCEM/ABRECHVH Settlement Using Shipping Document CHAR 1 0 /SAPCEM/ABRECHVH
/SAPCEM/ABRECHLG Settlement Using PBE Document CHAR 1 0 /SAPCEM/ABRECHLG
/SAPCEM/DISPOGR Planning Group CHAR 4 0 /SAPCEM/DISPOGRU /SAPCEM/DISPOGR

EQUI foreign key relationships

Table Field Check Table Check Field
0 EQUI BEGRU T370B Technical object authorization group MANDT
0 EQUI BEGRU T370B Technical object authorization group BEGRU
1 EQUI CHARGE MCH1 Batches (if Batch Management Cross-Plant) MANDT
0 EQUI ELIEF LFA1 Supplier Master (General Section) MANDT
0 EQUI ELIEF LFA1 Supplier Master (General Section) LIFNR
1 EQUI EQART T370K Type of technical object MANDT
1 EQUI EQART T370K Type of technical object EQART
0 EQUI EQASP T002 Language Keys (Component BC-I18) SPRAS
1 EQUI EQTYP T370T Equipment categories MANDT
1 EQUI EQTYP T370T Equipment categories EQTYP
0 EQUI EQUI_SNTYPE TQ80 Notification Types MANDT
0 EQUI EQUI_SNTYPE TQ80 Notification Types QMART
1 EQUI EQUI_SRTYPE COCF_CU_SRTYPE Shift Report Type - Definition SRTYPE
0 EQUI GEWEI T006 Units of Measurement MANDT
0 EQUI GEWEI T006 Units of Measurement MSEHI
1 EQUI HERLD T005 Countries MANDT
1 EQUI HERLD T005 Countries LAND1
0 EQUI IMRC_POINT IMPTT Measuring Point (Table) POINT
1 EQUI IUID_TYPE TIUID_TYPE Item Unique Identifier Type IUID_TYPE
0 EQUI J_3GEQART J_3GFEQUI External Equipment Type J_3GEQART
1 EQUI J_3GKONDE T178 Conditions: Groups for Materials MANDT
1 EQUI J_3GKONDE T178 Conditions: Groups for Materials KONDM
0 EQUI J_3GKZLADG J_3GLADEKE Loading Costs Indicator J_3GKZLADG
1 EQUI J_3GVERMEIN T006 Units of Measurement MANDT
0 EQUI KMATN MARA General Material Data MANDT
0 EQUI KMATN MARA General Material Data MATNR
1 EQUI KUNDE KNA1 General Data in Customer Master MANDT
1 EQUI KUNDE KNA1 General Data in Customer Master KUNNR
0 EQUI LAGER T001L Storage Locations MANDT
0 EQUI LAGER T001L Storage Locations WERKS
1 EQUI MANDT T000 Clients MANDT
0 EQUI MATNR MARA General Material Data MANDT
0 EQUI MATNR MARA General Material Data MATNR
1 EQUI MEINS T006 Units of Measurement MANDT
1 EQUI MEINS T006 Units of Measurement MSEHI
0 EQUI MGANR BGMK Master Warranty Header MANDT
0 EQUI MGANR BGMK Master Warranty Header MGANR
1 EQUI SPARTE TSPA Organizational Unit: Sales Divisions MANDT
1 EQUI SPARTE TSPA Organizational Unit: Sales Divisions SPART
0 EQUI WAERS TCURC Currency Codes MANDT
0 EQUI WAERS TCURC Currency Codes WAERS
1 EQUI WARPL MPLA Maintenance plan WARPL
0 EQUI WERK T001W Plants/Branches WERKS