SAP DIEQUZ EquipUsagePeriod Table data and field list

DIEQUZ 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 "EquipUsagePeriod" 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_DIEQUZ TYPE DIEQUZ.

The DIEQUZ table consists of various fields, each holding specific information or linking keys about EquipUsagePeriod data available in SAP. These include DATBI (Valid To Date), EQLFN (Consecutive numbering of EquipUsagePeriods on same day), ERDAT (Date on Which Record Was Created), ERNAM (Name of Person who Created the Object)... 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. .

DIEQUZ 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 DIEQUZ 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 DIEQUZ 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
EQUNR	Equipment Number	EQUNR	CHAR	18	EQUI	ALPHA	EQUNR	EQN	EQUI
DATBI	Valid To Date	DATBI	DATS	8			DATUM
EQLFN	Consecutive numbering of EquipUsagePeriods on same day	EQLFN	NUMC	3			NUM03	EQL
ERDAT	Date on Which Record Was Created	ERDAT	DATS	8			DATUM
ERNAM	Name of Person who Created the Object	ERNAM	CHAR	12			USNAM
AEDAT	Changed On	AEDAT	DATS	8			DATUM
AENAM	Name of Person Who Changed Object	AENAM	CHAR	12			USNAM
TIMBI	Equipment usage period time stamp	TIMBI	TIMS	6			ZEITBI
STNAM	Name of the user who maintained the status	STNAM	CHAR	12			USNAM
LVORM	Deletion Indicator	LVORM	CHAR	1			XFELD
DATAB	Valid-From Date	DATAB	DATS	8			DATUM
IWERK	Maintenance Planning Plant	IWERK	CHAR	4	T399I		WERKS	IWK
IWERKI	Data origin for planning plant field	INH_IWERKI	CHAR	1			INHER
SUBMT	Construction type material of the object	SUBMT	CHAR	18	MARA	MATN1	MATNR	MAT
MAPAR	Manufacturer part number	MAPAR	CHAR	30			MAPAR
HEQUI	Superordinate Equipment	HEQUI	CHAR	18	EQUI	ALPHA	EQUNR
HEQNR	Equipment position at InstallLoc (Superior Equip./FunctLoc)	HEQNR	CHAR	4			CHAR4
INGRP	Planner Group for Customer Service and Plant Maintenance	INGRP	CHAR	3	T024I		INGRP	IHG
INGRPI	Data origin for maintenance planner group field	INH_INGRPI	CHAR	1			INHER
PM_OBJTY	Object Type of CIM Resources for Work Center	PM_OBJTY	CHAR	2			CR_OBJTY
GEWRK	Object ID of the Work Center	LGWID	NUMC	8	CRID		CR_OBJID
GEWRKI	Data Origin for the Field 'Work Center'	INH_LGWIDI	CHAR	1			INHER
TIDNR	Technical identification number	TIDNR	CHAR	25			TIDNR
TIDNRI	Data origin for technical identification number field	INH_TIDNRI	CHAR	1			INHER
KUND1	Customer number	KUND1	CHAR	10	KNA1	ALPHA	KUNNR
KUND2	End customer number	KUND2	CHAR	10	KNA1	ALPHA	KUNNR
KUND3	Operator	KUND3	CHAR	10	KNA1	ALPHA	KUNNR
LIZNR	Equipment license number	LIZNR	CHAR	20			CHAR20
RBNR	Catalog Profile	RBNR	CHAR	9	T352B		RBNR
EZDAT	Date, intended for SAP internal use	EQDAT	DATS	8			DATUM
EZBER	Technical information, intended for SAP internal use	EQBER	CHAR	30			CHAR30
RBNR_I	Data origin for maintenance catalog field	INH_RBNR_I	CHAR	1			INHER
MANDT	Client	MANDT	CLNT	3	T000		MANDT
ILOAN	Location and account assignment for technical object	ILOAN	CHAR	12	Assigned to domain		ILOAN
TPLNR	Functional Location	TPLNR	CHAR	30	IFLOT	TPLNR	TPLNR	IFL	IFLM
ABCKZ	ABC indicator for technical object	ABCKZ	CHAR	1	T370C		ABCKZ
ABCKZI	Data origin for ABC indicator field	INH_ABCKZI	CHAR	1			INHER
EQFNR	Sort field	EQFNR	CHAR	30			CHAR30
EQFNRI	Data origin for sort field	INH_EQFNRI	CHAR	1			INHER
SWERK	Maintenance plant	SWERK	CHAR	4	T001W		WERKS	SWK
SWERKI	Data origin for maintenance plant field	INH_SWERKI	CHAR	1			INHER
STORT	Location of maintenance object	PMLOC	CHAR	10	T499S		AP_STAND
STORTI	Data origin for location field	INH_STORTI	CHAR	1			INHER
MSGRP	Room	RAUMNR	CHAR	8			CHAR8
MSGRPI	Data origin for room number field	INH_MSGRPI	CHAR	1			INHER
BEBER	Plant section	BEBER	CHAR	3	T357		BEBER	BBE
BEBERI	Data origin for plant section field	INH_BEBERI	CHAR	1			INHER
CR_OBJTY	Object types of the CIM resource	CR_OBJTY	CHAR	2			CR_OBJTY
PPSID	Object ID of PP work center	PPSID	NUMC	8	CRID		CR_OBJID
PPSIDI	Data origin for PP work center field	INH_PPSIDI	CHAR	1			INHER
GSBER	Business Area	GSBER	CHAR	4	TGSB		GSBER	GSB
GSBERI	Data origin for business area field	INH_GSBERI	CHAR	1			INHER
KOKRS	Controlling Area	KOKRS	CHAR	4	TKA01		CACCD	CAC
KOKRSI	Data origin for controlling area field	INH_KOKRSI	CHAR	1			INHER
KOSTL	Cost Center	KOSTL	CHAR	10	CSKS	ALPHA	KOSTL	KOS
KOSTLI	Data origin for cost center field	INH_KOSTLI	CHAR	1			INHER
PROID	Work Breakdown Structure Element (WBS Element)	PS_PSP_PNR	NUMC	8	PRPS	KONPR	PS_POSNR
PROIDI	Data origin for WBS element field	INH_PROIDI	CHAR	1			INHER
BUKRS	Company Code	BUKRS	CHAR	4	T001		BUKRS	BUK	C_T001
BUKRSI	Data origin for company code field	INH_BUKRSI	CHAR	1			INHER
ANLNR	Main Asset Number	ANLN1	CHAR	12	ANLH	ALPHA	ANLN1	AN1
ANLNRI	Data origin for asset main no./sub-no. fields	INH_ANLNRI	CHAR	1			INHER
ANLUN	Asset Subnumber	ANLN2	CHAR	4	ANLA	ALPHA	ANLN2	AN2
ANLUNI	Data origin indicator	INHER	CHAR	1			INHER
DAUFN	Standing order number	DAUFN	CHAR	12	AUFK	ALPHA	AUFNR		ORDP
DAUFNI	Data origin of standing order number field	INH_DAUFNI	CHAR	1			INHER
AUFNR	Settlement order	ILOM_ORDST	CHAR	12	AUFK	ALPHA	AUFNR		ORDE
AUFNRI	Data origin for settlement order field	INH_AUFNRI	CHAR	1			INHER
TPLNRI	Data origin for functional location field	INH_TPLNRI	CHAR	1			INHER
VKORG	Sales Organization	VKORG	CHAR	4	TVKO		VKORG	VKO	C_VKORG
VKORGI	Data origin for sales organization field	INH_VKORGI	CHAR	1			INHER
VTWEG	Distribution Channel	VTWEG	CHAR	2	TVKOV		VTWEG	VTW	C_VTWEG
VTWEGI	Data origin of distribution channel field	INH_VTWEGI	CHAR	1			INHER
SPART	Division	SPART	CHAR	2	TVTA		SPART	SPA	C_SPART
SPARTI	Data origin for division field	INH_SPARTI	CHAR	1			INHER
ADRNR	Address number	AD_ADDRNUM	CHAR	10	ADRC	ALPHA	AD_ADDRNUM	ADR
ADRNRI	Data origin for address field	INH_ADRNRI	CHAR	1			INHER
OWNER	Object reference indicator	ILOM_OWNER	CHAR	1			ILOM_OWNER
VKBUR	Sales Office	VKBUR	CHAR	4	TVKBZ		VKBUR	VKB
VKGRP	Sales Group	VKGRP	CHAR	3	TVBVK		VKGRP	VKG
ARBPL	Work center	ARBPL	CHAR	8			ARBPL	AGR
GEWRKE	Main work center for maintenance tasks	GEWRK	CHAR	8			ARBPL	VAP
NAME_LIST	Name for list displays	I_NAME_LST	CHAR	35			NAME
TEL_NUMBER	First telephone no.: dialling code+number	AD_TLNMBR1	CHAR	30			CHAR30
POST_CODE1	City postal code	AD_PSTCD1	CHAR	10			CHAR10
CITY1	City	AD_CITY1	CHAR	40			TEXT40		CLCITYNAME
CITY2	District	AD_CITY2	CHAR	40			TEXT40		CITY_PART
COUNTRY	Country Key	LAND1	CHAR	3	Assigned to domain		LAND1	LND
REGION	STATE (State, Province, County)	REGIO	CHAR	3	Assigned to domain		REGIO
STREET	Street	AD_STREET	CHAR	60			TEXT60		CLSTRTNAME
STRNO	Functional Location Label	ILOM_STRNO	CHAR	40			ILOM_STRNO
.INCLU--AP				0
J_3GEIGNER	Owner	J_3GEIGNER	CHAR	12	J_3GEIVERS		J_3GEIGVER		J_3GEE
J_3GVERWAL	Administrator	J_3GVERWAL	CHAR	12	J_3GEIVERS		J_3GEIGVER		J_3GEV
J_3GPMAUFE	PM Order Number (Owner)	J_3GPMAUFE	CHAR	12	AUFK	ALPHA	AUFNR	ANR
J_3GPMAUFV	PM Order Number (Administrator)	J_3GPMAUFV	CHAR	12	AUFK	ALPHA	AUFNR	ANR
J_3GPACHT	Leasing Type	J_3GPACHT	CHAR	1			J_3GKZPACH

Key field

Non-key field

< DIEQUIX - Equipment DIESL1 - Service packages per operation in the task list (1st level) >

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

As DIEQUZ 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 DIEQUZ as there is no data to select.

How to access SAP table DIEQUZ

Within an ECC or HANA version of SAP you can also view further information about DIEQUZ 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 DIEQUZ

    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

    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