SAP ABAP Table AFIH (Maintenance order header)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷
CRM (Application Component) Customer Relationship Management
⤷
CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷
IWO1 (Package) Appl. Development R/3 Plant Maintenance Order Processing
⤷
⤷
⤷
Basic Data
| Table Category | TRANSP | Transparent table |
| Transparent table | AFIH |
|
| Short Description | Maintenance order header |
Delivery and Maintenance
| Pool/cluster | ||
| Delivery Class | A | Application Table (Master- and Transaction Data) |
| Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
| |
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|---|---|---|---|---|---|---|---|---|---|
| 1 | |
MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
| 2 | |
AUFNR | AUFNR | CHAR | 12 | 0 | Order Number | AUFK | |
| 3 | |
0 | 0 | PM Order: Fields AFIH w/o Key | |||||
| 4 | |
ARTPR | ARTPR | CHAR | 2 | 0 | Priority Type | T356A | |
| 5 | |
PRIOK | PRIOK | CHAR | 1 | 0 | Priority | T356 | |
| 6 | |
EQUNR | EQUNR | CHAR | 18 | 0 | Equipment Number | EQUI | |
| 7 | |
BAUTL | MATNR | CHAR | 18 | 0 | Assembly | MARA | |
| 8 | |
ILOAN | ILOAN | CHAR | 12 | 0 | Location and account assignment for technical object | ILOA | |
| 9 | |
ILOAI | X | CHAR | 1 | 0 | ILOA Individual | ||
| 10 | |
ANLZU | ANLZU | CHAR | 1 | 0 | Syst.Condition | T357M | |
| 11 | |
IWERK | WERKS | CHAR | 4 | 0 | Maintenance Planning Plant | T399I | |
| 12 | |
INGRP | INGRP | CHAR | 3 | 0 | Planner Group for Customer Service and Plant Maintenance | T024I | |
| 13 | |
VAGRP | VAGRP | CHAR | 3 | 0 | Responsible planner group/department | T024A | |
| 14 | |
PM_OBJTY | CR_OBJTY | CHAR | 2 | 0 | Object Type of CIM Resources for Work Center | ||
| 15 | |
LGWID | CR_OBJID | NUMC | 8 | 0 | Object ID of the Work Center | CRID | |
| 16 | |
KUNUM | KUNNR | CHAR | 10 | 0 | Customer Number | KNA1 | |
| 17 | |
ANING | USNAM | CHAR | 12 | 0 | Name of Person Reponsible for System | ||
| 18 | |
GAUZT | FLTP | FLTP | 16 | 16 | Planned downtime in hours | ||
| 19 | |
MAUEH | MEINS | UNIT | 3 | 0 | Unit for Breakdown Duration | T006 | |
| 20 | |
ANLBD | DATUM | DATS | 8 | 0 | Date until which the system is available | ||
| 21 | |
ANLVD | DATUM | DATS | 8 | 0 | Date from which the system is available | ||
| 22 | |
ANLBZ | UHRZT | TIMS | 6 | 0 | Time until which the system is available | ||
| 23 | |
ANLVZ | UHRZT | TIMS | 6 | 0 | Time from Which System is Available | ||
| 24 | |
INSPK | USNAM | CHAR | 12 | 0 | Name of Person Responsible for Technical Inspection | ||
| 25 | |
DATAN | DATUM | DATS | 8 | 0 | Date of Technical Inspection | ||
| 26 | |
WARPL | WARPL | CHAR | 12 | 0 | Maintenance Plan | MPLA | |
| 27 | |
ABNUM | ABNUM | INT4 | 10 | 0 | Maintenance Plan Call Number | ||
| 28 | |
WAPOS | POSNU | CHAR | 16 | 0 | Maintenance item | ||
| 29 | |
LAUFN | AUFNR | CHAR | 12 | 0 | Order number | AUFK | |
| 30 | |
OBJKNR | OBJKN | INT4 | 10 | 0 | Object list number | SER00 | |
| 31 | |
REVNI | REVNI | CHAR | 8 | 0 | Revision of Plant Maintenance and Customer Service | T352R | |
| 32 | |
ADDAT | DATUM | DATS | 8 | 0 | PM Order: Reference Date | ||
| 33 | |
ADUHR | UZEIT | TIMS | 6 | 0 | Time of Reference Date | ||
| 34 | |
PM_PHASE | PM_PHASE | CHAR | 1 | 0 | Maintenance Processing Phase | ||
| 35 | |
ILA | ILART | CHAR | 3 | 0 | Maintenance activity type | T353I | |
| 36 | |
QMNUM | QMNUM | CHAR | 12 | 0 | Message Number | QMEL | |
| 37 | |
HISDA | DATUM | DATS | 8 | 0 | PM request: History date | ||
| 38 | |
AKKNZ | AKKNZ | CHAR | 1 | 0 | Order Category Indicator Plant Maintenance | ||
| 39 | |
AUF_PLKNZ | AUF_PLKNZ | CHAR | 1 | 0 | Maintenance order planning indicator | ||
| 40 | |
GERNR | GERNR | CHAR | 18 | 0 | Serial Number | ||
| 41 | |
MATNR | MATNR | CHAR | 18 | 0 | Material Number | MARA | |
| 42 | |
DEVICEID | DEVICEID | CHAR | 40 | 0 | Additional Device Data | ||
| 43 | |
SCRTP | SCRTP | CHAR | 4 | 0 | Scenario or Subscreen Category | TQBT | |
| 44 | |
ADDCOMPARE_CORE | ADDCOMPARE_CORE | CHAR | 40 | 0 | Reference Element PM/PS | * | |
| 45 | |
RSUPG | XFIELD | CHAR | 1 | 0 | Upgrade Order Indicator | ||
| 46 | |
0 | 0 | Fields for /ISDFPS/ Enhancements | |||||
| 47 | |
J_OBJNR | J_OBJNR | CHAR | 22 | 0 | Object number | * | |
| 48 | |
/ISDFPS/MEQUI | EQUNR | CHAR | 18 | 0 | Master Equipment | * | |
| 49 | |
0 | 0 | IUID Append | |||||
| 50 | |
UII_CHAR72 | UII_CHAR72 | CHAR | 72 | 0 | Unique Item Identifier |
Foreign Keys
| |
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right |
|---|---|---|---|---|---|---|---|
| 1 | AFIH | ANLZU | |
|
REF | C | CN |
| 2 | AFIH | APGRP | |
|
REF | C | CN |
| 3 | AFIH | ARTPR | |
|
REF | C | CN |
| 4 | AFIH | AUFNR | |
|
KEY | 1 | CN |
| 5 | AFIH | BAUTL | |
|
REF | C | CN |
| 6 | AFIH | EQUNR | |
|
REF | C | CN |
| 7 | AFIH | GAUEH | |
|
REF | C | CN |
| 8 | AFIH | GEWRK | |
|
REF | C | CN |
| 9 | AFIH | ILART | |
|
REF | C | CN |
| 10 | AFIH | ILOAN | |
|
REF | C | CN |
| 11 | AFIH | INGPR | |
|
REF | C | CN |
| 12 | AFIH | IWERK | |
|
REF | C | CN |
| 13 | AFIH | KUNUM | |
|
REF | C | CN |
| 14 | AFIH | LAUFN | |
|
REF | C | CN |
| 15 | AFIH | MANDT | |
|
KEY | 1 | CN |
| 16 | AFIH | OBKNR | |
|
|||
| 17 | AFIH | PRIOK | |
|
REF | C | CN |
| 18 | AFIH | QMNUM | |
|
REF | C | CN |
| 19 | AFIH | REVNR | |
|
REF | C | CN |
| 20 | AFIH | SCREENTY | |
|
|||
| 21 | AFIH | SERMAT | |
|
|||
| 22 | AFIH | WARPL | |
|
REF | C | CN |
History
| Last changed by/on | SAP | 20110901 |
| SAP Release Created in |