SAP ABAP Table HIKOLA (Generated Table for View)

Basic Data

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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	HIKOLA	ABCKZ	T370C	ABCKZ	REF	C	CN
2	HIKOLA	ADRNR	ADRC	ADDRNUMBER	REF	1	CN
3	HIKOLA	ANLNR	ANLH	ANLN1	REF	C	CN
4	HIKOLA	ANLUN	ANLA	ANLN2	REF	C	CN
5	HIKOLA	ANLZU	T357M	ANLZU	REF	C	CN
6	HIKOLA	APGRP	T024A	FEVOR	REF	C	CN
7	HIKOLA	ARTPR	T356A	ARTPR	REF	C	CN
8	HIKOLA	AUART	T003O	AUART	REF	1	CN
9	HIKOLA	BAUTL	MARA	MATNR	REF	C	CN
10	HIKOLA	BEBER	T357	BEBER	REF	C	CN
11	HIKOLA	BUKRS	T001	BUKRS	REF	1	CN
12	HIKOLA	DAUFN	AUFK	AUFNR	REF	C	CN
13	HIKOLA	EQUNR	EQUI	EQUNR	REF	C	CN
14	HIKOLA	GAUEH	T006	MSEHI	REF	C	CN
15	HIKOLA	GEWRK	CRID	OBJID	REF	C	CN
16	HIKOLA	GSBER	TGSB	GSBER	REF	1	CN
17	HIKOLA	IAUFNR	AUFK	AUFNR	REF	C	CN
18	HIKOLA	IBUKRS	T001	BUKRS	REF	C	CN
19	HIKOLA	IGSBER	TGSB	GSBER	REF	C	CN
20	HIKOLA	IKOKRS	TKA01	KOKRS	REF	C	CN
21	HIKOLA	ILART	T353I	ILART
22	HIKOLA	ILOAN	ILOA	ILOAN	REF	C	CN
23	HIKOLA	INGPR	T024I	INGRP	REF	C	CN
24	HIKOLA	IWERK	T001W	WERKS	REF	C	CN
25	HIKOLA	KOKRS	TKA01	KOKRS	REF	1	CN
26	HIKOLA	KOSTL	CSKS	KOSTL	REF	C	CN
27	HIKOLA	KUNUM	KNA1	KUNNR	REF	C	CN
28	HIKOLA	LAUFN	HIKO	AUFNR	REF	C	CN
29	HIKOLA	LEAD_AUFNR	HIKO	AUFNR
30	HIKOLA	MANDT	T000	MANDT	KEY	1	CN
31	HIKOLA	MAUFNR	HIKO	AUFNR	REF	C	CN
32	HIKOLA	OBJNR	ONR00	OBJNR
33	HIKOLA	PLNTY	TCA01	PLNTY	REF	C	CN
34	HIKOLA	PLVAR	T778P	PLVAR	REF	C	CN
35	HIKOLA	PPSID	CRID	OBJID	REF	C	CN
36	HIKOLA	PRIOK	T356	PRIOK	REF	C	CN
37	HIKOLA	PROID	PRPS	PSPNR		C	CN
38	HIKOLA	PSPEL	PRPS	PSPNR	REF	C	CN
39	HIKOLA	QMNUM	QMEL	QMNUM
40	HIKOLA	REVNR	T352R	REVNR
41	HIKOLA	SCREENTY	TQBT	SCREENTY
42	HIKOLA	SERMAT	MARA	MATNR
43	HIKOLA	SPART	TVTA	SPART	REF	1	CN
44	HIKOLA	STORT	T499S	STAND	REF	C	CN
45	HIKOLA	SWERK	T001W	WERKS	REF	1	CN
46	HIKOLA	TPLNR	IFLOT	TPLNR	REF	C	CN
47	HIKOLA	VAWRK	T001W	WERKS
48	HIKOLA	VKORG	TVKO	VKORG	REF	1	CN
49	HIKOLA	VTWEG	TVKOV	VTWEG	REF	1	CN
50	HIKOLA	WAERS	TCURC	WAERS	REF	1	CN
51	HIKOLA	WARPL	MPLA	WARPL	REF	C	CN
52	HIKOLA	WERKS	T001W	WERKS	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in