AFVUI SAP (Include structure of the user fields of the operation) Structure details

Dictionary Type: Structure
Description: Include structure of the user fields of the operation




ABAP Code to SELECT data from AFVUI
Related tables to AFVUI
Access table AFVUI




Structure field list including key, data, relationships and ABAP select examples

AFVUI is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Include structure of the user fields of the operation" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_AFVUI TYPE AFVUI.

The AFVUI table consists of various fields, each holding specific information or linking keys about Include structure of the user fields of the operation data available in SAP. These include USR00 (User field with 20 characters), USR01 (User field with 20 characters), USR02 (User field with 10 characters), USR03 (User field with 10 characters).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP AFVUI structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
SLWIDKey word ID for user-defined fields SLWIDCHAR7TCN00SLWID
USR00User field with 20 characters USRCHAR20CHAR20USRCHAR20
USR01User field with 20 characters USRCHAR20CHAR20USRCHAR20
USR02User field with 10 characters USRCHAR10CHAR10USRCHAR10
USR03User field with 10 characters USRCHAR10CHAR10USRCHAR10
USR04User field for quantity (length 10.3) USRQUAN13QUAN13(3) USRQUAN13
USE04User field: Unit for quantity fields USRUNITUNIT3T006CUNITMEINS
USR05User field for quantity (length 10.3) USRQUAN13QUAN13(3) USRQUAN13
USE05User field: Unit for quantity fields USRUNITUNIT3T006CUNITMEINS
USR06User-defined field for values (length 10,3) USRCURR13CURR13(3) USRCURR13
USE06User field: Unit for value fields USRCUKYCUKY5TCURCWAERS
USR07User-defined field for values (length 10,3) USRCURR13CURR13(3) USRCURR13
USE07User field: Unit for value fields USRCUKYCUKY5TCURCWAERS
USR08User field for date USRDATEDATS8USRDATE
USR09User field for date USRDATEDATS8USRDATE
USR10User-defined field: Indicator for reports USRFLAGCHAR1FLAG
USR11User-defined field: Indicator for reports USRFLAGCHAR1FLAG
VNAMEJoint Venture JV_NAMECHAR6T8JVALPHAJV_NAMEJVV
RECIDRecovery Indicator JV_RECINDCHAR2T8JJALPHAJV_RECIND
ETYPEEquity type JV_ETYPECHAR3T8JGALPHAJV_ETYPE
JV_OTYPEJoint Venture Object Type JV_OTYPECHAR4ALPHAJV_OTYPE
JV_JIBCLJIB/JIBE Class JV_JIBCLCHAR3T8J6AJV_JIBCLJIB
JV_JIBSAJIB/JIBE Subclass A JV_JIBSACHAR5T8J6CJV_JIBSAJBS
JV_OCOJV original cost object JV_OR_COCHAR1JV_OR_COB
DUMMY_CI_AFVUSingle-Character Indicator CHAR1CHAR1CHAR1
SPARAMETER1Scheduling Parameters for External Scheduling SPARAMETERCHAR4
SPARAMETER2Scheduling Parameters for External Scheduling SPARAMETERCHAR4
SPARAMETER3Scheduling Parameters for External Scheduling SPARAMETERCHAR4
.INCLU--AP 0
/MRSS/ID_PROFILERequirements Profile Was Changed Manually /MRSS/T_REQU_UPDCHAR1/MRSS/_HCM_BOOLEAN
/MRSS/PROF_KEYProfile Key /MRSS/T_RSG_REQUIDCHAR10ALPHA/MRSS/RSG_REQUID
/MRSS/PROF_GUIDCharacter field, length 32 CHAR32CHAR32CHAR32
/MRSS/ACT_TYPEProcess variant /MRSS/T_ACTIVITY_TYPECHAR1/MRSS/_ACTIVITY_TYPE
/MRSS/ORDER_PROBOrder probability in percent /MRSS/T_ORDER_PROBCHAR3OPROB/MRSS/_ORDER_PROB
/MRSS/INIT_DONEInternal initialization carried out once /MRSS/T_INIT_DONECHAR1FLAG
/MRSS/DATACHANGEData was changed in the controls on the user screen /MRSS/T_USCREENCTL_DATACHANGEDCHAR1FLAG
/MRSS/DEM_COUNTCounter for Demands in Operation /MRSS/T_DEM_COUNTNUMC4NUMC4
/MRSS/SUPERV_CNTNumber of Site Supervisors /MRSS/T_RAP_SUPERVISOR_COUNTCHAR2ALPHA/MRSS/_RAP_SUPERVISOR_COUNT
/MRSS/RULE_IDTime Rule Id /MRSS/T_RSG_TIME_RULE_IDCHAR25TEXT25
/MRSS/SALES_ORGSales Organization VKORGCHAR4Assigned to domainVKORGVKOC_VKORG
/MRSS/REFF_RCNTDetermination of Remaining Demand: No. of Resources /MRSS/T_REM_EFFORT_RES_COUNTNUMC3NUMC3
/MRSS/REFF_E_BEGTime stamp: start /MRSS/T_TIMESTAMP_BEGINNUMC14TSTLC/MRSS/_TIMESTAMP
/MRSS/REFF_E_ENDTime stamp: end /MRSS/T_TIMESTAMP_ENDNUMC14TSTLC/MRSS/_TIMESTAMP
/MRSS/REFF_L_BEGTime stamp: start /MRSS/T_TIMESTAMP_BEGINNUMC14TSTLC/MRSS/_TIMESTAMP
/MRSS/REFF_L_ENDTime stamp: end /MRSS/T_TIMESTAMP_ENDNUMC14TSTLC/MRSS/_TIMESTAMP
/MRSS/RELEVANTOperation Set as MRS-Relevant /MRSS/T_RELEVANT_FOR_MRSCHAR1FLAG
/MRSS/TEAM_PLANTeam Planning flag for Demand /MRSS/T_RSG_TEAM_PLANNINGCHAR1/MRSS/_RSG_TEAM_PLANNING
/MRSS/SINGL_RESIndicator for Forcing a Single Resource /MRSS/T_RSG_FORCE_SINGLE_RESCHAR1/MRSS/_BOOLEAN
/MRSS/TO_BEGDATField of type DATS DATSDATS8DATS
/MRSS/TO_BEGTIMField of type TIMS TIMSTIMS6TIME
/MRSS/TO_ENDDATField of type DATS DATSDATS8DATS
/MRSS/TO_ENDTIMField of type TIMS TIMSTIMS6TIME
/MRSS/TO_DURATCharacter Field Length = 10 CHAR10CHAR10CHAR10
/MRSS/TO_DUNITBase Unit of Measure MEINSUNIT3Assigned to domainCUNITMEINS
/MRSS/TO_DISTAN19 Characters CHAR19CHAR19CHAR19
/MRSS/TO_MANUALBoolean Variable /MRSS/T_RSG_BOOLEANCHAR1/MRSS/_RSG_BOOLEAN
/MRSS/FR_BEGDATField of type DATS DATSDATS8DATS
/MRSS/FR_BEGTIMField of type TIMS TIMSTIMS6TIME
/MRSS/FR_ENDDATField of type DATS DATSDATS8DATS
/MRSS/FR_ENDTIMField of type TIMS TIMSTIMS6TIME
/MRSS/FR_DURATCharacter Field Length = 10 CHAR10CHAR10CHAR10
/MRSS/FR_DUNITBase Unit of Measure MEINSUNIT3Assigned to domainCUNITMEINS
/MRSS/FR_DISTAN19 Characters CHAR19CHAR19CHAR19
/MRSS/FR_MANUALBoolean Variable /MRSS/T_RSG_BOOLEANCHAR1/MRSS/_RSG_BOOLEAN
.INCLU--AP 0
ILART_OPMaintenance activity type ILACHAR3Assigned to domainILARTH_T350I
.INCLU--AP 0
FERC_INDRegulatory indicator FE_INDCHAR4FERC_C7ALPHAFE_IND

Key field Non-key field



How do I retrieve data from SAP structure AFVUI using ABAP code?

As AFVUI is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on AFVUI as there is no data to select.

How to access SAP table AFVUI

Within an ECC or HANA version of SAP you can also view further information about AFVUI and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!