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

SAP Table AFVUI

Include structure of the user fields of the operation

AFVUI (Include 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 AFVUI to other SAP tables.

Source: AFVUI (Include structure of the user fields of the operation)

AFVUI table fields

Field Data element Checktable Datatype Length Decimals
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 CHAR 4 0
SPARAMETER2 Scheduling Parameters for External Scheduling SPARAMETER CHAR 4 0
SPARAMETER3 Scheduling Parameters for External Scheduling SPARAMETER 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

AFVUI foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
AFVUI ETYPE * T8JG Valid Investment Group FDATE
AFVUI ETYPE AFVUI ETYPE T8JG Valid Investment Group ETYPE
AFVUI ETYPE AFVUI VNAME T8JG Valid Investment Group VNAME
AFVUI ETYPE GJV_OBJDAT BUKRS T8JG Valid Investment Group BUKRS
AFVUI ETYPE SYST MANDT T8JG Valid Investment Group MANDT
AFVUI FERC_IND AFVUI FERC_IND FERC_C7 Regulatory indicators IND
AFVUI FERC_IND SYST MANDT FERC_C7 Regulatory indicators MANDT
AFVUI JV_JIBCL GJV_OBJDAT BUKRS T8J6A JIB/JIBE Class BUKRS
AFVUI JV_JIBCL SYST MANDT T8J6A JIB/JIBE Class MANDT
AFVUI JV_JIBCL AFVUI JV_JIBCL T8J6A JIB/JIBE Class CLASS
AFVUI JV_JIBSA SYST MANDT T8J6C JIB/JIBE Subclass MANDT
AFVUI JV_JIBSA GJV_OBJDAT BUKRS T8J6C JIB/JIBE Subclass BUKRS
AFVUI JV_JIBSA AFVUI JV_JIBCL T8J6C JIB/JIBE Subclass CLASS
AFVUI JV_JIBSA AFVUI JV_JIBSA T8J6C JIB/JIBE Subclass SUBCLASS
AFVUI RECID SYST MANDT T8JJ Recovery Indicator MANDT
AFVUI RECID GJV_OBJDAT BUKRS T8JJ Recovery Indicator BUKRS
AFVUI RECID AFVUI RECID T8JJ Recovery Indicator RECID
AFVUI SLWID AFVKI MANDT TCN00 Key Word ID for PS User Fields MANDT
AFVUI SLWID AFVUI SLWID TCN00 Key Word ID for PS User Fields SLWID
AFVUI USE04 AFVGI MANDT T006 Units of Measurement MANDT
AFVUI USE04 AFVUI USE04 T006 Units of Measurement MSEHI
AFVUI USE05 AFVGI MANDT T006 Units of Measurement MANDT
AFVUI USE05 AFVUI USE05 T006 Units of Measurement MSEHI
AFVUI USE06 AFVKI MANDT TCURC Currency Codes MANDT
AFVUI USE06 AFVUI USE06 TCURC Currency Codes WAERS
AFVUI USE07 AFVUI USE07 TCURC Currency Codes WAERS
AFVUI USE07 AFVKI MANDT TCURC Currency Codes MANDT
AFVUI VNAME AFVUI VNAME T8JV Joint Venture VNAME
AFVUI VNAME GJV_OBJDAT BUKRS T8JV Joint Venture BUKRS
AFVUI VNAME SYST MANDT T8JV Joint Venture MANDT