AFIH is a standard Maintenance Orders Transparent Table in SAP PM application, which stores Maintenance order header data. On this page, you can view the Table Structure, Columns(Fields), links to SAP Documentation, Wiki & Help Pages, Q&A, similar/related TCodes, Tables, FMs, ABAP Reports, BW Datasources, and Authorization Objects for AFIH. You can use the transaction code SE16 to view the data in this table, and SE11 TCode for the table structure and definition.

AFIH — Table Structure, Fields(Columns) and Definitions

    Position Column Name Description Data Element Primary Key Data Type Length Check Table
    1 MANDT Client MANDT X CLNT 3 T000
    2 AUFNR Order AUFNR X CHAR 12 AUFK
    3 .INCLUDE 0
    4 ARTPR Priority Type ARTPR CHAR 2 T356A
    5 PRIOK Priority PRIOK CHAR 1 T356
    6 EQUNR Equipment Number EQUNR CHAR 18 EQUI
    7 BAUTL Assembly BAUTL CHAR 40 MARA
    8 ILOAN Location and account assignment for technical object ILOAN CHAR 12 ILOA
    9 ILOAI ILOA individual ILOAI CHAR 1
    10 ANLZU Updated information in related user data field ANLZU CHAR 1 T357M
    11 IWERK Maintenance Planning Plant IWERK CHAR 4 T399I
    12 INGPR Updated information in related user data field INGRP CHAR 3 T024I
    13 APGRP Reserved Field/Unused Field VAGRP CHAR 3 T024A
    14 PM_OBJTY Updated information in related user data field PM_OBJTY CHAR 2
    15 GEWRK Updated information in related user data field LGWID NUMC 8 CRID
    16 KUNUM Account Number of Customer or Debtor KUNUM CHAR 10 KNA1
    17 ANING Updated information in related user data field ANING CHAR 12
    18 GAUZT Updated information in related user data field GAUZT FLTP 16
    19 GAUEH Updated information in related user data field MAUEH UNIT 3 T006
    20 ANLBD Updated information in related user data field ANLBD DATS 8
    21 ANLVD Updated information in related user data field ANLVD DATS 8
    22 ANLBZ Updated information in related user data field ANLBZ TIMS 6
    23 ANLVZ Updated information in related user data field ANLVZ TIMS 6
    24 INSPK Name of Person Responsible for Technical Inspection INSPK CHAR 12
    25 DATAN Date of Technical Inspection DATAN DATS 8
    26 WARPL Maintenance Plan WARPL CHAR 12 MPLA
    27 ABNUM Maintenance Plan Call Number ABNUM INT4 10
    28 WAPOS Maintenance Item WAPOS CHAR 16
    29 LAUFN Updated information in related user data field LAUFN CHAR 12 AUFK
    30 OBKNR Numerical field OBJKNR INT8 19 SER00
    31 REVNR Character field REVNI CHAR 8 T352R
    32 ADDAT Accident document date ADDAT DATS 8
    33 ADUHR Updated information in related user data field ADUHR TIMS 6
    34 IPHAS Updated information in related user data field PM_PHASE CHAR 1
    35 ILART Activity Type ILA CHAR 3 T353I
    36 QMNUM Notification QMNUM CHAR 12 QMEL
    37 HISDA Updated information in related user data field HISDA DATS 8
    38 AKKNZ Updated information in related user data field AKKNZ CHAR 1
    39 PLKNZ Updated information in related user data field AUF_PLKNZ CHAR 1
    40 SERIALNR Serial Number GERNR CHAR 18
    41 SERMAT Material Number MATNR CHAR 40 MARA
    42 DEVICEID Unique ID of Synchronization Container DEVICEID CHAR 40
    43 SCREENTY Scenario or Subscreen Category SCRTP CHAR 4 TQBT
    44 ADPSP Updated information in related user data field ADDCOMPARE_CORE CHAR 40
    45 RSUPG Upgrade Order Indicator RSUPG CHAR 1
    46 CHANGEDDATETIME UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS DEC 15
    47 .INCLU--AP 0
    48 /ISDFPS/OBJNR Object number J_OBJNR CHAR 22 *
    49 /ISDFPS/MEQUI Updated information in related user data field /ISDFPS/MEQUI CHAR 18 *
    50 .INCLU--AP 0
    51 /ISDFPS/MHIO_ADDATE Completion Date for Call Object MHIO_ADDAT DATS 8
    52 /ISDFPS/MHIO_ADTIME Completion Time for Call Object MHIO_ADUHR TIMS 6
    53 /ISDFPS/USERMODE Scheduling determined by user USERMOD CHAR 1
    54 .INCLU--AP 0
    55 UII Eindeutige Teile-ID UII_CHAR72 CHAR 72
    56 .INCLU--AP 0
    57 .INCLUDE 0
    58 ORCOD PM/CS Order Code Indicating Rotable Process ADPM_ORDERCODE CHAR 1 *
    59 PRMAN CMC: Priority Manually Changed ADPM_PRMAN CHAR 1
    60 PRVAL Single-Character Flag ADPM_RTPRIO NUMC 2
    61 TWTDE CMC: Use Minimum or Standard TWT from PP Matrix ADPM_TWTFLAG CHAR 1
    62 MSTCK Single-Character Flag CHAR1 CHAR 1

SAP Help, Wiki, Q&A and other resources for AFIH

Click the above link for the full list of resources and help pages, only the first few are posted below

  • Plankostenverwaltung | SAP Help Portal

    simulierte Plankosten von Arbeitsplänen, die zu einem bestimmten Zeitpunkt kalkuliert wurden

    https://help.sap.com/docs/BI_CONTENT_757/9c73d7ba21854ef6be678402913647c3/4e07bfd10c1f47859aa5c848b2a88357.html?locale=de-DE

  • Plankostenverwaltung aus Aufträgen und Meldungen | SAP Help Portal

    Diese DataSource extrahiert Daten zur Plankostenverwaltung aus Instandhaltungsaufträgen und -meldungen.

    "Equipmentnummer (fr Auftrge aus AFIH, fr Meldungen aus QMIH)"

    https://help.sap.com/docs/BI_CONTENT_757/9c73d7ba21854ef6be678402913647c3/fb8f36c26e5f456b95f7aea840e62df3.html?locale=de-DE

  • Planned Costs Maintenance from Orders and Notifications | SAP Help Portal

    This DataSource extracts data about planned costs maintenance from maintenance orders and notifications.

    "Equipment Number (for orders from AFIH, for notifications from QMIH)"

    https://help.sap.com/docs/BI_CONTENT_707/9c73d7ba21854ef6be678402913647c3/fb8f36c26e5f456b95f7aea840e62df3.html

  • Planned Costs Maintenance | SAP Help Portal

    simulated planned costs of maintenance items within a certain period of time

    https://help.sap.com/docs/BI_CONTENT_707/9c73d7ba21854ef6be678402913647c3/4e07bfd10c1f47859aa5c848b2a88357.html

  • Data Archiving in Plant Maintenance and Customer Service (PM/CS) - SAP Help Portal

     Table of Contents Menu 

    "For orders that you have transferred from a Release lower than or equal to 4.5B, you must changed the phase fields in the table AFIH using the report ZIPHAS00."

    https://help.sap.com/viewer/b4174aff4a234ed5be928a10c60997fb/6.18.10/en-US/ccc9b65334e6b54ce10000000a174cb4.html

  • What are the most important tables in SD, MM, PP, FI , CO and QM? - SAP Q&A

    What are the most important tables in SD, MM, PP, FI , CO and QM? i.e. most used.

    https://answers.sap.com/questions/1585271/what-are-the-most-important-tables-in-sd-mm-pp-fi.html

  • Link between EQUI and VBAK table - SAP Q&A

    I need to fetch data from both EQUI and VBAK tables and display the data together. But I am not finding a convenient link. I tried using aufnr from AFIH to link VBAK and EQUI, but it didnt workout for me. Please let me know the possible combinations to link VBAK and EQUI.

    https://answers.sap.com/questions/7792807/link-between-equi-and-vbak-table.html

  • Join MPLA to AUFK and AFIH - SAP Q&A

    I would like to be able to get the user status and priority from the work order and display it along with the maintenance plan and item data.

    https://answers.sap.com/questions/782735/join-mpla-to-aufk-and-afih.html

  • Relation tables EQUZ , AFIH | SAP Community

    There will be a planned 2-hour downtime on Sunday, Sept. 11 starting at 11 am CEST; 5 am EDT. During that time, users will still be able to view content (blogs and questions) but will not be able to post new blogs or questions. Please save your work.

    "Relation tables EQUZ , AFIH | SAP Community"

    https://answers.sap.com/questions/8354413/relation-tables-equz--afih.html

  • Relation tables EQUZ , AFIH - SAP Q&A

    AFIH and AUFK are the Header adn Item Details of a PM Order (Plant Maintenance)

    https://answers.sap.com/questions/8354413/relation-tables-equz-afih.html

  • View the full list of resources, SAP Help/Wiki pages and Q&A for AFIH


Related Tables

TABLE Description Functional Area
AUFK Order master data CO - Overhead Cost Orders
AFKO Order header data PP orders PP - Production Orders
AFVC Operation within an order PP - Production Orders
ILOA PM Object Location and Account Assignment PM - Functional Locations
AFRU Order Confirmations PP - Confirmations

Transaction Codes for SAP Table AFIH

TCODE Description Functional Area
AFAB Post depreciation FI - Basic Functions
SE11 ABAP Dictionary Maintenance Basis - Dictionary Maintenance
IW32 CHANGE ORDER PM - Maintenance Orders
IW33 Display PM Order PM - Maintenance Orders
IW31 Create Order PM - Maintenance Orders
IW39 Display PM orders PM - Maintenance Orders

FMs for SAP Table AFIH

FM Description Functional Area
BAPI_ALM_ORDER_MAINTAIN Process Maintenance-/Service Order PM - Maintenance Orders
REUSE_ALV_GRID_DISPLAY Output of a simple list (single-line) Basis - SAP List Viewer
CONVERSION_EXIT_ALPHA_INPUT Conversion exit ALPHA, external->internal Basis - Syntax, Compiler, Runtime
STATUS_TEXT_EDIT The 4 Character Status is Edited within One Line (40 Character) Cross Application - General status management
REUSE_ALV_FIELDCATALOG_MERGE Create field catalog from dictionary structure or internal table BC - SAP List Viewer
READ_TEXT SAPscript: Read text BC - SAPscript

ABAP Reports for SAP Table AFIH

ABAP REPORT Description Functional Area
RKO7KO8G Actual settlement: Internal Orders CO - Overhead Cost Orders
SAPLIQS0 Include SAPLIQS0
RSAP0001 Program for object type SAP0001 : BapiService Basis - BW Service API
BUILD_FIELDCAT Include ZHPM_STOCK_CHECK
RIAUFK20 Display and Change Service and Maintenance Orders PM - Maintenance Orders
RIORDST1 Repair: Status for PM/CS Orders PM - Maintenance Orders

BW Datasources for SAP Table AFIH

BW DATASOURCE Description Functional Area
2LIS_17_I3HDR Plant maintenance orders PM - Plant Maintenance
2LIS_17_I3OPER Plant Maintenance Order Process PM - Plant Maintenance
2LIS_18_I3OPER Service order operation -
2LIS_18_I3HDR Service Orders -
0PM_ORDER_ATTR Plant Maintenance Order Attribute PM - Plant Maintenance
2LIS_02_ITM Purchasing Data (Item Level) MM - Materials Management

Authorization Objects for SAP Table AFIH

AUTHORIZATION OBJECT Description Functional Area
K_KEKO CO-PC: Product Costing
ECM_VAL Change Management: Validity
J_1IEWT_HC health check for Migration to EWT
B_USERST_T Status Management: Set/Delete User Status using Transaction
I_IWERK PM: Maintenance Planning Plant
CMS_RBL Authorization object for receivable in CMS

Most searched SAP Plant Maintenance Tables