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
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
X Yes
NULL No
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
A Work center
AA Work center alias
FH Production resources/tools
H Hierarchy
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
0 Outstanding
1 Postponed (currently not used)
2 Released
3 Technically completed
4 Manual deletion indicator set
5 Historical order
6 Completed for business (from 4.6)
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
NULL 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 AUF_PLKNZ CHAR 1 0
NULL Unplanned order
1 Planned order
2 Immediate order
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
NULL No
X Yes
/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 SYST MANDT T356A Priority type table MANDT
AFIHF ARTPR AFIHF ARTPR T356A Priority type table ARTPR
AFIHF BAUTL SYST MANDT MARA General Material Data MANDT
AFIHF BAUTL AFIHF BAUTL MARA General Material Data MATNR
AFIHF EQUNR SYST MANDT EQUI Equipment master data MANDT
AFIHF EQUNR AFIHF EQUNR EQUI Equipment master data EQUNR
AFIHF GAUEH SYST MANT T006 Units of Measurement MANDT
AFIHF GAUEH AFIHF GAUEH T006 Units of Measurement MSEHI
AFIHF GEWRK AFIHF GEWRK CRID CIM Resource - Entities OBJID
AFIHF GEWRK SYST MANDT CRID CIM Resource - Entities MANDT
AFIHF GEWRK AFIHF PM_OBJTY CRID CIM Resource - Entities OBJTY
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 SYST MANDT T024I Maintenance planner groups MANDT
AFIHF INGPR AFIHF IWERK T024I Maintenance planner groups IWERK
AFIHF INGPR AFIHF INGPR T024I Maintenance planner groups INGRP
AFIHF IWERK AFIHF IWERK T399I Planning plant parameters IWERK
AFIHF IWERK AFHI MANDT T399I Planning plant parameters MANDT
AFIHF KUNUM AFIHF KUNUM KNA1 General Data in Customer Master KUNNR
AFIHF KUNUM SYST MANDT KNA1 General Data in Customer Master MANDT
AFIHF LAUFN SYST MANDT AUFK Order master data MANDT
AFIHF LAUFN AFIHF LAUFN AUFK Order master data AUFNR
AFIHF OBKNR AFIHF OBKNR SER00 General Header Table for Serial Number Management OBKNR
AFIHF OBKNR SYST MANDT SER00 General Header Table for Serial Number Management MANDT
AFIHF PRIOK AFIHF PRIOK T356 Priorities PRIOK
AFIHF PRIOK SYST MANDT T356 Priorities MANDT
AFIHF PRIOK AFIHF ARTPR T356 Priorities ARTPR
AFIHF QMNUM SYST MANDT QMEL Quality Notification MANDT
AFIHF QMNUM AFIHF QMNUM QMEL Quality Notification QMNUM
AFIHF REVNR AFIHF REVNR T352R Maintenance revisions REVNR
AFIHF REVNR SYST MANDT T352R Maintenance revisions MANDT
AFIHF REVNR AFIHF IWERK T352R Maintenance revisions IWERK
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 SYST MANDT MPLA Maintenance plan MANDT
AFIHF WARPL AFIHF WARPL MPLA Maintenance plan WARPL