SAP AFVU DB structure of the user fields of the operation Table
Overview
AFVU is a standard SAP S/4HANA table that stores DB structure of the user fields of the operation data. There are total 29 fields in the AFVU table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table AFVU belongs to Production Orders (PP-SFC) module and is located in the package Application Development ERP PP Production Orders (CO).
In addition, following links provide an overview of foreign key relationships, if any, that link AFVU to other SAP tables and standard CDS views available based on AFVU table in S/4HANA 2020.
Techincal Settings of AFVU
Below are technical details of the table AFVU
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of AFVU Fields
The following table gives you an overview of the fields available in AFVU
| 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 | |
| APLZL | General counter for order | CO_APLZL | AFVC | NUMC | 8 |
| SLWID | Key word ID for user-defined fields | SLWID | TCN00 | CHAR | 7 |
| USR00 | User field with 20 characters | USRCHAR20 | CHAR | 20 | |
| USR01 | User field with 20 characters | USRCHAR20 | CHAR | 20 | |
| USR02 | User field with 10 characters | USRCHAR10 | CHAR | 10 | |
| USR03 | User field with 10 characters | USRCHAR10 | CHAR | 10 | |
| USR04 | User field for quantity (length 10.3) | USRQUAN13 | QUAN | 13 | |
| USE04 | User field: Unit for quantity fields | USRUNIT | T006 | UNIT | 3 |
| USR05 | User field for quantity (length 10.3) | USRQUAN13 | QUAN | 13 | |
| USE05 | User field: Unit for quantity fields | USRUNIT | T006 | UNIT | 3 |
| USR06 | User-defined field for values (length 10,3) | USRCURR13 | CURR | 13 | |
| USE06 | User field: Unit for value fields | USRCUKY | TCURC | CUKY | 5 |
| USR07 | User-defined field for values (length 10,3) | USRCURR13 | CURR | 13 | |
| USE07 | User field: Unit for value fields | USRCUKY | TCURC | CUKY | 5 |
| USR08 | User field for date | USRDATE | DATS | 8 | |
| USR09 | User field for date | USRDATE | DATS | 8 | |
| USR10 | User-defined field: Indicator for reports | USRFLAG | CHAR | 1 | |
| USR11 | User-defined field: Indicator for reports | USRFLAG | CHAR | 1 | |
| VNAME | Joint venture | JV_NAME | T8JV | CHAR | 6 |
| RECID | Recovery Indicator | JV_RECIND | T8JJ | CHAR | 2 |
| ETYPE | Equity type | JV_ETYPE | T8JG | CHAR | 3 |
| JV_OTYPE | Joint Venture Object Type | JV_OTYPE | CHAR | 4 | |
| JV_JIBCL | JIB/JIBE Class | JV_JIBCL | T8J6A | CHAR | 3 |
| JV_JIBSA | JIB/JIBE Subclass A | JV_JIBSA | T8J6C | CHAR | 5 |
| JV_OCO | JV original cost object | JV_OR_CO | CHAR | 1 | |
| ILART_OP | Maintenance activity type | ILA | CHAR | 3 | |
| FERC_IND | Regulatory indicator | FE_IND | FERC_C7 | 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 AFVU
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| AFVU | APLZL | 1: 1 | AFVC |
| AFVU | ETYPE | : | T8JG |
| AFVU | FERC_IND | : | FERC_C7 |
| AFVU | JV_JIBCL | : | T8J6A |
| AFVU | JV_JIBSA | 1: CN | T8J6C |
| AFVU | MANDT | : | T000 |
| AFVU | RECID | : | T8JJ |
| AFVU | SLWID | : | TCN00 |
| AFVU | SPARAMETER1 | : | TSCHEDULEPARAM1 |
| AFVU | SPARAMETER2 | : | TSCHEDULEPARAM2 |
| AFVU | SPARAMETER3 | : | TSCHEDULEPARAM3 |
| AFVU | USE04 | : | T006 |
| AFVU | USE05 | : | T006 |
| AFVU | USE06 | : | TCURC |
| AFVU | USE07 | : | TCURC |
| AFVU | VNAME | : | T8JV |