AFVV

DB structure of the quantities/dates/values in the operation | #transactional | Component: Production Orders
Column Name Description
MANDT FK Client
AUFPL Routing number of operations in the order
APLZL FK General counter for order
Column Name Description
Column Name Description
📏 Unit of measure for activity (MEINH):
BMSCH Base Quantity
MINWE Minimum Send-Ahead Quantity
MGVRG Operation Total Quantity
ASVRG Operation Planned Scrap Quantity
LMNGA Total Confirmed Yield
XMNGA Total Scrap Quantity Confirmed
GMNGA Confirmed yield in order unit of measure
RMNGA Total Confirmed Rework Quantity
📏 Unit for a Break Time (ZEIER):
ZMERH Break Time
ISERH Confirmed Break Time
📏 Unit of Measurement of Standard Value (VGE01):
VGW01 Standard Value
OFM01 Forecast Value for Updating of Standard Value
📏 Unit of Measurement of Standard Value (VGE02):
VGW02 Standard Value
OFM02 Forecast Value for Updating of Standard Value
📏 Unit of Measurement of Standard Value (VGE03):
VGW03 Standard Value
OFM03 Forecast Value for Updating of Standard Value
📏 Unit of Measurement of Standard Value (VGE04):
VGW04 Standard Value
OFM04 Forecast Value for Updating of Standard Value
📏 Unit of Measurement of Standard Value (VGE05):
VGW05 Standard Value
OFM05 Forecast Value for Updating of Standard Value
📏 Unit of Measurement of Standard Value (VGE06):
VGW06 Standard Value
OFM06 Forecast Value for Updating of Standard Value
📏 Unit for the Minimum Overlap Time (ZEIMU):
ZMINU Minimum Overlap Time
📏 Unit for the Minimum Processing Time (ZEIMB):
ZMINB Minimum Processing Time
📏 Unit for the Maximum Wait Time (ZEILM):
ZLMAX Maximum Wait Time
📏 Unit for the Required Wait Time (ZEILP):
ZLPRO Minimum Wait Time
📏 Unit for the Standard Queue Time (ZEIWN):
ZWNOR Standard Queue Time
📏 Unit for the Minimum Queue Time (ZEIWM):
ZWMIN Minimum Queue Time
📏 Unit for the standard move time (ZEITN):
ZTNOR Standard Move Time
📏 Unit for the minimum move time (ZEITM):
ZTMIN Minimum Move Time
📏 Normal duration/unit (DAUNE):
DAUNO Normal duration of the activity
📏 Unit for the minimum duration (DAUME):
DAUMI Minimum activity duration
📏 Unit for work (ARBEH):
ARBEI Work involved in the activity
ISMNW Actual work
OFMNW Forecasted work (actual + remaining)
📏 Unit of measure for the activity to be confirmed (ILE01):
ISM01 Already Confirmed Activity
📏 Unit of measure for the activity to be confirmed (ILE02):
ISM02 Already Confirmed Activity
📏 Unit of measure for the activity to be confirmed (ILE03):
ISM03 Already Confirmed Activity
📏 Unit of measure for the activity to be confirmed (ILE04):
ISM04 Already Confirmed Activity
📏 Unit of measure for the activity to be confirmed (ILE05):
ISM05 Already Confirmed Activity
📏 Unit of measure for the activity to be confirmed (ILE06):
ISM06 Already Confirmed Activity
📏 Unit for forecast normal duration (EWDNE):
EWDAN Normal duration (from forecast) of activity
📏 Unit for forecast minimum duration (EWDME):
EWDAM Minimum duration (from forecast) for activity
📏 Unit for Offset to Start (EHOFFB):
OFFSTB Offset to sub-operation start
OFFSTE Offset to sub-operation finish
📏 Unit of the forecasted duration from the confirmation (PDAE):
PDAU Forecasted duration of activity from confirmation
📏 Grid Unit of Measure (QRASTEREH):
QRASTMENG Quantity Between Two Inspections
📏 Unit of Measure for Business Process Quantity (IPRE1):
IPRZ1 Confirmed Quantity/Activity for Business Process
📏 Unit for Remaining Quantity of Business Process (OPRE1):
OPRZ1 Remaining Quantity for Business Process
Column Name Description
FSAVD Earliest scheduled start: Execution (date)
FSAVZ Earliest scheduled start: Execution (time)
FSSBD Earliest scheduled start: Processing (date)
FSSBZ Earliest Scheduled Start: Processing (Time)
FSSAD Earliest scheduled start: Teardown (date)
FSSAZ Earliest Scheduled Start: Teardown (Time)
FSEDD Earliest scheduled finish: Execution (date)
FSEDZ Earliest scheduled finish: Execution (time)
FSSLD Earliest Scheduled Wait Start Date
FSSLZ Earliest Scheduled Wait Start Time
FSELD Earliest Scheduled Wait End Date
FSELZ Earliest Scheduled Wait End Time
SSAVD Latest scheduled start: Execution (date)
SSAVZ Latest scheduled start: Execution (time)
SSSBD Latest Scheduled Start: Processing (Date)
SSSBZ Latest Scheduled Start: Processing (Time)
SSSAD Latest Scheduled Start: Teardown (Date)
SSSAZ Latest Scheduled Start: Teardown (Time)
SSEDD Latest scheduled finish: Execution (date)
SSEDZ Latest scheduled finish: Execution (time)
SSSLD Latest Scheduled Wait Start Date
SSSLZ Latest Scheduled Wait Start Time
SSELD Latest Scheduled Wait End Date
SSELZ Latest Scheduled Wait End Time
ISAVD Actual Operation Start Date
IEAVD Actual Operation End Date
ISDD Actual Execution Start Date
ISDZ Actual Execution Start Time
IERD Actual Setup End Date
IERZ Actual Setup End Time
ISBD Actual Processing Start Date
ISBZ Actual Processing Start Time
IEBD Actual Processing End Date
IEBZ Actual Processing End Time
ISAD Actual Teardown Start Date
ISAZ Actual Teardown Start Time
IEDD Actual Execution End Date
IEDZ Actual Execution End Time
PEDD Forecast finish date of operation from confirmation
PEDZ Forecast End Time of Operation from Confirmation
NTANF Constraint for activity start (Basic)
NTANZ Constraint for activity start time (Basic)
NTEND Constraint for Finish of Activity (Basic)
NTENZ Basic finish time of the activity
EWSTD Forecasted start date for the activity
EWSTZ Forecast start time of the activity
EWEND Forecast finish date
EWENZ Forecast finish time for the activity
FPAVD Earliest scheduled start date (forecast)
FPAVZ Earliest scheduled start time (forecast)
FPEDD Earliest scheduled finish date (forecast)
FPEDZ Earliest scheduled finish time (forecast)
SPAVD Latest scheduled start date (forecast)
SPAVZ Latest scheduled start time (forecast)
SPEDD Latest scheduled finish date (forecast)
SPEDZ Latest scheduled finish time (forecast)
EPANF Dispatched start date for operation
EPANZ Dispatched start time for operation
EPEND Dispatched finish date
EPENZ Dispatched finish time
Column Name Description
EINSA Constraint on the basic start date for the activity Show values
EINSE Constraint on the finish date of the activity Show values
EWSTE Forecast date constraint on activity finish Show values
EWSTA Forecast date constraint on activity start Show values
IPRK1 No Remaining Quantity Expected for Business Process Show values
Column Name Description Domain name
UMREN Denominator for Converting Routing and Operation UoM UMBSN
UMREZ Numerator for Converting Routing and Operation UoM UMBSZ
PLIFZ Planned Delivery Time in Days DEC3
PUFFR Free float PUFFER
PUFGS Total float PUFFER
WARTZ Queue Time Used for Scheduling CX_ZEIT
RUEST Setup Time CX_ZEIT
BEARZ Processing Time CX_ZEIT
ABRUE Teardown CX_ZEIT
LIEGZ Wait Time Used for Scheduling CX_ZEIT
TRANZ Move Time used for Scheduling CX_ZEIT
PUFGP Total float (from forecast) PUFFER
PUFFP Free float (from forecast) PUFFER
BEARP Processing time (forecast) CX_ZEIT
QRASTZFAK Time Factor QPROBEFAK
AUFKT Execution Factor AFAKT
RWFAK Rework factor (is not used yet) AUSCHUFAK
TAKT takt within a line segment LD_TAKT
PSPM_INDICATOR Indicates PMCS date influence activity scheduling PSPM_INDICATOR
Master Data Relations Join Conditions
Unit for work
  • AFVV.MANDT == T006.MANDT
  • AFVV.ARBEH == T006.MSEHI
Reference Date for Start of Sub-Operation AFVV.BZOFFB == TCA54.BZOFF
Reference Date for Finish of Sub-Operation AFVV.BZOFFE == TCA54.BZOFF
Unit for the minimum duration
  • AFVV.MANDT == T006.MANDT
  • AFVV.DAUME == T006.MSEHI
Normal duration/unit
  • AFVV.MANDT == T006.MANDT
  • AFVV.DAUNE == T006.MSEHI
Unit for Offset to Start
  • AFVV.MANDT == T006.MANDT
  • AFVV.EHOFFB == T006.MSEHI
Unit for Offset to Finish
  • AFVV.MANDT == T006.MANDT
  • AFVV.EHOFFE == T006.MSEHI
Unit for forecast minimum duration
  • AFVV.MANDT == T006.MANDT
  • AFVV.EWDME == T006.MSEHI
Unit for forecast normal duration
  • AFVV.MANDT == T006.MANDT
  • AFVV.EWDNE == T006.MSEHI
Transportation Connection Points
  • Transportation Connection Points
  • Client
  • AFVV.KNOTE == TVKN.KNOTE
  • AFVV.MANDT == TVKN.MANDT
Client AFVV.MANDT == T000.MANDT
Unit of measure for activity
  • AFVV.MANDT == T006.MANDT
  • AFVV.MEINH == T006.MSEHI
Unit of the forecasted duration from the confirmation
  • AFVV.MANDT == T006.MANDT
  • AFVV.PDAE == T006.MSEHI
Unit of Measurement of Standard Value
  • AFVV.MANDT == T006.MANDT
  • AFVV.VGE01 == T006.MSEHI
Unit of Measurement of Standard Value
  • AFVV.MANDT == T006.MANDT
  • AFVV.VGE02 == T006.MSEHI
Unit of Measurement of Standard Value
  • AFVV.MANDT == T006.MANDT
  • AFVV.VGE03 == T006.MSEHI
Unit of Measurement of Standard Value
  • AFVV.MANDT == T006.MANDT
  • AFVV.VGE04 == T006.MSEHI
Unit of Measurement of Standard Value
  • AFVV.MANDT == T006.MANDT
  • AFVV.VGE05 == T006.MSEHI
Unit of Measurement of Standard Value
  • AFVV.MANDT == T006.MANDT
  • AFVV.VGE06 == T006.MSEHI
Deadline deviation reason
  • Deadline deviation reason
  • Client
  • AFVV.VSTGA == TVTG.VSTGA
  • AFVV.MANDT == TVTG.MANDT
Deadline function
  • AFVV.MANDT == TVTZ.MANDT
  • AFVV.VSTZW == TVTZ.VSTZW
Unit for a Break Time
  • AFVV.MANDT == T006.MANDT
  • AFVV.ZEIER == T006.MSEHI
Unit for the Maximum Wait Time
  • AFVV.MANDT == T006.MANDT
  • AFVV.ZEILM == T006.MSEHI
Unit for the Required Wait Time
  • AFVV.MANDT == T006.MANDT
  • AFVV.ZEILP == T006.MSEHI
Unit for the Minimum Processing Time
  • AFVV.MANDT == T006.MANDT
  • AFVV.ZEIMB == T006.MSEHI
Unit for the Minimum Overlap Time
  • AFVV.MANDT == T006.MANDT
  • AFVV.ZEIMU == T006.MSEHI
Unit for the minimum move time
  • AFVV.MANDT == T006.MANDT
  • AFVV.ZEITM == T006.MSEHI
Unit for the standard move time
  • AFVV.MANDT == T006.MANDT
  • AFVV.ZEITN == T006.MSEHI
Unit for the Minimum Queue Time
  • AFVV.MANDT == T006.MANDT
  • AFVV.ZEIWM == T006.MSEHI
Unit for the Standard Queue Time
  • AFVV.MANDT == T006.MANDT
  • AFVV.ZEIWN == T006.MSEHI