SAP ABAP View HIKOLA_IFLOS (PM order view using HIKO/ILOA (adjusted to alt. indicator))

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ PM-WOC-MH (Application Component) Maintenance History
     ⤷ IWO2 (Package) Application Development R/3 Plant Maintenance Order History

Basic Data

View Type	D	Database View
Database View	HIKOLA_IFLOS
Short Description	PM order view using HIKO/ILOA (adjusted to alt. indicator)
Root table	HIKO	Order master data history

Table

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

Join Conditions

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

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	*	HIKO	*		☐		☐
2	MANDT	HIKO	MANDT		☐	MANDT	☐	Client
3	AUFNR	HIKO	AUFNR		☐	AUFNR_H	☐	Order number historical
4	AUART	HIKO	AUART		☐	AUFART	☐	Order Type
5	AUTYP	HIKO	AUTYP		☐	AUFTYP	☐	Order category
6	KTEXT	HIKO	KTEXT		☐	AUFTEXT	☐	Description
7	LTEXT	HIKO	LTEXT		☐	AUFLTEXT	☐	Long Text Exists
8	LOEKZ	HIKO	LOEKZ		☐	AUFLOEKZ	☐	Deletion flag
9	MAUFNR	HIKO	MAUFNR		☐	MAUFNR_H	☐	Number of superior order historical
10	LEAD_AUFNR	HIKO	LEAD_AUFNR		☐	LAUFNR_H	☐	Number of leading order historical
11	PLVAR	HIKO	PLVAR		☐	PLVAR	☐	Plan Version
12	OBJNR	HIKO	OBJNR		☐	J_OBJNR	☐	Object number
13	VAPLZ	HIKO	VAPLZ		☐	GEWRK	☐	Main work center for maintenance tasks
14	VAWRK	HIKO	VAWRK		☐	WERGW	☐	Plant associated with main work center
15	BUKRS	HIKO	BUKRS		☐	BUKRS	☐	Company Code
16	WERKS	HIKO	WERKS		☐	WERKS_D	☐	Plant
17	GSBER	HIKO	GSBER		☐	GSBER	☐	Business Area
18	KOKRS	HIKO	KOKRS		☐	KOKRS	☐	Controlling Area
19	WAERS	HIKO	WAERS		☐	AUFWAERS	☐	Order Currency
20	GLTRP	HIKO	GLTRP		☐	CO_GLTRP	☐	Basic finish date
21	GSTRP	HIKO	GSTRP		☐	CO_GSTRP	☐	Basic start date
22	GSTRI	HIKO	GSTRI		☐	CO_GSTRI	☐	Actual start date
23	GETRI	HIKO	GETRI		☐	CO_GETRI	☐	Confirmed Order Finish Date
24	PSPEL	HIKO	PSPEL		☐	PS_PSP_ELE	☐	Work breakdown structure element (WBS element)
25	PLNTY	HIKO	PLNTY		☐	PLNTY	☐	Task List Type
26	PLNNR	HIKO	PLNNR		☐	PLNNR	☐	Key for Task List Group
27	PLNAL	HIKO	PLNAL		☐	PLNAL	☐	Group Counter
28	ZAEHL	HIKO	ZAEHL		☐	CIM_COUNT	☐	Internal counter
29	ERNAM	HIKO	ERNAM		☐	AUFERFNAM	☐	Entered by
30	ERDAT	HIKO	ERDAT		☐	AUFERFDAT	☐	Created on
31	AENAM	HIKO	AENAM		☐	AUFAENAM	☐	Last changed by
32	AEDAT	HIKO	AEDAT		☐	AUFAEDAT	☐	Change date for Order Master
33	ARTPR	HIKO	ARTPR		☐	ARTPR	☐	Priority Type
34	PRIOK	HIKO	PRIOK		☐	PRIOK	☐	Priority
35	EQUNR	HIKO	EQUNR		☐	EQUNR	☐	Equipment Number
36	BAUTL	HIKO	BAUTL		☐	BAUTL	☐	Assembly
37	ILOAN	HIKO	ILOAN		☐	ILOAN	☐	Location and account assignment for technical object
38	ILOAI	HIKO	ILOAI		☐	ILOAI	☐	ILOA Individual
39	ANLZU	HIKO	ANLZU		☐	ANLZU	☐	Syst.Condition
40	IWERK	HIKO	IWERK		☐	IWERK	☐	Maintenance Planning Plant
41	INGPR	HIKO	INGPR		☐	INGRP	☐	Planner Group for Customer Service and Plant Maintenance
42	APGRP	HIKO	APGRP		☐	VAGRP	☐	Responsible planner group/department
43	PM_OBJTY	HIKO	PM_OBJTY		☐	PM_OBJTY	☐	Object Type of CIM Resources for Work Center
44	GEWRK	HIKO	GEWRK		☐	LGWID	☐	Object ID of the Work Center
45	KUNUM	HIKO	KUNUM		☐	KUNUM	☐	Customer Number
46	ANING	HIKO	ANING		☐	ANING	☐	Name of Person Reponsible for System
47	GAUZT	HIKO	GAUZT		☐	GAUZT	☐	Planned downtime in hours
48	GAUEH	HIKO	GAUEH		☐	MAUEH	☐	Unit for Breakdown Duration
49	ANLBD	HIKO	ANLBD		☐	ANLBD	☐	Date until which the system is available
50	ANLVD	HIKO	ANLVD		☐	ANLVD	☐	Date from which the system is available
51	ANLBZ	HIKO	ANLBZ		☐	ANLBZ	☐	Time until which the system is available
52	ANLVZ	HIKO	ANLVZ		☐	ANLVZ	☐	Time from Which System is Available
53	INSPK	HIKO	INSPK		☐	INSPK	☐	Name of Person Responsible for Technical Inspection
54	DATAN	HIKO	DATAN		☐	DATAN	☐	Date of Technical Inspection
55	WARPL	HIKO	WARPL		☐	WARPL	☐	Maintenance Plan
56	ABNUM	HIKO	ABNUM		☐	ABNUM	☐	Maintenance Plan Call Number
57	WAPOS	HIKO	WAPOS		☐	WAPOS	☐	Maintenance item
58	LAUFN	HIKO	LAUFN		☐	LAUFN_H	☐	Order number historical
59	OBKNR	HIKO	OBKNR		☐	OBJKNR	☐	Object list number
60	REVNR	HIKO	REVNR		☐	REVNI	☐	Revision of Plant Maintenance and Customer Service
61	ADDAT	HIKO	ADDAT		☐	ADDAT	☐	PM Order: Reference Date
62	ADUHR	HIKO	ADUHR		☐	ADUHR	☐	Time of Reference Date
63	IPHAS	HIKO	IPHAS		☐	PM_PHASE	☐	Maintenance Processing Phase
64	ILART	HIKO	ILART		☐	ILA	☐	Maintenance activity type
65	QMNUM	HIKO	QMNUM		☐	QMNUM	☐	Message Number
66	HISDA	HIKO	HISDA		☐	HISDA	☐	PM request: History date
67	AKKNZ	HIKO	AKKNZ		☐	AKKNZ	☐	Order Category Indicator Plant Maintenance
68	PLKNZ	HIKO	PLKNZ		☐	AUF_PLKNZ	☐	Maintenance order planning indicator
69	USER4	HIKO	USER4		☐	AUFUSER4	☐	Estimated total costs of order
70	SERIALNR	HIKO	SERIALNR		☐	GERNR	☐	Serial Number
71	SERMAT	HIKO	SERMAT		☐	MATNR	☐	Material Number
72	DEVICEID	HIKO	DEVICEID		☐	DEVICEID	☐	Additional Device Data
73	SCREENTY	HIKO	SCREENTY		☐	SCRTP	☐	Scenario or Subscreen Category
74	UII	HIKO	UII		☐	UII_CHAR72	☐	Unique Item Identifier
75	TPLNR	IFLOS	STRNO		☐	ILOM_STRNO	☐	Functional location label
76	ABCKZ	ILOA	ABCKZ		☐	ABCKZ	☐	ABC Indicator for Technical Object
77	ABCKZI	ILOA	ABCKZI		☐	INH_ABCKZI	☐	Data origin for ABC indicator field
78	EQFNR	ILOA	EQFNR		☐	EQFNR	☐	Sort Field
79	EQFNRI	ILOA	EQFNRI		☐	INH_EQFNRI	☐	Data origin for sort field
80	SWERK	ILOA	SWERK		☐	SWERK	☐	Maintenance Plant
81	SWERKI	ILOA	SWERKI		☐	INH_SWERKI	☐	Data origin for maintenance plant field
82	STORT	ILOA	STORT		☐	PMLOC	☐	Location of maintenance object
83	STORTI	ILOA	STORTI		☐	INH_STORTI	☐	Data origin for location field
84	MSGRP	ILOA	MSGRP		☐	RAUMNR	☐	Room
85	MSGRPI	ILOA	MSGRPI		☐	INH_MSGRPI	☐	Data origin for room number field
86	BEBER	ILOA	BEBER		☐	BEBER	☐	Organizational Area
87	BEBERI	ILOA	BEBERI		☐	INH_BEBERI	☐	Data origin for company area field
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	PPSIDI	ILOA	PPSIDI		☐	INH_PPSIDI	☐	Data origin for PP work center field
91	IGSBER	ILOA	GSBER		☐	GSBER	☐	Business Area
92	GSBERI	ILOA	GSBERI		☐	INH_GSBERI	☐	Data origin for business area field
93	IKOKRS	ILOA	KOKRS		☐	KOKRS	☐	Controlling Area
94	KOKRSI	ILOA	KOKRSI		☐	INH_KOKRSI	☐	Data origin for controlling area field
95	KOSTL	ILOA	KOSTL		☐	KOSTL	☐	Cost Center
96	KOSTLI	ILOA	KOSTLI		☐	INH_KOSTLI	☐	Data origin for cost center field
97	PROID	ILOA	PROID		☐	PS_PSP_PNR	☐	Work Breakdown Structure Element (WBS Element)
98	PROIDI	ILOA	PROIDI		☐	INH_PROIDI	☐	Data origin for WBS element field
99	IBUKRS	ILOA	BUKRS		☐	BUKRS	☐	Company Code
100	BUKRSI	ILOA	BUKRSI		☐	INH_BUKRSI	☐	Data origin for company code field
101	ANLNR	ILOA	ANLNR		☐	ANLN1	☐	Main Asset Number
102	ANLNRI	ILOA	ANLNRI		☐	INH_ANLNRI	☐	Data origin for asset main no./sub-no. fields
103	ANLUN	ILOA	ANLUN		☐	ANLN2	☐	Asset Subnumber
104	ANLUNI	ILOA	ANLUNI		☐	INHER	☐	Data origin indicator
105	DAUFN	ILOA	DAUFN		☐	DAUFN	☐	Standing order number
106	DAUFNI	ILOA	DAUFNI		☐	INH_DAUFNI	☐	Data origin of standing order number field
107	IAUFNR	ILOA	AUFNR		☐	ILOM_ORDST	☐	Settlement order
108	AUFNRI	ILOA	AUFNRI		☐	INH_AUFNRI	☐	Data origin for settlement order field
109	TPLNRI	ILOA	TPLNRI		☐	INH_TPLNRI	☐	Data origin for functional location field
110	VKORG	ILOA	VKORG		☐	VKORG	☐	Sales Organization
111	VKORGI	ILOA	VKORGI		☐	INH_VKORGI	☐	Data origin for sales organization field
112	VTWEG	ILOA	VTWEG		☐	VTWEG	☐	Distribution Channel
113	VTWEGI	ILOA	VTWEGI		☐	INH_VTWEGI	☐	Data origin of distribution channel field
114	SPART	ILOA	SPART		☐	SPART	☐	Division
115	SPARTI	ILOA	SPARTI		☐	INH_SPARTI	☐	Data origin for division field
116	ADRNR	ILOA	ADRNR		☐	AD_ADDRNUM	☐	Address number
117	ADRNRI	ILOA	ADRNRI		☐	INH_ADRNRI	☐	Data origin for address field
118	OWNER	ILOA	OWNER		☐	ILOM_OWNER	☐	Object reference indicator
119	ALKEY	IFLOS	ALKEY		☐	ILOM_ALKEY	☐	Labeling system for functional locations
120	VERSN	IFLOS	VERSN		☐	ILOM_VERSN	☐	Version of functional location label
121	TPLNR_INT	IFLOS	TPLNR		☐	TPLNR	☐	Functional Location

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	46C