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 |