The EQUI table in SAP ERP or S/4HANA stores Equipment master data data. There are total 102 fields in EQUI table. The Equipment master data table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of EQUI table. It is in Application Develoment R/3 Equipment Management (IEQM) ABAP package and is part of the Equipment (PM-EQM-EQ) module.
SAP EQUI Table Fields
Following is the list of fields that are available in SAP EQUI table. The primary key fields of the table are MANDT (Client), EQUNR (Equipment Number).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT (3) |
| EQUNR | Equipment Number | EQUNR | CHAR (18) | |
| ERDAT | Date on which the record was created | ERDAT | DATS (8) | |
| ERNAM | Name of Person who Created the Object | ERNAM | CHAR (12) | |
| EQASP | Language in Which the Piece of Equipment was Entered | EQASP | T002 | LANG (1) |
| AEDAT | Date of Last Change | AEDAT | DATS (8) | |
| AENAM | Name of person who changed object | AENAM | CHAR (12) | |
| BEGRU | Technical object authorization group | IAUTG | T370B | CHAR (4) |
| EQTYP | Equipment category | EQTYP | T370T | CHAR (1) |
| EQART | Type of Technical Object | EQART | T370K | CHAR (10) |
| LVORM | SAP Development Reserve: Format CHAR, Length 1 | RESERVE_CHAR_001 | CHAR (1) | |
| INVNR | Inventory number | INVNR | CHAR (25) | |
| GROES | Size/dimension | GROSS | CHAR (18) | |
| BRGEW | Weight of object | OBJ_WEIGHT | QUAN (13) | |
| GEWEI | Unit of weight | WEIGHT_UNIT | T006 | UNIT (3) |
| ANSDT | Acquisition date | ANDTI | DATS (8) | |
| ANSWT | Acquisition Value | ANSWT | CURR (13) | |
| WAERS | Currency Key | WAERS | TCURC | CUKY (5) |
| ELIEF | Vendor number | ELIEF | LFA1 | CHAR (10) |
| GWLEN | Date on which the warranty ends | GWLEN | DATS (8) | |
| GWLDT | Guarantee date | GWLDT | DATS (8) | |
| WDBWT | Equipment replacement value | WDBWT | CURR (13) | |
| HERST | Manufacturer of Asset | HERST | CHAR (30) | |
| HERLD | Country of manufacture | HERLD | T005 | CHAR (3) |
| HZEIN | Manufacturer drawing number | HZEIN | CHAR (30) | |
| SERGE | Manufacturer serial number | SERGE | CHAR (30) | |
| TYPBZ | Manufacturer model number | TYPBZ | CHAR (20) | |
| BAUJJ | Year of construction | BAUJJ | CHAR (4) | |
| BAUMM | Month of construction | BAUMM | CHAR (2) | |
| APLKZ | Indicator: Task List Exists | APLKZ | CHAR (1) | |
| AULDT | First delivery date of the equipment | AULDT | DATS (8) | |
| INBDT | Start-up Date of the Technical Object | ILOM_DATAB | DATS (8) | |
| GERNR | Serial Number | GERNR | CHAR (18) | |
| EQLFN | Consecutive numbering of EquipUsagePeriods on same day | EQLFN | NUMC (3) | |
| GWLDV | Warranty date for Sales and Distribution | GWLDV | DATS (8) | |
| EQDAT | Date, intended for SAP internal use | EQDAT | DATS (8) | |
| EQBER | Technical information, intended for SAP internal use | EQBER | CHAR (30) | |
| EQNUM | Numerical field, intended for SAP internal use | EQNUM | NUMC (9) | |
| OBJNR | Object number | J_OBJNR | CHAR (22) | |
| EQSNR | EQSE Number | EQSNR | EQSE | CHAR (18) |
| CUOBJ | Configuration (internal object number) | CUOBJ | NUMC (18) | |
| KRFKZ | Referenced Configuration | KRFKZ | CHAR (1) | |
| KMATN | Configurable Material | KMATN | MARA | CHAR (40) |
| MATNR | Material Number | MATNR | MARA | CHAR (40) |
| SERNR | Serial Number | GERNR | CHAR (18) | |
| WERK | Plant | WERKS_D | T001W | CHAR (4) |
| LAGER | Storage location | LGORT_D | T001L | CHAR (4) |
| CHARGE | Batch Number | CHARG_D | MCH1 | CHAR (10) |
| KUNDE | Customer to Whom Serial Number was Delivered | KUNDSE | KNA1 | CHAR (10) |
| WARPL | Maintenance Plan | WARPL | MPLA | CHAR (12) |
| IMRC_POINT | Measuring Point | IMRC_POINT | IMPTT | CHAR (12) |
| REVLV | Revision Level | REVLV | CHAR (2) | |
| MGANR | Master warranty number | MGANR | BGMK | CHAR (20) |
| BEGRUI | Data origin for authorization group field | INH_BEGRUI | CHAR (1) | |
| S_EQUI | Equipment data exists | EQUIP_KNZ | CHAR (1) | |
| S_SERIAL | Serial data when maintaining equipment | KZKSD | CHAR (1) | |
| S_KONFI | Configuration supported | KONFKNZ | CHAR (1) | |
| S_SALE | Sales equipment | SDKNZ | CHAR (1) | |
| S_FHM | Equip. category relevant to production resources and tools | FHMKZ | CHAR (1) | |
| S_ELSE | Indicator: Other Data Active | ELSE_KNZ | CHAR (1) | |
| S_ISU | IS-U data | ISU_KNZ | CHAR (1) | |
| S_EQBS | EQSI Exists | KZEQBS | CHAR (1) | |
| S_FLEET | Indicator: Fleet object active | FLEET_KNZ | CHAR (1) | |
| BSTVP | Stock Check for Serial Numbers | BSTVP | CHAR (1) | |
| SPARTE | Division | SPARTE | TSPA | CHAR (2) |
| HANDLE | SAP Development Reserve: Integration of Date Segment (Key) | ITOBTMP_TSEGGUID | CHAR (22) | |
| TSEGTP | SAP Development Reserve: Integration Date Segment (Tempate) | ITOBTMP_TSEGTEMPLA | CHAR (10) | |
| EMATN | Material number corresponding to manufacturer part number | EMATN | CHAR (40) | |
| ACT_CHANGE_AA | Change Equipment Master when Changing Asset | AAPM_ACT_CHANGE_AA | CHAR (1) | |
| S_CC | Configuration Control Data | CCC_KNZ | CHAR (1) | |
| DATLWB | Date of Last Goods Movement | DATLWB | DATS (8) | |
| UII | Unique Item Identifier | UII_CHAR72 | CHAR (72) | |
| IUID_TYPE | Structure Type of UII | IUID_TYPE | TIUID_TYPE | CHAR (10) |
| UII_PLANT | Plant Responsible for UII | UII_PLANT | CHAR (4) | |
| CHANGEDDATETIME | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TZNTSTMPS | DEC (15) | |
| DESC | Material Description | MAKTX | CHAR (40) | |
| ZNAME1 | Name | NAME1 | CHAR (30) | |
| ZMTART | Material type | MTART | * | CHAR (4) |
| ZERDAT | Date on which the record was created | ERDAT | DATS (8) | |
| ZMENGE | Target Quantity in Sales Units | DZMENG | QUAN (13) | |
| ZWERKS | Plant | WERKS_D | CHAR (4) | |
| ZVKORG | Sales Organization | VKORG | CHAR (4) | |
| EQEXT_ACTIVE | Backpack Table /isdfps/lmeqext Active | /ISDFPS/DE_LM_DB_EQEXT_ACTIVE | CHAR (1) | |
| EQUI_SNTYPE | Shift Note Type | COCF_SN_SNTYPE | TQ80 | CHAR (2) |
| EQLB_DUTY | Logbook Duty | DIACL_DUTY | CHAR (1) | |
| EQLB_HIDE | Hide Logbook Display | DIACL_HIDE | CHAR (1) | |
| J_3GDISPO | Planning Indicator | J_3GDISPO | CHAR (1) | |
| J_3GZDEQUI | Indicator for Central-Decentral Equipment | J_3GZDEQUI | CHAR (1) | |
| J_3GEQART | Procurement Type for External Equipment | J_3GEQART | J_3GFEQUI | CHAR (10) |
| J_3GKZMENG | Item/Multipart Indicator | J_3GKZMENG | CHAR (1) | |
| J_3GKONDE | Material Price Group | KONDM | T178 | CHAR (2) |
| J_3GFIKTIV | Fictitious Indicator | J_3GFIKTIV | CHAR (1) | |
| J_3GBELTYP | Document Categories Allowed | J_3GBELTYP | CHAR (15) | |
| MEINS | Base Unit of Measure | MEINS | T006 | UNIT (3) |
| J_3GKZLADG | Indicator: Relevancy to Loading Costs | J_3GKZLADG | J_3GLADEKE | CHAR (1) |
| J_3GKZBERG | Indicator for Provision Fees | J_3GKZBERG | CHAR (1) | |
| J_3GEIFR | Indicator for Own/External Equipment | J_3GEIFR | CHAR (1) | |
| J_3GVERMEIN | Unit of Measure for Settlement | J_3GVERMEIN | T006 | UNIT (3) |
| J_3GZULNR | License Plate Number | J_3GLICENCE_NUM | CHAR (15) | |
| /SAPCEM/ABRECHVH | Settlement Using Shipping Document | /SAPCEM/ABRECHVH | CHAR (1) | |
| /SAPCEM/ABRECHLG | Settlement Using PBE Document | /SAPCEM/ABRECHLG | CHAR (1) | |
| /SAPCEM/DISPOGR | Planning Group | /SAPCEM/DISPOGR | /SAPCEM/DISPOGRU | CHAR (4) |
