EQUI SAP (Equipment master data) Table details
Dictionary Type: Table
Description: Equipment master data
Description: Equipment master data
Table field list including key, data, relationships and ABAP select examples
EQUI is a standard SAP Table which is used to store Equipment master data data and is available within R/3 SAP systems depending on the version and release level.
The EQUI table consists of various fields, each holding specific information or linking keys about Equipment master data data available in SAP. These include EQUNR (Equipment Number), ERDAT (Date on Which Record Was Created), ERNAM (Name of Person who Created the Object), EQASP (Language in Which the Piece of Equipment was Entered).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
Text table = EQKT
SAP EQUI table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
EQUNR | Equipment Number | EQUNR | CHAR | 18 | ALPHA | EQUNR | EQN | EQUI | |
ERDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | DATUM | ||||
ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
EQASP | Language in Which the Piece of Equipment was Entered | EQASP | LANG | 1 | T002 | ISOLA | SPRAS | ||
AEDAT | Changed On | AEDAT | DATS | 8 | DATUM | ||||
AENAM | Name of Person Who Changed Object | AENAM | CHAR | 12 | USNAM | ||||
BEGRU | Technical object authorization group | IAUTG | CHAR | 4 | T370B | IAUTG | |||
EQTYP | Equipment category | EQTYP | CHAR | 1 | T370T | EQTYP | EQT | ||
EQART | Type of Technical Object | EQART | CHAR | 10 | T370K | EQART | |||
LVORM | SAP Development Reserve: Format CHAR, Length 1 | RESERVE_CHAR_001 | CHAR | 1 | CHAR1 | ||||
INVNR | Inventory number | INVNR | CHAR | 25 | INVNR_ANLA | ||||
GROES | Size/dimension | GROSS | CHAR | 18 | GROES | ||||
BRGEW | Weight of object | OBJ_WEIGHT | QUAN | 13(3) | MENG13 | ||||
GEWEI | Unit of weight | WEIGHT_UNIT | UNIT | 3 | T006 | CUNIT | MEINS | ||
ANSDT | Acquisition date | ANDTI | DATS | 8 | DATUM | ||||
ANSWT | Acquisition Value | ANSWT | CURR | 13(2) | WERT | ||||
WAERS | Currency Key | WAERS | CUKY | 5 | TCURC | WAERS | FWS | ||
ELIEF | Vendor number | ELIEF | CHAR | 10 | LFA1 | ALPHA | LIFNR | ||
GWLEN | Date on which the warranty ends | GWLEN | DATS | 8 | DATUM | ||||
GWLDT | Warranty Date | GWLDT | DATS | 8 | DATUM | ||||
WDBWT | Equipment replacement value | WDBWT | CURR | 13(2) | WERT | ||||
HERST | Manufacturer of asset | HERST | CHAR | 30 | TEXT30 | ||||
HERLD | Country of manufacture | HERLD | CHAR | 3 | T005 | LAND1 | |||
HZEIN | Manufacturer drawing number | HZEIN | CHAR | 30 | HZEIN | ||||
SERGE | Manufacturer serial number | SERGE | CHAR | 30 | CHAR30 | ||||
TYPBZ | Manufacturer model number | TYPBZ | CHAR | 20 | TYPBZ | ||||
BAUJJ | Year of construction | BAUJJ | CHAR | 4 | GJAHR | CJAHR | |||
BAUMM | Month of construction | BAUMM | CHAR | 2 | BAUMM | ||||
APLKZ | Indicator: Task List Exists | APLKZ | CHAR | 1 | APLKZ | ||||
AULDT | First delivery date of the equipment | AULDT | DATS | 8 | DATUM | ||||
INBDT | Start-up Date of the Technical Object | ILOM_DATAB | DATS | 8 | DATUM | ||||
GERNR | Serial Number | GERNR | CHAR | 18 | GERNR | GERNR | SER | ||
EQLFN | Consecutive numbering of EquipUsagePeriods on same day | EQLFN | NUMC | 3 | NUM03 | EQL | |||
GWLDV | Warranty date for Sales and Distribution | GWLDV | DATS | 8 | DATUM | ||||
EQDAT | Date, intended for SAP internal use | EQDAT | DATS | 8 | DATUM | ||||
EQBER | Technical information, intended for SAP internal use | EQBER | CHAR | 30 | CHAR30 | ||||
EQNUM | Numerical field, intended for SAP internal use | EQNUM | NUMC | 9 | NUM9 | ||||
OBJNR | Object number | J_OBJNR | CHAR | 22 | Assigned to domain | J_OBJNR | ONR | ||
EQSNR | EQSE Number | EQSNR | CHAR | 18 | EQSE | EQSNR | |||
CUOBJ | Configuration (internal object number) | CUOBJ | NUMC | 18 | CUOBJ | CUX | |||
KRFKZ | Referenced Configuration | KRFKZ | CHAR | 1 | X | ||||
KMATN | Configurable Material | KMATN | CHAR | 18 | MARA | MATN1 | MATNR | MAT1 | |
MATNR | Material Number | MATNR | CHAR | 18 | MARA | MATN1 | MATNR | MAT | S_MAT1 |
SERNR | Serial Number | GERNR | CHAR | 18 | GERNR | GERNR | SER | ||
WERK | Plant | WERKS_D | CHAR | 4 | T001W | WERKS | WRK | H_T001W_C | |
LAGER | Storage Location | LGORT_D | CHAR | 4 | T001L | LGORT | LAG | ||
CHARGE | Batch Number | CHARG_D | CHAR | 10 | MCH1 | CHARG | CHA | ||
KUNDE | Customer to Whom Serial Number was Delivered | KUNDSE | CHAR | 10 | KNA1 | ALPHA | KUNNR | ||
WARPL | Maintenance Plan | WARPL | CHAR | 12 | MPLA | ALPHA | WARPL | MPL | MPLAL |
IMRC_POINT | Measuring Point | IMRC_POINT | CHAR | 12 | IMPTT | ALPHA | IMRC_POINT | IPT | IMPM |
REVLV | Revision Level | REVLV | CHAR | 2 | NUMCV | REVLV | RVS | ||
MGANR | Master warranty number | MGANR | CHAR | 20 | BGMK | ALPHA | MGANR | GAM | |
BEGRUI | Data origin for authorization group field | INH_BEGRUI | CHAR | 1 | INHER | ||||
S_EQUI | Equipment data exists | EQUIP_KNZ | CHAR | 1 | X | ||||
S_SERIAL | Serial data when maintaining equipment | KZKSD | CHAR | 1 | X | ||||
S_KONFI | Configuration supported | KONFKNZ | CHAR | 1 | XFELD | ||||
S_SALE | Sales equipment | SDKNZ | CHAR | 1 | XFELD | ||||
S_FHM | Equip. category relevant to production resources and tools | FHMKZ | CHAR | 1 | XFLAG | ||||
S_ELSE | Indicator: Other Data Active | ELSE_KNZ | CHAR | 1 | X | ||||
S_ISU | IS-U data | ISU_KNZ | CHAR | 1 | X | ||||
S_EQBS | EQSI Exists | KZEQBS | CHAR | 1 | KZEQBS | ||||
S_FLEET | Indicator: Fleet object active | FLEET_KNZ | CHAR | 1 | X | ||||
BSTVP | Stock Check for Serial Numbers | BSTVP | CHAR | 1 | BSTVP | ||||
SPARTE | Division | SPARTE | CHAR | 2 | TSPA | SPART | SPA | ||
HANDLE | SAP Development Reserve: Integration of Date Segment (Key) | ITOBTMP_TSEGGUID | CHAR | 22 | SYSUUID_22 | ||||
TSEGTP | SAP Development Reserve: Integration Date Segment (Tempate) | ITOBTMP_TSEGTEMPLA | CHAR | 10 | Assigned to domain | TMPLA | TSEGTEMPLA | ||
EMATN | Material Number Corresponding to Manufacturer Part Number | EMATN | CHAR | 18 | Assigned to domain | MATN1 | MATNR | HTN | |
ACT_CHANGE_AA | Change Equipment Master when Changing Asset | AAPM_ACT_CHANGE_AA | CHAR | 1 | AAPM_ACT | ||||
S_CC | Configuration Control Data | CCC_KNZ | CHAR | 1 | X | ||||
DATLWB | Date of Last Goods Movement | DATLWB | DATS | 8 | DATS | ||||
UII | Unique Item Identifier | UII_CHAR72 | CHAR | 72 | UII_CHAR72 | UII | H_UII | ||
IUID_TYPE | Structure Type of UII | IUID_TYPE | CHAR | 10 | TIUID_TYPE | IUID_TYPE | H_IUID_TYPE | ||
UII_PLANT | Plant Responsible for UII | UII_PLANT | CHAR | 4 | Assigned to domain | WERKS | WRK | H_T001W_C | |
/GEP/PASSENGER | Number of Passengers | /GEP/FLEET_D_PASSENGER | NUMC | 2 | /GEP/FLEET_DO_PASSENGER | ||||
/GEP/AUTOM | Vehicle Equipment: Automatic Transmission | /GEP/FLEET_D_AUTOM | CHAR | 1 | CMPFLAG | ||||
/GEP/KLIMA | Vehicle Equipment: Air Conditioning | /GEP/FLEET_D_KLIMA | CHAR | 1 | CMPFLAG | ||||
/GEP/DACHG | Vehicle Equipment: Roof Rack | /GEP/FLEET_D_DACHG | CHAR | 1 | CMPFLAG | ||||
/GEP/SCHNEEK | Vehicle Equipment: Snow Chains | /GEP/FLEET_D_SCHNEEK | CHAR | 1 | CMPFLAG | ||||
/GEP/WINTERR | Vehicle Equipment: Snow Tyres | /GEP/FLEET_D_WINTERR | CHAR | 1 | CMPFLAG | ||||
/GEP/VHCAT | Vehicle Type | /GEP/FLEET_D_VHCAT | CHAR | 2 | /GEP/FLEET_DO_VEHICLE_CAT | ||||
.INCLU--AP | 0 | ||||||||
EQEXT_ACTIVE | Backpack Table /isdfps/lmeqext Active | /ISDFPS/DE_LM_DB_EQEXT_ACTIVE | CHAR | 1 | XFELD | ||||
.INCLU--AP | 0 | ||||||||
/MRSS/ID_PROFILE | Requirements Profile Was Changed Manually | /MRSS/T_REQU_UPD | CHAR | 1 | /MRSS/_HCM_BOOLEAN | ||||
/MRSS/PROF_GUID | GUID | /MRSS/T_RSG_GUID | RAW | 16 | SYSUUID | ||||
/MRSS/PROF_KEY | Profile Key | /MRSS/T_RSG_REQUID | CHAR | 10 | ALPHA | /MRSS/RSG_REQUID | |||
/MRSS/DATACHANGE | Data was changed in the controls on the user screen | /MRSS/T_USCREENCTL_DATACHANGED | CHAR | 1 | FLAG | ||||
.INCLU--AP | 0 | ||||||||
EQUI_SRTYPE | Shift Report Type | COCF_SR_SRTYPE | CHAR | 10 | COCF_CU_SRTYPE | ||||
EQUI_SNTYPE | Shift Note Type | COCF_SN_SNTYPE | CHAR | 2 | TQ80 | QMART | |||
.INCLU--AP | 0 | ||||||||
EQLB_DUTY | Logbook Duty | DIACL_DUTY | CHAR | 1 | XFLAG | ||||
EQLB_HIDE | Hide Logbook Display | DIACL_HIDE | CHAR | 1 | XFLAG | ||||
.INCLU--AP | 0 | ||||||||
J_3GDISPO | Planning Indicator | J_3GDISPO | CHAR | 1 | J_3GDISPO | ||||
J_3GZDEQUI | Indicator for Central-Decentral Equipment | J_3GZDEQUI | CHAR | 1 | J_3GZDEQUI | ||||
J_3GEQART | Procurement Type for External Equipment | J_3GEQART | CHAR | 10 | J_3GFEQUI | J_3GEQART | |||
J_3GKZMENG | Item/Multipart Indicator | J_3GKZMENG | CHAR | 1 | J_3GKZMENG | ||||
J_3GKONDE | Material Pricing Group | KONDM | CHAR | 2 | T178 | KONDM | VKM | ||
J_3GFIKTIV | Fictitious Indicator | J_3GFIKTIV | CHAR | 1 | X | ||||
J_3GBELTYP | Document Categories Allowed | J_3GBELTYP | CHAR | 15 | CHAR15 | ||||
MEINS | Base Unit of Measure | MEINS | UNIT | 3 | T006 | CUNIT | MEINS | ||
J_3GKZLADG | Indicator: Relevancy to Loading Costs | J_3GKZLADG | CHAR | 1 | J_3GLADEKE | CHAR1 | |||
J_3GKZBERG | Indicator for Provision Fees | J_3GKZBERG | CHAR | 1 | J_3GKZBERG | ||||
J_3GEIFR | Indicator for Own/External Equipment | J_3GEIFR | CHAR | 1 | J_3GEIFR | ||||
J_3GVERMEIN | Unit of Measure for Settlement | J_3GVERMEIN | UNIT | 3 | T006 | CUNIT | MEINS | ||
J_3GZULNR | License Plate Number | J_3GLICENCE_NUM | CHAR | 15 | CHAR15 | ||||
/SAPCEM/ABRECHVH | Settlement Using Shipping Document | /SAPCEM/ABRECHVH | CHAR | 1 | XCHAR | ||||
/SAPCEM/ABRECHLG | Settlement Using PBE Document | /SAPCEM/ABRECHLG | CHAR | 1 | XCHAR | ||||
/SAPCEM/DISPOGR | Planning Group | /SAPCEM/DISPOGR | CHAR | 4 | /SAPCEM/DISPOGRU | /SAPCEM/DISPOGR |
Key field | Non-key field |
How do I retrieve data from SAP table EQUI using ABAP code
The following ABAP code Example will allow you to do a basic selection on EQUI to SELECT all data from the tableDATA: WA_EQUI TYPE EQUI.
SELECT SINGLE *
FROM EQUI
INTO CORRESPONDING FIELDS OF WA_EQUI
WHERE...
How to access SAP table EQUI
Within an ECC or HANA version of SAP you can also view further information about EQUI and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects