SAP table AFIH (Maintenance order header)

SAP table AFIH 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 CHAR 12 0 AUFK AUFNR
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 T399I 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 CHAR 12 0 AUFK LAUFN
OBKNR Object list number INT8 19 0 SER00 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
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
ADPSP Reference Element PM/PS CHAR 40 0 ADDCOMPARE_CORE
RSUPG Upgrade Order Indicator CHAR 1 0 RSUPG
CHANGEDDATETIME UTC Time Stamp in Short Form (YYYYMMDDhhmmss) DEC 15 0 TZNTSTMPS
MAINTORDPERSONRESPONSIBLE Person Responsible ID CHAR 12 0 EAMS_PERSON_RESPONSIBLE
MAINTORDOVRLPROCPHASE Process Phase CHAR 2 0 EAM_OSTAT_PHASE
01 Initiation
02 Screening
03 Planning
04 Approval
05 Preparation
06 Scheduling
07 Execution
08 Post Execution
09 Completion
MAINTORDOVRLPROCSUBPHASE Process Subphase CHAR 4 0 * EAM_OSTAT_SPHASE
DUMMY_AFIH_INCL_EEW_PS Custom Fields: Dummy for Use in Extension Includes CHAR 1 0 CFD_DUMMY
/ISDFPS/OBJNR Object number CHAR 22 0 * J_OBJNR
/ISDFPS/MEQUI Master Equipment CHAR 18 0 * /ISDFPS/MEQUI
/ISDFPS/MHIO_ADDATE Completion Date for Call Object DATS 8 0 MHIO_ADDAT
/ISDFPS/MHIO_ADTIME Completion Time for Call Object TIMS 6 0 MHIO_ADUHR
/ISDFPS/USERMODE Scheduling determined by user CHAR 1 0 USERMOD
UII Unique Item Identifier CHAR 72 0 UII_CHAR72
DATAMODELVERSION Data Migration State of Maintenance Order CHAR 2 0 EAM_SDM_VERSION_AFIH
00 No migrations have been performed
01 Migration of Person Responsible
SERVICE_DOC_TYPE Business Transaction Type CHAR 4 0 CRMT_PROCESS_TYPE
SERVICE_DOC_ID Transaction ID CHAR 10 0 CRMT_OBJECT_ID_DB
SERVICE_DOC_ITEM_ID Shortened Item Number in Document NUMC 6 0 CRMS4_NUMBER_INT
IS_BILLABLE Logical Variable CHAR 1 0 CRMT_BOOLEAN
FLDLOGSDELIVISHELDONSHORE Hold On-Shore CHAR 1 0 FLOG_HOLD
MAINTORDPROCMTINTEGSCENARIO Procurement Mode for Maintenance Order CHAR 1 0 MAINTORDPROCMTINTEGSCENARIO
ORCOD PM/CS Order Code Indicating Rotable Process CHAR 1 0 * ADPM_ORDERCODE
PRMAN CMC: Priority Manually Changed CHAR 1 0 ADPM_PRMAN
PRVAL Priority for PM/CS Orders NUMC 2 0 ADPM_RTPRIO
TWTDE CMC: Use Minimum or Standard TWT from PP Matrix CHAR 1 0 ADPM_TWTFLAG
MSTCK Single-Character Flag CHAR 1 0 CHAR1
LACD_DATE Final Due Date DATS 8 0 LACD_DATE
OLD_LACD_DATE Previous Final Due Date DATS 8 0 LACD_OLD

AFIH foreign key relationships

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