Follow us on LinkedIn for your next SAP project
← Back to Search

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 Possible values
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
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
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
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
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
/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 AFIH ANLZU T357M
Machine operating condition
 ANLZU
AFIH ANLZU SYST MANDT T357M
Machine operating condition
 MANDT
AFIH APGRP AFIH IWERK T024A
Planner group
 WERKS
AFIH APGRP AFIH APGRP T024A
Planner group
 FEVOR
AFIH APGRP AFIH MANDT T024A
Planner group
 MANDT
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 GEWRK CRID
CIM Resource - Entities
 OBJID
AFIH GEWRK AFIH MANDT CRID
CIM Resource - Entities
 MANDT
AFIH GEWRK AFIH PM_OBJTY CRID
CIM Resource - Entities
 OBJTY
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 MANDT KNA1
General Data in Customer Master
 MANDT
AFIH KUNUM AFIH KUNUM KNA1
General Data in Customer Master
 KUNNR
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 AFIH OBKNR SER00
General Header Table for Serial Number Management
 OBKNR
AFIH OBKNR SYST MANDT SER00
General Header Table for Serial Number Management
 MANDT
AFIH PRIOK AFIH ARTPR T356
Priorities
 ARTPR
AFIH PRIOK AFIH PRIOK T356
Priorities
 PRIOK
AFIH PRIOK AFIH MANDT T356
Priorities
 MANDT
AFIH QMNUM AFIH MANDT QMEL
Quality Notification
 MANDT
AFIH QMNUM AFIH QMNUM QMEL
Quality Notification
 QMNUM
AFIH REVNR AFIH MANDT T352R
Maintenance revisions
 MANDT
AFIH REVNR AFIH IWERK T352R
Maintenance revisions
 IWERK
AFIH REVNR AFIH REVNR T352R
Maintenance revisions
 REVNR
AFIH SCREENTY AFIH SCREENTY TQBT
Screen type table for subscreen
 SCREENTY
AFIH SERMAT AFIH SERMAT MARA
General Material Data
 MATNR
AFIH SERMAT AFIH MANDT MARA
General Material Data
 MANDT
AFIH WARPL AFIH MANDT MPLA
Maintenance plan
 MANDT
AFIH WARPL AFIH WARPL MPLA
Maintenance plan
 WARPL