SAP Table AFIH - Maintenance order header

Field Key Data Element Type Offset Leng Decimals Check Table Text
MANDT X MANDT CLNT 0 3 0 T000 Client
AUFNR X AUFNR CHAR 3 12 0 AUFK Order Number
ARTPR ARTPR CHAR 16 2 0 T356A Priority Type
PRIOK PRIOK CHAR 18 1 0 T356 Priority
EQUNR EQUNR CHAR 19 18 0 Equipment Number
BAUTL BAUTL CHAR 37 18 0 MARA Assembly
ILOAN ILOAN CHAR 55 12 0 ILOA Location and account assignment for technical object
ILOAI ILOAI CHAR 67 1 0 ILOA Individual
ANLZU ANLZU CHAR 68 1 0 T357M Syst.Condition
IWERK IWERK CHAR 69 4 0 T001W Maintenance Planning Plant
INGPR INGRP CHAR 73 3 0 T024I Planner Group for Customer Service and Plant Maintenance
APGRP VAGRP CHAR 76 3 0 T024A Responsible planner group/department
PM_OBJTY PM_OBJTY CHAR 79 2 0 Object Type of CIM Resources for Work Center
GEWRK LGWID NUMC 81 8 0 CRID Object ID of the Work Center
KUNUM KUNUM CHAR 89 10 0 KNA1 Customer Number
ANING ANING CHAR 99 12 0 Name of Person Reponsible for System
GAUZT GAUZT FLTP 112 16 16 Planned downtime in hours
GAUEH MAUEH UNIT 120 3 0 T006 Unit for Breakdown Duration
ANLBD ANLBD DATS 123 8 0 Date until which the system is available
ANLVD ANLVD DATS 131 8 0 Date from which the system is available
ANLBZ ANLBZ TIMS 139 6 0 Time until which the system is available
ANLVZ ANLVZ TIMS 145 6 0 Time from Which System is Available
INSPK INSPK CHAR 151 12 0 Name of Person Responsible for Technical Inspection
DATAN DATAN DATS 163 8 0 Date of Technical Inspection
WARPL WARPL CHAR 171 12 0 MPLA Maintenance Plan
ABNUM ABNUM INT4 184 10 0 Maintenance Plan Call Number
WAPOS WAPOS CHAR 188 16 0 Maintenance item
LAUFN LAUFN CHAR 204 12 0 AUFK Order number
OBKNR OBJKNR INT4 216 10 0 SER00 Object list number
REVNR REVNI CHAR 220 8 0 T352R Revision for Plant Maintenance and Customer Service
ADDAT ADDAT DATS 228 8 0 PM Order: Reference Date
ADUHR ADUHR TIMS 236 6 0 Time of Reference Date
IPHAS PM_PHASE CHAR 242 1 0 Maintenance Processing Phase
ILART ILA CHAR 243 3 0 T353I Maintenance activity type
QMNUM QMNUM CHAR 246 12 0 QMEL Notification No
HISDA HISDA DATS 258 8 0 PM request: History date
AKKNZ AKKNZ CHAR 266 1 0 Order Category Indicator Plant Maintenance
PLKNZ AUF_PLKNZ CHAR 267 1 0 Maintenance order planning indicator
SERIALNR GERNR CHAR 268 18 0 Serial Number
SERMAT MATNR CHAR 286 18 0 MARA Material Number
DEVICEID DEVICEID CHAR 304 40 0 Additional Device Data
SCREENTY SCRTP CHAR 344 4 0 Scenario or Subscreen Category
ADPSP ADDCOMPARE_CORE CHAR 348 40 0 Reference Element PM/PS
RSUPG RSUPG CHAR 388 1 0 Upgrade Order Indicator
/ISDFPS/OBJNR J_OBJNR CHAR 389 22 0 ONR00 Object number
/ISDFPS/MEQUI /ISDFPS/MEQUI CHAR 411 18 0 Master Equipment
UII UII_CHAR72 CHAR 429 72 0 Unique Item Identifier

1552769Mass change of order operations
998448MM_MATNR: Performance problems when reading table AFIH
996035Estimated costs after changing the fiscal year variants
799649Runtime IQ03 (history) long SELECT to VIAUFKST
484642Processing-intensive SQL statement for the VIAUF_AFVC view
774303PM_OBJTY not filled when creating maint./service orders
605760MM_MATNR: Performance problems after Note 566984
548268FAQ: Performance MM_MATNR
77791Error I0316 when archiving functional locations