SAP Table HIKO
Order master data history
HIKO (Order master data history) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link HIKO to other SAP tables.
HIKO table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||||||||||||||||||||||||
|
AUFNR
Order number historical
|
AUFNR_H |
CHAR
|
12 | 0 | ||||||||||||||||||||||||||||||
|
AUART
Order Type
|
AUFART | T003O |
CHAR
|
4 | 0 | |||||||||||||||||||||||||||||
|
AUTYP
Order category
|
AUFTYP |
NUMC
|
2 | 0 | ||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||
|
KTEXT
Description
|
AUFTEXT |
CHAR
|
40 | 0 | ||||||||||||||||||||||||||||||
|
LTEXT
Long Text Exists
|
AUFLTEXT |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||
|
LOEKZ
Deletion flag
|
AUFLOEKZ |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||
|
MAUFNR
Number of superior order historical
|
MAUFNR_H | HIKO |
CHAR
|
12 | 0 | |||||||||||||||||||||||||||||
|
LEAD_AUFNR
Number of leading order historical
|
LAUFNR_H | HIKO |
CHAR
|
12 | 0 | |||||||||||||||||||||||||||||
|
PLVAR
Plan Version
|
PLVAR | T778P |
CHAR
|
2 | 0 | |||||||||||||||||||||||||||||
|
OBJNR
Object number
|
J_OBJNR | ONR00 |
CHAR
|
22 | 0 | |||||||||||||||||||||||||||||
|
VAPLZ
Main work center for maintenance tasks
|
GEWRK |
CHAR
|
8 | 0 | ||||||||||||||||||||||||||||||
|
VAWRK
Plant associated with main work center
|
WERGW | T001W |
CHAR
|
4 | 0 | |||||||||||||||||||||||||||||
|
BUKRS
Company Code
|
BUKRS | T001 |
CHAR
|
4 | 0 | |||||||||||||||||||||||||||||
|
WERKS
Plant
|
WERKS_D | T001W |
CHAR
|
4 | 0 | |||||||||||||||||||||||||||||
|
GSBER
Business Area
|
GSBER | TGSB |
CHAR
|
4 | 0 | |||||||||||||||||||||||||||||
|
KOKRS
Controlling Area
|
KOKRS | TKA01 |
CHAR
|
4 | 0 | |||||||||||||||||||||||||||||
|
WAERS
Order Currency
|
AUFWAERS | TCURC |
CUKY
|
5 | 0 | |||||||||||||||||||||||||||||
|
GLTRP
Basic finish date
|
CO_GLTRP |
DATS
|
8 | 0 | ||||||||||||||||||||||||||||||
|
GSTRP
Basic start date
|
CO_GSTRP |
DATS
|
8 | 0 | ||||||||||||||||||||||||||||||
|
GSTRI
Actual start date
|
CO_GSTRI |
DATS
|
8 | 0 | ||||||||||||||||||||||||||||||
|
GETRI
Confirmed Order Finish Date
|
CO_GETRI |
DATS
|
8 | 0 | ||||||||||||||||||||||||||||||
|
PSPEL
Work breakdown structure element (WBS element)
|
PS_PSP_ELE | PRPS |
NUMC
|
8 | 0 | |||||||||||||||||||||||||||||
|
PLNTY
Task List Type
|
PLNTY | TCA01 |
CHAR
|
1 | 0 | |||||||||||||||||||||||||||||
|
PLNNR
Key for Task List Group
|
PLNNR |
CHAR
|
8 | 0 | ||||||||||||||||||||||||||||||
|
PLNAL
Group Counter
|
PLNAL |
CHAR
|
2 | 0 | ||||||||||||||||||||||||||||||
|
ZAEHL
Internal counter
|
CIM_COUNT |
NUMC
|
8 | 0 | ||||||||||||||||||||||||||||||
|
ERNAM
Entered by
|
AUFERFNAM |
CHAR
|
12 | 0 | ||||||||||||||||||||||||||||||
|
ERDAT
Created on
|
AUFERFDAT |
DATS
|
8 | 0 | ||||||||||||||||||||||||||||||
|
AENAM
Last changed by
|
AUFAENAM |
CHAR
|
12 | 0 | ||||||||||||||||||||||||||||||
|
AEDAT
Change date for Order Master
|
AUFAEDAT |
DATS
|
8 | 0 | ||||||||||||||||||||||||||||||
|
ARTPR
Priority Type
|
ARTPR | T356A |
CHAR
|
2 | 0 | |||||||||||||||||||||||||||||
|
PRIOK
Priority
|
PRIOK | T356 |
CHAR
|
1 | 0 | |||||||||||||||||||||||||||||
|
EQUNR
Equipment Number
|
EQUNR | EQUI |
CHAR
|
18 | 0 | |||||||||||||||||||||||||||||
|
BAUTL
Assembly
|
BAUTL | MARA |
CHAR
|
18 | 0 | |||||||||||||||||||||||||||||
|
ILOAN
Location and account assignment for technical object
|
ILOAN | ILOA |
CHAR
|
12 | 0 | |||||||||||||||||||||||||||||
|
ILOAI
ILOA Individual
|
ILOAI |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||
|
ANLZU
Syst.Condition
|
ANLZU | T357M |
CHAR
|
1 | 0 | |||||||||||||||||||||||||||||
|
IWERK
Maintenance Planning Plant
|
IWERK | T001W |
CHAR
|
4 | 0 | |||||||||||||||||||||||||||||
|
INGPR
Planner Group for Customer Service and Plant Maintenance
|
INGRP | T024I |
CHAR
|
3 | 0 | |||||||||||||||||||||||||||||
|
APGRP
Responsible planner group/department
|
VAGRP | T024A |
CHAR
|
3 | 0 | |||||||||||||||||||||||||||||
|
PM_OBJTY
Object Type of CIM Resources for Work Center
|
PM_OBJTY |
CHAR
|
2 | 0 | ||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||
|
GEWRK
Object ID of the Work Center
|
LGWID | CRID |
NUMC
|
8 | 0 | |||||||||||||||||||||||||||||
|
KUNUM
Customer Number
|
KUNUM | KNA1 |
CHAR
|
10 | 0 | |||||||||||||||||||||||||||||
|
ANING
Name of Person Reponsible for System
|
ANING |
CHAR
|
12 | 0 | ||||||||||||||||||||||||||||||
|
GAUZT
Planned downtime in hours
|
GAUZT |
FLTP
|
16 | 16 | ||||||||||||||||||||||||||||||
|
GAUEH
Unit for Breakdown Duration
|
MAUEH | T006 |
UNIT
|
3 | 0 | |||||||||||||||||||||||||||||
|
ANLBD
Date until which the system is available
|
ANLBD |
DATS
|
8 | 0 | ||||||||||||||||||||||||||||||
|
ANLVD
Date from which the system is available
|
ANLVD |
DATS
|
8 | 0 | ||||||||||||||||||||||||||||||
|
ANLBZ
Time until which the system is available
|
ANLBZ |
TIMS
|
6 | 0 | ||||||||||||||||||||||||||||||
|
ANLVZ
Time from Which System is Available
|
ANLVZ |
TIMS
|
6 | 0 | ||||||||||||||||||||||||||||||
|
INSPK
Name of Person Responsible for Technical Inspection
|
INSPK |
CHAR
|
12 | 0 | ||||||||||||||||||||||||||||||
|
DATAN
Date of Technical Inspection
|
DATAN |
DATS
|
8 | 0 | ||||||||||||||||||||||||||||||
|
WARPL
Maintenance Plan
|
WARPL | MPLA |
CHAR
|
12 | 0 | |||||||||||||||||||||||||||||
|
ABNUM
Maintenance Plan Call Number
|
ABNUM |
INT4
|
10 | 0 | ||||||||||||||||||||||||||||||
|
WAPOS
Maintenance item
|
WAPOS |
CHAR
|
16 | 0 | ||||||||||||||||||||||||||||||
|
LAUFN
Order number historical
|
LAUFN_H | HIKO |
CHAR
|
12 | 0 | |||||||||||||||||||||||||||||
|
OBKNR
Object list number
|
OBJKNR |
INT4
|
10 | 0 | ||||||||||||||||||||||||||||||
|
REVNR
Revision for Plant Maintenance and Customer Service
|
REVNI | T352R |
CHAR
|
8 | 0 | |||||||||||||||||||||||||||||
|
ADDAT
PM Order: Reference Date
|
ADDAT |
DATS
|
8 | 0 | ||||||||||||||||||||||||||||||
|
ADUHR
Time of Reference Date
|
ADUHR |
TIMS
|
6 | 0 | ||||||||||||||||||||||||||||||
|
IPHAS
Maintenance Processing Phase
|
PM_PHASE |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||
|
ILART
Maintenance activity type
|
ILA | T353I |
CHAR
|
3 | 0 | |||||||||||||||||||||||||||||
|
QMNUM
Notification No
|
QMNUM | QMEL |
CHAR
|
12 | 0 | |||||||||||||||||||||||||||||
|
HISDA
PM request: History date
|
HISDA |
DATS
|
8 | 0 | ||||||||||||||||||||||||||||||
|
AKKNZ
Order Category Indicator Plant Maintenance
|
AKKNZ |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||
|
PLKNZ
Maintenance order planning indicator
|
AUF_PLKNZ |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||
|
USER4
Estimated total costs of order
|
AUFUSER4 |
CURR
|
11 | 2 | ||||||||||||||||||||||||||||||
|
SERIALNR
Serial Number
|
GERNR |
CHAR
|
18 | 0 | ||||||||||||||||||||||||||||||
|
SERMAT
Material Number
|
MATNR | MARA |
CHAR
|
18 | 0 | |||||||||||||||||||||||||||||
|
DEVICEID
Additional Device Data
|
DEVICEID |
CHAR
|
40 | 0 | ||||||||||||||||||||||||||||||
|
SCREENTY
Scenario or Subscreen Category
|
SCRTP | TQBT |
CHAR
|
4 | 0 | |||||||||||||||||||||||||||||
|
DUMMY_CI_AUFK
Single-Character Indicator
|
CHAR1 |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||||
|
/MRSS/PL_STRU_ID
Resource planning nodes
|
/MRSS/T_PLAN_STRUCT_ID |
NUMC
|
8 | 0 | ||||||||||||||||||||||||||||||
|
/MRSS/PL_MAN_TYP
Assignment to resource planner or contact person
|
/MRSS/T_MANAGER_TYPE |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||
|
/MRSS/ORDER_PROB
Order probability in percent
|
/MRSS/T_ORDER_PROB |
CHAR
|
3 | 0 | ||||||||||||||||||||||||||||||
|
/MRSS/ACT_TYPE
Process variant
|
/MRSS/T_ACTIVITY_TYPE |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||
|
/MRSS/INIT_DONE
Internal initialization carried out once
|
/MRSS/T_INIT_DONE |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||
|
/MRSS/DATACHANGE
Data was changed in the controls on the user screen
|
/MRSS/T_USCREENCTL_DATACHANGED |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||
|
/MRSS/SALES_ORG
Sales Organization
|
VKORG |
CHAR
|
4 | 0 | ||||||||||||||||||||||||||||||
|
/MRSS/NW_BOOKED
Network Set to "Booked"
|
/MRSS/T_NW_BOOKED |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||
|
UII
Unique Item Identifier
|
UII_CHAR72 |
CHAR
|
72 | 0 | ||||||||||||||||||||||||||||||
HIKO foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| HIKO | ANLZU | HIKO | MANDT |
T357M
Machine operating condition
|
MANDT |
| HIKO | ANLZU | HIKO | ANLZU |
T357M
Machine operating condition
|
ANLZU |
| HIKO | APGRP | HIKO | MANDT |
T024A
Planner group
|
MANDT |
| HIKO | APGRP | HIKO | IWERK |
T024A
Planner group
|
WERKS |
| HIKO | APGRP | HIKO | APGRP |
T024A
Planner group
|
FEVOR |
| HIKO | ARTPR | HIKO | MANDT |
T356A
Priority type table
|
MANDT |
| HIKO | ARTPR | HIKO | ARTPR |
T356A
Priority type table
|
ARTPR |
| HIKO | AUART | HIKO | MANDT |
T003O
Order Types
|
CLIENT |
| HIKO | AUART | HIKO | AUART |
T003O
Order Types
|
AUART |
| HIKO | BAUTL | HIKO | BAUTL |
MARA
General Material Data
|
MATNR |
| HIKO | BAUTL | HIKO | MANDT |
MARA
General Material Data
|
MANDT |
| HIKO | BUKRS | HIKO | MANDT |
T001
Company Codes
|
MANDT |
| HIKO | BUKRS | HIKO | BUKRS |
T001
Company Codes
|
BUKRS |
| HIKO | EQUNR | HIKO | MANDT |
EQUI
Equipment master data
|
MANDT |
| HIKO | EQUNR | HIKO | EQUNR |
EQUI
Equipment master data
|
EQUNR |
| HIKO | GAUEH | HIKO | MANDT |
T006
Units of Measurement
|
MANDT |
| HIKO | GAUEH | HIKO | GAUEH |
T006
Units of Measurement
|
MSEHI |
| HIKO | GEWRK | HIKO | MANDT |
CRID
CIM Resource - Entities
|
MANDT |
| HIKO | GEWRK | HIKO | PM_OBJTY |
CRID
CIM Resource - Entities
|
OBJTY |
| HIKO | GEWRK | HIKO | GEWRK |
CRID
CIM Resource - Entities
|
OBJID |
| HIKO | GSBER | HIKO | MANDT |
TGSB
Business Areas
|
MANDT |
| HIKO | GSBER | HIKO | GSBER |
TGSB
Business Areas
|
GSBER |
| HIKO | ILART | HIKO | MANDT |
T353I
Maintenance activity types
|
MANDT |
| HIKO | ILART | HIKO | ILART |
T353I
Maintenance activity types
|
ILART |
| HIKO | ILOAN | HIKO | MANDT |
ILOA
PM Object Location and Account Assignment
|
MANDT |
| HIKO | ILOAN | HIKO | ILOAN |
ILOA
PM Object Location and Account Assignment
|
ILOAN |
| HIKO | INGPR | HIKO | MANDT |
T024I
Maintenance planner groups
|
MANDT |
| HIKO | INGPR | HIKO | IWERK |
T024I
Maintenance planner groups
|
IWERK |
| HIKO | INGPR | HIKO | INGPR |
T024I
Maintenance planner groups
|
INGRP |
| HIKO | IWERK | HIKO | MANDT |
T001W
Plants/Branches
|
MANDT |
| HIKO | IWERK | HIKO | IWERK |
T001W
Plants/Branches
|
WERKS |
| HIKO | KOKRS | HIKO | MANDT |
TKA01
Controlling Areas
|
MANDT |
| HIKO | KOKRS | HIKO | KOKRS |
TKA01
Controlling Areas
|
KOKRS |
| HIKO | KUNUM | HIKO | MANDT |
KNA1
General Data in Customer Master
|
MANDT |
| HIKO | KUNUM | HIKO | KUNUM |
KNA1
General Data in Customer Master
|
KUNNR |
| HIKO | LAUFN | HIKO | LAUFN |
HIKO
Order master data history
|
AUFNR |
| HIKO | LAUFN | HIKO | MANDT |
HIKO
Order master data history
|
MANDT |
| HIKO | LEAD_AUFNR | HIKO | MANDT |
HIKO
Order master data history
|
MANDT |
| HIKO | LEAD_AUFNR | HIKO | LEAD_AUFNR |
HIKO
Order master data history
|
AUFNR |
| HIKO | MANDT | HIKO | MANDT |
T000
Clients
|
MANDT |
| HIKO | MAUFNR | HIKO | MANDT |
HIKO
Order master data history
|
MANDT |
| HIKO | MAUFNR | HIKO | MAUFNR |
HIKO
Order master data history
|
AUFNR |
| HIKO | OBJNR | HIKO | OBJNR |
ONR00
General Object Number
|
OBJNR |
| HIKO | OBJNR | HIKO | MANDT |
ONR00
General Object Number
|
MANDT |
| HIKO | PLNTY | HIKO | MANDT |
TCA01
Task list types
|
MANDT |
| HIKO | PLNTY | HIKO | PLNTY |
TCA01
Task list types
|
PLNTY |
| HIKO | PLVAR | HIKO | PLVAR |
T778P
Plan Versions
|
PLVAR |
| HIKO | PLVAR | HIKO | MANDT |
T778P
Plan Versions
|
MANDT |
| HIKO | PRIOK | HIKO | MANDT |
T356
Priorities
|
MANDT |
| HIKO | PRIOK | HIKO | ARTPR |
T356
Priorities
|
ARTPR |
| HIKO | PRIOK | HIKO | PRIOK |
T356
Priorities
|
PRIOK |
| HIKO | PSPEL | HIKO | MANDT |
PRPS
WBS (Work Breakdown Structure) Element Master Data
|
MANDT |
| HIKO | PSPEL | HIKO | PSPEL |
PRPS
WBS (Work Breakdown Structure) Element Master Data
|
PSPNR |
| HIKO | QMNUM | HIKO | MANDT |
QMEL
Quality Notification
|
MANDT |
| HIKO | QMNUM | HIKO | QMNUM |
QMEL
Quality Notification
|
QMNUM |
| HIKO | REVNR | HIKO | REVNR |
T352R
Maintenance revisions
|
REVNR |
| HIKO | REVNR | HIKO | MANDT |
T352R
Maintenance revisions
|
MANDT |
| HIKO | REVNR | HIKO | IWERK |
T352R
Maintenance revisions
|
IWERK |
| HIKO | SCREENTY | HIKO | SCREENTY |
TQBT
Screen type table for subscreen
|
SCREENTY |
| HIKO | SERMAT | HIKO | MANDT |
MARA
General Material Data
|
MANDT |
| HIKO | SERMAT | HIKO | SERMAT |
MARA
General Material Data
|
MATNR |
| HIKO | VAWRK | HIKO | MANDT |
T001W
Plants/Branches
|
MANDT |
| HIKO | VAWRK | HIKO | VAWRK |
T001W
Plants/Branches
|
WERKS |
| HIKO | WAERS | HIKO | MANDT |
TCURC
Currency Codes
|
MANDT |
| HIKO | WAERS | HIKO | WAERS |
TCURC
Currency Codes
|
WAERS |
| HIKO | WARPL | HIKO | MANDT |
MPLA
Maintenance plan
|
MANDT |
| HIKO | WARPL | HIKO | WARPL |
MPLA
Maintenance plan
|
WARPL |
| HIKO | WERKS | HIKO | MANDT |
T001W
Plants/Branches
|
MANDT |
| HIKO | WERKS | HIKO | WERKS |
T001W
Plants/Branches
|
WERKS |