EQUI

Equipment master data | #masterdata | Component: Equipment
Column Name Description
MANDT FK Client
EQUNR Equipment Number
Column Name Description
💲 Currency Key (WAERS):
ANSWT Acquisition Value
WDBWT Equipment replacement value
Column Name Description
📏 Unit of weight (GEWEI):
BRGEW Weight of object
Column Name Description
ERDAT Date on which the record was created
AEDAT Last Changed On
ANSDT Acquisition date
GWLEN Date on which the warranty ends
GWLDT Guarantee date
AULDT First delivery date of the equipment
INBDT Start-up Date of the Technical Object
GWLDV Warranty date for Sales and Distribution
EQDAT Date, intended for SAP internal use
DATLWB Date of Last Goods Movement
ENDOFUSE End-of-Use Date of the Technical Object
Column Name Description
BAUMM Month of construction Show values
KRFKZ Referenced Configuration Show values
BEGRUI Data origin for authorization group field Show values
S_EQUI Equipment data exists Show values
S_SERIAL Serial data when maintaining equipment Show values
S_KONFI Configuration supported Show values
S_SALE Sales equipment Show values
S_FHM Equip. category relevant to production resources and tools Show values
S_ELSE Indicator: Other Data Active Show values
S_ISU IS-U data Show values
S_FLEET Indicator: Fleet object active Show values
BSTVP Stock Check for Serial Numbers Show values
ACT_CHANGE_AA Change Equipment Master when Changing Asset Show values
S_CC Configuration Control Data Show values
EQEXT_ACTIVE Backpack Table /isdfps/lmeqext Active Show values
EQLB_DUTY Logbook Duty Show values
EQLB_HIDE Hide Logbook Display Show values
J_3GDISPO Planning Indicator Show values
J_3GZDEQUI Indicator for Central-Decentral Equipment Show values
J_3GKZMENG Item/Multipart Indicator Show values
J_3GFIKTIV Fictitious Indicator Show values
J_3GKZBERG Indicator for Provision Fees Show values
J_3GEIFR Indicator for Own/External Equipment Show values
/SAPCEM/ABRECHVH Settlement Using Shipping Document Show values
/SAPCEM/ABRECHLG Settlement Using PBE Document Show values
Column Name Description Domain name
ERNAM Name of Person Responsible for Creating the Object USNAM
AENAM Name of Person Who Changed Object USNAM
LVORM SAP Development Reserve: Format CHAR, Length 1 CHAR1
INVNR Inventory number INVNR_ANLA
GROES Size/dimension GROES
HERST Manufacturer of Asset TEXT30
HZEIN Manufacturer drawing number HZEIN
SERGE Manufacturer's Serial Number CHAR30
TYPBZ Manufacturer model number TYPBZ
BAUJJ Year of construction CJAHR
APLKZ Indicator: Task List Exists APLKZ
GERNR Serial Number GERNR
EQLFN Consecutive numbering of EquipUsagePeriods on same day NUM03
EQBER Technical information, intended for SAP internal use CHAR30
EQNUM Numerical field, intended for SAP internal use NUM9
OBJNR Object number J_OBJNR
CUOBJ Configuration (internal object number) CUOBJ
SERNR Serial Number GERNR
REVLV Revision Level REVLV
S_EQBS EQSI Exists KZEQBS
HANDLE SAP Development Reserve: Integration of Date Segment (Key) SYSUUID_22
TSEGTP SAP Development Reserve: Integration Date Segment (Tempate) TSEGTEMPLA
EMATN Material number corresponding to manufacturer part number MATNR
UII Unique Item Identifier UII_CHAR72
UII_PLANT Plant Responsible for UII WERKS
CHANGEDDATETIME UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
DUMMY_EQUI_INCL_EEW_PS Custom Fields: Dummy for Use in Extension Includes
J_3GBELTYP Document Categories Allowed CHAR15
J_3GZULNR License Plate Number CHAR15
Master Data Relations Join Conditions
Technical Object Authorization Group
  • EQUI.MANDT == T370B.MANDT
  • EQUI.BEGRU == T370B.BEGRU
Batch Number
  • Material Number
  • Client
  • Batch Number
  • EQUI.MATNR == MCH1.MATNR
  • EQUI.MANDT == MCH1.MANDT
  • EQUI.CHARGE == MCH1.CHARG
Vendor number
  • EQUI.MANDT == LFA1.MANDT
  • EQUI.ELIEF == LFA1.LIFNR
Type of Technical Object
  • EQUI.MANDT == T370K.MANDT
  • EQUI.EQART == T370K.EQART
Language in Which the Piece of Equipment was Entered EQUI.EQASP == T002.SPRAS
EQSE Number
  • EQUI.MANDT == EQSE.MANDT
  • EQUI.EQSNR == EQSE.EQSNR
Equipment category
  • Equipment category
  • Client
  • EQUI.EQTYP == T370T.EQTYP
  • EQUI.MANDT == T370T.MANDT
Shift Note Type
  • EQUI.MANDT == TQ80.MANDT
  • EQUI.EQUI_SNTYPE == TQ80.QMART
Shift Report Type
  • Shift Report Type
  • Client
Unit of weight
  • EQUI.MANDT == T006.MANDT
  • EQUI.GEWEI == T006.MSEHI
Country/Region of Manufacture
  • Country/Region of Manufacture
  • Client
  • EQUI.HERLD == T005.LAND1
  • EQUI.MANDT == T005.MANDT
Measuring Point
  • Measuring Point
  • Client
  • EQUI.IMRC_POINT == IMPTT.POINT
  • EQUI.MANDT == IMPTT.MANDT
Foreign Key Check for IUID Type EQUI.IUID_TYPE == TIUID_TYPE.IUID_TYPE
Procurement Type for External Equipment
  • Procurement Type for External Equipment
  • Client
Material Price Group
  • EQUI.MANDT == T178.MANDT
  • EQUI.J_3GKONDE == T178.KONDM
Loading Costs Indicator
Unit of Measure for Settlement
  • EQUI.MANDT == T006.MANDT
  • EQUI.J_3GVERMEIN == T006.MSEHI
Configurable Material
  • Configurable Material
  • Client
  • EQUI.KMATN == MARA.MATNR
  • EQUI.MANDT == MARA.MANDT
Customer to Whom Serial Number was Delivered
  • EQUI.MANDT == KNA1.MANDT
  • EQUI.KUNDE == KNA1.KUNNR
Storage location
  • Storage location
  • Client
  • Plant
  • EQUI.LAGER == T001L.LGORT
  • EQUI.MANDT == T001L.MANDT
  • EQUI.WERK == T001L.WERKS
Client EQUI.MANDT == T000.MANDT
Material Number
  • Material Number
  • Client
  • EQUI.MATNR == MARA.MATNR
  • EQUI.MANDT == MARA.MANDT
Base Unit of Measure
  • EQUI.MANDT == T006.MANDT
  • EQUI.MEINS == T006.MSEHI
Master warranty number
  • Master warranty number
  • Client
  • EQUI.MGANR == BGMK.MGANR
  • EQUI.MANDT == BGMK.MANDT
Division
  • EQUI.MANDT == TSPA.MANDT
  • EQUI.SPARTE == TSPA.SPART
Currency Key
  • EQUI.MANDT == TCURC.MANDT
  • EQUI.WAERS == TCURC.WAERS
Maintenance Plan
  • Maintenance Plan
  • Client
  • EQUI.WARPL == MPLA.WARPL
  • EQUI.MANDT == MPLA.MANDT
Plant
  • EQUI.MANDT == T001W.MANDT
  • EQUI.WERK == T001W.WERKS
Other Relations | to Master Data Relations ↑ Join Conditions
Planning Group