SAP ABAP Table IEQT_WL_ITEMS (Interim Statuses - Items)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ PM-EQM-EQ (Application Component) Equipment
     ⤷ IEQCM_BE (Package) Change of Equipment History - Backend

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	IEQT_WL_ITEMS	Table Relationship Diagram
Short Description	Interim Statuses - Items

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	EQUNR	☑	EQUNR	EQUNR	CHAR	18	0	Equipment Number	*
3	LSTTYP	☑	IEQ_LSTTYP	CHAR1	CHAR	1	0	List Type
4	EVENT_DATE	☑	IEQ_DATAB	DATUM	DATS	8	0	Valid-From Date
5	EVENT_TIME	☑	IEQ_TIMAB	TIME	TIMS	6	0	Valid-From Time
6	EVENT_TYPE	☐	IEQ_EVENT_TYPE	IEQ_EVENT_TYPE	CHAR	1	0	Type of Event
7	FIELD_CNT	☐	IEQ_FIELD_CNT	INT1	INT1	3	0	Amount of Changed Fields
8	.INCLUDE	☐				0	0	Help Structure: Notification Data
9	NOTIF_CREATE	☐	IEQ_NOTIFICATION_CREATE	XFELD	CHAR	1	0	Create Notification
10	NOTIF_REFER	☐	IEQ_NOTIFICATION_REFERENCE	XFELD	CHAR	1	0	Link to Existing Notification
11	NOTIF_NOT_REQ	☐	IEQ_NOTIFICATION_NOT_REQUIRED	XFELD	CHAR	1	0	Notification is Not Required
12	NOTIF_DELETE	☐	IEQ_NOTIFICATION_DELETE	XFELD	CHAR	1	0	Delete Message
13	NOTIF_UNDEFINED	☐	IEQ_NOTIFICATION_UNDEFINED	XFELD	CHAR	1	0	Notification is Undefined
14	PROCESSED	☐	XFELD	XFELD	CHAR	1	0	Checkbox
15	QMNUM_REMOVAL	☐	IEQ_QMNUM_REMOVAL	QMNUM	CHAR	12	0	Dismantling Notification	QMEL
16	QMNUM_INSTALL	☐	IEQ_QMNUM_INSTALL	QMNUM	CHAR	12	0	Installation Notification	QMEL
17	CCM_PLRMV	☐	XFELD	XFELD	CHAR	1	0	Checkbox
18	CCM_UPRMV	☐	XFELD	XFELD	CHAR	1	0	Checkbox
19	CCM_USCND	☐	XFELD	XFELD	CHAR	1	0	Checkbox
20	CCM_SVCND	☐	XFELD	XFELD	CHAR	1	0	Checkbox
21	CCM_UKCND	☐	XFELD	XFELD	CHAR	1	0	Checkbox
22	.INCLUDE	☐				0	0	Help Structure: Equipment Usage Period
23	DATBI	☐	DATBI	DATUM	DATS	8	0	Valid To Date
24	EQLFN	☐	EQLFN	NUM03	NUMC	3	0	Consecutive numbering of EquipUsagePeriods on same day
25	EQUZN	☐	EQNNR	NUM03	NUMC	3	0	Number of next EquipUsagePeriod on same day
26	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
27	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
28	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
29	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
30	TIMBI	☐	TIMBI	ZEITBI	TIMS	6	0	Equipment usage period time stamp
31	ESTAI	☐	RESERVE_CHAR_001	CHAR1	CHAR	1	0	SAP Development Reserve: Format CHAR, Length 1
32	ESTAE	☐	RESERVE_CHAR_004	CHAR4	CHAR	4	0	SAP Development reserve: Format CHAR, length 4
33	STNAM	☐	RESERVE_CHAR_012	CHAR12	CHAR	12	0	SAP Development Reserve: Format CHAR, Length 12
34	LVORM	☐	RESERVE_CHAR_001	CHAR1	CHAR	1	0	SAP Development Reserve: Format CHAR, Length 1
35	DATAB	☐	DATAB	DATUM	DATS	8	0	Valid-From Date
36	IWERK	☐	IWERK	WERKS	CHAR	4	0	Maintenance Planning Plant	*
37	IWERKI	☐	INHER	INHER	CHAR	1	0	Data origin indicator
38	SUBMT	☐	SUBMT	MATNR	CHAR	18	0	Construction Type Material of the Object	*
39	MAPAR	☐	MAPAR	MAPAR	CHAR	30	0	Manufacturer part number
40	HEQUI	☐	HEQUI	EQUNR	CHAR	18	0	Superordinate Equipment	*
41	HEQNR	☐	HEQNR	CHAR4	CHAR	4	0	Equipment position at InstallLoc (Superior Equip./FunctLoc)
42	INGRP	☐	INGRP	INGRP	CHAR	3	0	Planner Group for Customer Service and Plant Maintenance	*
43	INGRPI	☐	INHER	INHER	CHAR	1	0	Data origin indicator
44	PM_OBJTY	☐	PM_OBJTY	CR_OBJTY	CHAR	2	0	Object Type of CIM Resources for Work Center
45	GEWRK	☐	LGWID	CR_OBJID	NUMC	8	0	Object ID of the Work Center	*
46	GEWRKI	☐	INHER	INHER	CHAR	1	0	Data origin indicator
47	TIDNR	☐	TIDNR	TIDNR	CHAR	25	0	Technical identification number
48	TIDNRI	☐	INHER	INHER	CHAR	1	0	Data origin indicator
49	ILOAN	☐	ILOAN	ILOAN	CHAR	12	0	Location and account assignment for technical object	*
50	KUND1	☐	KUND1	KUNNR	CHAR	10	0	Customer No.	*
51	KUND2	☐	KUND2	KUNNR	CHAR	10	0	End customer number	*
52	KUND3	☐	KUND3	KUNNR	CHAR	10	0	Operator	*
53	LIZNR	☐	LIZNR	CHAR20	CHAR	20	0	Equipment license number
54	RBNR	☐	RBNR	RBNR	CHAR	9	0	Report layout	*
55	EZDAT	☐	EQDAT	DATUM	DATS	8	0	Date
56	EZBER	☐	EQBER	CHAR30	CHAR	30	0	Text for Notes
57	EZNUM	☐	EQNUM	NUM9	NUMC	9	0	Numerical Field
58	RBNR_I	☐	INHER	INHER	CHAR	1	0	Data origin indicator
59	IBLNR	☐	IBLNR	BELNR	CHAR	10	0	Physical inventory document
60	BLDAT	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
61	PVS_FOCUS	☐	PVS_GUID_CCC	SYSUUID	RAW	16	0	Internal Identification for PVS Objects
62	PPEGUID	☐	PVS_GUID_CCC	SYSUUID	RAW	16	0	Internal Identification for PVS Objects
63	TECHS	☐	TECHS	TECHS	CHAR	12	0	Parameter Variant/Standard Variant
64	FUNCID	☐	CCC_FUNCID	CHAR40	CHAR	40	0	Function Identifier
65	FRCFIT	☐	CCC_FRCFIT	XCHAR	CHAR	1	0	Indicator: Forced Installation/Dismantling
66	FRCRMV	☐	CCC_FRCRMV	XCHAR	CHAR	1	0	Force Dismantling Flag
67	.INCLUDE	☐				0	0	Data part location and account assignment for PM object
68	TPLNR	☐	TPLNR	TPLNR	CHAR	30	0	Functional Location	IFLOT
69	ABCKZ	☐	ABCKZ	ABCKZ	CHAR	1	0	ABC Indicator for Technical Object	T370C
70	ABCKZI	☐	INH_ABCKZI	INHER	CHAR	1	0	Data origin for ABC indicator field
71	EQFNR	☐	EQFNR	CHAR30	CHAR	30	0	Sort Field
72	EQFNRI	☐	INH_EQFNRI	INHER	CHAR	1	0	Data origin for sort field
73	SWERK	☐	SWERK	WERKS	CHAR	4	0	Maintenance Plant	T001W
74	SWERKI	☐	INH_SWERKI	INHER	CHAR	1	0	Data origin for maintenance plant field
75	STORT	☐	PMLOC	AP_STAND	CHAR	10	0	Location of maintenance object	T499S
76	STORTI	☐	INH_STORTI	INHER	CHAR	1	0	Data origin for location field
77	MSGRP	☐	RAUMNR	CHAR8	CHAR	8	0	Room
78	MSGRPI	☐	INH_MSGRPI	INHER	CHAR	1	0	Data origin for room number field
79	BEBER	☐	BEBER	BEBER	CHAR	3	0	Organizational Area	T357
80	BEBERI	☐	INH_BEBERI	INHER	CHAR	1	0	Data origin for company area field
81	CR_OBJTY	☐	CR_OBJTY	CR_OBJTY	CHAR	2	0	Object types of the CIM resource
82	PPSID	☐	PPSID	CR_OBJID	NUMC	8	0	Object ID of PP work center	CRID
83	PPSIDI	☐	INH_PPSIDI	INHER	CHAR	1	0	Data origin for PP work center field
84	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
85	GSBERI	☐	INH_GSBERI	INHER	CHAR	1	0	Data origin for business area field
86	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
87	KOKRSI	☐	INH_KOKRSI	INHER	CHAR	1	0	Data origin for controlling area field
88	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
89	KOSTLI	☐	INH_KOSTLI	INHER	CHAR	1	0	Data origin for cost center field
90	PROID	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	PRPS
91	PROIDI	☐	INH_PROIDI	INHER	CHAR	1	0	Data origin for WBS element field
92	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
93	BUKRSI	☐	INH_BUKRSI	INHER	CHAR	1	0	Data origin for company code field
94	ANLNR	☐	ANLN1	ANLN1	CHAR	12	0	Main Asset Number	ANLH
95	ANLNRI	☐	INH_ANLNRI	INHER	CHAR	1	0	Data origin for asset main no./sub-no. fields
96	ANLUN	☐	ANLN2	ANLN2	CHAR	4	0	Asset Subnumber	ANLA
97	ANLUNI	☐	INHER	INHER	CHAR	1	0	Data origin indicator
98	DAUFN	☐	DAUFN	AUFNR	CHAR	12	0	Standing order number	AUFK
99	DAUFNI	☐	INH_DAUFNI	INHER	CHAR	1	0	Data origin of standing order number field
100	AUFNR	☐	ILOM_ORDST	AUFNR	CHAR	12	0	Settlement order	AUFK
101	AUFNRI	☐	INH_AUFNRI	INHER	CHAR	1	0	Data origin for settlement order field
102	TPLNRI	☐	INH_TPLNRI	INHER	CHAR	1	0	Data origin for functional location field
103	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
104	VKORGI	☐	INH_VKORGI	INHER	CHAR	1	0	Data origin for sales organization field
105	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVKOV
106	VTWEGI	☐	INH_VTWEGI	INHER	CHAR	1	0	Data origin of distribution channel field
107	SPART	☐	SPART	SPART	CHAR	2	0	Division	TVTA
108	SPARTI	☐	INH_SPARTI	INHER	CHAR	1	0	Data origin for division field
109	ADRNR	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	ADRC
110	ADRNRI	☐	INH_ADRNRI	INHER	CHAR	1	0	Data origin for address field
111	OWNER	☐	ILOM_OWNER	ILOM_OWNER	CHAR	1	0	Object reference indicator
112	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	TVKBZ
113	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVBVK
114	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	IEQT_WL_ITEMS	ABCKZ	T370C	ABCKZ	REF	1	CN
2	IEQT_WL_ITEMS	ADRNR	ADRC	ADDRNUMBER	REF	1	CN
3	IEQT_WL_ITEMS	ANLNR	ANLH	ANLN1	REF	1	CN
4	IEQT_WL_ITEMS	ANLUN	ANLA	ANLN2	REF	1	CN
5	IEQT_WL_ITEMS	AUFNR	AUFK	AUFNR	REF	1	CN
6	IEQT_WL_ITEMS	BEBER	T357	BEBER	REF	1	CN
7	IEQT_WL_ITEMS	BUKRS	T001	BUKRS	REF	1	CN
8	IEQT_WL_ITEMS	DAUFN	AUFK	AUFNR	REF	1	CN
9	IEQT_WL_ITEMS	GSBER	TGSB	GSBER	REF	1	CN
10	IEQT_WL_ITEMS	KOKRS	TKA01	KOKRS	REF	1	CN
11	IEQT_WL_ITEMS	KOSTL	CSKS	KOSTL	REF	1	CN
12	IEQT_WL_ITEMS	PPSID	CRID	OBJID	REF	1	CN
13	IEQT_WL_ITEMS	PROID	PRPS	PSPNR	REF	1	CN
14	IEQT_WL_ITEMS	QMNUM_INSTALL	QMEL	QMNUM
15	IEQT_WL_ITEMS	QMNUM_REMOVAL	QMEL	QMNUM
16	IEQT_WL_ITEMS	SPART	TVTA	SPART	REF	1	CN
17	IEQT_WL_ITEMS	STORT	T499S	STAND	REF	1	CN
18	IEQT_WL_ITEMS	SWERK	T001W	WERKS	REF	1	CN
19	IEQT_WL_ITEMS	TPLNR	IFLOT	TPLNR	REF	1	CN
20	IEQT_WL_ITEMS	VKBUR	TVKBZ	VKBUR	REF	1	CN
21	IEQT_WL_ITEMS	VKGRP	TVBVK	VKGRP	REF	1	CN
22	IEQT_WL_ITEMS	VKORG	TVKO	VKORG	REF	1	CN
23	IEQT_WL_ITEMS	VTWEG	TVKOV	VTWEG	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	600