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