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".

Fields for table EQUI

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
MANDTClientXMANDTCLNT6T000
EQUNREquipment NumberXEQUNRCHAR36
ERDATDate on which the record was createdERDATDATS16
ERNAMName of Person Responsible for Creating the ObjectERNAMCHAR24
EQASPLanguage in Which the Piece of Equipment was EnteredEQASPLANG2T002
AEDATLast Changed OnAEDATDATS16
AENAMName of Person Who Changed ObjectAENAMCHAR24
BEGRUTechnical Object Authorization GroupIAUTGCHAR8T370B
EQTYPEquipment categoryEQTYPCHAR2T370T
EQARTType of Technical ObjectEQARTCHAR20T370K
LVORMSAP Development Reserve: Format CHAR, Length 1RESERVE_CHAR_001CHAR2
INVNRInventory numberINVNRCHAR50
GROESSize/dimensionGROSSCHAR36
BRGEWWeight of objectOBJ_WEIGHTQUAN7
GEWEIUnit of weightWEIGHT_UNITUNIT6T006
ANSDTAcquisition dateANDTIDATS16
ANSWTAcquisition ValueANSWTCURR7
WAERSCurrency KeyWAERSCUKY10TCURC
ELIEFVendor numberELIEFCHAR20LFA1
GWLENDate on which the warranty endsGWLENDATS16
GWLDTGuarantee dateGWLDTDATS16
WDBWTEquipment replacement valueWDBWTCURR7
HERSTManufacturer of AssetHERSTCHAR60
HERLDCountry/Region of ManufactureHERLDCHAR6T005
HZEINManufacturer drawing numberHZEINCHAR60
SERGEManufacturer's Serial NumberSERGECHAR60
TYPBZManufacturer model numberTYPBZCHAR40
BAUJJYear of constructionBAUJJCHAR8
BAUMMMonth of constructionBAUMMCHAR4
APLKZIndicator: Task List ExistsAPLKZCHAR2
AULDTFirst delivery date of the equipmentAULDTDATS16
INBDTStart-up Date of the Technical ObjectILOM_DATABDATS16
GERNRSerial NumberGERNRCHAR36
EQLFNConsecutive numbering of EquipUsagePeriods on same dayEQLFNNUMC6
GWLDVWarranty date for Sales and DistributionGWLDVDATS16
EQDATDate, intended for SAP internal useEQDATDATS16
EQBERTechnical information, intended for SAP internal useEQBERCHAR60
EQNUMNumerical field, intended for SAP internal useEQNUMNUMC18
OBJNRObject numberJ_OBJNRCHAR44
EQSNREQSE NumberEQSNRCHAR36EQSE
CUOBJConfiguration (internal object number)CUOBJNUMC36
KRFKZReferenced ConfigurationKRFKZCHAR2
KMATNConfigurable MaterialKMATNCHAR80MARA
MATNRMaterial NumberMATNRCHAR80MARA
SERNRSerial NumberGERNRCHAR36
WERKPlantWERKS_DCHAR8T001W
LAGERStorage locationLGORT_DCHAR8T001L
CHARGEBatch NumberCHARG_DCHAR20MCH1
KUNDECustomer to Whom Serial Number was DeliveredKUNDSECHAR20KNA1
WARPLMaintenance PlanWARPLCHAR24MPLA
IMRC_POINTMeasuring PointIMRC_POINTCHAR24IMPTT
REVLVRevision LevelREVLVCHAR4
MGANRMaster warranty numberMGANRCHAR40BGMK
BEGRUIData origin for authorization group fieldINH_BEGRUICHAR2
S_EQUIEquipment data existsEQUIP_KNZCHAR2
S_SERIALSerial data when maintaining equipmentKZKSDCHAR2
S_KONFIConfiguration supportedKONFKNZCHAR2
S_SALESales equipmentSDKNZCHAR2
S_FHMEquip. category relevant to production resources and toolsFHMKZCHAR2
S_ELSEIndicator: Other Data ActiveELSE_KNZCHAR2
S_ISUIS-U dataISU_KNZCHAR2
S_EQBSEQSI ExistsKZEQBSCHAR2
S_FLEETIndicator: Fleet object activeFLEET_KNZCHAR2
BSTVPStock Check for Serial NumbersBSTVPCHAR2
SPARTEDivisionSPARTECHAR4TSPA
HANDLESAP Development Reserve: Integration of Date Segment (Key)ITOBTMP_TSEGGUIDCHAR44
TSEGTPSAP Development Reserve: Integration Date Segment (Tempate)ITOBTMP_TSEGTEMPLACHAR20
EMATNMaterial number corresponding to manufacturer part numberEMATNCHAR80
ACT_CHANGE_AAChange Equipment Master when Changing AssetAAPM_ACT_CHANGE_AACHAR2
S_CCConfiguration Control DataCCC_KNZCHAR2
DATLWBDate of Last Goods MovementDATLWBDATS16
UIIUnique Item IdentifierUII_CHAR72CHAR144
IUID_TYPEStructure Type of UIIIUID_TYPECHAR20TIUID_TYPE
UII_PLANTPlant Responsible for UIIUII_PLANTCHAR8
CHANGEDDATETIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)TZNTSTMPSDEC8
ENDOFUSEEnd-of-Use Date of the Technical ObjectENDOFUSE_DATEDATS16
.INCLUDEEQUI_INCL_EEW_PS0
DUMMY_EQUI_INCL_EEW_PSCustom Fields: Dummy for Use in Extension IncludesCFD_DUMMYCHAR2
.INCLUDECI_EQUI0
.INCLU--AP/ISDFPS/ST_LM_EQUI_APPEND0
EQEXT_ACTIVEBackpack Table /isdfps/lmeqext Active/ISDFPS/DE_LM_DB_EQEXT_ACTIVECHAR2
.INCLU--APCOCF_S_EQUI_APPEND0
EQUI_SRTYPEShift Report TypeCOCF_SR_SRTYPECHAR20COCF_CU_SRTYPE
EQUI_SNTYPEShift Note TypeCOCF_SN_SNTYPECHAR4TQ80
.INCLU--APDIACL_EQUI_APPEND0
EQLB_DUTYLogbook DutyDIACL_DUTYCHAR2
EQLB_HIDEHide Logbook DisplayDIACL_HIDECHAR2
.INCLU--APJ_3GEQUIA0
.INCLUDEJ_3GEQUIS0
J_3GDISPOPlanning IndicatorJ_3GDISPOCHAR2
J_3GZDEQUIIndicator for Central-Decentral EquipmentJ_3GZDEQUICHAR2
J_3GEQARTProcurement Type for External EquipmentJ_3GEQARTCHAR20J_3GFEQUI
J_3GKZMENGItem/Multipart IndicatorJ_3GKZMENGCHAR2
J_3GKONDEMaterial Price GroupKONDMCHAR4T178
J_3GFIKTIVFictitious IndicatorJ_3GFIKTIVCHAR2
J_3GBELTYPDocument Categories AllowedJ_3GBELTYPCHAR30
MEINSBase Unit of MeasureMEINSUNIT6T006
J_3GKZLADGIndicator: Relevancy to Loading CostsJ_3GKZLADGCHAR2J_3GLADEKE
J_3GKZBERGIndicator for Provision FeesJ_3GKZBERGCHAR2
J_3GEIFRIndicator for Own/External EquipmentJ_3GEIFRCHAR2
J_3GVERMEINUnit of Measure for SettlementJ_3GVERMEINUNIT6T006
J_3GZULNRLicense Plate NumberJ_3GLICENCE_NUMCHAR30
/SAPCEM/ABRECHVHSettlement Using Shipping Document/SAPCEM/ABRECHVHCHAR2
/SAPCEM/ABRECHLGSettlement Using PBE Document/SAPCEM/ABRECHLGCHAR2
/SAPCEM/DISPOGRPlanning Group/SAPCEM/DISPOGRCHAR8/SAPCEM/DISPOGRU
Privacy Policy