SAP AFFH PRT assignment data for the work order Table
Overview
AFFH is a standard SAP S/4HANA table that stores PRT assignment data for the work order data. There are total 68 fields in the AFFH table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table AFFH belongs to Production Resources/Tools (PP-BD-PRT) module and is located in the package R/3 Appl. development: PPS production resources/tools (CF).
In addition, following links provide an overview of foreign key relationships, if any, that link AFFH to other SAP tables and standard CDS views available based on AFFH table in S/4HANA 2020.
Techincal Settings of AFFH
Below are technical details of the table AFFH
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of AFFH Fields
The following table gives you an overview of the fields available in AFFH
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| AUFPL | Routing number of operations in the order | CO_AUFPL | NUMC | 10 | |
| PZLFH | Item Counter for Production Resources/Tools | PZLFH | NUMC | 8 | |
| 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 | Date of Last Change | 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 | CRID | NUMC | 8 |
| PLNTY_KEY | Task List Type | PLNTY | TCA01 | CHAR | 1 |
| 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 | ONR00 | CHAR | 22 |
| STEUF | Control Profile for Management of Production Resources/Tools | STEUF | TCF10 | CHAR | 4 |
| KZKBL | Indicator: Create load records for prod. resources/tools | KZKBL | CHAR | 1 | |
| BZOFFB | Reference Date for Start of Production Resource/Tool Usage | BZOFFB | TCA54 | CHAR | 2 |
| OFFSTB | Offset to start of production resource/tool usage | OFFSTB | QUAN | 5 | |
| EHOFFB | Offset Unit for Start of Prodn Resource/Tool Usage | EHOFFB | T006 | UNIT | 3 |
| BZOFFE | Reference date for end of production resource/tool usage | BZOFFE | TCA54 | CHAR | 2 |
| OFFSTE | Offset to finish of production resource/tool usage | OFFSTE | QUAN | 5 | |
| EHOFFE | Offset Unit for End of Production Resource/Tool Usage | EHOFFE | T006 | UNIT | 3 |
| 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 End 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 End Date for 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 end date of PRT usage | CF_IEFHD | DATS | 8 | |
| IEFHZ | Actual end time of PRT usage | CF_IEFHZ | TIMS | 6 | |
| DAUFL | Duration of PRT Usage | CF_DAUFL | FLTP | 16 | |
| DAUEH | Unit for Duration of PRT Usage | CF_DAUEH | T006 | UNIT | 3 |
| MGEINH | Unit for Quantity of Production Resources/Tools | MGEINH | T006 | UNIT | 3 |
| MGVGW | Standard Value for Quantity of Production Resources/Tools | MGVGW | QUAN | 9 | |
| MGSOLEH | Unit for Quantity of Production Resources/Tools | MGEINH | T006 | UNIT | 3 |
| MGSOL | Total Planned Quantity of Production Resource/Tool | MGSOL | QUAN | 9 | |
| MGISTEH | Unit for Quantity of Production Resources/Tools | MGEINH | T006 | UNIT | 3 |
| MGIST | Actual Quantity of Production Resource/Tool | MGIST | QUAN | 9 | |
| MGRSTEH | Unit for Quantity of Production Resources/Tools | MGEINH | T006 | UNIT | 3 |
| MGRST | Remaining Quantity of the Production Resource/Tool | MGRST | QUAN | 9 | |
| MGAUSEH | Unit for Quantity of Production Resources/Tools | MGEINH | T006 | UNIT | 3 |
| MGAUS | Quantity of checked-out production resources/tools | MGAUS | QUAN | 9 | |
| MGFORM | Formula for Calculating the Total Quantity of PRT | CF_MGFORM | TC25 | CHAR | 6 |
| EWEINH | Usage Value Unit of the Production Resource/Tool | EWEINH | T006 | UNIT | 3 |
| EWVGW | Standard Usage Value for Production Resources/Tools | EWVGW | QUAN | 9 | |
| EWSOLEH | Usage Value Unit of the Production Resource/Tool | EWEINH | T006 | UNIT | 3 |
| EWSOL | Total Planned Usage Value of Production Resource/Tool | EWSOL | QUAN | 9 | |
| EWISTEH | Usage Value Unit of the Production Resource/Tool | EWEINH | T006 | UNIT | 3 |
| EWIST | Actual Usage Value for Production Resource/Tool | EWIST | QUAN | 9 | |
| EWRSTEH | Usage Value Unit of the Production Resource/Tool | EWEINH | T006 | UNIT | 3 |
| EWRST | Remaining Usage Value of the Production Resource/Tool | EWRST | QUAN | 9 | |
| EWFORM | Formula for Calculating the Total Usage Value of PRT | CF_EWFORM | TC25 | CHAR | 6 |
| TXTSP | Language Key | SPRAS | T002 | LANG | 1 |
| KTSCH | Standard Text Key for Production Resources/Tools | CF_KTSCH | T435 | CHAR | 7 |
| 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 |
| PRT_VERSN | Routing Version | PLNVERSN | CHAR | 4 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for AFFH
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| AFFH | BZOFFB | C: CN | TCA54 |
| AFFH | BZOFFE | C: CN | TCA54 |
| AFFH | DAUEH | C: CN | T006 |
| AFFH | EHOFFB | C: CN | T006 |
| AFFH | EHOFFE | C: CN | T006 |
| AFFH | EWEINH | C: CN | T006 |
| AFFH | EWFORM | C: CN | TC25 |
| AFFH | EWISTEH | C: CN | T006 |
| AFFH | EWRSTEH | C: CN | T006 |
| AFFH | EWSOLEH | C: CN | T006 |
| AFFH | KTSCH | C: CN | T435 |
| AFFH | MANDT | 1: CN | T000 |
| AFFH | MGAUSEH | C: CN | T006 |
| AFFH | MGEINH | 1: CN | T006 |
| AFFH | MGFORM | C: CN | TC25 |
| AFFH | MGISTEH | C: CN | T006 |
| AFFH | MGRSTEH | C: CN | T006 |
| AFFH | MGSOLEH | C: CN | T006 |
| AFFH | OBJID | 1: CN | CRID |
| AFFH | OBJNR | 1: CN | ONR00 |
| AFFH | PLNTY_KEY | C: CN | TCA01 |
| AFFH | STEUF | 1: CN | TCF10 |
| AFFH | TXTSP | C: CN | T002 |