SAP Table MCAFIH

PM-/CS Order

MCAFIH (PM-/CS Order) 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 MCAFIH to other SAP tables.

MCAFIH table fields

Field Data element Checktable Datatype Length Decimals
AUFNR Order Number AUFNR CHAR 12 0
AUART Order Type AUFART CHAR 4 0
ILART Maintenance activity type ILA CHAR 3 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)
PLKNZ Maintenance order planning indicator AUF_PLKNZ CHAR 1 0
NULL Unplanned order
1 Planned order
2 Immediate order
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)
OBJNR Object number J_OBJNR CHAR 22 0
AUFPL Routing number of operations in the order CO_AUFPL NUMC 10 0
PRIOK Priority PRIOK CHAR 1 0
QMNUM Notification No QMNUM CHAR 12 0
IWERK Maintenance Planning Plant IWERK CHAR 4 0
INGRP Planner Group for Customer Service and Plant Maintenance INGRP CHAR 3 0
TPLNR Functional Location TPLNR CHAR 30 0
EQUNR Equipment Number EQUNR CHAR 18 0
BAUTL_HD Assembly BAUTL CHAR 18 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 NUMC 8 0
AWERK Plant associated with main work center AWERK CHAR 4 0
VAPLZ Main work center for maintenance tasks GEWRK CHAR 8 0
REVNR Revision for Plant Maintenance and Customer Service REVNI CHAR 8 0
ABCKZ ABC indicator for technical object ABCKZ CHAR 1 0
SWERK Maintenance plant SWERK CHAR 4 0
STORT Asset location STORT CHAR 10 0
BEBER Plant section BEBER CHAR 3 0
MSGRP Room RAUMNR CHAR 8 0
GSBER Business Area GSBER CHAR 4 0
BUKRS Company Code BUKRS CHAR 4 0
KOKRS Controlling Area KOKRS CHAR 4 0
KOSTL Cost Center KOSTL CHAR 10 0
WARPL Maintenance Plan WARPL CHAR 12 0
WAPOS Maintenance item WAPOS CHAR 16 0
VKORG Sales Organization VKORG CHAR 4 0
VTWEG Distribution Channel VTWEG CHAR 2 0
SPART Division SPART CHAR 2 0
VKGRP Sales Group VKGRP CHAR 3 0
VKBUR Sales Office VKBUR CHAR 4 0
KUNUM Customer Number KUNUM CHAR 10 0
KDAUF Sales Order Number KDAUF CHAR 10 0
KDPOS Item Number in Sales Order KDPOS NUMC 6 0
GLTRP Basic finish date CO_GLTRP DATS 8 0
GSTRP Basic Start Date PM_ORDGSTRP DATS 8 0
FTRMS Scheduled release date CO_FTRMS DATS 8 0
GLTRS Scheduled finish CO_GLTRS DATS 8 0
GSTRS Scheduled start CO_GSTRS DATS 8 0
GSTRI Actual start date CO_GSTRI DATS 8 0
GETRI Confirmed Order Finish Date CO_GETRI DATS 8 0
FTRMI Actual release date CO_FTRMI DATS 8 0
IDAT2 Technical completion date AUFIDAT2 DATS 8 0
ADDAT PM Order: Reference Date ADDAT DATS 8 0
ADUHR Time of Reference Date ADUHR TIMS 6 0
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
ERDAT Date on Which Record Was Created ERDAT DATS 8 0
ERFZEIT Time, at Which Record Was Added ERZEIT TIMS 6 0
AENAM Name of Person Who Changed Object AENAM CHAR 12 0
AEDAT Changed On AEDAT DATS 8 0
AEZEIT Time of Change AEZEIT TIMS 6 0
SYSTZ Time Zone TIMEZONE CHAR 6 0
EHTAG Lead Time Unit (Day) QEINHTAG UNIT 3 0
ZHLAFIH Number of orders DZHLAFIH INT4 10 0
ZHLAFIH_OFFEN Number of Open Orders DZHLAFIH_OF INT4 10 0
ZHLAFIH_ABGS Number of Closed Orders DZHLAFIH_AB INT4 10 0
ZHLAFIH_NDGEF Number of orders not to be run DZHLAFIH_ND INT4 10 0
ZHLAFIH_TGERL Number of On-time Closed Orders DZHLAFIH_TE INT4 10 0
ZHLAFIH_SOF Number of Immediate Orders DZHLAFIH_SOF INT4 10 0
ZHLAFIH_UNGPL Number of Unscheduled Orders DZHLAFIH_UPL INT4 10 0
ZHLAFIH_GEPL Number of Planned Orders DZHLAFIH_GPL INT4 10 0
DLZNETTO Order Lead Time/Working Days Acc. to Factory Calendar(Net) DAFIHDZ_N FLTP 16 16
DLZBRUTTO Order Run-time in Calendar Days (Gross) DAFIHDZ_B FLTP 16 16
ASTTX Field displaying user status CO_ASTTX CHAR 40 0
STTXT System Status CO_STTXT CHAR 40 0
GLUZS Scheduled finish time CO_GLUZS TIMS 6 0
GSUZS Scheduled Start (Time) CO_GSUZS TIMS 6 0
GLUZP Basic finish (time) CO_GLUZP TIMS 6 0
GSUZP Basic start time CO_GSUZP TIMS 6 0
GSUZI Actual start time CO_GSUZI TIMS 6 0
GEUZI Confirmed order finish (time) CO_GEUZI TIMS 6 0
ARM_SETUP Configuration Code /ISDFPS/LM_ARM_SETUP CHAR 30 0
MODEL_ID Model ID/Weapon System /ISDFPS/DE_LM_MODEL_ID CHAR 14 0
NUM_PERSONS Number of Persons /ISDFPS/LM_NUM_PERS NUMC 3 0
KRYPTOSTATUS Crypto Status /ISDFPS/LM_KRYPTO CHAR 1 0
LANDING_LOC Destination /ISDFPS/LM_LOCATION CHAR 40 0
CALL_SIGN Call Sign /ISDFPS/LM_CALL_SIGN CHAR 12 0
TIME_OVER_TARGET Time Over Target /ISDFPS/LM_TIME_OT TIMS 6 0
TARGET_LOC Destination /ISDFPS/LM_LOCATION CHAR 40 0
ZULU_TNZONE Time Zone TZNZONE CHAR 6 0
START_TNZONE Takeoff/Landing Time in the Zulu Time Zone /ISDFPS/LM_TIME TIMS 6 0
START_DATE Date /ISDFPS/LM_DATE DATS 8 0
LANDING_TNZONE Takeoff/Landing Time in the Zulu Time Zone /ISDFPS/LM_TIME TIMS 6 0
LANDING_DATE Date /ISDFPS/LM_DATE DATS 8 0
FLIGHT_DURATION Planned Flight Time /ISDFPS/FLIGHT_DURATION DEC 11 2
FL_DURATION_UNIT Time Unit for Planned Flight Duration /ISDFPS/FLIGHT_DURATION_UNIT UNIT 3 0
F_OBJNR Object number J_OBJNR CHAR 22 0
OPERATN_ID_GUID Internal Key for Force Element /ISDFPS/FORCE_ID CHAR 32 0
OPERATN_ID_PLVAR Plan Version PLVAR CHAR 2 0
OPERATN_ID_OTYPE Object Type OTYPE CHAR 2 0
OPERATN_ID_OBJID Object ID HROBJID NUMC 8 0
OPERATION_CNT Internal (Version) Counter /ISDFPS/FORCE_CNT NUMC 6 0
MISSION Mission /ISDFPS/DE_LM_MISSION CHAR 12 0
EXTERNAL_ID External ID /ISDFPS/DE_LM_EXTERNAL_ID CHAR 12 0
LATEST_TAKE_OFF Latest Takeoff /ISDFPS/DE_LM_LATEST_TAKE_OFF TIMS 6 0
LAUNCHING_PAD Runway /ISDFPS/DE_LM_LAUNCHING_PAD CHAR 5 0
STEXT Description /ISDFPS/DE_LM_DESCR CHAR 40 0
FORCE_CNT Internal (Version) Counter /ISDFPS/FORCE_CNT NUMC 6 0
CREADAT Date of Application /ISDFPS/CREADAT DATS 8 0
CREABY Created by /ISDFPS/CREABY CHAR 12 0
CHNGDAT Last Changed on /ISDFPS/CHNGDAT DATS 8 0
CHNGBY Last Changed by /ISDFPS/CHNGBY CHAR 12 0
LOGSYS Logical System /ISDFPS/LOGSYS CHAR 10 0
ISFLIGHT Checkbox XFELD CHAR 1 0
X Yes
NULL No
ESTAT User Status J_ESTAT CHAR 5 0