SAP ABAP Table HIKOLA_HIVG (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	HIKOLA_HIVG	Table Relationship Diagram
Short Description	Generated Table for View

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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	HIKOLA_HIVG	ABCKZ	T370C	ABCKZ	REF	C	CN
2	HIKOLA_HIVG	ANLZU	T357M	ANLZU	REF	C	CN
3	HIKOLA_HIVG	APLZL	AFVC	APLZL	REF	C	CN
4	HIKOLA_HIVG	ARBEH	T006	MSEHI	REF	C	CN
5	HIKOLA_HIVG	ARTPR	T356A	ARTPR	REF	C	CN
6	HIKOLA_HIVG	AUART	T003O	AUART	REF	1	CN
7	HIKOLA_HIVG	BAUTL	MARA	MATNR	REF	C	CN
8	HIKOLA_HIVG	BEBER	T357	BEBER	REF	C	CN
9	HIKOLA_HIVG	BUKRS	T001	BUKRS	REF	1	CN
10	HIKOLA_HIVG	DAUFN	AUFK	AUFNR	REF	C	CN
11	HIKOLA_HIVG	EKGRP	T024	EKGRP	REF	C	CN
12	HIKOLA_HIVG	EKORG	T024E	EKORG	REF	C	CN
13	HIKOLA_HIVG	EQUNR	EQUI	EQUNR	REF	C	CN
14	HIKOLA_HIVG	GAUEH	T006	MSEHI	REF	C	CN
15	HIKOLA_HIVG	GEWRK	CRID	OBJID	REF	C	CN
16	HIKOLA_HIVG	GSBER	TGSB	GSBER	REF	1	CN
17	HIKOLA_HIVG	ILART	T353I	ILART
18	HIKOLA_HIVG	ILOAN	ILOA	ILOAN	REF	C	CN
19	HIKOLA_HIVG	INFNR	EINA	INFNR	REF	C	CN
20	HIKOLA_HIVG	INGPR	T024I	INGRP	REF	C	CN
21	HIKOLA_HIVG	IWERK	T001W	WERKS	REF	C	CN
22	HIKOLA_HIVG	KOKRS	TKA01	KOKRS	REF	1	CN
23	HIKOLA_HIVG	KTSCH	T435	VLSCH	REF	C	CN
24	HIKOLA_HIVG	KUNUM	KNA1	KUNNR	REF	C	CN
25	HIKOLA_HIVG	LAUFN	HIKO	AUFNR	REF	C	CN
26	HIKOLA_HIVG	LEAD_AUFNR	HIKO	AUFNR
27	HIKOLA_HIVG	LIFNR	LFA1	LIFNR	REF	C	CN
28	HIKOLA_HIVG	LOGRP	T421	LOGRP	REF	C	CN
29	HIKOLA_HIVG	MANDT	T000	MANDT	KEY	1	CN
30	HIKOLA_HIVG	MATKL	T023	MATKL	REF	C	CN
31	HIKOLA_HIVG	MAUFNR	HIKO	AUFNR	REF	C	CN
32	HIKOLA_HIVG	MEINH	T006	MSEHI	REF	C	CN
33	HIKOLA_HIVG	OBJNR	ONR00	OBJNR
34	HIKOLA_HIVG	PLGRP	T024A	FEVOR	REF	C	CN
35	HIKOLA_HIVG	PLNTY	TCA01	PLNTY	REF	C	CN
36	HIKOLA_HIVG	PLVAR	T778P	PLVAR	REF	C	CN
37	HIKOLA_HIVG	PPSID	CRID	OBJID	REF	C	CN
38	HIKOLA_HIVG	PRIOK	T356	PRIOK	REF	C	CN
39	HIKOLA_HIVG	PROID	PRPS	PSPNR		C	CN
40	HIKOLA_HIVG	PSPEL	PRPS	PSPNR	REF	C	CN
41	HIKOLA_HIVG	QMNUM	QMEL	QMNUM
42	HIKOLA_HIVG	QUALF	T423	QUALF	REF	C	CN
43	HIKOLA_HIVG	REVNR	T352R	REVNR
44	HIKOLA_HIVG	SAKTO	CSKA	KSTAR	REF	C	CN
45	HIKOLA_HIVG	SCREENTY	TQBT	SCREENTY
46	HIKOLA_HIVG	SERMAT	MARA	MATNR
47	HIKOLA_HIVG	SPART	TVTA	SPART	REF	1	CN
48	HIKOLA_HIVG	STEUS	T430	STEUS	REF	1	1
49	HIKOLA_HIVG	STORT	T499S	STAND	REF	C	CN
50	HIKOLA_HIVG	STRNO	IFLOT	TPLNR	REF	C	CN
51	HIKOLA_HIVG	SWERK	T001W	WERKS	REF	1	CN
52	HIKOLA_HIVG	TPLNR	IFLOT	TPLNR	REF	C	CN
53	HIKOLA_HIVG	TXTSP	T002	SPRAS	REF	C	CN
54	HIKOLA_HIVG	VAWRK	T001W	WERKS
55	HIKOLA_HIVG	VKORG	TVKO	VKORG	REF	1	CN
56	HIKOLA_HIVG	VTWEG	TVKOV	VTWEG	REF	1	CN
57	HIKOLA_HIVG	V_ANLZU	T357M	ANLZU	REF	C	CN
58	HIKOLA_HIVG	V_ISTRU	MARA	MATNR	REF	C	CN
59	HIKOLA_HIVG	V_OBJNR	ONR00	OBJNR	REF	1	1
60	HIKOLA_HIVG	V_WAERS	TCURC	WAERS	REF	C	CN
61	HIKOLA_HIVG	V_WERKS	T001W	WERKS	REF	1	CN
62	HIKOLA_HIVG	WAERS	TCURC	WAERS	REF	1	CN
63	HIKOLA_HIVG	WARPL	MPLA	WARPL	REF	C	CN
64	HIKOLA_HIVG	WERKS	T001W	WERKS	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in