AFVV - DB structure of the quantities/dates/values in the operation

DB structure of the quantities/dates/values in the operation information is stored in SAP table AFVV.
It is part of development package CO in software component PP-SFC. This development package consists of objects that can be grouped under "Application Development ERP PP Production Orders".

Fields for table AFVV

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
MANDTClientXMANDTCLNT6T000
AUFPLRouting number of operations in the orderXCO_AUFPLNUMC20
APLZLGeneral counter for orderXCO_APLZLNUMC16AFVC
.INCLUDEAFVVI0
MEINHUnit of measure for activityVORMEUNIT6T006
UMRENDenominator for Converting Routing and Operation UoMCP_UMRENDEC3
UMREZNumerator for Converting Routing and Operation UoMCP_UMREZDEC3
BMSCHBase QuantityBMSCHQUAN7
VGE01Unit of Measurement of Standard ValueVGWRTEHUNIT6T006
VGW01Standard ValueVGWRTQUAN5
VGE02Unit of Measurement of Standard ValueVGWRTEHUNIT6T006
VGW02Standard ValueVGWRTQUAN5
VGE03Unit of Measurement of Standard ValueVGWRTEHUNIT6T006
VGW03Standard ValueVGWRTQUAN5
VGE04Unit of Measurement of Standard ValueVGWRTEHUNIT6T006
VGW04Standard ValueVGWRTQUAN5
VGE05Unit of Measurement of Standard ValueVGWRTEHUNIT6T006
VGW05Standard ValueVGWRTQUAN5
VGE06Unit of Measurement of Standard ValueVGWRTEHUNIT6T006
VGW06Standard ValueVGWRTQUAN5
MINWEMinimum Send-Ahead QuantityMINWEIQUAN7
PLIFZPlanned Delivery Time in DaysPLIFZDEC2
DAUNONormal duration of the activityDAUNORQUAN3
DAUNENormal duration/unitDAUNOREUNIT6T006
DAUMIMinimum activity durationDAUMINQUAN3
DAUMEUnit for the minimum durationDAUMINEUNIT6T006
EINSAConstraint on the basic start date for the activityEINSCHRACHAR2
EINSEConstraint on the finish date of the activityEINSCHRECHAR2
ARBEIWork involved in the activityARBEITQUAN4
ARBEHUnit for workARBEITEUNIT6T006
MGVRGOperation Total QuantityMGVRGQUAN7
ASVRGOperation Planned Scrap QuantityASVRGQUAN7
LMNGATotal Confirmed YieldLMNGAQUAN7
XMNGATotal Scrap Quantity ConfirmedXMNGAQUAN7
GMNGAConfirmed yield in order unit of measureGMNGAQUAN7
ISM01Already Confirmed ActivityCO_RUMNGQUAN7
ISM02Already Confirmed ActivityCO_RUMNGQUAN7
ISM03Already Confirmed ActivityCO_RUMNGQUAN7
ISM04Already Confirmed ActivityCO_RUMNGQUAN7
ISM05Already Confirmed ActivityCO_RUMNGQUAN7
ISM06Already Confirmed ActivityCO_RUMNGQUAN7
ISMNWActual workCO_ISMNWQUAN7
FSAVDEarliest scheduled start: Execution (date)FSAVDDATS16
FSAVZEarliest scheduled start: Execution (time)FSAVZTIMS12
FSSBDEarliest scheduled start: Processing (date)FSSBDDATS16
FSSBZEarliest Scheduled Start: Processing (Time)FSSBZTIMS12
FSSADEarliest scheduled start: Teardown (date)FSSADDATS16
FSSAZEarliest Scheduled Start: Teardown (Time)FSSAZTIMS12
FSEDDEarliest scheduled finish: Execution (date)FSEDDDATS16
FSEDZEarliest scheduled finish: Execution (time)FSEDZTIMS12
FSSLDEarliest Scheduled Wait Start DateFSSLDDATS16
FSSLZEarliest Scheduled Wait Start TimeFSSLZTIMS12
FSELDEarliest Scheduled Wait End DateFSELDDATS16
FSELZEarliest Scheduled Wait End TimeFSELZTIMS12
SSAVDLatest scheduled start: Execution (date)SSAVDDATS16
SSAVZLatest scheduled start: Execution (time)SSAVZTIMS12
SSSBDLatest Scheduled Start: Processing (Date)SSSBDDATS16
SSSBZLatest Scheduled Start: Processing (Time)SSSBZTIMS12
SSSADLatest Scheduled Start: Teardown (Date)SSSADDATS16
SSSAZLatest Scheduled Start: Teardown (Time)SSSAZTIMS12
SSEDDLatest scheduled finish: Execution (date)SSEDDDATS16
SSEDZLatest scheduled finish: Execution (time)SSEDZTIMS12
SSSLDLatest Scheduled Wait Start DateSSSLDDATS16
SSSLZLatest Scheduled Wait Start TimeSSSLZTIMS12
SSELDLatest Scheduled Wait End DateSSELDDATS16
SSELZLatest Scheduled Wait End TimeSSELZTIMS12
ISAVDActual Operation Start DateISAVDDATS16
IEAVDActual Operation End DateIEAVDDATS16
ISDDActual Execution Start DateISDDDATS16
ISDZActual Execution Start TimeISDZTIMS12
IERDActual Setup End DateIERDDATS16
IERZActual Setup End TimeIERZTIMS12
ISBDActual Processing Start DateISBDDATS16
ISBZActual Processing Start TimeISBZTIMS12
IEBDActual Processing End DateIEBDDATS16
IEBZActual Processing End TimeIEBZTIMS12
ISADActual Teardown Start DateISADDATS16
ISAZActual Teardown Start TimeISAZTIMS12
IEDDActual Execution End DateIEDDDATS16
IEDZActual Execution End TimeIEDZTIMS12
PEDDForecast finish date of operation from confirmationCO_PEDDDATS16
PEDZForecast End Time of Operation from ConfirmationCO_PEDZTIMS12
PUFFRFree floatPUFFR_FREIDEC2
PUFGSTotal floatPUFFR_GESMDEC2
NTANFConstraint for activity start (Basic)VORGABESTDDATS16
NTANZConstraint for activity start time (Basic)VORGABESTZTIMS12
NTENDConstraint for Finish of Activity (Basic)VORGABEEND2DATS16
NTENZBasic finish time of the activityVORGABEENZTIMS12
EWSTDForecasted start date for the activityEWSTARTDDATS16
EWSTZForecast start time of the activityEWSTARTZTIMS12
EWENDForecast finish dateEWENDEDDATS16
EWENZForecast finish time for the activityEWENDEZTIMS12
EWDANNormal duration (from forecast) of activityEWDANQUAN3
EWDNEUnit for forecast normal durationEWDNEUNIT6T006
EWDAMMinimum duration (from forecast) for activityEWDAMQUAN3
EWDMEUnit for forecast minimum durationEWDMEUNIT6T006
EWSTEForecast date constraint on activity finishPS_RESTECHAR2
EWSTAForecast date constraint on activity startPS_RESTACHAR2
WARTZQueue Time Used for SchedulingWARTEZEITFLTP8
WRTZEUnit of Measure for Queue TimeWTRZEUNIT6
RUESTSetup TimeRUESTFLTP8
RSTZEUnit of Measure for Setup TimeRSTZEUNIT6
BEARZProcessing TimeBEARZEITFLTP8
BEAZEUnit of measure for processing timeBEAZEUNIT6
ABRUETeardownABRUEFLTP8
ARUZEUnit of Measure for TeardownARUZEUNIT6
LIEGZWait Time Used for SchedulingLIEGEZEITFLTP8
LIGZEUnit of Measure for Wait TimeLIGZEUNIT6
TRANZMove Time used for SchedulingTRANSZEITFLTP8
TRAZEUnit of Measure for Move TimeTRAZEUNIT6
ISERHConfirmed Break TimeISERHQUAN5
OFM01Forecast Value for Updating of Standard ValueCO_SCHAETZQUAN5
OFM02Forecast Value for Updating of Standard ValueCO_SCHAETZQUAN5
OFM03Forecast Value for Updating of Standard ValueCO_SCHAETZQUAN5
OFM04Forecast Value for Updating of Standard ValueCO_SCHAETZQUAN5
OFM05Forecast Value for Updating of Standard ValueCO_SCHAETZQUAN5
OFM06Forecast Value for Updating of Standard ValueCO_SCHAETZQUAN5
OFMNWForecasted work (actual + remaining)OFMNWQUAN4
BZOFFBReference Date for Start of Sub-OperationCP_OBZOFFBCHAR4TCA54
EHOFFBUnit for Offset to StartCP_OEHOFFBUNIT6T006
OFFSTBOffset to sub-operation startCP_OOFFSTBQUAN3
OFFSTEOffset to sub-operation finishCP_OOFFSTEQUAN3
BZOFFEReference Date for Finish of Sub-OperationCP_OBZOFFECHAR4TCA54
EHOFFEUnit for Offset to FinishCP_OEHOFFEUNIT6T006
FPAVDEarliest scheduled start date (forecast)FPAVDDATS16
FPAVZEarliest scheduled start time (forecast)FPAVZTIMS12
FPEDDEarliest scheduled finish date (forecast)FPEDDDATS16
FPEDZEarliest scheduled finish time (forecast)FPEDZTIMS12
SPAVDLatest scheduled start date (forecast)SPAVDDATS16
SPAVZLatest scheduled start time (forecast)SPAVZTIMS12
SPEDDLatest scheduled finish date (forecast)SPEDDDATS16
SPEDZLatest scheduled finish time (forecast)SPEDZTIMS12
BEAZPUnit of processing time (Forecast)BEAZEPUNIT6
PUFGPTotal float (from forecast)PPUFF_GESMDEC2
PUFFPFree float (from forecast)PPUFF_FREIDEC2
BEARPProcessing time (forecast)PBEARZEITFLTP8
EPANFDispatched start date for operationEPANFDATS16
EPANZDispatched start time for operationEPANZTIMS12
EPENDDispatched finish dateEPENDDATS16
EPENZDispatched finish timeEPENZTIMS12
PDAUForecasted duration of activity from confirmationPDAUQUAN3
PDAEUnit of the forecasted duration from the confirmationPDAEUNIT6T006
KNOTETransportation Connection PointsKNOTECHAR20TVKN
VSTZWDeadline functionVSTZWCHAR8TVTZ
VSTGADeadline deviation reasonVSTGACHAR8TVTG
QRASTZEHTTime UnitQRASTZEHTUNIT6*
QRASTZFAKTime FactorQRASTZFAKDEC3
QRASTMENGQuantity Between Two InspectionsQRASTMENGQUAN7
QRASTEREHGrid Unit of MeasureQRASTEREHUNIT6*
AUFKTExecution FactorAFAKTDEC2
RMNGATotal Confirmed Rework QuantityRMNGAQUAN7
ILE01Unit of measure for the activity to be confirmedCO_ISMNGEHUNIT6*
ILE02Unit of measure for the activity to be confirmedCO_ISMNGEHUNIT6*
ILE03Unit of measure for the activity to be confirmedCO_ISMNGEHUNIT6*
ILE04Unit of measure for the activity to be confirmedCO_ISMNGEHUNIT6*
ILE05Unit of measure for the activity to be confirmedCO_ISMNGEHUNIT6*
ILE06Unit of measure for the activity to be confirmedCO_ISMNGEHUNIT6*
RWFAKRework factor (is not used yet)RWFAKDEC3
IPRZ1Confirmed Quantity/Activity for Business ProcessCO_IPRZSQUAN7
IPRE1Unit of Measure for Business Process QuantityRU_IPRZEUNIT6*
IPRK1No Remaining Quantity Expected for Business ProcessRU_IPRZKCHAR2
TAKTtakt within a line segmentLD_TAKTNUMC8
OPRZ1Remaining Quantity for Business ProcessOPRZ1QUAN7
OPRE1Unit for Remaining Quantity of Business ProcessOPRE1UNIT6*
PSPM_INDICATORIndicates PMCS date influence activity schedulingPSPM_INDICATORCHAR2
Privacy Policy