1. Home
  2. Resources
  3. SAP Tables
  4. AFVU - DB structure of the user fields of the operation

SAP Table AFVU

DB structure of the user fields of the operation

AFVU (DB structure of the user fields of the operation) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link AFVU to other SAP tables.

AFVU table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
AUFPL Routing number of operations in the order CO_AUFPL NUMC 10 0
APLZL General counter for order CO_APLZL AFVC NUMC 8 0
SLWID Key word ID for user-defined fields SLWID TCN00 CHAR 7 0
USR00 User field with 20 characters USRCHAR20 CHAR 20 0
USR01 User field with 20 characters USRCHAR20 CHAR 20 0
USR02 User field with 10 characters USRCHAR10 CHAR 10 0
USR03 User field with 10 characters USRCHAR10 CHAR 10 0
USR04 User field for quantity (length 10.3) USRQUAN13 QUAN 13 3
USE04 User field: Unit for quantity fields USRUNIT T006 UNIT 3 0
USR05 User field for quantity (length 10.3) USRQUAN13 QUAN 13 3
USE05 User field: Unit for quantity fields USRUNIT T006 UNIT 3 0
USR06 User-defined field for values (length 10,3) USRCURR13 CURR 13 3
USE06 User field: Unit for value fields USRCUKY TCURC CUKY 5 0
USR07 User-defined field for values (length 10,3) USRCURR13 CURR 13 3
USE07 User field: Unit for value fields USRCUKY TCURC CUKY 5 0
USR08 User field for date USRDATE DATS 8 0
USR09 User field for date USRDATE DATS 8 0
USR10 User-defined field: Indicator for reports USRFLAG CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
USR11 User-defined field: Indicator for reports USRFLAG CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
VNAME Joint Venture JV_NAME T8JV CHAR 6 0
RECID Recovery Indicator JV_RECIND T8JJ CHAR 2 0
ETYPE Equity type JV_ETYPE T8JG CHAR 3 0
JV_OTYPE Joint Venture Object Type JV_OTYPE CHAR 4 0
JV_JIBCL JIB/JIBE Class JV_JIBCL T8J6A CHAR 3 0
JV_JIBSA JIB/JIBE Subclass A JV_JIBSA T8J6C CHAR 5 0
JV_OCO JV original cost object JV_OR_CO CHAR 1 0
P object type for projects
O object type for orders
C object type for costcenters
NULL object type for current object
DUMMY_CI_AFVU Single-Character Indicator CHAR1 CHAR 1 0
SPARAMETER1 Scheduling Parameters for External Scheduling SPARAMETER TSCHEDULEPARAM1 CHAR 4 0
SPARAMETER2 Scheduling Parameters for External Scheduling SPARAMETER TSCHEDULEPARAM2 CHAR 4 0
SPARAMETER3 Scheduling Parameters for External Scheduling SPARAMETER TSCHEDULEPARAM3 CHAR 4 0
/MRSS/ID_PROFILE Requirements Profile Was Changed Manually /MRSS/T_REQU_UPD CHAR 1 0
NULL FALSE
X TRUE
/MRSS/PROF_KEY Profile Key /MRSS/T_RSG_REQUID CHAR 10 0
/MRSS/PROF_GUID Character field, length 32 CHAR32 CHAR 32 0
/MRSS/ACT_TYPE Process variant /MRSS/T_ACTIVITY_TYPE CHAR 1 0
NULL Not Relevant to Resource Planning
1 Contact person process
2 Resource planner process
3 Background Resource Planning Process
/MRSS/ORDER_PROB Order probability in percent /MRSS/T_ORDER_PROB CHAR 3 0
/MRSS/INIT_DONE Internal initialization carried out once /MRSS/T_INIT_DONE CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
/MRSS/DATACHANGE Data was changed in the controls on the user screen /MRSS/T_USCREENCTL_DATACHANGED CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
/MRSS/DEM_COUNT Counter for Demands in Operation /MRSS/T_DEM_COUNT NUMC 4 0
/MRSS/SUPERV_CNT Number of Site Supervisors /MRSS/T_RAP_SUPERVISOR_COUNT CHAR 2 0
/MRSS/RULE_ID Time Rule Id /MRSS/T_RSG_TIME_RULE_ID CHAR 25 0
/MRSS/SALES_ORG Sales Organization VKORG CHAR 4 0
/MRSS/REFF_RCNT Determination of Remaining Demand: No. of Resources /MRSS/T_REM_EFFORT_RES_COUNT NUMC 3 0
/MRSS/REFF_E_BEG Time stamp: start /MRSS/T_TIMESTAMP_BEGIN NUMC 14 0
/MRSS/REFF_E_END Time stamp: end /MRSS/T_TIMESTAMP_END NUMC 14 0
/MRSS/REFF_L_BEG Time stamp: start /MRSS/T_TIMESTAMP_BEGIN NUMC 14 0
/MRSS/REFF_L_END Time stamp: end /MRSS/T_TIMESTAMP_END NUMC 14 0
/MRSS/RELEVANT Operation Set as MRS-Relevant /MRSS/T_RELEVANT_FOR_MRS CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
/MRSS/TEAM_PLAN Team Planning flag for Demand /MRSS/T_RSG_TEAM_PLANNING CHAR 1 0
NULL FALSE
X TRUE
/MRSS/SINGL_RES Indicator for Forcing a Single Resource /MRSS/T_RSG_FORCE_SINGLE_RES CHAR 1 0
NULL FALSE
X TRUE
/MRSS/TO_BEGDAT Field of type DATS DATS DATS 8 0
/MRSS/TO_BEGTIM Field of type TIMS TIMS TIMS 6 0
/MRSS/TO_ENDDAT Field of type DATS DATS DATS 8 0
/MRSS/TO_ENDTIM Field of type TIMS TIMS TIMS 6 0
/MRSS/TO_DURAT Character Field Length = 10 CHAR10 CHAR 10 0
/MRSS/TO_DUNIT Base Unit of Measure MEINS UNIT 3 0
/MRSS/TO_DISTAN 19 Characters CHAR19 CHAR 19 0
/MRSS/TO_MANUAL Boolean Variable /MRSS/T_RSG_BOOLEAN CHAR 1 0
NULL FALSE
X TRUE
/MRSS/FR_BEGDAT Field of type DATS DATS DATS 8 0
/MRSS/FR_BEGTIM Field of type TIMS TIMS TIMS 6 0
/MRSS/FR_ENDDAT Field of type DATS DATS DATS 8 0
/MRSS/FR_ENDTIM Field of type TIMS TIMS TIMS 6 0
/MRSS/FR_DURAT Character Field Length = 10 CHAR10 CHAR 10 0
/MRSS/FR_DUNIT Base Unit of Measure MEINS UNIT 3 0
/MRSS/FR_DISTAN 19 Characters CHAR19 CHAR 19 0
/MRSS/FR_MANUAL Boolean Variable /MRSS/T_RSG_BOOLEAN CHAR 1 0
NULL FALSE
X TRUE
ILART_OP Maintenance activity type ILA CHAR 3 0
FERC_IND Regulatory indicator FE_IND FERC_C7 CHAR 4 0

AFVU foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
AFVU APLZL AFVU MANDT AFVC Operation within an order MANDT
AFVU APLZL AFVU AUFPL AFVC Operation within an order AUFPL
AFVU APLZL AFVU APLZL AFVC Operation within an order APLZL
AFVU ETYPE AFVU VNAME T8JG Valid Investment Group VNAME
AFVU ETYPE AFVU ETYPE T8JG Valid Investment Group ETYPE
AFVU ETYPE * T8JG Valid Investment Group FDATE
AFVU ETYPE SYST MANDT T8JG Valid Investment Group MANDT
AFVU ETYPE GJV_OBJDAT BUKRS T8JG Valid Investment Group BUKRS
AFVU FERC_IND SYST MANDT FERC_C7 Regulatory indicators MANDT
AFVU FERC_IND AFVU FERC_IND FERC_C7 Regulatory indicators IND
AFVU JV_JIBCL SYST MANDT T8J6A JIB/JIBE Class MANDT
AFVU JV_JIBCL GJV_OBJDAT BUKRS T8J6A JIB/JIBE Class BUKRS
AFVU JV_JIBCL AFVU JV_JIBCL T8J6A JIB/JIBE Class CLASS
AFVU JV_JIBSA GJV_OBJDAT BUKRS T8J6C JIB/JIBE Subclass BUKRS
AFVU JV_JIBSA AFVU JV_JIBCL T8J6C JIB/JIBE Subclass CLASS
AFVU JV_JIBSA AFVU JV_JIBSA T8J6C JIB/JIBE Subclass SUBCLASS
AFVU JV_JIBSA SYST MANDT T8J6C JIB/JIBE Subclass MANDT
AFVU MANDT AFVU MANDT T000 Clients MANDT
AFVU RECID AFVU RECID T8JJ Recovery Indicator RECID
AFVU RECID SYST MANDT T8JJ Recovery Indicator MANDT
AFVU RECID GJV_OBJDAT BUKRS T8JJ Recovery Indicator BUKRS
AFVU SLWID AFVUK MANDT TCN00 Key Word ID for PS User Fields MANDT
AFVU SLWID AFVU SLWID TCN00 Key Word ID for PS User Fields SLWID
AFVU SPARAMETER1 AFVU SPARAMETER1 TSCHEDULEPARAM1 Scheduling Parameter 1 SPARAMETER
AFVU SPARAMETER1 AFVU MANDT TSCHEDULEPARAM1 Scheduling Parameter 1 MANDT
AFVU SPARAMETER2 AFVU MANDT TSCHEDULEPARAM2 Scheduling Parameter 2 MANDT
AFVU SPARAMETER2 AFVU SPARAMETER2 TSCHEDULEPARAM2 Scheduling Parameter 2 SPARAMETER
AFVU SPARAMETER3 AFVU MANDT TSCHEDULEPARAM3 Scheduling Parameter 3 MANDT
AFVU SPARAMETER3 AFVU SPARAMETER3 TSCHEDULEPARAM3 Scheduling Parameter 3 SPARAMETER
AFVU USE04 AFVGI MANDT T006 Units of Measurement MANDT
AFVU USE04 AFVU USE04 T006 Units of Measurement MSEHI
AFVU USE05 AFVGI MANDT T006 Units of Measurement MANDT
AFVU USE05 AFVU USE05 T006 Units of Measurement MSEHI
AFVU USE06 AFVKI MANDT TCURC Currency Codes MANDT
AFVU USE06 AFVU USE06 TCURC Currency Codes WAERS
AFVU USE07 AFVKI MANDT TCURC Currency Codes MANDT
AFVU USE07 AFVU USE07 TCURC Currency Codes WAERS
AFVU VNAME SYST MANDT T8JV Joint Venture MANDT
AFVU VNAME GJV_OBJDAT BUKRS T8JV Joint Venture BUKRS
AFVU VNAME AFVU VNAME T8JV Joint Venture VNAME