SAP ABAP Table HIKOLA_HIVGIFLOS (Generated Table for View)

Basic Data

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

History

Last changed by/on	SAP	20130529
SAP Release Created in