SAP ABAP Table DIEQUZ (EquipUsagePeriod)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ IEQM (Package) Application Develoment R/3 Equipment Management

Basic Data

Table Category	INTTAB	Structure
Structure	DIEQUZ	Table Relationship Diagram
Short Description	EquipUsagePeriod

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	EQUNR	☐	EQUNR	EQUNR	CHAR	18	0	Equipment Number	EQUI
2	DATBI	☐	DATBI	DATUM	DATS	8	0	Valid To Date
3	EQLFN	☐	EQLFN	NUM03	NUMC	3	0	Consecutive numbering of EquipUsagePeriods on same day
4	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
5	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
6	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
7	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
8	TIMBI	☐	TIMBI	ZEITBI	TIMS	6	0	Equipment usage period time stamp
9	STNAM	☐	STNAM	USNAM	CHAR	12	0	Name of the user who maintained the status
10	LVORM	☐	LVORM	XFELD	CHAR	1	0	Deletion Indicator
11	DATAB	☐	DATAB	DATUM	DATS	8	0	Valid-From Date
12	IWERK	☐	IWERK	WERKS	CHAR	4	0	Maintenance Planning Plant	T399I
13	IWERKI	☐	INH_IWERKI	INHER	CHAR	1	0	Data origin for planning plant field
14	SUBMT	☐	SUBMT	MATNR	CHAR	18	0	Construction Type Material of the Object	MARA
15	MAPAR	☐	MAPAR	MAPAR	CHAR	30	0	Manufacturer part number
16	HEQUI	☐	HEQUI	EQUNR	CHAR	18	0	Superordinate Equipment	EQUI
17	HEQNR	☐	HEQNR	CHAR4	CHAR	4	0	Equipment position at InstallLoc (Superior Equip./FunctLoc)
18	INGRP	☐	INGRP	INGRP	CHAR	3	0	Planner Group for Customer Service and Plant Maintenance	T024I
19	INGRPI	☐	INH_INGRPI	INHER	CHAR	1	0	Data origin for maintenance planner group field
20	PM_OBJTY	☐	PM_OBJTY	CR_OBJTY	CHAR	2	0	Object Type of CIM Resources for Work Center
21	GEWRK	☐	LGWID	CR_OBJID	NUMC	8	0	Object ID of the Work Center	CRID
22	GEWRKI	☐	INH_LGWIDI	INHER	CHAR	1	0	Data Origin for the Field 'Work Center'
23	TIDNR	☐	TIDNR	TIDNR	CHAR	25	0	Technical identification number
24	TIDNRI	☐	INH_TIDNRI	INHER	CHAR	1	0	Data origin for technical identification number field
25	KUND1	☐	KUND1	KUNNR	CHAR	10	0	Customer No.	KNA1
26	KUND2	☐	KUND2	KUNNR	CHAR	10	0	End customer number	KNA1
27	KUND3	☐	KUND3	KUNNR	CHAR	10	0	Operator	KNA1
28	LIZNR	☐	LIZNR	CHAR20	CHAR	20	0	Equipment license number
29	RBNR	☐	RBNR	RBNR	CHAR	9	0	Report layout	T352B
30	EZDAT	☐	EQDAT	DATUM	DATS	8	0	Date
31	EZBER	☐	EQBER	CHAR30	CHAR	30	0	Text for Notes
32	RBNR_I	☐	INH_RBNR_I	INHER	CHAR	1	0	Data origin for maintenance catalog field
33	.INCLUDE	☐				0	0	PM Object Location and Account Assignment
34	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
35	ILOAN	☐	ILOAN	ILOAN	CHAR	12	0	Location and account assignment for technical object	*
36	.INCLUDE	☐				0	0	Data part location and account assignment for PM object
37	TPLNR	☐	TPLNR	TPLNR	CHAR	30	0	Functional Location	IFLOT
38	ABCKZ	☐	ABCKZ	ABCKZ	CHAR	1	0	ABC Indicator for Technical Object	T370C
39	ABCKZI	☐	INH_ABCKZI	INHER	CHAR	1	0	Data origin for ABC indicator field
40	EQFNR	☐	EQFNR	CHAR30	CHAR	30	0	Sort Field
41	EQFNRI	☐	INH_EQFNRI	INHER	CHAR	1	0	Data origin for sort field
42	SWERK	☐	SWERK	WERKS	CHAR	4	0	Maintenance Plant	T001W
43	SWERKI	☐	INH_SWERKI	INHER	CHAR	1	0	Data origin for maintenance plant field
44	STORT	☐	PMLOC	AP_STAND	CHAR	10	0	Location of maintenance object	T499S
45	STORTI	☐	INH_STORTI	INHER	CHAR	1	0	Data origin for location field
46	MSGRP	☐	RAUMNR	CHAR8	CHAR	8	0	Room
47	MSGRPI	☐	INH_MSGRPI	INHER	CHAR	1	0	Data origin for room number field
48	BEBER	☐	BEBER	BEBER	CHAR	3	0	Organizational Area	T357
49	BEBERI	☐	INH_BEBERI	INHER	CHAR	1	0	Data origin for company area field
50	CR_OBJTY	☐	CR_OBJTY	CR_OBJTY	CHAR	2	0	Object types of the CIM resource
51	PPSID	☐	PPSID	CR_OBJID	NUMC	8	0	Object ID of PP work center	CRID
52	PPSIDI	☐	INH_PPSIDI	INHER	CHAR	1	0	Data origin for PP work center field
53	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
54	GSBERI	☐	INH_GSBERI	INHER	CHAR	1	0	Data origin for business area field
55	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
56	KOKRSI	☐	INH_KOKRSI	INHER	CHAR	1	0	Data origin for controlling area field
57	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
58	KOSTLI	☐	INH_KOSTLI	INHER	CHAR	1	0	Data origin for cost center field
59	PROID	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	PRPS
60	PROIDI	☐	INH_PROIDI	INHER	CHAR	1	0	Data origin for WBS element field
61	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
62	BUKRSI	☐	INH_BUKRSI	INHER	CHAR	1	0	Data origin for company code field
63	ANLNR	☐	ANLN1	ANLN1	CHAR	12	0	Main Asset Number	ANLH
64	ANLNRI	☐	INH_ANLNRI	INHER	CHAR	1	0	Data origin for asset main no./sub-no. fields
65	ANLUN	☐	ANLN2	ANLN2	CHAR	4	0	Asset Subnumber	ANLA
66	ANLUNI	☐	INHER	INHER	CHAR	1	0	Data origin indicator
67	DAUFN	☐	DAUFN	AUFNR	CHAR	12	0	Standing order number	AUFK
68	DAUFNI	☐	INH_DAUFNI	INHER	CHAR	1	0	Data origin of standing order number field
69	AUFNR	☐	ILOM_ORDST	AUFNR	CHAR	12	0	Settlement order	AUFK
70	AUFNRI	☐	INH_AUFNRI	INHER	CHAR	1	0	Data origin for settlement order field
71	TPLNRI	☐	INH_TPLNRI	INHER	CHAR	1	0	Data origin for functional location field
72	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
73	VKORGI	☐	INH_VKORGI	INHER	CHAR	1	0	Data origin for sales organization field
74	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVKOV
75	VTWEGI	☐	INH_VTWEGI	INHER	CHAR	1	0	Data origin of distribution channel field
76	SPART	☐	SPART	SPART	CHAR	2	0	Division	TVTA
77	SPARTI	☐	INH_SPARTI	INHER	CHAR	1	0	Data origin for division field
78	ADRNR	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	ADRC
79	ADRNRI	☐	INH_ADRNRI	INHER	CHAR	1	0	Data origin for address field
80	OWNER	☐	ILOM_OWNER	ILOM_OWNER	CHAR	1	0	Object reference indicator
81	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	TVKBZ
82	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVBVK
83	.INCLUDE	☐				0	0
84	ARBPL	☐	ARBPL	ARBPL	CHAR	8	0	Work center
85	GEWRKE	☐	GEWRK	ARBPL	CHAR	8	0	Main work center for maintenance tasks
86	.INCLUDE	☐				0	0	Display Structure Reporting PM Address Data
87	NAME_LIST	☐	I_NAME_LST	NAME	CHAR	35	0	Name for list displays
88	TEL_NUMBER	☐	AD_TLNMBR1	CHAR30	CHAR	30	0	First telephone no.: dialling code+number
89	POST_CODE1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
90	CITY1	☐	AD_CITY1	TEXT40	CHAR	40	0	City
91	CITY2	☐	AD_CITY2	TEXT40	CHAR	40	0	District
92	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
93	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
94	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
95	STRNO	☐	ILOM_STRNO	ILOM_STRNO	CHAR	40	0	Functional location label

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	DIEQUZ	ABCKZ	T370C	ABCKZ	REF	C	CN
2	DIEQUZ	ADRNR	ADRC	ADDRNUMBER	REF	1	CN
3	DIEQUZ	ANLNR	ANLH	ANLN1	REF	C	CN
4	DIEQUZ	ANLUN	ANLA	ANLN2	REF	C	CN
5	DIEQUZ	AUFNR	AUFK	AUFNR	REF	C	CN
6	DIEQUZ	BEBER	T357	BEBER	REF	C	CN
7	DIEQUZ	BUKRS	T001	BUKRS	REF	C	CN
8	DIEQUZ	DAUFN	AUFK	AUFNR	REF	C	CN
9	DIEQUZ	EQUNR	EQUI	EQUNR
10	DIEQUZ	GEWRK	CRID	OBJID
11	DIEQUZ	GSBER	TGSB	GSBER	REF	C	CN
12	DIEQUZ	HEQUI	EQUI	EQUNR
13	DIEQUZ	INGRP	T024I	INGRP
14	DIEQUZ	IWERK	T399I	IWERK
15	DIEQUZ	KOKRS	TKA01	KOKRS	REF	C	CN
16	DIEQUZ	KOSTL	CSKS	KOSTL	REF	C	CN
17	DIEQUZ	KUND1	KNA1	KUNNR
18	DIEQUZ	KUND2	KNA1	KUNNR
19	DIEQUZ	KUND3	KNA1	KUNNR
20	DIEQUZ	MANDT	T000	MANDT	KEY	1	CN
21	DIEQUZ	PPSID	CRID	OBJID	REF	C	CN
22	DIEQUZ	PROID	PRPS	PSPNR		C	CN
23	DIEQUZ	RBNR	T352B	RBNR
24	DIEQUZ	SPART	TVTA	SPART	REF	1	CN
25	DIEQUZ	STORT	T499S	STAND	REF	C	CN
26	DIEQUZ	SUBMT	MARA	MATNR
27	DIEQUZ	SWERK	T001W	WERKS	REF	1	CN
28	DIEQUZ	TPLNR	IFLOT	TPLNR	REF	C	CN
29	DIEQUZ	VKBUR	TVKBZ	VKBUR	REF	1	CN
30	DIEQUZ	VKGRP	TVBVK	VKGRP	REF	1	CN
31	DIEQUZ	VKORG	TVKO	VKORG	REF	1	CN
32	DIEQUZ	VTWEG	TVKOV	VTWEG	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in