SAP DIEQUI Equipment Table data and field list

DIEQUI is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Equipment" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_DIEQUI TYPE DIEQUI.

The DIEQUI table consists of various fields, each holding specific information or linking keys about Equipment data available in SAP. These include EQUNR (Equipment Number), ERDAT (Date on Which Record Was Created), ERNAM (Name of Person who Created the Object), EQASP (Language in Which the Piece of Equipment was Entered)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

DIEQUI structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP DIEQUI structure fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the DIEQUI table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
EQUNREquipment Number EQUNRCHAR18EQUIALPHAEQUNREQNEQUI
ERDATDate on Which Record Was Created ERDATDATS8DATUM
ERNAMName of Person who Created the Object ERNAMCHAR12USNAM
EQASPLanguage in Which the Piece of Equipment was Entered EQASPLANG1T002ISOLASPRAS
AEDATChanged On AEDATDATS8DATUM
AENAMName of Person Who Changed Object AENAMCHAR12USNAM
BEGRUTechnical object authorization group IAUTGCHAR4T370BIAUTG
EQTYPEquipment category EQTYPCHAR1T370TEQTYPEQT
EQARTType of Technical Object EQARTCHAR10T370KEQART
LVORMDeletion Indicator LVORMCHAR1XFELD
INVNRInventory number INVNRCHAR25INVNR_ANLA
GROESSize/dimension GROSSCHAR18GROES
BRGEWGross Weight BRGEWQUAN13(3) MENG13
GEWEIWeight Unit GEWEIUNIT3T006CUNITMEINS
ANSDTAcquisition date ANDTIDATS8DATUM
ANSWTAcquisition Value ANSWTCURR13(2) WERT
WAERSCurrency Key WAERSCUKY5TCURCWAERSFWS
ELIEFVendor number ELIEFCHAR10LFA1ALPHALIFNR
GWLDT_KCustomer Warranty Start IGWLDT_KDATS8DATUM
GWLEN_KWarranty End for Customer IGWLEN_KDATS8DATUM
MGANR_KMaster Warranty Number for Customer IMGANR_KCHAR20Assigned to domainALPHAMGANRGAM
GARTX_KCustomer Warranty Description IGARTXL_KCHAR40TXT40
GWLDT_LVendor Warranty Start IGWLDT_LDATS8DATUM
GWLEN_LWarranty End for Vendor IGWLEN_LDATS8DATUM
MGANR_LMaster Warranty Number for Vendor IMGANR_LCHAR20Assigned to domainALPHAMGANRGAM
GARTX_LVendor Warranty Description IGARTXL_LCHAR40TXT40
WDBWTEquipment replacement value WDBWTCURR13(2) WERT
HERSTManufacturer of asset HERSTCHAR30TEXT30
HERLDCountry of manufacture HERLDCHAR3T005LAND1
HZEINManufacturer drawing number HZEINCHAR30HZEIN
SERGEManufacturer serial number SERGECHAR30CHAR30
TYPBZManufacturer model number TYPBZCHAR20TYPBZ
BAUJJYear of construction BAUJJCHAR4GJAHRCJAHR
BAUMMMonth of construction BAUMMCHAR2BAUMM
APLKZIndicator: Task List Exists APLKZCHAR1APLKZ
AULDTFirst delivery date of the equipment AULDTDATS8DATUM
INBDTFirst start-up date INBDTDATS8DATUM
TXASPPrimary language indicator for text segment KZMLACHAR1CHAR1
EQLFNConsecutive numbering of EquipUsagePeriods on same day EQLFNNUMC3NUM03EQL
GWLDVWarranty date for Sales and Distribution GWLDVDATS8DATUM
EQDATDate, intended for SAP internal use EQDATDATS8DATUM
EQBERTechnical information, intended for SAP internal use EQBERCHAR30CHAR30
EQNUMNumerical field, intended for SAP internal use EQNUMNUMC9NUM9
OBJNRObject number J_OBJNRCHAR22Assigned to domainJ_OBJNRONR
EQSNREQSE Number EQSNRCHAR18EQSEEQSNR
CUOBJConfiguration (internal object number) CUOBJNUMC18CUOBJCUX
KRFKZReferenced Configuration KRFKZCHAR1X
KMATNConfigurable Material KMATNCHAR18MARAMATN1MATNRMAT1
MATNRMaterial Number MATNRCHAR18MARAMATN1MATNRMATS_MAT1
SERNRSerial Number GERNRCHAR18GERNRGERNRSER
WERKPlant WERKS_DCHAR4T001WWERKSWRKH_T001W_C
LAGERStorage Location LGORT_DCHAR4T001LLGORTLAG
CHARGEBatch Number CHARG_DCHAR10MCH1CHARGCHA
KUNDECustomer to Whom Serial Number was Delivered KUNDSECHAR10KNA1ALPHAKUNNR
WARPLMaintenance Plan WARPLCHAR12MPLAALPHAWARPLMPLMPLAL
IMRC_POINTMeasuring Point IMRC_POINTCHAR12IMPTTALPHAIMRC_POINTIPTIMPM
REVLVRevision Level REVLVCHAR2NUMCVREVLVRVS
STTXTSystem status line J_STEXTCHAR40TEXT40
USTXTUser Status Line J_ATEXTCHAR40TEXT40
SPRASLanguage Key SPRASLANG1T002ISOLASPRASSPRH_T002
EQKTXDescription of technical object KTX01CHAR40TEXT40
KZLTXIndicator: More long text exists KZLTXCHAR1XFELD
UIIUnique Item Identifier UII_CHAR72CHAR72UII_CHAR72UIIH_UII
.INCLU--AP 0
J_3GDISPOPlanning Indicator J_3GDISPOCHAR1J_3GDISPO
J_3GZDEQUIIndicator for Central-Decentral Equipment J_3GZDEQUICHAR1J_3GZDEQUI
J_3GEQARTProcurement Type for External Equipment J_3GEQARTCHAR10J_3GFEQUIJ_3GEQART
J_3GKZMENGItem/Multipart Indicator J_3GKZMENGCHAR1J_3GKZMENG
J_3GKONDEMaterial Pricing Group KONDMCHAR2T178KONDMVKM
J_3GFIKTIVFictitious Indicator J_3GFIKTIVCHAR1X
J_3GBELTYPDocument Categories Allowed J_3GBELTYPCHAR15CHAR15
MEINSBase Unit of Measure MEINSUNIT3T006CUNITMEINS
J_3GKZLADGIndicator: Relevancy to Loading Costs J_3GKZLADGCHAR1J_3GLADEKECHAR1
J_3GKZBERGIndicator for Provision Fees J_3GKZBERGCHAR1J_3GKZBERG
J_3GEIFRIndicator for Own/External Equipment J_3GEIFRCHAR1J_3GEIFR
J_3GVERMEINUnit of Measure for Settlement J_3GVERMEINUNIT3T006CUNITMEINS
J_3GZULNRLicense Plate Number J_3GLICENCE_NUMCHAR15CHAR15
/SAPCEM/ABRECHVHSettlement Using Shipping Document /SAPCEM/ABRECHVHCHAR1XCHAR
/SAPCEM/ABRECHLGSettlement Using PBE Document /SAPCEM/ABRECHLGCHAR1XCHAR
/SAPCEM/DISPOGRPlanning Group /SAPCEM/DISPOGRCHAR4/SAPCEM/DISPOGRU/SAPCEM/DISPOGR

Key field Non-key field



How do I retrieve data from SAP structure DIEQUI using ABAP code?

As DIEQUI is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on DIEQUI as there is no data to select.

How to access SAP table DIEQUI

Within an ECC or HANA version of SAP you can also view further information about DIEQUI and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).

Related SAP tables and the relationships to DIEQUI

    DIAUFK - PM order
        DIIHPA - Partner PM/QM
    DIIHGNS - Permits issued
        DIAFVC - Maintenance Operations
            DIKBEDH - Capacity load (logical database AFI)
                DIKBEDS - Splits/Capacity Assignment (LDB AFI)
            DIAFRU - PM Completion Confirmation
            DIAFAB - Output structure for order relationships
            DIRESB - PM Materials
            DIAFFH - PM resources
        DIAUFKU - PM Sub-Orders
        DIAUFM - Goods movements for order
        DIIFLO - Functional location
        DIPMCO - Plan/Actual Cost and Revenue per Value Category
        DIEQUI - Equipment
        DIQMEL - PM notification
        DIOBJK - Object List
            DIIFLOX - Functional location
            DIEQUIX - Equipment
            DIQMELX - PM notification
        DIIHSG - Permits

    DIEQUI - Equipment
        DIIHPA - Partner PM/QM
        DIINET - Object Link
        DIIMPT - Measuring Point: Output Structure for ABAP Lists
            DIIMRG - Measurement Doc.: Output Structure for ABAP Lists
        DIIHSG - Permits
        DIEQUZ - Equipment Usage Period
            DIIFLO - Functional Location
            DIQMEL - PM Notification
            DIAUFK - PM Order
        DICLASS - Class
            DICLDAT - Characteristic Valuation
        DIDRAD - Document

    DIT372I - Network ID
        DINWATTR - Network Attribute Data, used for multi level netwo
        DIINET - Object link
            DIEQUI - Equipment
                DIQMEL - PM Notification
                DIIMPT - Measuring Point: Output Structure for ABAP Lists
                    DIIMRG - Measurement Document: Output Structure for ABAP Li
                DIAUFK - PM Order

    DIINET - Object link
        DIEQUI - Equipment
        DIIFLO - Functional location
        DICLASS - Class
            DICLDAT - Characteristic valuation
        DIDRAD - Document

    DIIFLO - Functional location
        DIEQUI - Equipment
            STPOX - BOM Items (Extended for List Displays)

    DIEAPL - Maintenance Task List or General Task List
        DIPLKO - Task List Header
    DIPLFH - Production Resources/Tools for Operations
    DIPLPOS - PM Sub-Operations
    DIPLMK - Inspection Charact. per Operation in Task List
    DICUKN - Object Dependencies per Operation in Task List
    DIESLL - Service Packages per Operation in Task List
        DICULL - Obj. Dependencies per Service Package in Task List
        DIESL1 - Service Packages per Operation in Task List
            DICUL1 - Obj. Dependencies per Service Package in Task List
            DIESL2 - Service Packages per Operation in Task List
                DICUL2 - Obj. Dependencies per Service Package in Task List
    DIIFLO - Functional Location
                DIESL3 - Service Packages per Operation in Task List
                    DICUL3 - Obj. Dependencies per Service Package in Task List
                    DIESL4 - Service Packages per Operation in Task List
                        DICUL4 - Obj. Dependencies per Service Package in Task List
    DIEQUI - Equipment
    DIPLFL - Task List Sequence
        DIPLPO - Operations
            DIPLAB - Output Structure Relationships Task Lists
            DIPLWP - Maintenance Packages per Operation
            DIPLMZ - Material Components per Operation
                DICUK1 - Obj. Dependencies per Material Comp. in Task List

    DIQMEL - PM notification
        DIIHPA - Partner PM/QM
        DIQMSM - Notification tasks
        DIQMMAX - Activity for Notif.
        DIAUFK - PM order
        DIIFLO - Functional location
        DIEQUI - Equipment
        DIQMFE - PM notification item
            DIQMUR - Cause of notification item
            DIQMSMX - Tasks for notification item
            DIQMMA - Activities for notification item
            DICLASS - Class
                DICLDAT - Characteristic valuation

    DIOBJK - Object List
        DIEQUI - Equipment
        DISER02 - Internal Structure SER02
        DISER01 - Serial Numbers for Delivery

    DIIFLO - Functional Location
        DIIHPA - Partner PM/QM
        DIINET - Object Link
        DIIMPT - Measuring Point: Output Structure for ABAP Lists
            DIIMRG - Measurement Doc.: Output Structure for ABAP Lists
        DIIHSG - Permits
        DIEQUZ - Equipment Usage Period
            DIEQUI - Equipment
        DIQMEL - PM Notification
        DIAUFK - PM Order
        DICLASS - Class
            DICLDAT - Characteristic Valuation
        DIDRAD - Document