AFFH SAP table for – PRT assignment data for the work order

Here we would like to draw your attention to AFFH table in SAP. As we know it is being mainly used with the SAP PP-BD (Basic Data – PP) component which is coming under PP module (Production Planning). AFFH is a SAP standard transparent table used for storing PRT assignment data for the work order related data in SAP. It comes under the package CF.

SAP AFFH table

Table AFFH technical data

TableAFFH
Data storingPRT assignment data for the work order
ModulePP
ComponentPP-BD
SAP PackageCF
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP AFFH Table Fields

Here is the details of each fields in this table.You can find the discription, data type and assigned lenth of each of the fields in AFFH table.

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • USERC : Name of Person Who Changed Object
    Its data type is C (Character String) with field length 12
  • OBJTY : Object types of the CIM resource
    Its data type is C (Character String) with field length 2
  • OBJID : Object ID of the resource
    Its data type is N (Character String with Digits Only) with field length 8
  • PLNTY_KEY : Task List Type
    Its data type is C (Character String) with field length 1
  • PLNNR_KEY : Key for Task List Group
    Its data type is C (Character String) with field length 8
  • PZLFH_KEY : Item counter for production resources/tools
    Its data type is N (Character String with Digits Only) with field length 8
  • ZAEHL_KEY : Internal counter
    Its data type is N (Character String with Digits Only) with field length 8
  • OBJCT : Object of a task list
    Its data type is C (Character String) with field length 1
  • APLZL : Internal counter
    Its data type is N (Character String with Digits Only) with field length 8
  • PSNFH : Item Number for Production Resource/Tool
    Its data type is N (Character String with Digits Only) with field length 4
  • AUFPL : Routing number of operations in the order
    Its a key field. Its data type is N (Character String with Digits Only) with field length 10
  • OBJNR : Object number
    Its data type is C (Character String) with field length 22
  • STEUF : Control key for management of production resources/tools
    Its data type is C (Character String) with field length 4
  • KZKBL : Indicator: Create load records for prod. resources/tools
    Its data type is C (Character String) with field length 1
  • BZOFFB : Reference date to start of production resource/tool usage
    Its data type is C (Character String) with field length 2
  • OFFSTB : Offset to start of production resource/tool usage
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • EHOFFB : Offset unit for start of prod. resource/tool usage
    Its data type is C (Character String) with field length 3
  • BZOFFE : Reference date for end of production resource/tool usage
    Its data type is C (Character String) with field length 2
  • OFFSTE : Offset to finish of production resource/tool usage
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • EHOFFE : Offset unit for end of production resource/tool usage
    Its data type is C (Character String) with field length 3
  • FSFHD : Earliest scheduled start (date) for PRT usage
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • PZLFH : Item counter for production resources/tools
    Its a key field. Its data type is N (Character String with Digits Only) with field length 8
  • FSFHZ : Earliest scheduled start (time) for PRT usage
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • FEFHD : Earliest scheduled finish (date) of PRT usage
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • FEFHZ : Earliest scheduled end (time) of PRT usage
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • SSFHD : Latest scheduled start (date) for PRT usage
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • SSFHZ : Latest scheduled start (time) for PRT usage
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • SEFHD : Latest scheduled finish (date) of PRT usage
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • SEFHZ : Latest scheduled end (time) for PRT usage
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • ISFHD : Actual start (date) of PRT usage
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • ISFHZ : Actual start (time) of PRT usage
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • IEFHD : Actual finish (date) of PRT usage
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • .INCLUDE : PRT assignment data for the work order
    Its include structure/component is is AFFH_INC
  • IEFHZ : Actual finish (time) of PRT usage
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • DAUFL : Duration of PRT usage
    Its data type is F (Floating point number) with field length 8
  • DAUEH : Time unit for duration of PRT usage
    Its data type is C (Character String) with field length 3
  • MGEINH : Quantity unit of production resource/tool
    Its data type is C (Character String) with field length 3
  • MGVGW : Standard value for the PRT quantity
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 5
  • MGSOLEH : Quantity unit of production resource/tool
    Its data type is C (Character String) with field length 3
  • MGSOL : Total planned quantity of production resource/tool
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 5
  • MGISTEH : Quantity unit of production resource/tool
    Its data type is C (Character String) with field length 3
  • MGIST : Confirmed quantity of production resource/tool
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 5
  • MGRSTEH : Quantity unit of production resource/tool
    Its data type is C (Character String) with field length 3
  • LOEKZ : Deletion Indicator
    Its data type is C (Character String) with field length 1
  • MGRST : Remaining quantity of the production resource/tool
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 5
  • MGAUSEH : Quantity unit of production resource/tool
    Its data type is C (Character String) with field length 3
  • MGAUS : Quantity of checked-out production resources/tools
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 5
  • MGFORM : Formula for calculating the total quantity of PRT
    Its data type is C (Character String) with field length 6
  • EWEINH : Usage value unit of the production resource/tool
    Its data type is C (Character String) with field length 3
  • EWVGW : Standard usage value for production resources/tools
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 5
  • EWSOLEH : Usage value unit of the production resource/tool
    Its data type is C (Character String) with field length 3
  • EWSOL : Total planned usage value of production resource/tool
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 5
  • EWISTEH : Usage value unit of the production resource/tool
    Its data type is C (Character String) with field length 3
  • EWIST : Actual usage value for production resource/tool
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 5
  • PARKZ : Indicator: inactive changes
    Its data type is C (Character String) with field length 1
  • EWRSTEH : Usage value unit of the production resource/tool
    Its data type is C (Character String) with field length 3
  • EWRST : Remaining usage value of the production resource/tool
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 5
  • EWFORM : Formula for calculating the total usage value of PRT
    Its data type is C (Character String) with field length 6
  • TXTSP : Language Key
    Its data type is C (Character String) with field length 1
  • KTSCH : Standard text key for production resources/tools
    Its data type is C (Character String) with field length 7
  • TXTZ1 : First line of text for production resources/tools
    Its data type is C (Character String) with field length 40
  • OBJTYPE : Change indicator
    Its data type is C (Character String) with field length 1
  • CH_PROC : Process that has lead to the change of an object
    Its data type is C (Character String) with field length 1
  • AENNR : Change Number
    Its data type is C (Character String) with field length 12
  • DATUI : Date Record Created on
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • USERI : User Who Created Record
    Its data type is C (Character String) with field length 12
  • DATUC : Last Changed On
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8