SAP ABAP View HIKOLA_HIVG (Historic Maintenance Orders and Operations)

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ PM (Application Component) Plant Maintenance
     ⤷ IHREP (Package) Maintenance Reporting

Basic Data

View Type	D	Database View
Database View	HIKOLA_HIVG
Short Description	Historic Maintenance Orders and Operations
Root table	HIKO	Order master data history

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	HIKO	HIKO
2	ILOA
3	HIVG

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	HIVG	MANDT	JL	EQ				0	0
2	HIKO	MANDT	JR	EQ			AND	0	0
3	HIVG	AUFNR	JL	EQ				0	0
4	HIKO	AUFNR	JR	EQ			AND	0	0
5	ILOA	MANDT	JL	EQ				0	0
6	HIKO	MANDT	JR	EQ			AND	0	0
7	ILOA	ILOAN	JL	EQ				0	0
8	HIKO	ILOAN	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	HIKO	MANDT		☐	MANDT	☐	Client
2	AUFNR	HIKO	AUFNR		☐	AUFNR_H	☐	Order number historical
3	VORNR	HIVG	VORNR		☐	VORNR	☐	Operation/Activity Number
4	UVORN	HIVG	UVORN		☐	UVORN	☐	Suboperation
5	TPLNR	ILOA	TPLNR		☐	TPLNR	☐	Functional Location
6	STRNO	ILOA	TPLNR		☐	TPLNR	☐	Functional Location
7	*	HIKO	*		☐		☐
8	-	HIKO	MANDT		☐	MANDT	☐	Client
9	-	HIKO	AUFNR		☐	AUFNR_H	☐	Order number historical
10	AUART	HIKO	AUART		☐	AUFART	☐	Order Type
11	AUTYP	HIKO	AUTYP		☐	AUFTYP	☐	Order category
12	KTEXT	HIKO	KTEXT		☐	AUFTEXT	☐	Description
13	LTEXT	HIKO	LTEXT		☐	AUFLTEXT	☐	Long Text Exists
14	LOEKZ	HIKO	LOEKZ		☐	AUFLOEKZ	☐	Deletion flag
15	MAUFNR	HIKO	MAUFNR		☐	MAUFNR_H	☐	Number of superior order historical
16	LEAD_AUFNR	HIKO	LEAD_AUFNR		☐	LAUFNR_H	☐	Number of leading order historical
17	PLVAR	HIKO	PLVAR		☐	PLVAR	☐	Plan Version
18	OBJNR	HIKO	OBJNR		☐	J_OBJNR	☐	Object number
19	VAPLZ	HIKO	VAPLZ		☐	GEWRK	☐	Main work center for maintenance tasks
20	VAWRK	HIKO	VAWRK		☐	WERGW	☐	Plant associated with main work center
21	BUKRS	HIKO	BUKRS		☐	BUKRS	☐	Company Code
22	WERKS	HIKO	WERKS		☐	WERKS_D	☐	Plant
23	GSBER	HIKO	GSBER		☐	GSBER	☐	Business Area
24	KOKRS	HIKO	KOKRS		☐	KOKRS	☐	Controlling Area
25	WAERS	HIKO	WAERS		☐	AUFWAERS	☐	Order Currency
26	GLTRP	HIKO	GLTRP		☐	CO_GLTRP	☐	Basic finish date
27	GSTRP	HIKO	GSTRP		☐	CO_GSTRP	☐	Basic start date
28	GSTRI	HIKO	GSTRI		☐	CO_GSTRI	☐	Actual start date
29	GETRI	HIKO	GETRI		☐	CO_GETRI	☐	Confirmed Order Finish Date
30	PSPEL	HIKO	PSPEL		☐	PS_PSP_ELE	☐	Work breakdown structure element (WBS element)
31	PLNTY	HIKO	PLNTY		☐	PLNTY	☐	Task List Type
32	PLNNR	HIKO	PLNNR		☐	PLNNR	☐	Key for Task List Group
33	PLNAL	HIKO	PLNAL		☐	PLNAL	☐	Group Counter
34	ZAEHL	HIKO	ZAEHL		☐	CIM_COUNT	☐	Internal counter
35	ERNAM	HIKO	ERNAM		☐	AUFERFNAM	☐	Entered by
36	ERDAT	HIKO	ERDAT		☐	AUFERFDAT	☐	Created on
37	AENAM	HIKO	AENAM		☐	AUFAENAM	☐	Last changed by
38	AEDAT	HIKO	AEDAT		☐	AUFAEDAT	☐	Change date for Order Master
39	ARTPR	HIKO	ARTPR		☐	ARTPR	☐	Priority Type
40	PRIOK	HIKO	PRIOK		☐	PRIOK	☐	Priority
41	EQUNR	HIKO	EQUNR		☐	EQUNR	☐	Equipment Number
42	BAUTL	HIKO	BAUTL		☐	BAUTL	☐	Assembly
43	ILOAN	HIKO	ILOAN		☐	ILOAN	☐	Location and account assignment for technical object
44	ILOAI	HIKO	ILOAI		☐	ILOAI	☐	ILOA Individual
45	ANLZU	HIKO	ANLZU		☐	ANLZU	☐	Syst.Condition
46	IWERK	HIKO	IWERK		☐	IWERK	☐	Maintenance Planning Plant
47	INGPR	HIKO	INGPR		☐	INGRP	☐	Planner Group for Customer Service and Plant Maintenance
48	PM_OBJTY	HIKO	PM_OBJTY		☐	PM_OBJTY	☐	Object Type of CIM Resources for Work Center
49	GEWRK	HIKO	GEWRK		☐	LGWID	☐	Object ID of the Work Center
50	KUNUM	HIKO	KUNUM		☐	KUNUM	☐	Customer Number
51	ANING	HIKO	ANING		☐	ANING	☐	Name of Person Reponsible for System
52	GAUZT	HIKO	GAUZT		☐	GAUZT	☐	Planned downtime in hours
53	GAUEH	HIKO	GAUEH		☐	MAUEH	☐	Unit for Breakdown Duration
54	ANLBD	HIKO	ANLBD		☐	ANLBD	☐	Date until which the system is available
55	ANLVD	HIKO	ANLVD		☐	ANLVD	☐	Date from which the system is available
56	ANLBZ	HIKO	ANLBZ		☐	ANLBZ	☐	Time until which the system is available
57	ANLVZ	HIKO	ANLVZ		☐	ANLVZ	☐	Time from Which System is Available
58	INSPK	HIKO	INSPK		☐	INSPK	☐	Name of Person Responsible for Technical Inspection
59	DATAN	HIKO	DATAN		☐	DATAN	☐	Date of Technical Inspection
60	WARPL	HIKO	WARPL		☐	WARPL	☐	Maintenance Plan
61	ABNUM	HIKO	ABNUM		☐	ABNUM	☐	Maintenance Plan Call Number
62	WAPOS	HIKO	WAPOS		☐	WAPOS	☐	Maintenance item
63	LAUFN	HIKO	LAUFN		☐	LAUFN_H	☐	Order number historical
64	OBKNR	HIKO	OBKNR		☐	OBJKNR	☐	Object list number
65	REVNR	HIKO	REVNR		☐	REVNI	☐	Revision of Plant Maintenance and Customer Service
66	ADDAT	HIKO	ADDAT		☐	ADDAT	☐	PM Order: Reference Date
67	ADUHR	HIKO	ADUHR		☐	ADUHR	☐	Time of Reference Date
68	IPHAS	HIKO	IPHAS		☐	PM_PHASE	☐	Maintenance Processing Phase
69	ILART	HIKO	ILART		☐	ILA	☐	Maintenance activity type
70	QMNUM	HIKO	QMNUM		☐	QMNUM	☐	Message Number
71	HISDA	HIKO	HISDA		☐	HISDA	☐	PM request: History date
72	AKKNZ	HIKO	AKKNZ		☐	AKKNZ	☐	Order Category Indicator Plant Maintenance
73	PLKNZ	HIKO	PLKNZ		☐	AUF_PLKNZ	☐	Maintenance order planning indicator
74	USER4	HIKO	USER4		☐	AUFUSER4	☐	Estimated total costs of order
75	SERIALNR	HIKO	SERIALNR		☐	GERNR	☐	Serial Number
76	SERMAT	HIKO	SERMAT		☐	MATNR	☐	Material Number
77	DEVICEID	HIKO	DEVICEID		☐	DEVICEID	☐	Additional Device Data
78	SCREENTY	HIKO	SCREENTY		☐	SCRTP	☐	Scenario or Subscreen Category
79	UII	HIKO	UII		☐	UII_CHAR72	☐	Unique Item Identifier
80	PLGRP	HIKO	APGRP		☐	VAGRP	☐	Responsible planner group/department
81	STORT	ILOA	STORT		☐	PMLOC	☐	Location of maintenance object
82	KOSTL	ILOA	KOSTL		☐	KOSTL	☐	Cost Center
83	ABCKZ	ILOA	ABCKZ		☐	ABCKZ	☐	ABC Indicator for Technical Object
84	EQFNR	ILOA	EQFNR		☐	EQFNR	☐	Sort Field
85	SWERK	ILOA	SWERK		☐	SWERK	☐	Maintenance Plant
86	MSGRP	ILOA	MSGRP		☐	RAUMNR	☐	Room
87	BEBER	ILOA	BEBER		☐	BEBER	☐	Organizational Area
88	CR_OBJTY	ILOA	CR_OBJTY		☐	CR_OBJTY	☐	Object types of the CIM resource
89	PPSID	ILOA	PPSID		☐	PPSID	☐	Object ID of PP work center
90	PROID	ILOA	PROID		☐	PS_PSP_PNR	☐	Work Breakdown Structure Element (WBS Element)
91	ANLNR	ILOA	ANLNR		☐	ANLN1	☐	Main Asset Number
92	ANLUN	ILOA	ANLUN		☐	ANLN2	☐	Asset Subnumber
93	DAUFN	ILOA	DAUFN		☐	DAUFN	☐	Standing order number
94	OWNER	ILOA	OWNER		☐	ILOM_OWNER	☐	Object reference indicator
95	VKORG	ILOA	VKORG		☐	VKORG	☐	Sales Organization
96	VTWEG	ILOA	VTWEG		☐	VTWEG	☐	Distribution Channel
97	SPART	ILOA	SPART		☐	SPART	☐	Division
98	AUFPL	HIVG	AUFPL		☐	CO_AUFPL	☐	Routing number of operations in the order
99	APLZL	HIVG	APLZL		☐	CO_APLZL	☐	General counter for order
100	STEUS	HIVG	STEUS		☐	STEUS	☐	Control key
101	ARBID	HIVG	ARBID		☐	OBJEKTID	☐	Object ID
102	V_WERKS	HIVG	WERKS		☐	WERKS_D	☐	Plant
103	KTSCH	HIVG	KTSCH		☐	KTSCH	☐	Standard text key
104	LTXA1	HIVG	LTXA1		☐	LTXA1	☐	Operation short text
105	LOANZ	HIVG	LOANZ		☐	LOHNANZ	☐	Number of Time Tickets
106	LOART	HIVG	LOART		☐	LOHNART	☐	Wage type
107	QUALF	HIVG	QUALF		☐	QUALF	☐	Suitability
108	LOGRP	HIVG	LOGRP		☐	LOHNGRP	☐	Wage group
109	LIFNR	HIVG	LIFNR		☐	LIFNR	☐	Account Number of Vendor or Creditor
110	PREIS	HIVG	PREIS		☐	PREIS	☐	Price
111	PEINH	HIVG	PEINH		☐	PEINH	☐	Price unit
112	SAKTO	HIVG	SAKTO		☐	KSTAR	☐	Cost Element
113	V_WAERS	HIVG	WAERS		☐	WAERS	☐	Currency Key
114	INFNR	HIVG	INFNR		☐	INFNR	☐	Number of purchasing info record
115	EKORG	HIVG	EKORG		☐	EKORG	☐	Purchasing organization
116	EKGRP	HIVG	EKGRP		☐	VG_EKGRP	☐	Purchasing group for external processing
117	MATKL	HIVG	MATKL		☐	MATKL	☐	Material Group
118	ANZZL	HIVG	ANZZL		☐	ANZKAP	☐	Number of capacities required
119	RUECK	HIVG	RUECK		☐	CO_RUECK	☐	Completion confirmation number for the operation
120	RMZHL	HIVG	RMZHL		☐	CIM_COUNT	☐	Internal counter
121	V_OBJNR	HIVG	OBJNR		☐	J_OBJNR	☐	Object number
122	V_ANLZU	HIVG	ANLZU		☐	ANLZU	☐	Syst.Condition
123	V_ISTRU	HIVG	ISTRU		☐	ISTRU	☐	Assembly
124	PERNR	HIVG	PERNR		☐	CO_PERNR	☐	Personnel number
125	TXTSP	HIVG	TXTSP		☐	SPRAS	☐	Language Key
126	MEINH	HIVG	MEINH		☐	VORME	☐	Unit of measure for activity
127	ARBEI	HIVG	ARBEI		☐	ARBEIT	☐	Work involved in the activity
128	ARBEH	HIVG	ARBEH		☐	ARBEITE	☐	Unit for work
129	ISMNW	HIVG	ISMNW		☐	CO_ISMNW	☐	Actual work
130	ISDD	HIVG	ISDD		☐	ISDD	☐	Actual start: Execution (date)
131	ISDZ	HIVG	ISDZ		☐	ISDZ	☐	Actual start: Execution/setup (time)
132	IEDD	HIVG	IEDD		☐	IEDD	☐	Actual finish: Execution (date)
133	IEDZ	HIVG	IEDZ		☐	IEDZ	☐	Actual finish: Execution (time)
134	AUFKT	HIVG	AUFKT		☐	AFAKT	☐	Execution Factor
135	V_TPLNR	HIVG	TPLNR		☐	TPLNR	☐	Functional Location
136	V_EQUNR	HIVG	EQUNR		☐	EQUNR	☐	Equipment Number

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

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

History

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