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