EQUI is a standard Equipment Transparent Table in SAP PM application, which stores Equipment master data data. On this page, you can view the Table Structure, Columns(Fields), links to SAP Documentation, Wiki & Help Pages, Q&A, similar/related TCodes, Tables, FMs, ABAP Reports, and Authorization Objects for EQUI. You can use the transaction code SE16 to view the data in this table, and SE11 TCode for the table structure and definition.

EQUI — Table Structure, Fields(Columns) and Definitions

    Position Column Name Description Data Element Primary Key Data Type Length Check Table
    1 MANDT Client MANDT X CLNT 3 T000
    2 EQUNR Equipment Number EQUNR X CHAR 18
    3 ERDAT Created on ERDAT DATS 8
    4 ERNAM Created by ERNAM CHAR 12
    5 EQASP Language in which the piece of equipment was entered EQASP LANG 1 T002
    6 AEDAT Changed on AEDAT DATS 8
    7 AENAM Name of Person Who Changed Object AENAM CHAR 12
    8 BEGRU Authorization Group IAUTG CHAR 4 T370B
    9 EQTYP Equipment Category EQTYP CHAR 1 T370T
    10 EQART Type of Technical Object EQART CHAR 10 T370K
    11 LVORM Deletion Flag for 1-Level Deletion Logic RESERVE_CHAR_001 CHAR 1
    12 INVNR Inventory number INVNR CHAR 25
    13 GROES Size/dimensions GROSS CHAR 18
    14 BRGEW Gross Weight OBJ_WEIGHT QUAN 13
    15 GEWEI Weight unit WEIGHT_UNIT UNIT 3 T006
    16 ANSDT Acquisition date ANDTI DATS 8
    17 ANSWT Acquisition Value ANSWT CURR 13
    18 WAERS Currency WAERS CUKY 5 TCURC
    19 ELIEF Vendor number ELIEF CHAR 10 LFA1
    20 GWLEN Date on which the warranty ends GWLEN DATS 8
    21 GWLDT Warranty Date GWLDT DATS 8
    22 WDBWT Equipment replacement value WDBWT CURR 13
    23 HERST Checkbox HERST CHAR 30
    24 HERLD Country of manufacture HERLD CHAR 3 T005
    25 HZEIN Manufacturer drawing number HZEIN CHAR 30
    26 SERGE Manufacturer serial number SERGE CHAR 30
    27 TYPBZ Checkbox TYPBZ CHAR 20
    28 BAUJJ Year of construction BAUJJ CHAR 4
    29 BAUMM Month of construction BAUMM CHAR 2
    30 APLKZ Indicator: Task List Exists APLKZ CHAR 1
    31 AULDT First delivery date of the equipment AULDT DATS 8
    32 INBDT Date ILOM_DATAB DATS 8
    33 GERNR Serial Number GERNR CHAR 18
    34 EQLFN Consecutive numbering of EquipUsagePeriods on same day EQLFN NUMC 3
    35 GWLDV Warranty date for Sales and Distribution GWLDV DATS 8
    36 EQDAT Date EQDAT DATS 8
    37 EQBER Text for Notes EQBER CHAR 30
    38 EQNUM Numerical Field EQNUM NUMC 9
    39 OBJNR Object number J_OBJNR CHAR 22
    40 EQSNR EQSE Number EQSNR CHAR 18 EQSE
    41 CUOBJ Configuration (internal object number) CUOBJ NUMC 18
    42 KRFKZ Referenced Configuration KRFKZ CHAR 1
    43 KMATN Configurable Material KMATN CHAR 40 MARA
    44 MATNR Material MATNR CHAR 40 MARA
    45 SERNR BOM explosion number GERNR CHAR 18
    46 WERK Plant WERKS_D CHAR 4 T001W
    47 LAGER Storage location LGORT_D CHAR 4 T001L
    48 CHARGE Freight Charge CHARG_D CHAR 10 MCH1
    49 KUNDE Reason for trip (e.g. customer/requisitioner) KUNDSE CHAR 10 KNA1
    50 WARPL Maintenance Plan WARPL CHAR 12 MPLA
    51 IMRC_POINT Measuring Point IMRC_POINT CHAR 12 IMPTT
    52 REVLV Revision Level REVLV CHAR 2
    53 MGANR Master warranty number MGANR CHAR 20 BGMK
    54 BEGRUI Data origin for authorization group field INH_BEGRUI CHAR 1
    55 S_EQUI Equipment EQUIP_KNZ CHAR 1
    56 S_SERIAL Serial data when maintaining equipment KZKSD CHAR 1
    57 S_KONFI Configuration supported KONFKNZ CHAR 1
    58 S_SALE Sales equipment SDKNZ CHAR 1
    59 S_FHM Equip. category relevant to production resources and tools FHMKZ CHAR 1
    60 S_ELSE Indicator: Other Data Active ELSE_KNZ CHAR 1
    61 S_ISU IS-U data ISU_KNZ CHAR 1
    62 S_EQBS EQSI Exists KZEQBS CHAR 1
    63 S_FLEET Indicator: Fleet object active FLEET_KNZ CHAR 1
    64 BSTVP Stock Check for Serial Numbers BSTVP CHAR 1
    65 SPARTE Division SPARTE CHAR 2 TSPA
    66 HANDLE Worldwide unique key for LIKP-VBELN ITOBTMP_TSEGGUID CHAR 22
    67 TSEGTP Event group time segment delivery header ITOBTMP_TSEGTEMPLA CHAR 10
    68 EMATN Material EMATN CHAR 40
    69 ACT_CHANGE_AA Change Equipment Master when Changing Asset AAPM_ACT_CHANGE_AA CHAR 1
    70 S_CC Configuration Control Data CCC_KNZ CHAR 1
    71 DATLWB Date of Last Goods Movement DATLWB DATS 8
    72 UII Eindeutige Teile-ID UII_CHAR72 CHAR 72
    73 IUID_TYPE Updated information in related user data field IUID_TYPE CHAR 10 TIUID_TYPE
    74 UII_PLANT Plant Responsible for UII UII_PLANT CHAR 4
    75 CHANGEDDATETIME UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS DEC 15
    76 .INCLUDE 0
    77 .INCLU--AP 0
    78 EQEXT_ACTIVE Backpack Table /isdfps/lmeqext Active /ISDFPS/DE_LM_DB_EQEXT_ACTIVE CHAR 1
    79 .INCLU--AP 0
    80 EQUI_SRTYPE Shift Report Type COCF_SR_SRTYPE CHAR 10 COCF_CU_SRTYPE
    81 EQUI_SNTYPE Shift Note Type COCF_SN_SNTYPE CHAR 2 TQ80
    82 .INCLU--AP 0
    83 EQLB_DUTY Logbook Duty DIACL_DUTY CHAR 1
    84 EQLB_HIDE Hide Logbook Display DIACL_HIDE CHAR 1
    85 .INCLU--AP 0
    86 .INCLUDE 0
    87 J_3GDISPO Planning Indicator J_3GDISPO CHAR 1
    88 J_3GZDEQUI Indicator for Central-Decentral Equipment J_3GZDEQUI CHAR 1
    89 J_3GEQART Procurement Type for External Equipment J_3GEQART CHAR 10 J_3GFEQUI
    90 J_3GKZMENG Item/Multipart Indicator J_3GKZMENG CHAR 1
    91 J_3GKONDE Material Pricing Group KONDM CHAR 2 T178
    92 J_3GFIKTIV Fictitious Indicator J_3GFIKTIV CHAR 1
    93 J_3GBELTYP Document Categories Allowed J_3GBELTYP CHAR 15
    94 MEINS Base Unit MEINS UNIT 3 T006
    95 J_3GKZLADG Indicator: Relevancy to Loading Costs J_3GKZLADG CHAR 1 J_3GLADEKE
    96 J_3GKZBERG Indicator for Provision Fees J_3GKZBERG CHAR 1
    97 J_3GEIFR Indicator for Own/External Equipment J_3GEIFR CHAR 1
    98 J_3GVERMEIN Unit of Measure for Settlement J_3GVERMEIN UNIT 3 T006
    99 J_3GZULNR License Plate Number J_3GLICENCE_NUM CHAR 15
    100 /SAPCEM/ABRECHVH Settlement Using Shipping Document /SAPCEM/ABRECHVH CHAR 1
    101 /SAPCEM/ABRECHLG Settlement Using PBE Document /SAPCEM/ABRECHLG CHAR 1
    102 /SAPCEM/DISPOGR Planning Group /SAPCEM/DISPOGR CHAR 4 /SAPCEM/DISPOGRU

SAP Help, Wiki, Q&A and other resources for EQUI

Click the above link for the full list of resources and help pages, only the first few are posted below

  • Connection | SAP Help Portal

    The SAP Enhancements (SMOD) and Project Management of SAP Enhancements (CMOD) transactions are available for the enhancement and preassignment of fields for connections.

    https://help.sap.com/docs/SAP_ERP_SPV/d4ce605b11dc4126adb2187ba9bf554b/9c6dce53118d4308e10000000a174cb4.html

  • Device | SAP Help Portal

    The SAP Enhancements (SMOD) and Project Management of SAP Enhancements (CMOD) transactions are available for the enhancement and preassignment of fields for devices.

    "Table EQUI contains device data. The customer include CI_EQUL is used to include customer-specific fields in the database table. You cannot preassign fields for devices. You can use the field selection to display fields for device and connection (both based on EQUIpment) differently."

    https://help.sap.com/docs/SAP_ERP/fb16109e195d45dbb11a5658abb94fff/906dce53118d4308e10000000a174cb4.html

  • Device - SAP Help Portal

    Enhancement and Preassignment of Fields:

    "Table EQUI contains device data. The customer include CI_EQUL is used to include customer-specific fields in the database table. You cannot preassign fields for devices. You can use the field selection to display fields for device and connection (both based on EQUIpment) differently."

    https://help.sap.com/viewer/35e865264f0d401cb9f1757d04ccdf8c/6.06.22/en-US/906dce53118d4308e10000000a174cb4.html

  • Connection - SAP Help Portal

    Enhancement and Preassignment of Fields:

    https://help.sap.com/viewer/35e865264f0d401cb9f1757d04ccdf8c/6.06.22/en-US/9c6dce53118d4308e10000000a174cb4.html

  • IE01 General Tab Screen Enhancement - SAP Q&A

    January 29, 2022 - There will be planned downtime on the platform. It will affect only the tutorials and openSAP. Please be aware you will not be able to access these functions during the downtime. Please save your work.

    https://answers.sap.com/questions/10753482/ie01-general-tab-screen-enhancement.html

  • Reg. IA02 transaction - SAP Q&A

    i wrote a piece of code which would trigger an warning message when someone enters a material having storage condition as hazardous.

    https://answers.sap.com/questions/1079929/reg-ia02-transaction.html

  • idoc failure - SAP Q&A

    We had an issue yesterday when one of the idocs failed to process as  the object it was trying to access was locked by user SAPBATCH.

    "From the screenshot it looks to be table EQUI."

    https://answers.sap.com/questions/11015573/idoc-failure.html

  • update the serial number status - SAP Q&A

       We are facing very often the error message "System status ESTO is active (EQU 14584774)" due to, somethime, the serial number we want to receive is on the plant already.

    https://answers.sap.com/questions/11059839/update-the-serial-number-status.html

  • Answers for "Weight calculation for a KMAT based upon components"Re: Weight calculation for a KMAT based upon componentsRe: Line Item plant allocationRe: Line Item plant allocation

    I have a situation where a sales order was entered for a specific variant configurator part, a production order was cut, an EQUIpment number/serial number was generated and assigned to the production order.

    https://answers.sap.com/questions/11070624/how-to-change-configurable-material-in-equipment-m.html

  • ETM View in IE01/IE02 - SAP Q&A

    I need some information related ETM view in IE01/IE02 , where that view should be enable and what is the purpose of this ?

    "The audit program counts the number of such EQUIpments. If you are not using many of these ETM EQUIpments then you can archive them using archiving object PM_EQUI. Once you run Preproc for EQUIpment master data a deletion flag status is set and it is no longer counted for ETM audit."

    https://answers.sap.com/questions/11232047/etm-view-in-ie01ie02.html

  • View the full list of resources, SAP Help/Wiki pages and Q&A for EQUI


Related Tables

TABLE Description Functional Area
OBJK Plant Maintenance Object List Logistics - Serial Numbers
EQUZ Equipment time segment PM - Equipment
ITOB Generierte Tabelle zu einem View PM - Technical Objects
SER01 Document Header for Serial Numbers for Delivery Logistics - Serial Numbers
JEST Individual Object Status Cross Application - General status management

Transaction Codes for SAP Table EQUI

TCODE Description Functional Area
IE02 Change Equipment PM - Equipment
IE03 Display Equipment PM - Equipment
CMOD Enhancements Basis - Customer Enhancements
SE11 ABAP Dictionary Maintenance Basis - Dictionary Maintenance
SMOD SAP Enhancement Management Basis - Customer Enhancements
IE01 Create Equipment PM - Equipment

FMs for SAP Table EQUI

FM Description Functional Area
EXIT_SAPLITO0_002 Customer Include ITO0: Data Export (Include => Caller) PM - Technical Objects
EXIT_SAPLITO0_001 Customer Include ITO0: Data Import (Initiator => Include) PM - Technical Objects
BAPI_OBJCL_GETDETAIL Classification BAPI: Read Classification Information on Object Cross Application - Classification
BAPI_TRANSACTION_COMMIT Execute external Commit when using BAPIs Basis - ALE Integration Technology
CONVERSION_EXIT_ALPHA_INPUT Conversion exit ALPHA, external->internal Basis - Syntax, Compiler, Runtime
GET_SERNOS_OF_DOCUMENT Ermittlung Serialnummern zum Beleg Logistics - Serial Numbers

ABAP Reports for SAP Table EQUI

ABAP REPORT Description Functional Area
BALVBUFDEL Reset ALV buffer Basis - SAP List Viewer
RIMASE01 Adjust MASE Entries to Match Resident DB Status Logistics - Serial Numbers
RIINV00 INVENTORY_PROBLEM_RECOGNIZE Logistics - Serial Numbers
RISERNR9 Copying of the Changed Stock Check Flag Logistics - Serial Numbers
RISERNR1 Serial Number History Logistics - Serial Numbers
SAPLITO0 PM Technical Objects: Subscreens

Authorization Objects for SAP Table EQUI

AUTHORIZATION OBJECT Description Functional Area
M_MSEG_BWA Goods Movements: Movement Type

Most searched SAP Plant Maintenance Tables