AFFH - PRT assignment data for the work order
PRT assignment data for the work order information is stored in SAP table AFFH.
It is part of development package CF in software component PP-BD-PRT. This development package consists of objects that can be grouped under "R/3 Appl. development: PPS production resources/tools".
It is part of development package CF in software component PP-BD-PRT. This development package consists of objects that can be grouped under "R/3 Appl. development: PPS production resources/tools".
Fields for table AFFH
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | T000 |
| AUFPL | Routing number of operations in the order | X | CO_AUFPL | NUMC | 20 | |
| PZLFH | Item Counter for Production Resources/Tools | X | PZLFH | NUMC | 16 | |
| .INCLUDE | AFFH_INC | 0 | ||||
| LOEKZ | Deletion Indicator | LKENZ | CHAR | 2 | ||
| PARKZ | Indicator: inactive changes | PARKZ | CHAR | 2 | ||
| DATUI | Date Record Created On | ANDAT | DATS | 16 | ||
| USERI | User who created record | ANNAM | CHAR | 24 | ||
| DATUC | Last Changed On | AEDAT | DATS | 16 | ||
| USERC | Name of Person Who Changed Object | AENAM | CHAR | 24 | ||
| OBJTY | Object types of the CIM resource | CR_OBJTY | CHAR | 4 | ||
| OBJID | Object ID of the resource | CR_OBJID | NUMC | 16 | CRID | |
| PLNTY_KEY | Task List Type | PLNTY | CHAR | 2 | TCA01 | |
| PLNNR_KEY | Key for Task List Group | PLNNR | CHAR | 16 | ||
| PZLFH_KEY | Item Counter for Production Resources/Tools | PZLFH | NUMC | 16 | ||
| OBJCT | Object of a task list | OBJCT_D | CHAR | 2 | ||
| APLZL | Internal counter | CIM_COUNT | NUMC | 16 | ||
| PSNFH | Item Number for Production Resource/Tool | PSNFH | NUMC | 8 | ||
| OBJNR | Object number | J_OBJNR | CHAR | 44 | ONR00 | |
| STEUF | Control Profile for Management of Production Resources/Tools | STEUF | CHAR | 8 | TCF10 | |
| KZKBL | Indicator: Create load records for prod. resources/tools | KZKBL | CHAR | 2 | ||
| BZOFFB | Reference Date for Start of Production Resource/Tool Usage | BZOFFB | CHAR | 4 | TCA54 | |
| OFFSTB | Offset to start of production resource/tool usage | OFFSTB | QUAN | 3 | ||
| EHOFFB | Offset Unit for Start of Prodn Resource/Tool Usage | EHOFFB | UNIT | 6 | T006 | |
| BZOFFE | Reference date for end of production resource/tool usage | BZOFFE | CHAR | 4 | TCA54 | |
| OFFSTE | Offset to finish of production resource/tool usage | OFFSTE | QUAN | 3 | ||
| EHOFFE | Offset Unit for End of Production Resource/Tool Usage | EHOFFE | UNIT | 6 | T006 | |
| FSFHD | Earliest Scheduled Start Date for PRT Usage | CF_FSFHD | DATS | 16 | ||
| FSFHZ | Earliest Scheduled Start Time for PRT Usage | CF_FSFHZ | TIMS | 12 | ||
| FEFHD | Earliest Scheduled End Date of PRT Usage | CF_FEFHD | DATS | 16 | ||
| FEFHZ | Earliest Scheduled End Time of PRT Usage | CF_FEFHZ | TIMS | 12 | ||
| SSFHD | Latest Scheduled Start Date for PRT Usage | CF_SSFHD | DATS | 16 | ||
| SSFHZ | Latest Scheduled Start Time for PRT Usage | CF_SSFHZ | TIMS | 12 | ||
| SEFHD | Latest Scheduled End Date for PRT Usage | CF_SEFHD | DATS | 16 | ||
| SEFHZ | Latest Scheduled End Time for PRT Usage | CF_SEFHZ | TIMS | 12 | ||
| ISFHD | Actual start date of PRT usage | CF_ISFHD | DATS | 16 | ||
| ISFHZ | Actual start time of PRT usage | CF_ISFHZ | TIMS | 12 | ||
| IEFHD | Actual end date of PRT usage | CF_IEFHD | DATS | 16 | ||
| IEFHZ | Actual end time of PRT usage | CF_IEFHZ | TIMS | 12 | ||
| DAUFL | Duration of PRT Usage | CF_DAUFL | FLTP | 8 | ||
| DAUEH | Unit for Duration of PRT Usage | CF_DAUEH | UNIT | 6 | T006 | |
| MGEINH | Unit for Quantity of Production Resources/Tools | MGEINH | UNIT | 6 | T006 | |
| MGVGW | Standard Value for Quantity of Production Resources/Tools | MGVGW | QUAN | 5 | ||
| MGSOLEH | Unit for Quantity of Production Resources/Tools | MGEINH | UNIT | 6 | T006 | |
| MGSOL | Total Planned Quantity of Production Resource/Tool | MGSOL | QUAN | 5 | ||
| MGISTEH | Unit for Quantity of Production Resources/Tools | MGEINH | UNIT | 6 | T006 | |
| MGIST | Actual Quantity of Production Resource/Tool | MGIST | QUAN | 5 | ||
| MGRSTEH | Unit for Quantity of Production Resources/Tools | MGEINH | UNIT | 6 | T006 | |
| MGRST | Remaining Quantity of the Production Resource/Tool | MGRST | QUAN | 5 | ||
| MGAUSEH | Unit for Quantity of Production Resources/Tools | MGEINH | UNIT | 6 | T006 | |
| MGAUS | Quantity of checked-out production resources/tools | MGAUS | QUAN | 5 | ||
| MGFORM | Formula for Calculating the Total Quantity of PRT | CF_MGFORM | CHAR | 12 | TC25 | |
| EWEINH | Usage Value Unit of the Production Resource/Tool | EWEINH | UNIT | 6 | T006 | |
| EWVGW | Standard Usage Value for Production Resources/Tools | EWVGW | QUAN | 5 | ||
| EWSOLEH | Usage Value Unit of the Production Resource/Tool | EWEINH | UNIT | 6 | T006 | |
| EWSOL | Total Planned Usage Value of Production Resource/Tool | EWSOL | QUAN | 5 | ||
| EWISTEH | Usage Value Unit of the Production Resource/Tool | EWEINH | UNIT | 6 | T006 | |
| EWIST | Actual Usage Value for Production Resource/Tool | EWIST | QUAN | 5 | ||
| EWRSTEH | Usage Value Unit of the Production Resource/Tool | EWEINH | UNIT | 6 | T006 | |
| EWRST | Remaining Usage Value of the Production Resource/Tool | EWRST | QUAN | 5 | ||
| EWFORM | Formula for Calculating the Total Usage Value of PRT | CF_EWFORM | CHAR | 12 | TC25 | |
| TXTSP | Language Key | SPRAS | LANG | 2 | T002 | |
| KTSCH | Standard Text Key for Production Resources/Tools | CF_KTSCH | CHAR | 14 | T435 | |
| TXTZ1 | First Line of Text for Production Resources/Tools | TXTZ1 | CHAR | 80 | ||
| OBJTYPE | Change indicator | OCM_OBJ_TYPE | CHAR | 2 | ||
| CH_PROC | Process that has lead to the change of an object | OCM_CH_PROC | CHAR | 2 | ||
| AENNR | Change Number | AENNR | CHAR | 24 | * | |
| PRT_VERSN | Routing Version | PLNVERSN | CHAR | 8 | ||
| REGISTRABLE | Specifies that the PRT can be Registered in Execution | MPE_PRT_REGISTRABLE | CHAR | 2 |