SAP table HIKO (Order master data history)

SAP table HIKO has 2 primary key fields being MANDT,AUFNR.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
AUFNR Order number historical CHAR 12 0 AUFNR_H
AUART Order Type CHAR 4 0 T003O AUFART
AUTYP Order category NUMC 2 0 AUFTYP
01 Internal Order (Controlling)
02 Accrual Calculation Order (Controlling)
03 Model Order (Controlling)
04 CO Production Order
05 Product Cost Collector
06 QM Order
10 PP Production Order
20 Network
30 Maintenance order
40 Process Order
50 Inspection Lot
60 Personnel Order
70 Shipping deadlines
99 Master Planned order
KTEXT Description CHAR 40 0 AUFTEXT
LTEXT Long Text Exists CHAR 1 0 AUFLTEXT
LOEKZ Deletion Flag CHAR 1 0 AUFLOEKZ
MAUFNR Number of superior order historical CHAR 12 0 HIKO MAUFNR_H
LEAD_AUFNR Number of leading order historical CHAR 12 0 HIKO LAUFNR_H
PLVAR Plan Version CHAR 2 0 T778P PLVAR
OBJNR Object number CHAR 22 0 ONR00 J_OBJNR
VAPLZ Main work center for maintenance tasks CHAR 8 0 GEWRK
VAWRK Plant associated with main work center CHAR 4 0 T001W WERGW
BUKRS Company Code CHAR 4 0 T001 BUKRS
WERKS Plant CHAR 4 0 T001W WERKS_D
GSBER Business Area CHAR 4 0 TGSB GSBER
KOKRS Controlling Area CHAR 4 0 TKA01 KOKRS
WAERS Order Currency CUKY 5 0 TCURC AUFWAERS
GLTRP Basic finish date DATS 8 0 CO_GLTRP
GSTRP Basic start date DATS 8 0 CO_GSTRP
GSTRI Actual start date DATS 8 0 CO_GSTRI
GETRI Confirmed Order Finish Date DATS 8 0 CO_GETRI
PSPEL Work breakdown structure element (WBS element) NUMC 8 0 PRPS PS_PSP_ELE
PLNTY Task List Type CHAR 1 0 TCA01 PLNTY
PLNNR Key for Task List Group CHAR 8 0 PLNNR
PLNAL Group Counter CHAR 2 0 PLNAL
ZAEHL Internal counter NUMC 8 0 CIM_COUNT
ERNAM Entered By CHAR 12 0 AUFERFNAM
ERDAT Created On DATS 8 0 AUFERFDAT
AENAM Last Changed By CHAR 12 0 AUFAENAM
AEDAT Change Date for Order Master DATS 8 0 AUFAEDAT
ARTPR Priority Type CHAR 2 0 T356A ARTPR
PRIOK Priority CHAR 1 0 T356 PRIOK
EQUNR Equipment Number CHAR 18 0 EQUI EQUNR
BAUTL Assembly CHAR 40 0 MARA BAUTL
ILOAN Location and account assignment for technical object CHAR 12 0 ILOA ILOAN
ILOAI ILOA Individual CHAR 1 0 ILOAI
ANLZU System Condition CHAR 1 0 T357M ANLZU
IWERK Maintenance Planning Plant CHAR 4 0 T001W IWERK
INGPR Planner Group for Customer Service and Plant Maintenance CHAR 3 0 T024I INGRP
APGRP Responsible Planner Group or Department CHAR 3 0 T024A VAGRP
PM_OBJTY Object Type of CIM Resources for Work Center CHAR 2 0 PM_OBJTY
GEWRK Object ID of the Work Center NUMC 8 0 CRID LGWID
KUNUM Customer Number CHAR 10 0 KNA1 KUNUM
ANING Name of Person Reponsible for System CHAR 12 0 ANING
GAUZT Planned downtime in hours FLTP 16 16 GAUZT
GAUEH Unit for Breakdown Duration UNIT 3 0 T006 MAUEH
ANLBD Date until which the system is available DATS 8 0 ANLBD
ANLVD Date from which the system is available DATS 8 0 ANLVD
ANLBZ Time until which the system is available TIMS 6 0 ANLBZ
ANLVZ Time from Which System is Available TIMS 6 0 ANLVZ
INSPK Name of Person Responsible for Technical Inspection CHAR 12 0 INSPK
DATAN Date of Technical Inspection DATS 8 0 DATAN
WARPL Maintenance Plan CHAR 12 0 MPLA WARPL
ABNUM Maintenance Plan Call Number INT4 10 0 ABNUM
WAPOS Maintenance item CHAR 16 0 WAPOS
LAUFN Order number historical CHAR 12 0 HIKO LAUFN_H
OBKNR Object list number INT8 19 0 OBJKNR
REVNR Revision for Plant Maintenance and Customer Service CHAR 8 0 T352R REVNI
ADDAT PM Order: Reference Date DATS 8 0 ADDAT
ADUHR Time of Reference Date TIMS 6 0 ADUHR
IPHAS Maintenance Processing Phase CHAR 1 0 PM_PHASE
0 Outstanding
1 Postponed (currently not used)
2 Released
3 Technically completed
4 Manual deletion indicator set
5 Historical order
6 Completed for business
ILART Maintenance activity type CHAR 3 0 T353I ILA
QMNUM Notification Number CHAR 12 0 QMEL QMNUM
HISDA PM request: History date DATS 8 0 HISDA
AKKNZ Order Category Indicator Plant Maintenance CHAR 1 0 AKKNZ
Order created online
1 Order created historically
2 Order created subsequently
3 Order from notification
4 Order from maintenance plan
5 Order from reference
6 Follow-up order
7 Generated order from IM_SM_CREATE_ORDER
8 Order for an SD service item
9 Order for an SD repair item (RMA)
PLKNZ Maintenance order planning indicator CHAR 1 0 AUF_PLKNZ
Unplanned order
1 Planned order
2 Immediate order
USER4 Estimated total costs of order CURR 11 2 AUFUSER4
SERIALNR Serial Number CHAR 18 0 GERNR
SERMAT Material Number CHAR 40 0 MARA MATNR
DEVICEID Additional Device Data CHAR 40 0 DEVICEID
SCREENTY Scenario or Subscreen Category CHAR 4 0 TQBT SCRTP
UII Unique Item Identifier CHAR 72 0 UII_CHAR72

HIKO foreign key relationships

Table Field Check Table Check Field
0 HIKO ANLZU T357M Machine operating condition MANDT
1 HIKO APGRP T024A Planner group WERKS
0 HIKO ARTPR T356A Priority type table MANDT
0 HIKO ARTPR T356A Priority type table ARTPR
1 HIKO AUART T003O Order Types AUART
0 HIKO BAUTL MARA General Material Data MANDT
0 HIKO BAUTL MARA General Material Data MATNR
1 HIKO BUKRS T001 Company Codes BUKRS
0 HIKO EQUNR EQUI Equipment master data MANDT
1 HIKO GAUEH T006 Units of Measurement MANDT
1 HIKO GAUEH T006 Units of Measurement MSEHI
0 HIKO GEWRK CRID CIM Resource - Entities MANDT
0 HIKO GEWRK CRID CIM Resource - Entities OBJID
1 HIKO GSBER TGSB Business Areas MANDT
1 HIKO GSBER TGSB Business Areas GSBER
0 HIKO ILART T353I Maintenance activity types MANDT
0 HIKO ILART T353I Maintenance activity types ILART
1 HIKO ILOAN ILOA PM Object Location and Account Assignment MANDT
1 HIKO ILOAN ILOA PM Object Location and Account Assignment ILOAN
0 HIKO INGPR T024I Maintenance planner groups INGRP
1 HIKO IWERK T001W Plants/Branches MANDT
1 HIKO IWERK T001W Plants/Branches WERKS
0 HIKO KOKRS TKA01 Controlling Areas MANDT
1 HIKO KUNUM KNA1 General Data in Customer Master MANDT
1 HIKO KUNUM KNA1 General Data in Customer Master KUNNR
0 HIKO LAUFN HIKO Order master data history AUFNR
1 HIKO LEAD_AUFNR HIKO Order master data history AUFNR
0 HIKO MANDT T000 Clients MANDT
1 HIKO MAUFNR HIKO Order master data history AUFNR
0 HIKO OBJNR ONR00 General Object Number MANDT
1 HIKO PLNTY TCA01 Task list types MANDT
0 HIKO PLVAR T778P Plan Versions MANDT
1 HIKO PRIOK T356 Priorities MANDT
1 HIKO PRIOK T356 Priorities ARTPR
0 HIKO PSPEL PRPS WBS (Work Breakdown Structure) Element Master Data MANDT
0 HIKO PSPEL PRPS WBS (Work Breakdown Structure) Element Master Data PSPNR
1 HIKO QMNUM QMEL Quality Notification MANDT
1 HIKO QMNUM QMEL Quality Notification QMNUM
0 HIKO REVNR T352R Maintenance revisions MANDT
1 HIKO SERMAT MARA General Material Data MANDT
1 HIKO SERMAT MARA General Material Data MATNR
0 HIKO VAWRK T001W Plants/Branches MANDT
0 HIKO VAWRK T001W Plants/Branches WERKS
1 HIKO WAERS TCURC Currency Codes MANDT
1 HIKO WAERS TCURC Currency Codes WAERS
0 HIKO WARPL MPLA Maintenance plan WARPL
1 HIKO WERKS T001W Plants/Branches MANDT
1 HIKO WERKS T001W Plants/Branches WERKS