SAP table AFFHI (PSIS - Individual Overviews: Production Resources/Tools)

Field Description Data Type Length Decimals Checktable Data Element
ARNUMMER Archiving Session Number CHAR 6 0 ADMI_RUN_D
VSGRUPPE Group for a project version CHAR 20 0 VSGRUPPE
VSNUMMER Number or description of a version CHAR 12 0 VSNMR
PRCTR Profit Center CHAR 10 0 CEPC PRCTR
PRNAM Investment program name CHAR 8 0 IMTP IM_PRNAM
PRPOS Identification for an investment program position CHAR 24 0 IM_POSID
PSPID Project definition CHAR 24 0 PS_PSPID
POSID Work Breakdown Structure Element (WBS Element) CHAR 24 0 PS_POSID
KDAUF Sales Document CHAR 10 0 * VBELN_VA
KDPOS Sales Document Item NUMC 6 0 * POSNR_VA
AUFNR Order/Network number CHAR 12 0 AUFK AUF_NETNR
VORNR Activity number in network and standard network CHAR 4 0 CN_VORNR
PSNFH Item Number for Production Resource/Tool NUMC 4 0 PSNFH
AUTYPTXT Display Field for Order Category Description CHAR 40 0 AUTYPTEXT
STEUF Control Profile for Management of Production Resources/Tools CHAR 4 0 TCF10 STEUF
STEUTXT Control Key Description CHAR 40 0 STEUTXT
KZKBL Indicator: Create load records for prod. resources/tools CHAR 1 0 KZKBL
BZOFFB Reference Date for Start of Production Resource/Tool Usage CHAR 2 0 TCA54 BZOFFB
OFFSTB Offset to start of production resource/tool usage QUAN 5 0 OFFSTB
EHOFFB Offset Unit for Start of Prodn Resource/Tool Usage UNIT 3 0 T006 EHOFFB
BZOFFE Reference date for end of production resource/tool usage CHAR 2 0 TCA54 BZOFFE
OFFSTE Offset to finish of production resource/tool usage QUAN 5 0 OFFSTE
EHOFFE Offset Unit for End of Production Resource/Tool Usage UNIT 3 0 T006 EHOFFE
FSFHD Earliest Scheduled Start Date for PRT Usage DATS 8 0 CF_FSFHD
FSFHZ Earliest Scheduled Start Time for PRT Usage TIMS 6 0 CF_FSFHZ
FEFHD Earliest Scheduled End Date of PRT Usage DATS 8 0 CF_FEFHD
FEFHZ Earliest Scheduled End Time of PRT Usage TIMS 6 0 CF_FEFHZ
SSFHD Latest Scheduled Start Date for PRT Usage DATS 8 0 CF_SSFHD
SSFHZ Latest Scheduled Start Time for PRT Usage TIMS 6 0 CF_SSFHZ
SEFHD Latest Scheduled End Date for PRT Usage DATS 8 0 CF_SEFHD
SEFHZ Latest Scheduled End Time for PRT Usage TIMS 6 0 CF_SEFHZ
ISFHD Actual start date of PRT usage DATS 8 0 CF_ISFHD
ISFHZ Actual start time of PRT usage TIMS 6 0 CF_ISFHZ
IEFHD Actual end date of PRT usage DATS 8 0 CF_IEFHD
IEFHZ Actual end time of PRT usage TIMS 6 0 CF_IEFHZ
DAUSE Duration of the PRT usage QUAN 5 1 CF_DAUSE
DAUEH Unit for Duration of PRT Usage UNIT 3 0 T006 CF_DAUEH
MGEINH Unit for Quantity of Production Resources/Tools UNIT 3 0 T006 MGEINH
MGVGW Standard Value for Quantity of Production Resources/Tools QUAN 9 3 MGVGW
MGSOLEH Unit for Quantity of Production Resources/Tools UNIT 3 0 T006 MGEINH
MGSOL Total Planned Quantity of Production Resource/Tool QUAN 9 3 MGSOL
MGISTEH Unit for Quantity of Production Resources/Tools UNIT 3 0 T006 MGEINH
MGIST Actual Quantity of Production Resource/Tool QUAN 9 3 MGIST
MGRSTEH Unit for Quantity of Production Resources/Tools UNIT 3 0 T006 MGEINH
MGRST Remaining Quantity of the Production Resource/Tool QUAN 9 3 MGRST
MGAUSEH Unit for Quantity of Production Resources/Tools UNIT 3 0 T006 MGEINH
MGAUS Quantity of checked-out production resources/tools QUAN 9 3 MGAUS
MGFORM Formula for Calculating the Total Quantity of PRT CHAR 6 0 TC25 CF_MGFORM
EWEINH Usage Value Unit of the Production Resource/Tool UNIT 3 0 T006 EWEINH
EWVGW Standard Usage Value for Production Resources/Tools QUAN 9 3 EWVGW
EWSOLEH Usage Value Unit of the Production Resource/Tool UNIT 3 0 T006 EWEINH
EWSOL Total Planned Usage Value of Production Resource/Tool QUAN 9 3 EWSOL
EWISTEH Usage Value Unit of the Production Resource/Tool UNIT 3 0 T006 EWEINH
EWIST Actual Usage Value for Production Resource/Tool QUAN 9 3 EWIST
EWRSTEH Usage Value Unit of the Production Resource/Tool UNIT 3 0 T006 EWEINH
EWRST Remaining Usage Value of the Production Resource/Tool QUAN 9 3 EWRST
EWFORM Formula for Calculating the Total Usage Value of PRT CHAR 6 0 TC25 CF_EWFORM
TXTSP Language Key LANG 1 0 T002 SPRAS
KTSCH Standard Text Key for Production Resources/Tools CHAR 7 0 T435 CF_KTSCH
TXTZ1 First Line of Text for Production Resources/Tools CHAR 40 0 TXTZ1
FHMAR Production Resources/Tools Category CHAR 1 0 TCF02 FHMAR
FHMNR Production resource/tool number CHAR 40 0 FHMNR
FHWRK Production Resources/Tools in Plant CHAR 4 0 T001W FHWRK
MATNR Material Number CHAR 40 0 MARA MATNR
MTEXT Material description CHAR 40 0 PS_MATTEXT
SFHNR Production resources and tools CHAR 18 0 SFHNR
DOKAR Document Type CHAR 3 0 TDWA DOKAR
DOKNR Document number CHAR 25 0 DRAW DOKNR
DOKVR Document Version CHAR 2 0 DOKVR
DOKTL Document Part CHAR 3 0 DOKTL_D
EQUNR Equipment Number CHAR 18 0 EQUI EQUNR
EQPNT Measuring Point CHAR 12 0 IMPTT IMRC_POINT
EQPTX Description of Measuring Point CHAR 40 0 IMRC_PTTXT
MSEHI Unit of Measurement UNIT 3 0 T006 MSEHI
FHKTX Description of the Production Resource/Tool CHAR 40 0 FHKTX
FGRU1 Grouping Key 1 for Production Resources/Tools CHAR 4 0 TCF12 FGRUA
FGRU2 Grouping Key 2 for Production Resources/Tools CHAR 4 0 TCF12 FGRUB
TXTKZ Long Text Exists CHAR 1 0 CF_TXTKZ
STATXT Edited status text CHAR 80 0 STATUSTEXT_2
DUMMY_AFVC_INCL_EEW_PS Dummy function in length 1 CHAR 1 0 DUMMY
AUTYP Order category NUMC 2 0 AUFTYP
01 Internal Order (Controlling)
02 Accrual Calculation Order (Controlling)
03 Model Order (Controlling)
04 CO Production Order
05 Product Cost Collector
06 QM Order
10 PP Production Order
20 Network
30 Maintenance order
40 Process Order
50 Inspection Lot
60 Personnel Order
70 Shipping deadlines
99 Master Planned order
VGTYP Activity or element category CHAR 3 0 VGTYP
KALID Factory calendar key CHAR 2 0 FABKL
INT_ID ID/Object key CHAR 30 0 OBJEKT_ID
LIGHT ALV control: Exception as LED CHAR 1 0 LVC_EXLED
AUFPL Routing number of operations in the order NUMC 10 0 CO_AUFPL
PZLFH Item Counter for Production Resources/Tools NUMC 8 0 PZLFH

AFFHI foreign key relationships

Table Field Check Table Check Field
0 AFFHI AUFNR AUFK Order master data AUFNR
1 AFFHI BZOFFB TCA54 Key for reference dates used in offset scheduling BZOFF
0 AFFHI BZOFFE TCA54 Key for reference dates used in offset scheduling BZOFF
1 AFFHI DAUEH T006 Units of Measurement MANDT
1 AFFHI DAUEH T006 Units of Measurement MSEHI
0 AFFHI DOKAR TDWA Document Types MANDT
0 AFFHI DOKAR TDWA Document Types DOKAR
1 AFFHI DOKNR DRAW Document Info Record DOKNR
1 AFFHI DOKNR DRAW Document Info Record DOKVR
1 AFFHI DOKNR DRAW Document Info Record DOKTL
0 AFFHI EHOFFB T006 Units of Measurement MANDT
1 AFFHI EHOFFE T006 Units of Measurement MANDT
0 AFFHI EQPNT IMPTT Measuring Point (Table) POINT
1 AFFHI EQUNR EQUI Equipment master data MANDT
0 AFFHI EWEINH T006 Units of Measurement MANDT
1 AFFHI EWFORM TC25 Work center formulas MANDT
0 AFFHI EWISTEH T006 Units of Measurement MANDT
0 AFFHI EWISTEH T006 Units of Measurement MSEHI
1 AFFHI EWRSTEH T006 Units of Measurement MANDT
1 AFFHI EWRSTEH T006 Units of Measurement MSEHI
0 AFFHI EWSOLEH T006 Units of Measurement MANDT
0 AFFHI EWSOLEH T006 Units of Measurement MSEHI
1 AFFHI FGRU1 TCF12 Key for grouping production resources/tools MANDT
0 AFFHI FGRU2 TCF12 Key for grouping production resources/tools MANDT
1 AFFHI FHWRK T001W Plants/Branches WERKS
0 AFFHI KTSCH T435 Standard texts for routing/ref. op set items MANDT
1 AFFHI MATNR MARA General Material Data MANDT
1 AFFHI MATNR MARA General Material Data MATNR
0 AFFHI MGAUSEH T006 Units of Measurement MANDT
0 AFFHI MGAUSEH T006 Units of Measurement MSEHI
1 AFFHI MGEINH T006 Units of Measurement MANDT
0 AFFHI MGFORM TC25 Work center formulas MANDT
1 AFFHI MGISTEH T006 Units of Measurement MANDT
1 AFFHI MGISTEH T006 Units of Measurement MSEHI
0 AFFHI MGRSTEH T006 Units of Measurement MANDT
0 AFFHI MGRSTEH T006 Units of Measurement MSEHI
1 AFFHI MGSOLEH T006 Units of Measurement MANDT
1 AFFHI MGSOLEH T006 Units of Measurement MSEHI
0 AFFHI MSEHI T006 Units of Measurement MANDT
1 AFFHI PRCTR CEPC Profit Center Master Data Table PRCTR
1 AFFHI PRCTR CEPC Profit Center Master Data Table DATBI
1 AFFHI PRCTR CEPC Profit Center Master Data Table KOKRS
0 AFFHI PRNAM IMTP Investment programs MANDT
0 AFFHI PRNAM IMTP Investment programs GJAHR
1 AFFHI STEUF TCF10 PRT control key MANDT
0 AFFHI TXTSP T002 Language Keys (Component BC-I18) SPRAS