SAP Table AFIHF
PM Order: Fields AFIH w/o Key
AFIHF (PM Order: Fields AFIH w/o Key) 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 AFIHF to other SAP tables.
AFIHF table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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 | ||||||||||||||||||||||||
AFIHF foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| AFIHF | ANLZU | SYST | MANDT |
T357M
Machine operating condition
|
MANDT |
| AFIHF | ANLZU | AFIHF | ANLZU |
T357M
Machine operating condition
|
ANLZU |
| AFIHF | APGRP | SYST | MANDT |
T024A
Planner group
|
MANDT |
| AFIHF | APGRP | AFIHF | IWERK |
T024A
Planner group
|
WERKS |
| AFIHF | APGRP | AFIHF | APGRP |
T024A
Planner group
|
FEVOR |
| AFIHF | ARTPR | AFIHF | ARTPR |
T356A
Priority type table
|
ARTPR |
| AFIHF | ARTPR | SYST | MANDT |
T356A
Priority type table
|
MANDT |
| AFIHF | BAUTL | SYST | MANDT |
MARA
General Material Data
|
MANDT |
| AFIHF | BAUTL | AFIHF | BAUTL |
MARA
General Material Data
|
MATNR |
| AFIHF | EQUNR | AFIHF | EQUNR |
EQUI
Equipment master data
|
EQUNR |
| AFIHF | EQUNR | SYST | MANDT |
EQUI
Equipment master data
|
MANDT |
| AFIHF | GAUEH | AFIHF | GAUEH |
T006
Units of Measurement
|
MSEHI |
| AFIHF | GAUEH | SYST | MANT |
T006
Units of Measurement
|
MANDT |
| AFIHF | GEWRK | SYST | MANDT |
CRID
CIM Resource - Entities
|
MANDT |
| AFIHF | GEWRK | AFIHF | PM_OBJTY |
CRID
CIM Resource - Entities
|
OBJTY |
| AFIHF | GEWRK | AFIHF | GEWRK |
CRID
CIM Resource - Entities
|
OBJID |
| AFIHF | ILART | SYST | MANDT |
T353I
Maintenance activity types
|
MANDT |
| AFIHF | ILART | AFIHF | ILART |
T353I
Maintenance activity types
|
ILART |
| AFIHF | ILOAN | SYST | MANDT |
ILOA
PM Object Location and Account Assignment
|
MANDT |
| AFIHF | ILOAN | AFIHF | ILOAN |
ILOA
PM Object Location and Account Assignment
|
ILOAN |
| AFIHF | INGPR | AFIHF | IWERK |
T024I
Maintenance planner groups
|
IWERK |
| AFIHF | INGPR | AFIHF | INGPR |
T024I
Maintenance planner groups
|
INGRP |
| AFIHF | INGPR | SYST | MANDT |
T024I
Maintenance planner groups
|
MANDT |
| AFIHF | IWERK | AFHI | MANDT |
T399I
Planning plant parameters
|
MANDT |
| AFIHF | IWERK | AFIHF | IWERK |
T399I
Planning plant parameters
|
IWERK |
| AFIHF | KUNUM | SYST | MANDT |
KNA1
General Data in Customer Master
|
MANDT |
| AFIHF | KUNUM | AFIHF | KUNUM |
KNA1
General Data in Customer Master
|
KUNNR |
| AFIHF | LAUFN | SYST | MANDT |
AUFK
Order master data
|
MANDT |
| AFIHF | LAUFN | AFIHF | LAUFN |
AUFK
Order master data
|
AUFNR |
| AFIHF | OBKNR | SYST | MANDT |
SER00
General Header Table for Serial Number Management
|
MANDT |
| AFIHF | OBKNR | AFIHF | OBKNR |
SER00
General Header Table for Serial Number Management
|
OBKNR |
| AFIHF | PRIOK | SYST | MANDT |
T356
Priorities
|
MANDT |
| AFIHF | PRIOK | AFIHF | ARTPR |
T356
Priorities
|
ARTPR |
| AFIHF | PRIOK | AFIHF | PRIOK |
T356
Priorities
|
PRIOK |
| AFIHF | QMNUM | SYST | MANDT |
QMEL
Quality Notification
|
MANDT |
| AFIHF | QMNUM | AFIHF | QMNUM |
QMEL
Quality Notification
|
QMNUM |
| AFIHF | REVNR | SYST | MANDT |
T352R
Maintenance revisions
|
MANDT |
| AFIHF | REVNR | AFIHF | IWERK |
T352R
Maintenance revisions
|
IWERK |
| AFIHF | REVNR | AFIHF | REVNR |
T352R
Maintenance revisions
|
REVNR |
| AFIHF | SCREENTY | AFIHF | SCREENTY |
TQBT
Screen type table for subscreen
|
SCREENTY |
| AFIHF | SERMAT | AFIH | MANDT |
MARA
General Material Data
|
MANDT |
| AFIHF | SERMAT | AFIHF | SERMAT |
MARA
General Material Data
|
MATNR |
| AFIHF | WARPL | AFIHF | WARPL |
MPLA
Maintenance plan
|
WARPL |
| AFIHF | WARPL | SYST | MANDT |
MPLA
Maintenance plan
|
MANDT |