1. Home
  2. Resources
  3. SAP Tables
  4. AFIH - Maintenance order header

SAP Table AFIH

Maintenance order header

AFIH (Maintenance order header) 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 AFIH to other SAP tables.

AFIH table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
AUFNR Order Number AUFNR AUFK CHAR 12 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 T399I 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 LAUFN AUFK CHAR 12 0
OBKNR Object list number OBJKNR SER00 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
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
ADPSP Reference Element PM/PS ADDCOMPARE_CORE CHAR 40 0
RSUPG Upgrade Order Indicator RSUPG CHAR 1 0
NULL No
X Yes
/ISDFPS/OBJNR Object number J_OBJNR CHAR 22 0
/ISDFPS/MEQUI Master Equipment /ISDFPS/MEQUI CHAR 18 0
UII Unique Item Identifier UII_CHAR72 CHAR 72 0

AFIH foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
AFIH ANLZU SYST MANDT T357M Machine operating condition MANDT
AFIH ANLZU AFIH ANLZU T357M Machine operating condition ANLZU
AFIH APGRP AFIH APGRP T024A Planner group FEVOR
AFIH APGRP AFIH MANDT T024A Planner group MANDT
AFIH APGRP AFIH IWERK T024A Planner group WERKS
AFIH ARTPR AFIH MANDT T356A Priority type table MANDT
AFIH ARTPR AFIH ARTPR T356A Priority type table ARTPR
AFIH AUFNR AFIH MANDT AUFK Order master data MANDT
AFIH AUFNR AFIH AUFNR AUFK Order master data AUFNR
AFIH BAUTL AFIH MANDT MARA General Material Data MANDT
AFIH BAUTL AFIH BAUTL MARA General Material Data MATNR
AFIH EQUNR AFIH MANDT EQUI Equipment master data MANDT
AFIH EQUNR AFIH EQUNR EQUI Equipment master data EQUNR
AFIH GAUEH AFIH MANDT T006 Units of Measurement MANDT
AFIH GAUEH AFIH GAUEH T006 Units of Measurement MSEHI
AFIH GEWRK AFIH MANDT CRID CIM Resource - Entities MANDT
AFIH GEWRK AFIH PM_OBJTY CRID CIM Resource - Entities OBJTY
AFIH GEWRK AFIH GEWRK CRID CIM Resource - Entities OBJID
AFIH ILART AFIH MANDT T353I Maintenance activity types MANDT
AFIH ILART AFIH ILART T353I Maintenance activity types ILART
AFIH ILOAN AFIH MANDT ILOA PM Object Location and Account Assignment MANDT
AFIH ILOAN AFIH ILOAN ILOA PM Object Location and Account Assignment ILOAN
AFIH INGPR AFIH MANDT T024I Maintenance planner groups MANDT
AFIH INGPR AFIH IWERK T024I Maintenance planner groups IWERK
AFIH INGPR AFIH INGPR T024I Maintenance planner groups INGRP
AFIH IWERK AFIH MANDT T399I Planning plant parameters MANDT
AFIH IWERK AFIH IWERK T399I Planning plant parameters IWERK
AFIH KUNUM AFIH KUNUM KNA1 General Data in Customer Master KUNNR
AFIH KUNUM AFIH MANDT KNA1 General Data in Customer Master MANDT
AFIH LAUFN AFIH MANDT AUFK Order master data MANDT
AFIH LAUFN AFIH LAUFN AUFK Order master data AUFNR
AFIH MANDT AFIH MANDT T000 Clients MANDT
AFIH OBKNR SYST MANDT SER00 General Header Table for Serial Number Management MANDT
AFIH OBKNR AFIH OBKNR SER00 General Header Table for Serial Number Management OBKNR
AFIH PRIOK AFIH PRIOK T356 Priorities PRIOK
AFIH PRIOK AFIH MANDT T356 Priorities MANDT
AFIH PRIOK AFIH ARTPR T356 Priorities ARTPR
AFIH QMNUM AFIH MANDT QMEL Quality Notification MANDT
AFIH QMNUM AFIH QMNUM QMEL Quality Notification QMNUM
AFIH REVNR AFIH REVNR T352R Maintenance revisions REVNR
AFIH REVNR AFIH MANDT T352R Maintenance revisions MANDT
AFIH REVNR AFIH IWERK T352R Maintenance revisions IWERK
AFIH SCREENTY AFIH SCREENTY TQBT Screen type table for subscreen SCREENTY
AFIH SERMAT AFIH MANDT MARA General Material Data MANDT
AFIH SERMAT AFIH SERMAT MARA General Material Data MATNR
AFIH WARPL AFIH WARPL MPLA Maintenance plan WARPL
AFIH WARPL AFIH MANDT MPLA Maintenance plan MANDT