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 | Possible values | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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 | ||||||||||||
|
||||||||||||||||
|
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 | ||||||||||||
|
||||||||||||||||
|
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 | ||||||||||||
|
||||||||||||||||
|
S_EQUI
Equipment data exists
|
EQUIP_KNZ |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
S_SERIAL
Serial data when maintaining equipment
|
KZKSD |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
S_KONFI
Configuration supported
|
KONFKNZ |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
S_SALE
Sales equipment
|
SDKNZ |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
S_FHM
Equip. category relevant to production resources and tools
|
FHMKZ |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
S_ELSE
Indicator: Other Data Active
|
ELSE_KNZ |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
S_ISU
IS-U data
|
ISU_KNZ |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
S_EQBS
EQSI Exists
|
KZEQBS |
CHAR
|
1 | 0 | ||||||||||||
|
S_FLEET
Indicator: Fleet object active
|
FLEET_KNZ |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
BSTVP
Stock Check for Serial Numbers
|
BSTVP |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
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 | ||||||||||||
|
||||||||||||||||
|
S_CC
Configuration Control Data
|
CCC_KNZ |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
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 | ||||||||||||
|
||||||||||||||||
|
/GEP/KLIMA
Vehicle Equipment: Air Conditioning
|
/GEP/FLEET_D_KLIMA |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
/GEP/DACHG
Vehicle Equipment: Roof Rack
|
/GEP/FLEET_D_DACHG |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
/GEP/SCHNEEK
Vehicle Equipment: Snow Chains
|
/GEP/FLEET_D_SCHNEEK |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
/GEP/WINTERR
Vehicle Equipment: Snow Tyres
|
/GEP/FLEET_D_WINTERR |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
/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 | ||||||||||||
|
||||||||||||||||
|
/MRSS/ID_PROFILE
Requirements Profile Was Changed Manually
|
/MRSS/T_REQU_UPD |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
/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 | ||||||||||||
|
||||||||||||||||
|
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 | ||||||||||||
|
||||||||||||||||
|
EQLB_HIDE
Hide Logbook Display
|
DIACL_HIDE |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
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 |