SAP table reference

EQUI

Equipment master data

Explore another table

Enter a table code or keyword to continue exploring.

Explore the structure, fields and relationships of SAP table EQUI.

SAP table EQUI has 2 primary key fields: MANDT,EQUNR.

When analysing data from one SAP instance, MANDT is normally identical across the dataset and may be omitted from relationships. When combining multiple instances, include MANDT.

/ Fields

EQUI fields.

98 fields
FieldDescriptionData typeLengthDecimalsCheck tableData element
Key MANDT ClientCLNT30 T000 MANDT
Key EQUNR Equipment NumberCHAR180 EQUNR
ERDAT Date on which the record was createdDATS80 ERDAT
ERNAM Name of Person Responsible for Creating the ObjectCHAR120 ERNAM
EQASP Language in Which the Piece of Equipment was EnteredLANG10 T002 EQASP
AEDAT Last Changed OnDATS80 AEDAT
AENAM Name of Person Who Changed ObjectCHAR120 AENAM
BEGRU Technical Object Authorization GroupCHAR40 T370B IAUTG
EQTYP Equipment categoryCHAR10 T370T EQTYP
EQART Type of Technical ObjectCHAR100 T370K EQART
LVORM SAP Development Reserve: Format CHAR, Length 1CHAR10 RESERVE_CHAR_001
INVNR Inventory numberCHAR250 INVNR
GROES Size/dimensionCHAR180 GROSS
BRGEW Weight of objectQUAN133 OBJ_WEIGHT
GEWEI Unit of weightUNIT30 T006 WEIGHT_UNIT
ANSDT Acquisition dateDATS80 ANDTI
ANSWT Acquisition ValueCURR132 ANSWT
WAERS Currency KeyCUKY50 TCURC WAERS
ELIEF Vendor numberCHAR100 LFA1 ELIEF
GWLEN Date on which the warranty endsDATS80 GWLEN
GWLDT Guarantee dateDATS80 GWLDT
WDBWT Equipment replacement valueCURR132 WDBWT
HERST Manufacturer of AssetCHAR300 HERST
HERLD Country/Region of ManufactureCHAR30 T005 HERLD
HZEIN Manufacturer drawing numberCHAR300 HZEIN
SERGE Manufacturer's Serial NumberCHAR300 SERGE
TYPBZ Manufacturer model numberCHAR200 TYPBZ
BAUJJ Year of constructionCHAR40 BAUJJ
BAUMM Month of constructionCHAR20 BAUMM
APLKZ Indicator: Task List ExistsCHAR10 APLKZ
AULDT First delivery date of the equipmentDATS80 AULDT
INBDT Start-up Date of the Technical ObjectDATS80 ILOM_DATAB
GERNR Serial NumberCHAR180 GERNR
EQLFN Consecutive numbering of EquipUsagePeriods on same dayNUMC30 EQLFN
GWLDV Warranty date for Sales and DistributionDATS80 GWLDV
EQDAT Date, intended for SAP internal useDATS80 EQDAT
EQBER Technical information, intended for SAP internal useCHAR300 EQBER
EQNUM Numerical field, intended for SAP internal useNUMC90 EQNUM
OBJNR Object numberCHAR220 J_OBJNR
EQSNR EQSE NumberCHAR180 EQSE EQSNR
CUOBJ Configuration (internal object number)NUMC180 CUOBJ
KRFKZ Referenced ConfigurationCHAR10 KRFKZ
KMATN Configurable MaterialCHAR400 MARA KMATN
MATNR Material NumberCHAR400 MARA MATNR
SERNR Serial NumberCHAR180 GERNR
WERK PlantCHAR40 T001W WERKS_D
LAGER Storage locationCHAR40 T001L LGORT_D
CHARGE Batch NumberCHAR100 MCH1 CHARG_D
KUNDE Customer to Whom Serial Number was DeliveredCHAR100 KNA1 KUNDSE
WARPL Maintenance PlanCHAR120 MPLA WARPL
IMRC_POINT Measuring PointCHAR120 IMPTT IMRC_POINT
REVLV Revision LevelCHAR20 REVLV
MGANR Master warranty numberCHAR200 BGMK MGANR
BEGRUI Data origin for authorization group fieldCHAR10 INH_BEGRUI
S_EQUI Equipment data existsCHAR10 EQUIP_KNZ
S_SERIAL Serial data when maintaining equipmentCHAR10 KZKSD
S_KONFI Configuration supportedCHAR10 KONFKNZ
S_SALE Sales equipmentCHAR10 SDKNZ
S_FHM Equip. category relevant to production resources and toolsCHAR10 FHMKZ
S_ELSE Indicator: Other Data ActiveCHAR10 ELSE_KNZ
S_ISU IS-U dataCHAR10 ISU_KNZ
S_EQBS EQSI ExistsCHAR10 KZEQBS
S_FLEET Indicator: Fleet object activeCHAR10 FLEET_KNZ
BSTVP Stock Check for Serial NumbersCHAR10 BSTVP
SPARTE DivisionCHAR20 TSPA SPARTE
HANDLE SAP Development Reserve: Integration of Date Segment (Key)CHAR220 ITOBTMP_TSEGGUID
TSEGTP SAP Development Reserve: Integration Date Segment (Tempate)CHAR100 ITOBTMP_TSEGTEMPLA
EMATN Material number corresponding to manufacturer part numberCHAR400 EMATN
ACT_CHANGE_AA Change Equipment Master when Changing AssetCHAR10 AAPM_ACT_CHANGE_AA
S_CC Configuration Control DataCHAR10 CCC_KNZ
DATLWB Date of Last Goods MovementDATS80 DATLWB
UII Unique Item IdentifierCHAR720 UII_CHAR72
IUID_TYPE Structure Type of UIICHAR100 TIUID_TYPE IUID_TYPE
UII_PLANT Plant Responsible for UIICHAR40 UII_PLANT
CHANGEDDATETIME UTC Time Stamp in Short Form (YYYYMMDDhhmmss)DEC150 TZNTSTMPS
ENDOFUSE End-of-Use Date of the Technical ObjectDATS80 ENDOFUSE_DATE
DUMMY_EQUI_INCL_EEW_PS Custom Fields: Dummy for Use in Extension IncludesCHAR10 CFD_DUMMY
EQEXT_ACTIVE Backpack Table /isdfps/lmeqext ActiveCHAR10 /ISDFPS/DE_LM_DB_EQEXT_ACTIVE
EQUI_SRTYPE Shift Report TypeCHAR100 COCF_CU_SRTYPE COCF_SR_SRTYPE
EQUI_SNTYPE Shift Note TypeCHAR20 TQ80 COCF_SN_SNTYPE
EQLB_DUTY Logbook DutyCHAR10 DIACL_DUTY
EQLB_HIDE Hide Logbook DisplayCHAR10 DIACL_HIDE
J_3GDISPO Planning IndicatorCHAR10 J_3GDISPO
J_3GZDEQUI Indicator for Central-Decentral EquipmentCHAR10 J_3GZDEQUI
J_3GEQART Procurement Type for External EquipmentCHAR100 J_3GFEQUI J_3GEQART
J_3GKZMENG Item/Multipart IndicatorCHAR10 J_3GKZMENG
J_3GKONDE Material Price GroupCHAR20 T178 KONDM
J_3GFIKTIV Fictitious IndicatorCHAR10 J_3GFIKTIV
J_3GBELTYP Document Categories AllowedCHAR150 J_3GBELTYP
MEINS Base Unit of MeasureUNIT30 T006 MEINS
J_3GKZLADG Indicator: Relevancy to Loading CostsCHAR10 J_3GLADEKE J_3GKZLADG
J_3GKZBERG Indicator for Provision FeesCHAR10 J_3GKZBERG
J_3GEIFR Indicator for Own/External EquipmentCHAR10 J_3GEIFR
J_3GVERMEIN Unit of Measure for SettlementUNIT30 T006 J_3GVERMEIN
J_3GZULNR License Plate NumberCHAR150 J_3GLICENCE_NUM
/SAPCEM/ABRECHVH Settlement Using Shipping DocumentCHAR10 /SAPCEM/ABRECHVH
/SAPCEM/ABRECHLG Settlement Using PBE DocumentCHAR10 /SAPCEM/ABRECHLG
/SAPCEM/DISPOGR Planning GroupCHAR40 /SAPCEM/DISPOGRU /SAPCEM/DISPOGR
/ Relationships

EQUI relationships.

43 relationships
TableFieldCheck tableDescriptionCheck field
EQUIBEGRUT370BTechnical object authorization groupMANDT
EQUIBEGRUT370BTechnical object authorization groupBEGRU
EQUICHARGEMCH1Batches (if Batch Management Cross-Plant)MANDT
EQUIELIEFLFA1Supplier Master (General Section)MANDT
EQUIELIEFLFA1Supplier Master (General Section)LIFNR
EQUIEQARTT370KType of technical objectMANDT
EQUIEQARTT370KType of technical objectEQART
EQUIEQASPT002Language Keys (Component BC-I18)SPRAS
EQUIEQTYPT370TEquipment categoriesMANDT
EQUIEQTYPT370TEquipment categoriesEQTYP
EQUIEQUI_SNTYPETQ80Notification TypesMANDT
EQUIEQUI_SNTYPETQ80Notification TypesQMART
EQUIEQUI_SRTYPECOCF_CU_SRTYPEShift Report Type - DefinitionSRTYPE
EQUIGEWEIT006Units of MeasurementMANDT
EQUIGEWEIT006Units of MeasurementMSEHI
EQUIHERLDT005CountriesMANDT
EQUIHERLDT005CountriesLAND1
EQUIIMRC_POINTIMPTTMeasuring Point (Table)POINT
EQUIIUID_TYPETIUID_TYPEItem Unique Identifier TypeIUID_TYPE
EQUIJ_3GEQARTJ_3GFEQUIExternal Equipment TypeJ_3GEQART
EQUIJ_3GKONDET178Conditions: Groups for MaterialsMANDT
EQUIJ_3GKONDET178Conditions: Groups for MaterialsKONDM
EQUIJ_3GKZLADGJ_3GLADEKELoading Costs IndicatorJ_3GKZLADG
EQUIJ_3GVERMEINT006Units of MeasurementMANDT
EQUIKMATNMARAGeneral Material DataMANDT
EQUIKMATNMARAGeneral Material DataMATNR
EQUIKUNDEKNA1General Data in Customer MasterMANDT
EQUIKUNDEKNA1General Data in Customer MasterKUNNR
EQUILAGERT001LStorage LocationsMANDT
EQUILAGERT001LStorage LocationsWERKS
EQUIMANDTT000ClientsMANDT
EQUIMATNRMARAGeneral Material DataMANDT
EQUIMATNRMARAGeneral Material DataMATNR
EQUIMEINST006Units of MeasurementMANDT
EQUIMEINST006Units of MeasurementMSEHI
EQUIMGANRBGMKMaster Warranty HeaderMANDT
EQUIMGANRBGMKMaster Warranty HeaderMGANR
EQUISPARTETSPAOrganizational Unit: Sales DivisionsMANDT
EQUISPARTETSPAOrganizational Unit: Sales DivisionsSPART
EQUIWAERSTCURCCurrency CodesMANDT
EQUIWAERSTCURCCurrency CodesWAERS
EQUIWARPLMPLAMaintenance planWARPL
EQUIWERKT001WPlants/BranchesWERKS