SAP table AFVU (DB structure of the user fields of the operation)
SAP table AFVU has 3 primary key fields being MANDT,AUFPL,APLZL.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| AUFPL | Routing number of operations in the order | NUMC | 10 | 0 | CO_AUFPL | ||
| APLZL | General counter for order | NUMC | 8 | 0 | AFVC | CO_APLZL | |
| SLWID | Key word ID for user-defined fields | CHAR | 7 | 0 | TCN00 | SLWID | |
| USR00 | User field with 20 characters | CHAR | 20 | 0 | USRCHAR20 | ||
| USR01 | User field with 20 characters | CHAR | 20 | 0 | USRCHAR20 | ||
| USR02 | User Field with 10 Characters | CHAR | 10 | 0 | USRCHAR10 | ||
| USR03 | User Field with 10 Characters | CHAR | 10 | 0 | USRCHAR10 | ||
| USR04 | User field for quantity (length 10.3) | QUAN | 13 | 3 | USRQUAN13 | ||
| USE04 | User field: Unit for quantity fields | UNIT | 3 | 0 | T006 | USRUNIT | |
| USR05 | User field for quantity (length 10.3) | QUAN | 13 | 3 | USRQUAN13 | ||
| USE05 | User field: Unit for quantity fields | UNIT | 3 | 0 | T006 | USRUNIT | |
| USR06 | User-defined field for values (length 10,3) | CURR | 13 | 3 | USRCURR13 | ||
| USE06 | User field: Unit for value fields | CUKY | 5 | 0 | TCURC | USRCUKY | |
| USR07 | User-defined field for values (length 10,3) | CURR | 13 | 3 | USRCURR13 | ||
| USE07 | User field: Unit for value fields | CUKY | 5 | 0 | TCURC | USRCUKY | |
| USR08 | User field for date | DATS | 8 | 0 | USRDATE | ||
| USR09 | User field for date | DATS | 8 | 0 | USRDATE | ||
| USR10 | User-defined field: Indicator for reports | CHAR | 1 | 0 | USRFLAG | ||
| USR11 | User-defined field: Indicator for reports | CHAR | 1 | 0 | USRFLAG | ||
| VNAME | Joint venture | CHAR | 6 | 0 | T8JV | JV_NAME | |
| RECID | Recovery Indicator | CHAR | 2 | 0 | T8JJ | JV_RECIND | |
| ETYPE | Equity type | CHAR | 3 | 0 | T8JG | JV_ETYPE | |
| JV_OTYPE | Joint Venture Object Type | CHAR | 4 | 0 | JV_OTYPE | ||
| JV_JIBCL | JIB/JIBE Class | CHAR | 3 | 0 | T8J6A | JV_JIBCL | |
| JV_JIBSA | JIB/JIBE Subclass A | CHAR | 5 | 0 | T8J6C | JV_JIBSA | |
| JV_OCO | JV original cost object | CHAR | 1 | 0 | JV_OR_CO | ||
| DUMMY_AFVU_INCL_EEW_PS | Custom Fields: Dummy for Use in Extension Includes | CHAR | 1 | 0 | CFD_DUMMY | ||
| SPARAMETER1 | Scheduling Parameters for External Scheduling | CHAR | 4 | 0 | TSCHEDULEPARAM1 | SPARAMETER | |
| SPARAMETER2 | Scheduling Parameters for External Scheduling | CHAR | 4 | 0 | TSCHEDULEPARAM2 | SPARAMETER | |
| SPARAMETER3 | Scheduling Parameters for External Scheduling | CHAR | 4 | 0 | TSCHEDULEPARAM3 | SPARAMETER | |
| ILART_OP | Maintenance activity type | CHAR | 3 | 0 | ILA | ||
| FERC_IND | Regulatory indicator | CHAR | 4 | 0 | FERC_C7 | FE_IND |
AFVU foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 AFVU | APLZL | AFVC | Operation within an order | AUFPL |
| 0 AFVU | APLZL | AFVC | Operation within an order | APLZL |
| 1 AFVU | ETYPE | T8JG | Valid Investment Group | MANDT |
| 1 AFVU | ETYPE | T8JG | Valid Investment Group | BUKRS |
| 1 AFVU | ETYPE | T8JG | Valid Investment Group | VNAME |
| 1 AFVU | ETYPE | T8JG | Valid Investment Group | FDATE |
| 0 AFVU | FERC_IND | FERC_C7 | Regulatory indicators | MANDT |
| 0 AFVU | FERC_IND | FERC_C7 | Regulatory indicators | IND |
| 1 AFVU | JV_JIBCL | T8J6A | JIB/JIBE Class | MANDT |
| 1 AFVU | JV_JIBCL | T8J6A | JIB/JIBE Class | BUKRS |
| 1 AFVU | JV_JIBCL | T8J6A | JIB/JIBE Class | CLASS |
| 0 AFVU | JV_JIBSA | T8J6C | JIB/JIBE Subclass | MANDT |
| 0 AFVU | JV_JIBSA | T8J6C | JIB/JIBE Subclass | BUKRS |
| 1 AFVU | MANDT | T000 | Clients | MANDT |
| 0 AFVU | RECID | T8JJ | Recovery Indicator | MANDT |
| 0 AFVU | RECID | T8JJ | Recovery Indicator | BUKRS |
| 1 AFVU | SLWID | TCN00 | Key Word ID for PS User Fields | MANDT |
| 0 AFVU | SPARAMETER1 | TSCHEDULEPARAM1 | Scheduling Parameter 1 | SPARAMETER |
| 1 AFVU | SPARAMETER2 | TSCHEDULEPARAM2 | Scheduling Parameter 2 | SPARAMETER |
| 0 AFVU | SPARAMETER3 | TSCHEDULEPARAM3 | Scheduling Parameter 3 | SPARAMETER |
| 1 AFVU | USE04 | T006 | Units of Measurement | MANDT |
| 0 AFVU | USE05 | T006 | Units of Measurement | MANDT |
| 1 AFVU | USE06 | TCURC | Currency Codes | MANDT |
| 1 AFVU | USE06 | TCURC | Currency Codes | WAERS |
| 0 AFVU | USE07 | TCURC | Currency Codes | MANDT |
| 0 AFVU | USE07 | TCURC | Currency Codes | WAERS |
| 1 AFVU | VNAME | T8JV | Joint Venture | MANDT |
| 1 AFVU | VNAME | T8JV | Joint Venture | BUKRS |
| 1 AFVU | VNAME | T8JV | Joint Venture | VNAME |