SAP VSAFFH_CN Version: PRT allocation to work order Table
Overview
VSAFFH_CN is a standard SAP S/4HANA table that stores Version: PRT allocation to work order data. There are total 71 fields in the VSAFFH_CN table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VSAFFH_CN belongs to Simulation (PS-SIM) module and is located in the package R/3 Application development: Version Management (CNVS).
In addition, following links provide an overview of foreign key relationships, if any, that link VSAFFH_CN to other SAP tables and standard CDS views available based on VSAFFH_CN table in S/4HANA 2020.
Techincal Settings of VSAFFH_CN
Below are technical details of the table VSAFFH_CN
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VSAFFH_CN Fields
The following table gives you an overview of the fields available in VSAFFH_CN
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT | 3 | |
| VSNMR | Number or description of a version | VSNMR | CHAR | 12 | |
| 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 | |
| ORGAUFPL | Routing number of operations in the order | CO_AUFPL | NUMC | 10 | |
| ORGPZLFH | Item Counter for Production Resources/Tools | PZLFH | NUMC | 8 |
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 VSAFFH_CN
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VSAFFH_CN | BZOFFB | C: CN | TCA54 |
| VSAFFH_CN | BZOFFE | C: CN | TCA54 |
| VSAFFH_CN | DAUEH | C: CN | T006 |
| VSAFFH_CN | EHOFFB | C: CN | T006 |
| VSAFFH_CN | EHOFFE | C: CN | T006 |
| VSAFFH_CN | EWEINH | C: CN | T006 |
| VSAFFH_CN | EWFORM | C: CN | TC25 |
| VSAFFH_CN | EWISTEH | C: CN | T006 |
| VSAFFH_CN | EWRSTEH | C: CN | T006 |
| VSAFFH_CN | EWSOLEH | C: CN | T006 |
| VSAFFH_CN | KTSCH | C: CN | T435 |
| VSAFFH_CN | MGAUSEH | C: CN | T006 |
| VSAFFH_CN | MGEINH | 1: CN | T006 |
| VSAFFH_CN | MGFORM | C: CN | TC25 |
| VSAFFH_CN | MGISTEH | C: CN | T006 |
| VSAFFH_CN | MGRSTEH | C: CN | T006 |
| VSAFFH_CN | MGSOLEH | C: CN | T006 |
| VSAFFH_CN | OBJID | 1: CN | CRID |
| VSAFFH_CN | OBJNR | 1: CN | ONR00 |
| VSAFFH_CN | PLNTY_KEY | C: CN | TCA01 |
| VSAFFH_CN | STEUF | 1: CN | TCF10 |
| VSAFFH_CN | TXTSP | C: CN | T002 |