SAP AFVVI Include structure of the operation quantities/dates/values Table data and field list

AFVVI 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 operation quantities/dates/values" 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_AFVVI TYPE AFVVI.

The AFVVI table consists of various fields, each holding specific information or linking keys about Include structure of the operation quantities/dates/values data available in SAP. These include UMREN (Denominator for converting rtg and op units of measure), UMREZ (Numerator for converting task list and oper. un. of measure), BMSCH (Base Quantity), ZMERH (Break)... 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. .

AFVVI structure Technical Details:

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


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

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the AFVVI table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MEINHUnit of Measure for Activity/Operation VORMEUNIT3T006CUNITMEINS
UMRENDenominator for converting rtg and op units of measure CP_UMRENDEC5UMBSN
UMREZNumerator for converting task list and oper. un. of measure CP_UMREZDEC5UMBSZ
BMSCHBase Quantity BMSCHQUAN13(3) BMSCH
ZMERHBreak DZMERHQUAN9(3) VGWRT
ZEIERUnit for the break time DZEIERUNIT3T006CUNITMEINS
VGE01Unit of measure for the standard value VGWRTEHUNIT3T006CUNITMEINS
VGW01Standard Value VGWRTQUAN9(3) VGWRT
VGE02Unit of measure for the standard value VGWRTEHUNIT3T006CUNITMEINS
VGW02Standard Value VGWRTQUAN9(3) VGWRT
VGE03Unit of measure for the standard value VGWRTEHUNIT3T006CUNITMEINS
VGW03Standard Value VGWRTQUAN9(3) VGWRT
VGE04Unit of measure for the standard value VGWRTEHUNIT3T006CUNITMEINS
VGW04Standard Value VGWRTQUAN9(3) VGWRT
VGE05Unit of measure for the standard value VGWRTEHUNIT3T006CUNITMEINS
VGW05Standard Value VGWRTQUAN9(3) VGWRT
VGE06Unit of measure for the standard value VGWRTEHUNIT3T006CUNITMEINS
VGW06Standard Value VGWRTQUAN9(3) VGWRT
ZEIMUUnit for the minimum overlap time DZEIMUUNIT3T006CUNITMEINS
ZMINUMinimum overlap time DZMINUQUAN9(3) VGWRT
MINWEMinimum Send-Ahead Quantity MINWEIQUAN13(3) MINWEI
ZEIMBUnit for the minimum processing time DZEIMBUNIT3T006CUNITMEINS
ZMINBMinimum processing time DZMINBQUAN9(3) VGWRT
ZEILMUnit for the maximum wait time DZEILMUNIT3T006CUNITMEINS
ZLMAXMaximum wait time DZLMAXQUAN9(3) VGWRT
ZEILPUnit for the required wait time DZEILPUNIT3T006CUNITMEINS
ZLPROMinimum wait time DZLPROQUAN9(3) VGWRT
ZEIWNUnit for the standard queue time DZEIWNUNIT3T006CUNITMEINS
ZWNORStandard queue time DZWNORQUAN9(3) VGWRT
ZEIWMUnit for the minumum queue time DZEIWMUNIT3T006CUNITMEINS
ZWMINMinimum queue time DZWMINQUAN9(3) VGWRT
ZEITNUnit for the standard move time DZEITNUNIT3T006CUNITMEINS
ZTNORStandard move time DZTNORQUAN9(3) VGWRT
ZEITMUnit for the minimum move time DZEITMUNIT3T006CUNITMEINS
ZTMINMinimum move time DZTMINQUAN9(3) VGWRT
PLIFZPlanned Delivery Time in Days PLIFZDEC3DEC3
DAUNONormal duration of the activity DAUNORQUAN5(1) DAUER_4_1
DAUNENormal duration/unit DAUNOREUNIT3T006CUNITMEINS
DAUMIMinimum activity duration DAUMINQUAN5(1) DAUER_4_1
DAUMEUnit for the minimum duration DAUMINEUNIT3T006CUNITMEINS
EINSAConstraint on the basic start date for the activity EINSCHRACHAR1RESTRIKSTR
EINSEConstraint on the finish date of the activity EINSCHRECHAR1RESTRIKEND
ARBEIWork involved in the activity ARBEITQUAN7(1) ARBEIT
ARBEHUnit for work ARBEITEUNIT3T006CUNITMEINS
MGVRGOperation Quantity MGVRGQUAN13(3) MENG13
ASVRGOperation scrap ASVRGQUAN13(3) MENG13
LMNGATotal Yield Confirmed LMNGAQUAN13(3) MENG13
XMNGATotal scrap quantity confirmed XMNGAQUAN13(3) MENG13
GMNGAConfirmed yield in order unit of measure GMNGAQUAN13(3) MENG13
ISM01Previously confirmed activity CO_RUMNGQUAN13(3) MENGV13
ISM02Previously confirmed activity CO_RUMNGQUAN13(3) MENGV13
ISM03Previously confirmed activity CO_RUMNGQUAN13(3) MENGV13
ISM04Previously confirmed activity CO_RUMNGQUAN13(3) MENGV13
ISM05Previously confirmed activity CO_RUMNGQUAN13(3) MENGV13
ISM06Previously confirmed activity CO_RUMNGQUAN13(3) MENGV13
ISMNWActual work CO_ISMNWQUAN13(3) MENG13
FSAVDEarliest scheduled start: Execution (date) FSAVDDATS8DATUM
FSAVZEarliest scheduled start: Execution (time) FSAVZTIMS6ATIME
FSSBDEarliest scheduled start: Processing (date) FSSBDDATS8DATUM
FSSBZEarliest scheduled start: Processing (time) FSSBZTIMS6ATIME
FSSADEarliest scheduled start: Teardown (date) FSSADDATS8DATUM
FSSAZEarliest scheduled start: Teardown (time) FSSAZTIMS6ATIME
FSEDDEarliest scheduled finish: Execution (date) FSEDDDATS8DATUM
FSEDZEarliest scheduled finish: Execution (time) FSEDZTIMS6ATIME
FSSLDEarliest scheduled start: Wait (date) FSSLDDATS8DATUM
FSSLZEarliest scheduled start: Wait (time) FSSLZTIMS6ATIME
FSELDEarliest scheduled finish: Wait (date) FSELDDATS8DATUM
FSELZEarliest scheduled finish: Wait (time) FSELZTIMS6ATIME
SSAVDLatest scheduled start: Execution (date) SSAVDDATS8DATUM
SSAVZLatest scheduled start: Execution (time) SSAVZTIMS6ATIME
SSSBDLatest scheduled start: Processing (date) SSSBDDATS8DATUM
SSSBZLatest scheduled start: Processing (time) SSSBZTIMS6ATIME
SSSADLatest scheduled start: Teardown (date) SSSADDATS8DATUM
SSSAZLatest scheduled start: Teardown (time) SSSAZTIMS6ATIME
SSEDDLatest scheduled finish: Execution (date) SSEDDDATS8DATUM
SSEDZLatest scheduled finish: Execution (time) SSEDZTIMS6ATIME
SSSLDLatest scheduled start: Wait time (date) SSSLDDATS8DATUM
SSSLZLatest scheduled start: Wait time SSSLZTIMS6ATIME
SSELDLatest scheduled finish: Wait time (date) SSELDDATS8DATUM
SSELZLatest scheduled finish: Wait time SSELZTIMS6ATIME
ISAVDActual operation start (date) ISAVDDATS8DATUM
IEAVDActual finish of operation (date) IEAVDDATS8DATUM
ISDDActual start: Execution (date) ISDDDATS8DATUM
ISDZActual start: Execution/setup (time) ISDZTIMS6ATIME
IERDActual finish: Setup (date) IERDDATS8DATUM
IERZActual finish: Setup (time) IERZTIMS6ATIME
ISBDActual start: Processing (date) ISBDDATS8DATUM
ISBZActual start: Processing (time) ISBZTIMS6ATIME
IEBDActual finish: Processing (date) IEBDDATS8DATUM
IEBZActual processing finish (time) IEBZTIMS6ATIME
ISADActual start: Teardown (date) ISADDATS8DATUM
ISAZActual start: Teardown (time) ISAZTIMS6ATIME
IEDDActual finish: Execution (date) IEDDDATS8DATUMEDR
IEDZActual finish: Execution (time) IEDZTIMS6ATIMEEZR
PEDDForecast finish date of operation from confirmation CO_PEDDDATS8DATUM
PEDZForecast finish time of operation from confirmation CO_PEDZTIMS6ATIME
PUFFRFree float PUFFR_FREIDEC3PUFFER
PUFGSTotal float PUFFR_GESMDEC3PUFFER
NTANFConstraint for activity start (Basic) VORGABESTDDATS8VORGABESTR
NTANZConstraint for activity start time (Basic) VORGABESTZTIMS6ATIME
NTENDConstraint for Finish of Activity (Basic) VORGABEEND2DATS8VORGABEEND
NTENZBasic finish time of the activity VORGABEENZTIMS6ATIME
EWSTDForecasted start date for the activity EWSTARTDDATS8DATUM
EWSTZForecast start time of the activity EWSTARTZTIMS6ATIME
EWENDForecast finish date EWENDEDDATS8DATUM
EWENZForecast finish time for the activity EWENDEZTIMS6ATIME
EWDANNormal duration (from forecast) of activity EWDANQUAN5(1) DAUER_4_1
EWDNEUnit for forecast normal duration EWDNEUNIT3T006CUNITMEINS
EWDAMMinimum duration (from forecast) for activity EWDAMQUAN5(1) DAUER_4_1
EWDMEUnit for forecast minimum duration EWDMEUNIT3T006CUNITMEINS
EWSTEForecast date constraint on activity finish PS_RESTECHAR1RESTRIKEND
EWSTAForecast date constraint on activity start PS_RESTACHAR1RESTRIKSTR
WARTZQueue time used for scheduling WARTEZEITFLTP16(16) CX_ZEIT
WRTZEUnit of measure for queue time WTRZEUNIT3CUNITEINHEIT
RUESTSetup time RUESTFLTP16(16) CX_ZEIT
RSTZEUnit of measure for setup time RSTZEUNIT3CUNITEINHEIT
BEARZProcessing time BEARZEITFLTP16(16) CX_ZEIT
BEAZEUnit of measure for processing time BEAZEUNIT3CUNITEINHEIT
ABRUETeardown ABRUEFLTP16(16) CX_ZEIT
ARUZEUnit of measure for teardown ARUZEUNIT3CUNITEINHEIT
LIEGZWait time used for scheduling LIEGEZEITFLTP16(16) CX_ZEIT
LIGZEUnit of measure for wait time LIGZEUNIT3CUNITEINHEIT
TRANZMove time used for scheduling TRANSZEITFLTP16(16) CX_ZEIT
TRAZEUnit of measure for move time TRAZEUNIT3CUNITEINHEIT
ISERHConfirmed break time ISERHQUAN9(3) VGWRT
OFM01Forecast value used to update the standard value CO_SCHAETZQUAN9(3) VGWRT
OFM02Forecast value used to update the standard value CO_SCHAETZQUAN9(3) VGWRT
OFM03Forecast value used to update the standard value CO_SCHAETZQUAN9(3) VGWRT
OFM04Forecast value used to update the standard value CO_SCHAETZQUAN9(3) VGWRT
OFM05Forecast value used to update the standard value CO_SCHAETZQUAN9(3) VGWRT
OFM06Forecast value used to update the standard value CO_SCHAETZQUAN9(3) VGWRT
OFMNWForecasted work (actual + remaining) OFMNWQUAN7(1) ARBEIT
BZOFFBReference date for start of sub-operation CP_OBZOFFBCHAR2TCA54CP_BZOFF
EHOFFBUnit for offset to start CP_OEHOFFBUNIT3T006CUNITMEINS
OFFSTBOffset to sub-operation start CP_OOFFSTBQUAN5VNZTV
OFFSTEOffset to sub-operation finish CP_OOFFSTEQUAN5VNZTV
BZOFFEReference date for finish of sub-operation CP_OBZOFFECHAR2TCA54CP_BZOFF
EHOFFEUnit for offset to finish CP_OEHOFFEUNIT3T006CUNITMEINS
FPAVDEarliest scheduled start date (forecast) FPAVDDATS8DATUM
FPAVZEarliest scheduled start time (forecast) FPAVZTIMS6ATIME
FPEDDEarliest scheduled finish date (forecast) FPEDDDATS8DATUM
FPEDZEarliest scheduled finish time (forecast) FPEDZTIMS6ATIME
SPAVDLatest scheduled start date (forecast) SPAVDDATS8DATUM
SPAVZLatest scheduled start time (forecast) SPAVZTIMS6ATIME
SPEDDLatest scheduled finish date (forecast) SPEDDDATS8DATUM
SPEDZLatest scheduled finish time (forecast) SPEDZTIMS6ATIME
BEAZPUnit of processing time (Forecast) BEAZEPUNIT3CUNITEINHEIT
PUFGPTotal float (from forecast) PPUFF_GESMDEC3PUFFER
PUFFPFree float (from forecast) PPUFF_FREIDEC3PUFFER
BEARPProcessing time (forecast) PBEARZEITFLTP16(16) CX_ZEIT
EPANFDispatched start date for operation EPANFDATS8DATUM
EPANZDispatched start time for operation EPANZTIMS6ATIME
EPENDDispatched finish date EPENDDATS8DATUM
EPENZDispatched finish time EPENZTIMS6ATIME
PDAUForecasted duration of activity from confirmation PDAUQUAN5(1) DAUER_4_1
PDAEUnit of the forecasted duration from the confirmation PDAEUNIT3T006CUNITMEINS
KNOTETransportation Connection Points KNOTECHAR10TVKNKNOTN
VSTZWDeadline function VSTZWCHAR4TVTZVSTZW
VSTGADeadline deviation reason VSTGACHAR4TVTGVSTGA
QRASTZEHTTime Unit QRASTZEHTUNIT3Assigned to domainCUNITMEINS
QRASTZFAKTime Factor QRASTZFAKDEC5(2) QPROBEFAK
QRASTMENGQuantity Between Two Inspections QRASTMENGQUAN13(3) MENG13
QRASTEREHGrid Unit of Measure QRASTEREHUNIT3Assigned to domainCUNITMEINS
AUFKTExecution Factor AFAKTDEC3AFAKT
RMNGATotal confirmed rework quantity RMNGAQUAN13(3) MENGV13
ILE01Unit of measure for the activity to be confirmed CO_ISMNGEHUNIT3Assigned to domainCUNITMEINS
ILE02Unit of measure for the activity to be confirmed CO_ISMNGEHUNIT3Assigned to domainCUNITMEINS
ILE03Unit of measure for the activity to be confirmed CO_ISMNGEHUNIT3Assigned to domainCUNITMEINS
ILE04Unit of measure for the activity to be confirmed CO_ISMNGEHUNIT3Assigned to domainCUNITMEINS
ILE05Unit of measure for the activity to be confirmed CO_ISMNGEHUNIT3Assigned to domainCUNITMEINS
ILE06Unit of measure for the activity to be confirmed CO_ISMNGEHUNIT3Assigned to domainCUNITMEINS
RWFAKRework factor (is not used yet) RWFAKDEC5(3) AUSCHUFAK
IPRZ1Confirmed quantity/work for business process CO_IPRZSQUAN13(3) MENGV13
IPRE1Unit of measurement for conf. quantity for business process RU_IPRZEUNIT3Assigned to domainCUNITMEINS
IPRK1No remaining quantity expected for business process RU_IPRZKCHAR1XFELD
TAKTtakt within a line segment LD_TAKTNUMC4LD_TAKT
OPRZ1Remaining quantity for business process OPRZ1QUAN13(3) MENGV13
OPRE1Unit for remaining quantity of business process OPRE1UNIT3Assigned to domainCUNITMEINS
PSPM_INDICATORIndicates PMCS date influence activity scheduling PSPM_INDICATORCHAR1PSPM_INDICATOR

Key field Non-key field



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

As AFVVI 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 AFVVI as there is no data to select.

How to access SAP table AFVVI

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

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