1. Home
  2. Resources
  3. SAP Tables
  4. AFFH - PRT assignment data for the work order

SAP Table AFFH

PRT assignment data for the work order

AFFH (PRT assignment data for the work 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 AFFH to other SAP tables.

AFFH table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
AUFPL Routing number of operations in the order CO_AUFPL NUMC 10 0
PZLFH Item counter for production resources/tools PZLFH NUMC 8 0
LOEKZ Deletion Indicator LKENZ CHAR 1 0
X Yes
NULL No
PARKZ Indicator: inactive changes PARKZ CHAR 1 0
X Yes
NULL No
DATUI Date record created on ANDAT DATS 8 0
USERI User who created record ANNAM CHAR 12 0
DATUC Changed On AEDAT DATS 8 0
USERC Name of Person Who Changed Object AENAM CHAR 12 0
OBJTY Object types of the CIM resource CR_OBJTY CHAR 2 0
A Work center
AA Work center alias
FH Production resources/tools
H Hierarchy
OBJID Object ID of the resource CR_OBJID CRID NUMC 8 0
PLNTY_KEY Task List Type PLNTY TCA01 CHAR 1 0
PLNNR_KEY Key for Task List Group PLNNR CHAR 8 0
PZLFH_KEY Item counter for production resources/tools PZLFH NUMC 8 0
ZAEHL_KEY Internal counter CIM_COUNT NUMC 8 0
OBJCT Object of a task list OBJCT_D CHAR 1 0
1 Confirmations for operation
2 Confirmations for sub-operation
3 Header in variable list
4 Period title (group processing)
5 Total for period (group processing)
6 Report title for capacity
7 Projects
8 WBS elements
9 Orders
A Header/Group counter
B BOM items/Reservations
C Capacity detail list/Operation
D Capacity detail list for sub-operations
E Equipment
F PRT for operation
G PRT for sub-operation
H Maintenance strategy
I Preventive maintenance package
J Filter list
K Master inspection characteristic
M Material component
N Material components for sub-ops
O Operation
P Inspection characteristic
Q Project item
R Relationships
S Sequence
T PS text
U Sub-operation
W Work center
V Process instruction
Y Operations (forecast)
Z Allocate-dependent values
APLZL Internal counter CIM_COUNT NUMC 8 0
PSNFH Item Number for Production Resource/Tool PSNFH NUMC 4 0
OBJNR Object number J_OBJNR ONR00 CHAR 22 0
STEUF Control key for management of production resources/tools STEUF TCF10 CHAR 4 0
KZKBL Indicator: Create load records for prod. resources/tools KZKBL CHAR 1 0
X Yes
NULL No
BZOFFB Reference date to start of production resource/tool usage BZOFFB TCA54 CHAR 2 0
OFFSTB Offset to start of production resource/tool usage OFFSTB QUAN 5 0
EHOFFB Offset unit for start of prod. resource/tool usage EHOFFB T006 UNIT 3 0
BZOFFE Reference date for end of production resource/tool usage BZOFFE TCA54 CHAR 2 0
OFFSTE Offset to finish of production resource/tool usage OFFSTE QUAN 5 0
EHOFFE Offset unit for end of production resource/tool usage EHOFFE T006 UNIT 3 0
FSFHD Earliest scheduled start (date) for PRT usage CF_FSFHD DATS 8 0
FSFHZ Earliest scheduled start (time) for PRT usage CF_FSFHZ TIMS 6 0
FEFHD Earliest scheduled finish (date) of PRT usage CF_FEFHD DATS 8 0
FEFHZ Earliest scheduled end (time) of PRT usage CF_FEFHZ TIMS 6 0
SSFHD Latest scheduled start (date) for PRT usage CF_SSFHD DATS 8 0
SSFHZ Latest scheduled start (time) for PRT usage CF_SSFHZ TIMS 6 0
SEFHD Latest scheduled finish (date) of PRT usage CF_SEFHD DATS 8 0
SEFHZ Latest scheduled end (time) for PRT usage CF_SEFHZ TIMS 6 0
ISFHD Actual start (date) of PRT usage CF_ISFHD DATS 8 0
ISFHZ Actual start (time) of PRT usage CF_ISFHZ TIMS 6 0
IEFHD Actual finish (date) of PRT usage CF_IEFHD DATS 8 0
IEFHZ Actual finish (time) of PRT usage CF_IEFHZ TIMS 6 0
DAUFL Duration of PRT usage CF_DAUFL FLTP 16 16
DAUEH Time unit for duration of PRT usage CF_DAUEH T006 UNIT 3 0
MGEINH Quantity unit of production resource/tool MGEINH T006 UNIT 3 0
MGVGW Standard value for the PRT quantity MGVGW QUAN 9 3
MGSOLEH Quantity unit of production resource/tool MGEINH T006 UNIT 3 0
MGSOL Total planned quantity of production resource/tool MGSOL QUAN 9 3
MGISTEH Quantity unit of production resource/tool MGEINH T006 UNIT 3 0
MGIST Confirmed quantity of production resource/tool MGIST QUAN 9 3
MGRSTEH Quantity unit of production resource/tool MGEINH T006 UNIT 3 0
MGRST Remaining quantity of the production resource/tool MGRST QUAN 9 3
MGAUSEH Quantity unit of production resource/tool MGEINH T006 UNIT 3 0
MGAUS Quantity of checked-out production resources/tools MGAUS QUAN 9 3
MGFORM Formula for calculating the total quantity of PRT CF_MGFORM TC25 CHAR 6 0
EWEINH Usage value unit of the production resource/tool EWEINH T006 UNIT 3 0
EWVGW Standard usage value for production resources/tools EWVGW QUAN 9 3
EWSOLEH Usage value unit of the production resource/tool EWEINH T006 UNIT 3 0
EWSOL Total planned usage value of production resource/tool EWSOL QUAN 9 3
EWISTEH Usage value unit of the production resource/tool EWEINH T006 UNIT 3 0
EWIST Actual usage value for production resource/tool EWIST QUAN 9 3
EWRSTEH Usage value unit of the production resource/tool EWEINH T006 UNIT 3 0
EWRST Remaining usage value of the production resource/tool EWRST QUAN 9 3
EWFORM Formula for calculating the total usage value of PRT CF_EWFORM TC25 CHAR 6 0
TXTSP Language Key SPRAS T002 LANG 1 0
KTSCH Standard text key for production resources/tools CF_KTSCH T435 CHAR 7 0
TXTZ1 First line of text for production resources/tools TXTZ1 CHAR 40 0
OBJTYPE Change indicator OCM_OBJ_TYPE CHAR 1 0
+ Object created
- Object is to be deleted
C Object changed
M Object reassigned
NULL Normal object
0 Zero Object
CH_PROC Process that has lead to the change of an object OCM_CH_PROC CHAR 1 0
NULL Not changed
1 Manually changed
2 Change sales order
3 Release of change number
4 Change assembly order
5 Change number supplement
6 Change number shift
7 Direct assignment
AENNR Change Number AENNR CHAR 12 0

AFFH foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
AFFH BZOFFB AFFH BZOFFB TCA54 Key for reference dates used in offset scheduling BZOFF
AFFH BZOFFE AFFH BZOFFE TCA54 Key for reference dates used in offset scheduling BZOFF
AFFH DAUEH AFFH DAUEH T006 Units of Measurement MSEHI
AFFH DAUEH AFFH MANDT T006 Units of Measurement MANDT
AFFH EHOFFB AFFH MANDT T006 Units of Measurement MANDT
AFFH EHOFFB AFFH EHOFFB T006 Units of Measurement MSEHI
AFFH EHOFFE AFFH MANDT T006 Units of Measurement MANDT
AFFH EHOFFE AFFH EHOFFE T006 Units of Measurement MSEHI
AFFH EWEINH AFFH EWEINH T006 Units of Measurement MSEHI
AFFH EWEINH AFFH MANDT T006 Units of Measurement MANDT
AFFH EWFORM AFFH MANDT TC25 Work center formulas MANDT
AFFH EWFORM AFFH EWFORM TC25 Work center formulas IDENT
AFFH EWISTEH AFFH MANDT T006 Units of Measurement MANDT
AFFH EWISTEH AFFH EWISTEH T006 Units of Measurement MSEHI
AFFH EWRSTEH AFFH MANDT T006 Units of Measurement MANDT
AFFH EWRSTEH AFFH EWRSTEH T006 Units of Measurement MSEHI
AFFH EWSOLEH AFFH MANDT T006 Units of Measurement MANDT
AFFH EWSOLEH AFFH EWSOLEH T006 Units of Measurement MSEHI
AFFH KTSCH AFFH MANDT T435 Standard texts for routing/ref. op set items MANDT
AFFH KTSCH AFFH KTSCH T435 Standard texts for routing/ref. op set items VLSCH
AFFH MANDT AFFH MANDT T000 Clients MANDT
AFFH MGAUSEH AFFH MANDT T006 Units of Measurement MANDT
AFFH MGAUSEH AFFH MGAUSEH T006 Units of Measurement MSEHI
AFFH MGEINH AFFH MGEINH T006 Units of Measurement MSEHI
AFFH MGEINH AFFH MANDT T006 Units of Measurement MANDT
AFFH MGFORM AFFH MANDT TC25 Work center formulas MANDT
AFFH MGFORM AFFH MGFORM TC25 Work center formulas IDENT
AFFH MGISTEH AFFH MANDT T006 Units of Measurement MANDT
AFFH MGISTEH AFFH MGISTEH T006 Units of Measurement MSEHI
AFFH MGRSTEH AFFH MANDT T006 Units of Measurement MANDT
AFFH MGRSTEH AFFH MGRSTEH T006 Units of Measurement MSEHI
AFFH MGSOLEH AFFH MGSOLEH T006 Units of Measurement MSEHI
AFFH MGSOLEH AFFH MANDT T006 Units of Measurement MANDT
AFFH OBJID AFFH MANDT CRID CIM Resource - Entities MANDT
AFFH OBJID AFFH OBJTY CRID CIM Resource - Entities OBJTY
AFFH OBJID AFFH OBJID CRID CIM Resource - Entities OBJID
AFFH OBJNR AFFH MANDT ONR00 General Object Number MANDT
AFFH OBJNR AFFH OBJNR ONR00 General Object Number OBJNR
AFFH PLNTY_KEY AFFH MANDT TCA01 Task list types MANDT
AFFH PLNTY_KEY AFFH PLNTY_KEY TCA01 Task list types PLNTY
AFFH STEUF AFFH MANDT TCF10 PRT control key MANDT
AFFH STEUF AFFH STEUF TCF10 PRT control key STEUF
AFFH TXTSP AFFH TXTSP T002 Language Keys (Component BC-I18) SPRAS