SAP table HIVG (PM order history - operations)

SAP table HIVG has 4 primary key fields being MANDT,AUFNR,VORNR,UVORN.

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 HIKO AUFNR_H
VORNR Operation/Activity Number CHAR 4 0 VORNR
UVORN Suboperation CHAR 4 0 UVORN
AUFPL Routing number of operations in the order NUMC 10 0 CO_AUFPL
APLZL General counter for order NUMC 8 0 AFVC CO_APLZL
PLNTY Task List Type CHAR 1 0 TCA01 PLNTY
PLNNR Key for Task List Group CHAR 8 0 PLNNR
PLNKN Number of the Task List Node NUMC 8 0 PLNKN
ZAEHL Internal counter NUMC 8 0 CIM_COUNT
STEUS Control key CHAR 4 0 T430 STEUS
ARBPL Work Center CHAR 8 0 ARBPL
ARBID Object ID NUMC 8 0 OBJEKTID
WERKS Plant CHAR 4 0 T001W WERKS_D
KTSCH Standard Text Key CHAR 7 0 T435 KTSCH
LTXA1 Operation Short Text CHAR 40 0 LTXA1
TXTSP Language Key LANG 1 0 T002 SPRAS
ANLZU System Condition CHAR 1 0 T357M ANLZU
ISTRU Assembly CHAR 40 0 MARA ISTRU
OBJNR Object number CHAR 22 0 ONR00 J_OBJNR
ARBEI Work involved in the activity QUAN 7 1 ARBEIT
ARBEH Unit for work UNIT 3 0 T006 ARBEITE
ANZZL Number of capacities required INT1 3 0 ANZKAP
ISMNW Actual work QUAN 13 3 CO_ISMNW
ISMNE Unit for work UNIT 3 0 T006 ARBEITE
ISDD Actual Execution Start Date DATS 8 0 ISDD
ISDZ Actual Execution Start Time TIMS 6 0 ISDZ
IEDD Actual Execution End Date DATS 8 0 IEDD
IEDZ Actual Execution End Time TIMS 6 0 IEDZ
LOGRP Wage Group CHAR 3 0 T421 LOHNGRP
LOART Wage type CHAR 4 0 LOHNART
LOANZ Number of Time Tickets DEC 3 0 LOHNANZ
QUALF Suitability CHAR 2 0 T423 QUALF
RUECK Completion confirmation number for the operation NUMC 10 0 CO_RUECK
RMZHL Internal counter NUMC 8 0 CIM_COUNT
MGVRG Operation Total Quantity QUAN 13 3 MGVRG
MEINH Unit of measure for activity UNIT 3 0 T006 VORME
PREIS Price CURR 11 2 PREIS
PEINH Price unit DEC 5 0 PEINH
WAERS Currency Key CUKY 5 0 TCURC WAERS
PLIFZ Planned Delivery Time in Days DEC 3 0 PLIFZ
SAKTO Cost Element CHAR 10 0 CSKA KSTAR
MATKL Material Group CHAR 9 0 T023 MATKL
EKORG Purchasing organization CHAR 4 0 T024E EKORG
EKGRP Purchasing Group for External Processing Activity CHAR 3 0 T024 VG_EKGRP
ESOKZ Purchasing info record category CHAR 1 0 ESOKZ
0 Standard
1 Chargeable
2 Consignment
3 Subcontracting
P Pipeline
INFNR Number of purchasing info record CHAR 10 0 EINA INFNR
LIFNR Account Number of Supplier CHAR 10 0 LFA1 LIFNR
SORTL Sort Term for Non-Stock Info Records CHAR 10 0 SORTI
PERNR Personnel number NUMC 8 0 CO_PERNR
OTYPE Object Type CHAR 2 0 T778O OTYPE
OBJEKTID Object ID NUMC 8 0 OBJEKTID
SLWID Key word ID for user-defined fields CHAR 7 0 TCN00 SLWID
USR00 User field with 20 characters CHAR 20 0 USRCHAR20
USR01 User field with 20 characters CHAR 20 0 USRCHAR20
USR02 User Field with 10 Characters CHAR 10 0 USRCHAR10
USR03 User Field with 10 Characters CHAR 10 0 USRCHAR10
USR04 User field for quantity (length 10.3) QUAN 13 3 USRQUAN13
USE04 User field: Unit for quantity fields UNIT 3 0 T006 USRUNIT
USR05 User field for quantity (length 10.3) QUAN 13 3 USRQUAN13
USE05 User field: Unit for quantity fields UNIT 3 0 T006 USRUNIT
USR06 User-defined field for values (length 10,3) CURR 13 3 USRCURR13
USE06 User field: Unit for value fields CUKY 5 0 TCURC USRCUKY
USR07 User-defined field for values (length 10,3) CURR 13 3 USRCURR13
USE07 User field: Unit for value fields CUKY 5 0 TCURC USRCUKY
USR08 User field for date DATS 8 0 USRDATE
USR09 User field for date DATS 8 0 USRDATE
USR10 User-defined field: Indicator for reports CHAR 1 0 USRFLAG
USR11 User-defined field: Indicator for reports CHAR 1 0 USRFLAG
AUFKT Execution Factor DEC 3 0 AFAKT
TPLNR Functional Location CHAR 30 0 TPLNR
EQUNR Equipment Number CHAR 18 0 EQUNR
CL_TYPE Checklists: Checklist type at operation CHAR 8 0 EAM_CL_TYPE

HIVG foreign key relationships

Table Field Check Table Check Field
0 HIVG ANLZU T357M Machine operating condition MANDT
1 HIVG APLZL AFVC Operation within an order AUFPL
1 HIVG APLZL AFVC Operation within an order APLZL
0 HIVG ARBEH T006 Units of Measurement MANDT
1 HIVG AUFNR HIKO Order master data history AUFNR
0 HIVG EKGRP T024 Purchasing Groups EKGRP
1 HIVG EKORG T024E Purchasing Organizations EKORG
0 HIVG INFNR EINA Purchasing Info Record: General Data INFNR
1 HIVG ISMNE T006 Units of Measurement MSEHI
0 HIVG ISTRU MARA General Material Data MANDT
0 HIVG ISTRU MARA General Material Data MATNR
1 HIVG KTSCH T435 Standard texts for routing/ref. op set items MANDT
0 HIVG LIFNR LFA1 Supplier Master (General Section) MANDT
0 HIVG LIFNR LFA1 Supplier Master (General Section) LIFNR
1 HIVG LOGRP T421 Wage groups MANDT
0 HIVG MANDT T000 Clients MANDT
1 HIVG MATKL T023 Material Groups MATKL
0 HIVG MEINH T006 Units of Measurement MANDT
0 HIVG MEINH T006 Units of Measurement MSEHI
1 HIVG OBJNR ONR00 General Object Number MANDT
0 HIVG OTYPE T778O Object Types MANDT
0 HIVG OTYPE T778O Object Types OTYPE
1 HIVG PLNTY TCA01 Task list types MANDT
0 HIVG QUALF T423 Wage group qualification MANDT
0 HIVG QUALF T423 Wage group qualification QUALF
1 HIVG SAKTO CSKA Cost Elements (Data Dependent on Chart of Accounts) MANDT
1 HIVG SAKTO CSKA Cost Elements (Data Dependent on Chart of Accounts) KTOPL
0 HIVG SLWID TCN00 Key Word ID for PS User Fields MANDT
1 HIVG STEUS T430 Operation/Activity control key MANDT
1 HIVG STEUS T430 Operation/Activity control key PLNAW
1 HIVG STEUS T430 Operation/Activity control key STEUS
0 HIVG TXTSP T002 Language Keys (Component BC-I18) SPRAS
1 HIVG USE04 T006 Units of Measurement MANDT
0 HIVG USE05 T006 Units of Measurement MANDT
1 HIVG USE06 TCURC Currency Codes MANDT
1 HIVG USE06 TCURC Currency Codes WAERS
0 HIVG USE07 TCURC Currency Codes MANDT
0 HIVG USE07 TCURC Currency Codes WAERS
1 HIVG WAERS TCURC Currency Codes MANDT
1 HIVG WAERS TCURC Currency Codes WAERS
0 HIVG WERKS T001W Plants/Branches MANDT
0 HIVG WERKS T001W Plants/Branches WERKS