SAP ABAP Table HIKO (Order master data history)

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

Table Category	TRANSP	Transparent table
Transparent table	HIKO	Table Relationship Diagram
Short Description	Order master data history

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	.INCLUDE	☐				0	0
74	.INCLU--AP	☐				0	0	IUID Append
75	UII	☐	UII_CHAR72	UII_CHAR72	CHAR	72	0	Unique Item Identifier

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	HIKO	ANLZU	T357M	ANLZU	REF	C	CN
2	HIKO	APGRP	T024A	FEVOR	REF	C	CN
3	HIKO	ARTPR	T356A	ARTPR	REF	C	CN
4	HIKO	AUART	T003O	AUART	REF	1	CN
5	HIKO	BAUTL	MARA	MATNR	REF	C	CN
6	HIKO	BUKRS	T001	BUKRS	REF	1	CN
7	HIKO	EQUNR	EQUI	EQUNR	REF	C	CN
8	HIKO	GAUEH	T006	MSEHI	REF	C	CN
9	HIKO	GEWRK	CRID	OBJID	REF	C	CN
10	HIKO	GSBER	TGSB	GSBER	REF	1	CN
11	HIKO	ILART	T353I	ILART
12	HIKO	ILOAN	ILOA	ILOAN	REF	C	CN
13	HIKO	INGPR	T024I	INGRP	REF	C	CN
14	HIKO	IWERK	T001W	WERKS	REF	C	CN
15	HIKO	KOKRS	TKA01	KOKRS	REF	1	CN
16	HIKO	KUNUM	KNA1	KUNNR	REF	C	CN
17	HIKO	LAUFN	HIKO	AUFNR	REF	C	CN
18	HIKO	LEAD_AUFNR	HIKO	AUFNR
19	HIKO	MANDT	T000	MANDT	KEY	1	CN
20	HIKO	MAUFNR	HIKO	AUFNR	REF	C	CN
21	HIKO	OBJNR	ONR00	OBJNR
22	HIKO	PLNTY	TCA01	PLNTY	REF	C	CN
23	HIKO	PLVAR	T778P	PLVAR	REF	C	CN
24	HIKO	PRIOK	T356	PRIOK	REF	C	CN
25	HIKO	PSPEL	PRPS	PSPNR	REF	C	CN
26	HIKO	QMNUM	QMEL	QMNUM
27	HIKO	REVNR	T352R	REVNR
28	HIKO	SCREENTY	TQBT	SCREENTY
29	HIKO	SERMAT	MARA	MATNR
30	HIKO	VAWRK	T001W	WERKS
31	HIKO	WAERS	TCURC	WAERS	REF	1	CN
32	HIKO	WARPL	MPLA	WARPL	REF	C	CN
33	HIKO	WERKS	T001W	WERKS	REF	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in