Menu

SAP Table AFFH

PRT assignment data for the work order

Recommended Now

All-new Echo Dot Smart speaker with Alexa

This bundle includes Echo Dot (3rd Gen) Charcoal and Philips Hue White A19 Medium Lumen Smart Bulb, 1100 Lumens. Built in Smart Home hub. Ask Alexa to control Zigbee-compatible devices. No additional Philips Hue hub required. Two choices for easy smart lighting - Start setting the mood with Hue Smart bulbs and your Echo device, supporting up to 5 Hue Bluetooth & Zigbee smart bulbs. Add the Hue Hub for whole-home smart lighting (up to 50 light points) and bonus features.

Check it out on amazon.com →

The table AFFH (PRT assignment data for the work order) is a standard table in SAP ERP. It belongs to the package CF.

Technical Information

Table AFFH
Short Text PRT assignment data for the work order
Package CF
Table Type Transparent Table

Fields for Table AFFH

Field Name Key Description Data Element Type Length Check Table
MANDT Client MANDT CLNT 3 T000
AUFPL Routing number of operations in the order CO_AUFPL NUMC 10
PZLFH Item counter for production resources/tools PZLFH NUMC 8
Include Structure: AFFH_INC
LOEKZ Deletion Indicator LKENZ CHAR 1
PARKZ Indicator: inactive changes PARKZ CHAR 1
DATUI Date record created on ANDAT DATS 8
USERI User who created record ANNAM CHAR 12
DATUC Changed On AEDAT DATS 8
USERC Name of Person Who Changed Object AENAM CHAR 12
OBJTY Object types of the CIM resource CR_OBJTY CHAR 2
OBJID Object ID of the resource CR_OBJID NUMC 8 CRID
PLNTY_KEY Task List Type PLNTY CHAR 1 TCA01
PLNNR_KEY Key for Task List Group PLNNR CHAR 8
PZLFH_KEY Item counter for production resources/tools PZLFH NUMC 8
ZAEHL_KEY Internal counter CIM_COUNT NUMC 8
OBJCT Object of a task list OBJCT_D CHAR 1
APLZL Internal counter CIM_COUNT NUMC 8
PSNFH Item Number for Production Resource/Tool PSNFH NUMC 4
OBJNR Object number J_OBJNR CHAR 22 ONR00
STEUF Control key for management of production resources/tools STEUF CHAR 4 TCF10
KZKBL Indicator: Create load records for prod. resources/tools KZKBL CHAR 1
BZOFFB Reference date to start of production resource/tool usage BZOFFB CHAR 2 TCA54
OFFSTB Offset to start of production resource/tool usage OFFSTB QUAN 5
EHOFFB Offset unit for start of prod. resource/tool usage EHOFFB UNIT 3 T006
BZOFFE Reference date for end of production resource/tool usage BZOFFE CHAR 2 TCA54
OFFSTE Offset to finish of production resource/tool usage OFFSTE QUAN 5
EHOFFE Offset unit for end of production resource/tool usage EHOFFE UNIT 3 T006
FSFHD Earliest scheduled start (date) for PRT usage CF_FSFHD DATS 8
FSFHZ Earliest scheduled start (time) for PRT usage CF_FSFHZ TIMS 6
FEFHD Earliest scheduled finish (date) of PRT usage CF_FEFHD DATS 8
FEFHZ Earliest scheduled end (time) of PRT usage CF_FEFHZ TIMS 6
SSFHD Latest scheduled start (date) for PRT usage CF_SSFHD DATS 8
SSFHZ Latest scheduled start (time) for PRT usage CF_SSFHZ TIMS 6
SEFHD Latest scheduled finish (date) of PRT usage CF_SEFHD DATS 8
SEFHZ Latest scheduled end (time) for PRT usage CF_SEFHZ TIMS 6
ISFHD Actual start (date) of PRT usage CF_ISFHD DATS 8
ISFHZ Actual start (time) of PRT usage CF_ISFHZ TIMS 6
IEFHD Actual finish (date) of PRT usage CF_IEFHD DATS 8
IEFHZ Actual finish (time) of PRT usage CF_IEFHZ TIMS 6
DAUFL Duration of PRT usage CF_DAUFL FLTP 16
DAUEH Time unit for duration of PRT usage CF_DAUEH UNIT 3 T006
MGEINH Quantity unit of production resource/tool MGEINH UNIT 3 T006
MGVGW Standard value for the PRT quantity MGVGW QUAN 9
MGSOLEH Quantity unit of production resource/tool MGEINH UNIT 3 T006
MGSOL Total planned quantity of production resource/tool MGSOL QUAN 9
MGISTEH Quantity unit of production resource/tool MGEINH UNIT 3 T006
MGIST Confirmed quantity of production resource/tool MGIST QUAN 9
MGRSTEH Quantity unit of production resource/tool MGEINH UNIT 3 T006
MGRST Remaining quantity of the production resource/tool MGRST QUAN 9
MGAUSEH Quantity unit of production resource/tool MGEINH UNIT 3 T006
MGAUS Quantity of checked-out production resources/tools MGAUS QUAN 9
MGFORM Formula for calculating the total quantity of PRT CF_MGFORM CHAR 6 TC25
EWEINH Usage value unit of the production resource/tool EWEINH UNIT 3 T006
EWVGW Standard usage value for production resources/tools EWVGW QUAN 9
EWSOLEH Usage value unit of the production resource/tool EWEINH UNIT 3 T006
EWSOL Total planned usage value of production resource/tool EWSOL QUAN 9
EWISTEH Usage value unit of the production resource/tool EWEINH UNIT 3 T006
EWIST Actual usage value for production resource/tool EWIST QUAN 9
EWRSTEH Usage value unit of the production resource/tool EWEINH UNIT 3 T006
EWRST Remaining usage value of the production resource/tool EWRST QUAN 9
EWFORM Formula for calculating the total usage value of PRT CF_EWFORM CHAR 6 TC25
TXTSP Language Key SPRAS LANG 1 T002
KTSCH Standard text key for production resources/tools CF_KTSCH CHAR 7 T435
TXTZ1 First line of text for production resources/tools TXTZ1 CHAR 40
OBJTYPE Change indicator OCM_OBJ_TYPE CHAR 1
CH_PROC Process that has lead to the change of an object OCM_CH_PROC CHAR 1
AENNR Change Number AENNR CHAR 12 *