1. Home
  2. Resources
  3. SAP Tables
  4. HIKO - Order master data history

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
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
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
KTEXT Description AUFTEXT CHAR 40 0
LTEXT Long Text Exists AUFLTEXT CHAR 1 0
X Yes
NULL No
LOEKZ Deletion flag AUFLOEKZ CHAR 1 0
X Yes
NULL No
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
X Yes
NULL No
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
A Work center
AA Work center alias
FH Production resources/tools
H Hierarchy
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
0 Outstanding
1 Postponed (currently not used)
2 Released
3 Technically completed
4 Manual deletion indicator set
5 Historical order
6 Completed for business (from 4.6)
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
NULL 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 AUF_PLKNZ CHAR 1 0
NULL Unplanned order
1 Planned order
2 Immediate order
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
C Contact Person
R Resource Manager
/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
NULL Not Relevant to Resource Planning
1 Contact person process
2 Resource planner process
3 Background Resource Planning Process
/MRSS/INIT_DONE Internal initialization carried out once /MRSS/T_INIT_DONE CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
/MRSS/DATACHANGE Data was changed in the controls on the user screen /MRSS/T_USCREENCTL_DATACHANGED CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
/MRSS/SALES_ORG Sales Organization VKORG CHAR 4 0
/MRSS/NW_BOOKED Network Set to "Booked" /MRSS/T_NW_BOOKED CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
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