SAP Table

EQUI Equipment master data

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

If you are only analysing data from a single SAP instance you may omit field MANDT in your relationships as it will be the same across the entire dataset. On the other hand, if you are combining data from multiple SAP instances you need to take MANDT into account.

/ Fields

EQUI columns.

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

EQUI foreign keys.

Table Field Check Table Description Check Field
EQUI BEGRU T370B Technical object authorization group MANDT
EQUI BEGRU T370B Technical object authorization group BEGRU
EQUI CHARGE MCH1 Batches (if Batch Management Cross-Plant) MANDT
EQUI ELIEF LFA1 Supplier Master (General Section) MANDT
EQUI ELIEF LFA1 Supplier Master (General Section) LIFNR
EQUI EQART T370K Type of technical object MANDT
EQUI EQART T370K Type of technical object EQART
EQUI EQASP T002 Language Keys (Component BC-I18) SPRAS
EQUI EQTYP T370T Equipment categories MANDT
EQUI EQTYP T370T Equipment categories EQTYP
EQUI EQUI_SNTYPE TQ80 Notification Types MANDT
EQUI EQUI_SNTYPE TQ80 Notification Types QMART
EQUI EQUI_SRTYPE COCF_CU_SRTYPE Shift Report Type - Definition SRTYPE
EQUI GEWEI T006 Units of Measurement MANDT
EQUI GEWEI T006 Units of Measurement MSEHI
EQUI HERLD T005 Countries MANDT
EQUI HERLD T005 Countries LAND1
EQUI IMRC_POINT IMPTT Measuring Point (Table) POINT
EQUI IUID_TYPE TIUID_TYPE Item Unique Identifier Type IUID_TYPE
EQUI J_3GEQART J_3GFEQUI External Equipment Type J_3GEQART
EQUI J_3GKONDE T178 Conditions: Groups for Materials MANDT
EQUI J_3GKONDE T178 Conditions: Groups for Materials KONDM
EQUI J_3GKZLADG J_3GLADEKE Loading Costs Indicator J_3GKZLADG
EQUI J_3GVERMEIN T006 Units of Measurement MANDT
EQUI KMATN MARA General Material Data MANDT
EQUI KMATN MARA General Material Data MATNR
EQUI KUNDE KNA1 General Data in Customer Master MANDT
EQUI KUNDE KNA1 General Data in Customer Master KUNNR
EQUI LAGER T001L Storage Locations MANDT
EQUI LAGER T001L Storage Locations WERKS
EQUI MANDT T000 Clients MANDT
EQUI MATNR MARA General Material Data MANDT
EQUI MATNR MARA General Material Data MATNR
EQUI MEINS T006 Units of Measurement MANDT
EQUI MEINS T006 Units of Measurement MSEHI
EQUI MGANR BGMK Master Warranty Header MANDT
EQUI MGANR BGMK Master Warranty Header MGANR
EQUI SPARTE TSPA Organizational Unit: Sales Divisions MANDT
EQUI SPARTE TSPA Organizational Unit: Sales Divisions SPART
EQUI WAERS TCURC Currency Codes MANDT
EQUI WAERS TCURC Currency Codes WAERS
EQUI WARPL MPLA Maintenance plan WARPL
EQUI WERK T001W Plants/Branches WERKS
Back to SAP tables