SAP AFIH Maintenance order header Table
Overview
AFIH is a standard SAP S/4HANA table that stores Maintenance order header data. There are total 65 fields in the AFIH table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table AFIH belongs to Maintenance Orders (PM-WOC-MO) module and is located in the package Appl. Development R/3 Plant Maintenance Order Processing (IWO1).
In addition, following links provide an overview of foreign key relationships, if any, that link AFIH to other SAP tables and standard CDS views available based on AFIH table in S/4HANA 2020.
Techincal Settings of AFIH
Below are technical details of the table AFIH
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of AFIH Fields
The following table gives you an overview of the fields available in AFIH
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| AUFNR | Order Number | AUFNR | AUFK | CHAR | 12 |
| ARTPR | Priority Type | ARTPR | T356A | CHAR | 2 |
| PRIOK | Priority | PRIOK | T356 | CHAR | 1 |
| EQUNR | Equipment Number | EQUNR | EQUI | CHAR | 18 |
| BAUTL | Assembly | BAUTL | MARA | CHAR | 40 |
| ILOAN | Location and account assignment for technical object | ILOAN | ILOA | CHAR | 12 |
| ILOAI | ILOA Individual | ILOAI | CHAR | 1 | |
| ANLZU | System Condition | ANLZU | T357M | CHAR | 1 |
| IWERK | Maintenance Planning Plant | IWERK | T399I | CHAR | 4 |
| INGPR | Planner Group for Customer Service and Plant Maintenance | INGRP | T024I | CHAR | 3 |
| APGRP | Responsible Planner Group or Department | VAGRP | T024A | CHAR | 3 |
| PM_OBJTY | Object Type of CIM Resources for Work Center | PM_OBJTY | CHAR | 2 | |
| GEWRK | Object ID of the Work Center | LGWID | CRID | NUMC | 8 |
| KUNUM | Customer Number | KUNUM | KNA1 | CHAR | 10 |
| ANING | Name of Person Reponsible for System | ANING | CHAR | 12 | |
| GAUZT | Planned downtime in hours | GAUZT | FLTP | 16 | |
| GAUEH | Unit for Breakdown Duration | MAUEH | T006 | UNIT | 3 |
| ANLBD | Date until which the system is available | ANLBD | DATS | 8 | |
| ANLVD | Date from which the system is available | ANLVD | DATS | 8 | |
| ANLBZ | Time until which the system is available | ANLBZ | TIMS | 6 | |
| ANLVZ | Time from Which System is Available | ANLVZ | TIMS | 6 | |
| INSPK | Name of Person Responsible for Technical Inspection | INSPK | CHAR | 12 | |
| DATAN | Date of Technical Inspection | DATAN | DATS | 8 | |
| WARPL | Maintenance Plan | WARPL | MPLA | CHAR | 12 |
| ABNUM | Maintenance Plan Call Number | ABNUM | INT4 | 10 | |
| WAPOS | Maintenance item | WAPOS | CHAR | 16 | |
| LAUFN | Order number | LAUFN | AUFK | CHAR | 12 |
| OBKNR | Object list number | OBJKNR | SER00 | INT8 | 19 |
| REVNR | Revision for Plant Maintenance and Customer Service | REVNI | T352R | CHAR | 8 |
| ADDAT | PM Order: Reference Date | ADDAT | DATS | 8 | |
| ADUHR | Time of Reference Date | ADUHR | TIMS | 6 | |
| IPHAS | Maintenance Processing Phase | PM_PHASE | CHAR | 1 | |
| ILART | Maintenance activity type | ILA | T353I | CHAR | 3 |
| QMNUM | Notification Number | QMNUM | QMEL | CHAR | 12 |
| HISDA | PM request: History date | HISDA | DATS | 8 | |
| AKKNZ | Order Category Indicator Plant Maintenance | AKKNZ | CHAR | 1 | |
| PLKNZ | Maintenance order planning indicator | AUF_PLKNZ | CHAR | 1 | |
| SERIALNR | Serial Number | GERNR | CHAR | 18 | |
| SERMAT | Material Number | MATNR | MARA | CHAR | 40 |
| DEVICEID | Additional Device Data | DEVICEID | CHAR | 40 | |
| SCREENTY | Scenario or Subscreen Category | SCRTP | TQBT | CHAR | 4 |
| ADPSP | Reference Element PM/PS | ADDCOMPARE_CORE | CHAR | 40 | |
| RSUPG | Upgrade Order Indicator | RSUPG | CHAR | 1 | |
| CHANGEDDATETIME | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TZNTSTMPS | DEC | 15 | |
| MAINTORDPERSONRESPONSIBLE | Person Responsible ID | EAMS_PERSON_RESPONSIBLE | CHAR | 12 | |
| MAINTORDOVRLPROCPHASE | Overall Process Phase | EAM_OSTAT_PHASE | CHAR | 2 | |
| MAINTORDOVRLPROCSUBPHASE | Overall Process Subphase | EAM_OSTAT_SPHASE | * | CHAR | 4 |
| /ISDFPS/OBJNR | Object number | J_OBJNR | * | CHAR | 22 |
| /ISDFPS/MEQUI | Master Equipment | /ISDFPS/MEQUI | * | CHAR | 18 |
| /ISDFPS/MHIO_ADDATE | Completion Date for Call Object | MHIO_ADDAT | DATS | 8 | |
| /ISDFPS/MHIO_ADTIME | Completion Time for Call Object | MHIO_ADUHR | TIMS | 6 | |
| /ISDFPS/USERMODE | Scheduling determined by user | USERMOD | CHAR | 1 | |
| UII | Unique Item Identifier | UII_CHAR72 | CHAR | 72 | |
| DATAMODELVERSION | Data Migration State of Maintenance Order | EAM_SDM_VERSION_AFIH | CHAR | 2 | |
| SERVICE_DOC_TYPE | Business Transaction Type | CRMT_PROCESS_TYPE | CHAR | 4 | |
| SERVICE_DOC_ID | Transaction ID | CRMT_OBJECT_ID_DB | CHAR | 10 | |
| SERVICE_DOC_ITEM_ID | Shortened Item Number in Document | CRMS4_NUMBER_INT | NUMC | 6 | |
| IS_BILLABLE | Logical Variable | CRMT_BOOLEAN | CHAR | 1 | |
| FLDLOGSDELIVISHELDONSHORE | Hold On-Shore | FLOG_HOLD | CHAR | 1 | |
| ORCOD | PM/CS Order Code Indicating Rotable Process | ADPM_ORDERCODE | * | CHAR | 1 |
| PRMAN | CMC: Priority Manually Changed | ADPM_PRMAN | CHAR | 1 | |
| PRVAL | Priority for PM/CS Orders | ADPM_RTPRIO | NUMC | 2 | |
| TWTDE | CMC: Use Minimum or Standard TWT from PP Matrix | ADPM_TWTFLAG | CHAR | 1 | |
| MSTCK | Single-Character Flag | CHAR1 | CHAR | 1 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for AFIH
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| AFIH | ANLZU | C: CN | T357M |
| AFIH | APGRP | C: CN | T024A |
| AFIH | ARTPR | C: CN | T356A |
| AFIH | AUFNR | 1: CN | AUFK |
| AFIH | BAUTL | C: CN | MARA |
| AFIH | EQUNR | C: CN | EQUI |
| AFIH | GAUEH | C: CN | T006 |
| AFIH | GEWRK | C: CN | CRID |
| AFIH | ILART | C: CN | T353I |
| AFIH | ILOAN | C: CN | ILOA |
| AFIH | INGPR | C: CN | T024I |
| AFIH | IWERK | C: CN | T399I |
| AFIH | KUNUM | C: CN | KNA1 |
| AFIH | LAUFN | C: CN | AUFK |
| AFIH | MANDT | 1: CN | T000 |
| AFIH | OBKNR | : | SER00 |
| AFIH | PRIOK | C: CN | T356 |
| AFIH | QMNUM | C: CN | QMEL |
| AFIH | REVNR | C: CN | T352R |
| AFIH | SCREENTY | : | TQBT |
| AFIH | SERMAT | : | MARA |
| AFIH | WARPL | C: CN | MPLA |