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

Field Key Data Element Type Offset Leng Decimals Check Table Text
MANDT X MANDT CLNT 0 3 0 T000 Client
AUFPL X CO_AUFPL NUMC 3 10 0 Routing number of operations in the order
APLZL X CO_APLZL NUMC 13 8 0 General counter for order
MEINH VORME UNIT 24 3 0 T006 Unit of Measure for Activity/Operation
UMREN CP_UMREN DEC 27 5 0 Denominator for converting rtg and op units of measure
UMREZ CP_UMREZ DEC 30 5 0 Numerator for converting task list and oper. un. of measure
BMSCH BMSCH QUAN 33 13 3 Base Quantity
ZMERH DZMERH QUAN 40 9 3 Break
ZEIER DZEIER UNIT 45 3 0 T006 Unit for the break time
VGE01 VGWRTEH UNIT 48 3 0 T006 Unit of measure for the standard value
VGW01 VGWRT QUAN 51 9 3 Standard Value
VGE02 VGWRTEH UNIT 56 3 0 T006 Unit of measure for the standard value
VGW02 VGWRT QUAN 59 9 3 Standard Value
VGE03 VGWRTEH UNIT 64 3 0 T006 Unit of measure for the standard value
VGW03 VGWRT QUAN 67 9 3 Standard Value
VGE04 VGWRTEH UNIT 72 3 0 T006 Unit of measure for the standard value
VGW04 VGWRT QUAN 75 9 3 Standard Value
VGE05 VGWRTEH UNIT 80 3 0 T006 Unit of measure for the standard value
VGW05 VGWRT QUAN 83 9 3 Standard Value
VGE06 VGWRTEH UNIT 88 3 0 T006 Unit of measure for the standard value
VGW06 VGWRT QUAN 91 9 3 Standard Value
ZEIMU DZEIMU UNIT 96 3 0 T006 Unit for the minimum overlap time
ZMINU DZMINU QUAN 99 9 3 Minimum overlap time
MINWE MINWEI QUAN 104 13 3 Minimum Send-Ahead Quantity
ZEIMB DZEIMB UNIT 111 3 0 T006 Unit for the minimum processing time
ZMINB DZMINB QUAN 114 9 3 Minimum processing time
ZEILM DZEILM UNIT 119 3 0 T006 Unit for the maximum wait time
ZLMAX DZLMAX QUAN 122 9 3 Maximum wait time
ZEILP DZEILP UNIT 127 3 0 T006 Unit for the required wait time
ZLPRO DZLPRO QUAN 130 9 3 Minimum wait time
ZEIWN DZEIWN UNIT 135 3 0 T006 Unit for the standard queue time
ZWNOR DZWNOR QUAN 138 9 3 Standard queue time
ZEIWM DZEIWM UNIT 143 3 0 T006 Unit for the minumum queue time
ZWMIN DZWMIN QUAN 146 9 3 Minimum queue time
ZEITN DZEITN UNIT 151 3 0 T006 Unit for the standard move time
ZTNOR DZTNOR QUAN 154 9 3 Standard move time
ZEITM DZEITM UNIT 159 3 0 T006 Unit for the minimum move time
ZTMIN DZTMIN QUAN 162 9 3 Minimum move time
PLIFZ PLIFZ DEC 167 3 0 Planned Delivery Time in Days
DAUNO DAUNOR QUAN 169 5 1 Normal duration of the activity
DAUNE DAUNORE UNIT 172 3 0 T006 Normal duration/unit
DAUMI DAUMIN QUAN 175 5 1 Minimum activity duration
DAUME DAUMINE UNIT 178 3 0 T006 Unit for the minimum duration
EINSA EINSCHRA CHAR 181 1 0 Constraint on the basic start date for the activity
EINSE EINSCHRE CHAR 182 1 0 Constraint on the finish date of the activity
ARBEI ARBEIT QUAN 183 7 1 Work involved in the activity
ARBEH ARBEITE UNIT 187 3 0 T006 Unit for work
MGVRG MGVRG QUAN 190 13 3 Operation Quantity
ASVRG ASVRG QUAN 197 13 3 Operation scrap
LMNGA LMNGA QUAN 204 13 3 Total Yield Confirmed
XMNGA XMNGA QUAN 211 13 3 Total scrap quantity confirmed
GMNGA GMNGA QUAN 218 13 3 Confirmed yield in order unit of measure
ISM01 CO_RUMNG QUAN 225 13 3 Previously confirmed activity
ISM02 CO_RUMNG QUAN 232 13 3 Previously confirmed activity
ISM03 CO_RUMNG QUAN 239 13 3 Previously confirmed activity
ISM04 CO_RUMNG QUAN 246 13 3 Previously confirmed activity
ISM05 CO_RUMNG QUAN 253 13 3 Previously confirmed activity
ISM06 CO_RUMNG QUAN 260 13 3 Previously confirmed activity
ISMNW CO_ISMNW QUAN 267 13 3 Actual work
FSAVD FSAVD DATS 274 8 0 Earliest scheduled start: Execution (date)
FSAVZ FSAVZ TIMS 282 6 0 Earliest scheduled start: Execution (time)
FSSBD FSSBD DATS 288 8 0 Earliest scheduled start: Processing (date)
FSSBZ FSSBZ TIMS 296 6 0 Earliest scheduled start: Processing (time)
FSSAD FSSAD DATS 302 8 0 Earliest scheduled start: Teardown (date)
FSSAZ FSSAZ TIMS 310 6 0 Earliest scheduled start: Teardown (time)
FSEDD FSEDD DATS 316 8 0 Earliest scheduled finish: Execution (date)
FSEDZ FSEDZ TIMS 324 6 0 Earliest scheduled finish: Execution (time)
FSSLD FSSLD DATS 330 8 0 Earliest scheduled start: Wait (date)
FSSLZ FSSLZ TIMS 338 6 0 Earliest scheduled start: Wait (time)
FSELD FSELD DATS 344 8 0 Earliest scheduled finish: Wait (date)
FSELZ FSELZ TIMS 352 6 0 Earliest scheduled finish: Wait (time)
SSAVD SSAVD DATS 358 8 0 Latest scheduled start: Execution (date)
SSAVZ SSAVZ TIMS 366 6 0 Latest scheduled start: Execution (time)
SSSBD SSSBD DATS 372 8 0 Latest scheduled start: Processing (date)
SSSBZ SSSBZ TIMS 380 6 0 Latest scheduled start: Processing (time)
SSSAD SSSAD DATS 386 8 0 Latest scheduled start: Teardown (date)
SSSAZ SSSAZ TIMS 394 6 0 Latest scheduled start: Teardown (time)
SSEDD SSEDD DATS 400 8 0 Latest scheduled finish: Execution (date)
SSEDZ SSEDZ TIMS 408 6 0 Latest scheduled finish: Execution (time)
SSSLD SSSLD DATS 414 8 0 Latest scheduled start: Wait time (date)
SSSLZ SSSLZ TIMS 422 6 0 Latest scheduled start: Wait time
SSELD SSELD DATS 428 8 0 Latest scheduled finish: Wait time (date)
SSELZ SSELZ TIMS 436 6 0 Latest scheduled finish: Wait time
ISAVD ISAVD DATS 442 8 0 Actual operation start (date)
IEAVD IEAVD DATS 450 8 0 Actual finish of operation (date)
ISDD ISDD DATS 458 8 0 Actual start: Execution (date)
ISDZ ISDZ TIMS 466 6 0 Actual start: Execution/setup (time)
IERD IERD DATS 472 8 0 Actual finish: Setup (date)
IERZ IERZ TIMS 480 6 0 Actual finish: Setup (time)
ISBD ISBD DATS 486 8 0 Actual start: Processing (date)
ISBZ ISBZ TIMS 494 6 0 Actual start: Processing (time)
IEBD IEBD DATS 500 8 0 Actual finish: Processing (date)
IEBZ IEBZ TIMS 508 6 0 Actual processing finish (time)
ISAD ISAD DATS 514 8 0 Actual start: Teardown (date)
ISAZ ISAZ TIMS 522 6 0 Actual start: Teardown (time)
IEDD IEDD DATS 528 8 0 Actual finish: Execution (date)
IEDZ IEDZ TIMS 536 6 0 Actual finish: Execution (time)
PEDD CO_PEDD DATS 542 8 0 Forecast finish date of operation from confirmation
PEDZ CO_PEDZ TIMS 550 6 0 Forecast finish time of operation from confirmation
PUFFR PUFFR_FREI DEC 556 3 0 Free float
PUFGS PUFFR_GESM DEC 558 3 0 Total float
NTANF VORGABESTD DATS 560 8 0 Constraint for activity start (Basic)
NTANZ VORGABESTZ TIMS 568 6 0 Constraint for activity start time (Basic)
NTEND VORGABEEND2 DATS 574 8 0 Constraint for Finish of Activity (Basic)
NTENZ VORGABEENZ TIMS 582 6 0 Basic finish time of the activity
EWSTD EWSTARTD DATS 588 8 0 Forecasted start date for the activity
EWSTZ EWSTARTZ TIMS 596 6 0 Forecast start time of the activity
EWEND EWENDED DATS 602 8 0 Forecast finish date
EWENZ EWENDEZ TIMS 610 6 0 Forecast finish time for the activity
EWDAN EWDAN QUAN 616 5 1 Normal duration (from forecast) of activity
EWDNE EWDNE UNIT 619 3 0 T006 Unit for forecast normal duration
EWDAM EWDAM QUAN 622 5 1 Minimum duration (from forecast) for activity
EWDME EWDME UNIT 625 3 0 T006 Unit for forecast minimum duration
EWSTE PS_RESTE CHAR 628 1 0 Forecast date constraint on activity finish
EWSTA PS_RESTA CHAR 629 1 0 Forecast date constraint on activity start
WARTZ WARTEZEIT FLTP 632 16 16 Queue time used for scheduling
WRTZE WTRZE UNIT 640 3 0 Unit of measure for queue time
RUEST RUEST FLTP 648 16 16 Setup time
RSTZE RSTZE UNIT 656 3 0 Unit of measure for setup time
BEARZ BEARZEIT FLTP 664 16 16 Processing time
BEAZE BEAZE UNIT 672 3 0 Unit of measure for processing time
ABRUE ABRUE FLTP 680 16 16 Teardown
ARUZE ARUZE UNIT 688 3 0 Unit of measure for teardown
LIEGZ LIEGEZEIT FLTP 696 16 16 Wait time used for scheduling
LIGZE LIGZE UNIT 704 3 0 Unit of measure for wait time
TRANZ TRANSZEIT FLTP 712 16 16 Move time used for scheduling
TRAZE TRAZE UNIT 720 3 0 Unit of measure for move time
ISERH ISERH QUAN 723 9 3 Confirmed break time
OFM01 CO_SCHAETZ QUAN 728 9 3 Forecast value used to update the standard value
OFM02 CO_SCHAETZ QUAN 733 9 3 Forecast value used to update the standard value
OFM03 CO_SCHAETZ QUAN 738 9 3 Forecast value used to update the standard value
OFM04 CO_SCHAETZ QUAN 743 9 3 Forecast value used to update the standard value
OFM05 CO_SCHAETZ QUAN 748 9 3 Forecast value used to update the standard value
OFM06 CO_SCHAETZ QUAN 753 9 3 Forecast value used to update the standard value
OFMNW OFMNW QUAN 758 7 1 Forecasted work (actual + remaining)
BZOFFB CP_OBZOFFB CHAR 762 2 0 TCA54 Reference date for start of sub-operation
EHOFFB CP_OEHOFFB UNIT 764 3 0 T006 Unit for offset to start
OFFSTB CP_OOFFSTB QUAN 767 5 0 Offset to sub-operation start
OFFSTE CP_OOFFSTE QUAN 770 5 0 Offset to sub-operation finish
BZOFFE CP_OBZOFFE CHAR 773 2 0 TCA54 Reference date for finish of sub-operation
EHOFFE CP_OEHOFFE UNIT 775 3 0 T006 Unit for offset to finish
FPAVD FPAVD DATS 778 8 0 Earliest scheduled start date (forecast)
FPAVZ FPAVZ TIMS 786 6 0 Earliest scheduled start time (forecast)
FPEDD FPEDD DATS 792 8 0 Earliest scheduled finish date (forecast)
FPEDZ FPEDZ TIMS 800 6 0 Earliest scheduled finish time (forecast)
SPAVD SPAVD DATS 806 8 0 Latest scheduled start date (forecast)
SPAVZ SPAVZ TIMS 814 6 0 Latest scheduled start time (forecast)
SPEDD SPEDD DATS 820 8 0 Latest scheduled finish date (forecast)
SPEDZ SPEDZ TIMS 828 6 0 Latest scheduled finish time (forecast)
BEAZP BEAZEP UNIT 834 3 0 Unit of processing time (Forecast)
PUFGP PPUFF_GESM DEC 837 3 0 Total float (from forecast)
PUFFP PPUFF_FREI DEC 839 3 0 Free float (from forecast)
BEARP PBEARZEIT FLTP 848 16 16 Processing time (forecast)
EPANF EPANF DATS 856 8 0 Dispatched start date for operation
EPANZ EPANZ TIMS 864 6 0 Dispatched start time for operation
EPEND EPEND DATS 870 8 0 Dispatched finish date
EPENZ EPENZ TIMS 878 6 0 Dispatched finish time
PDAU PDAU QUAN 884 5 1 Forecasted duration of activity from confirmation
PDAE PDAE UNIT 887 3 0 T006 Unit of the forecasted duration from the confirmation
KNOTE KNOTE CHAR 890 10 0 TVKN Transportation Connection Points
VSTZW VSTZW CHAR 900 4 0 Deadline function
VSTGA VSTGA CHAR 904 4 0 TVTG Deadline deviation reason
QRASTZEHT QRASTZEHT UNIT 908 3 0 T006 Time Unit
QRASTZFAK QRASTZFAK DEC 911 5 2 Time Factor
QRASTMENG QRASTMENG QUAN 914 13 3 Quantity Between Two Inspections
QRASTEREH QRASTEREH UNIT 921 3 0 T006 Grid Unit of Measure
AUFKT AFAKT DEC 924 3 0 Execution Factor
RMNGA RMNGA QUAN 926 13 3 Total confirmed rework quantity
ILE01 CO_ISMNGEH UNIT 933 3 0 T006 Unit of measure for the activity to be confirmed
ILE02 CO_ISMNGEH UNIT 936 3 0 T006 Unit of measure for the activity to be confirmed
ILE03 CO_ISMNGEH UNIT 939 3 0 T006 Unit of measure for the activity to be confirmed
ILE04 CO_ISMNGEH UNIT 942 3 0 T006 Unit of measure for the activity to be confirmed
ILE05 CO_ISMNGEH UNIT 945 3 0 T006 Unit of measure for the activity to be confirmed
ILE06 CO_ISMNGEH UNIT 948 3 0 T006 Unit of measure for the activity to be confirmed
RWFAK RWFAK DEC 951 5 3 Rework factor (is not used yet)
IPRZ1 CO_IPRZS QUAN 954 13 3 Confirmed quantity/work for business process
IPRE1 RU_IPRZE UNIT 961 3 0 T006 Unit of measurement for conf. quantity for business process
IPRK1 RU_IPRZK CHAR 964 1 0 No remaining quantity expected for business process
TAKT LD_TAKT NUMC 965 4 0 takt within a line segment
OPRZ1 OPRZ1 QUAN 969 13 3 Remaining quantity for business process
OPRE1 OPRE1 UNIT 976 3 0 T006 Unit for remaining quantity of business process

664088DB15: QAKL, AFVC, AFVV missing for archiving QM_CONTROL
482478Operation: incorrect unit for "Processing time"
379475Columns of the table section display incorrect values
372771PSBW: Date extraction PS using GETWA_NOT_ASSIGNED
352409PPT:Processing time and plannd delivry time missing
207790Duration and dates in the PS Info System
215868PSBW:0PS_DAT_NAE and 0PS_DAT_NWA: Duration + Buffers
52631Enhancing KKRAMERK (Ref. Characteristics Projects)