SAP table AFFHR (PRT Structure for Project Reporting)

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

AFFHR foreign key relationships

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