AFVV is a standard Production Orders Transparent Table in SAP PP application, which stores DB structure of the quantities/dates/values in the operation data. On this page, you can view the Table Structure, Columns(Fields), links to SAP Documentation, Wiki & Help Pages, Q&A, similar/related TCodes, Tables, FMs, ABAP Reports, BW Datasources, and Authorization Objects for AFVV. You can use the transaction code SE16 to view the data in this table, and SE11 TCode for the table structure and definition.

AFVV — Table Structure, Fields(Columns) and Definitions

    Position Column Name Description Data Element Primary Key Data Type Length Check Table
    1 MANDT Client MANDT X CLNT 3 T000
    2 AUFPL Routing number of operations in the order CO_AUFPL X NUMC 10
    3 APLZL General counter for order CO_APLZL X NUMC 8 AFVC
    4 .INCLUDE 0
    5 MEINH Unit of Measure VORME UNIT 3 T006
    6 UMREN Denominator CP_UMREN DEC 5
    7 UMREZ Equal To CP_UMREZ DEC 5
    8 BMSCH Base quantity BMSCH QUAN 13
    9 ZMERH Break DZMERH QUAN 9
    10 ZEIER Unit for Break Time DZEIER UNIT 3 T006
    11 VGE01 Measurement unit for standard value VGWRTEH UNIT 3 T006
    12 VGW01 Standard value of processing time VGWRT QUAN 9
    13 VGE02 Measurement unit for standard value VGWRTEH UNIT 3 T006
    14 VGW02 Standard value of setup time VGWRT QUAN 9
    15 VGE03 Measurement unit for standard value VGWRTEH UNIT 3 T006
    16 VGW03 Standard value of machine time VGWRT QUAN 9
    17 VGE04 Measurement unit for standard value VGWRTEH UNIT 3 T006
    18 VGW04 Standard value of variable activity VGWRT QUAN 9
    19 VGE05 Measurement unit for standard value VGWRTEH UNIT 3 T006
    20 VGW05 Standard value of teardown time VGWRT QUAN 9
    21 VGE06 Measurement unit for standard value VGWRTEH UNIT 3 T006
    22 VGW06 Standard value of variable activity VGWRT QUAN 9
    23 ZEIMU 3-Byte field DZEIMU UNIT 3 T006
    24 ZMINU Character Field Length = 10 DZMINU QUAN 9
    25 MINWE Text field length 14 MINWEI QUAN 13
    26 ZEIMB 3-Byte field DZEIMB UNIT 3 T006
    27 ZMINB Character Field Length = 10 DZMINB QUAN 9
    28 ZEILM Unit for the maximum wait time DZEILM UNIT 3 T006
    29 ZLMAX Maximum Wait Time DZLMAX QUAN 9
    30 ZEILP 3-Byte field DZEILP UNIT 3 T006
    31 ZLPRO Character Field Length = 10 DZLPRO QUAN 9
    32 ZEIWN 3-Byte field DZEIWN UNIT 3 T006
    33 ZWNOR Character Field Length = 10 DZWNOR QUAN 9
    34 ZEIWM 3-Byte field DZEIWM UNIT 3 T006
    35 ZWMIN Character Field Length = 10 DZWMIN QUAN 9
    36 ZEITN 3-Byte field DZEITN UNIT 3 T006
    37 ZTNOR Character Field Length = 10 DZTNOR QUAN 9
    38 ZEITM 3-Byte field DZEITM UNIT 3 T006
    39 ZTMIN Character Field Length = 10 DZTMIN QUAN 9
    40 PLIFZ Planned delivery time in days PLIFZ DEC 3
    41 DAUNO Normal duration of the activity DAUNOR QUAN 5
    42 DAUNE Unit for normal duration DAUNORE UNIT 3 T006
    43 DAUMI Minimum activity duration DAUMIN QUAN 5
    44 DAUME Unit for the minimum duration DAUMINE UNIT 3 T006
    45 EINSA Constraint on the basic start date for the activity EINSCHRA CHAR 1
    46 EINSE Constraint on the finish date of the activity EINSCHRE CHAR 1
    47 ARBEI Work involved in the activity ARBEIT QUAN 7
    48 ARBEH Unit for work ARBEITE UNIT 3 T006
    49 MGVRG Text field length 14 MGVRG QUAN 13
    50 ASVRG Operation scrap ASVRG QUAN 13
    51 LMNGA Yield LMNGA QUAN 13
    52 XMNGA Scrap XMNGA QUAN 13
    53 GMNGA Previously confirmed yield in order unit of measure GMNGA QUAN 13
    54 ISM01 Text (20 Characters) CO_RUMNG QUAN 13
    55 ISM02 Text (20 Characters) CO_RUMNG QUAN 13
    56 ISM03 Text (20 Characters) CO_RUMNG QUAN 13
    57 ISM04 Text (20 Characters) CO_RUMNG QUAN 13
    58 ISM05 Text (20 Characters) CO_RUMNG QUAN 13
    59 ISM06 Text (20 Characters) CO_RUMNG QUAN 13
    60 ISMNW Actual work CO_ISMNW QUAN 13
    61 FSAVD Earl.start date FSAVD DATS 8
    62 FSAVZ Earliest scheduled start: Execution (time) FSAVZ TIMS 6
    63 FSSBD Earliest scheduled start: Processing (date) FSSBD DATS 8
    64 FSSBZ Earliest Scheduled Start: Processing (Time) FSSBZ TIMS 6
    65 FSSAD Earliest scheduled start: Teardown (date) FSSAD DATS 8
    66 FSSAZ Earliest Scheduled Start: Teardown (Time) FSSAZ TIMS 6
    67 FSEDD Earliest scheduled finish: Execution (date) FSEDD DATS 8
    68 FSEDZ Earliest scheduled finish: Execution (time) FSEDZ TIMS 6
    69 FSSLD Earliest scheduled start: Wait (date) FSSLD DATS 8
    70 FSSLZ Earliest scheduled start: Wait (time) FSSLZ TIMS 6
    71 FSELD Earliest scheduled finish: Wait (date) FSELD DATS 8
    72 FSELZ Earliest scheduled finish: Wait (time) FSELZ TIMS 6
    73 SSAVD Latest scheduled start: Execution (date) SSAVD DATS 8
    74 SSAVZ Latest scheduled start: Execution (time) SSAVZ TIMS 6
    75 SSSBD Latest scheduled start: Processing (date) SSSBD DATS 8
    76 SSSBZ Latest scheduled start: Processing (time) SSSBZ TIMS 6
    77 SSSAD Latest scheduled start: Teardown (date) SSSAD DATS 8
    78 SSSAZ Latest scheduled start: Teardown (time) SSSAZ TIMS 6
    79 SSEDD Lat.finish date SSEDD DATS 8
    80 SSEDZ Latest scheduled finish: Execution (time) SSEDZ TIMS 6
    81 SSSLD Latest scheduled start: Wait time (date) SSSLD DATS 8
    82 SSSLZ Latest scheduled start: Wait time SSSLZ TIMS 6
    83 SSELD Latest scheduled finish: Wait time (date) SSELD DATS 8
    84 SSELZ Latest scheduled finish: Wait time SSELZ TIMS 6
    85 ISAVD Date ISAVD DATS 8
    86 IEAVD Date IEAVD DATS 8
    87 ISDD Field of type DATS ISDD DATS 8
    88 ISDZ Field of type TIMS ISDZ TIMS 6
    89 IERD Updated information in related user data field IERD DATS 8
    90 IERZ Updated information in related user data field IERZ TIMS 6
    91 ISBD Earliest scheduled start: Execution (date) ISBD DATS 8
    92 ISBZ Earliest scheduled start: Execution (time) ISBZ TIMS 6
    93 IEBD Earliest scheduled start: Execution (date) IEBD DATS 8
    94 IEBZ Earliest scheduled start: Execution (time) IEBZ TIMS 6
    95 ISAD Updated information in related user data field ISAD DATS 8
    96 ISAZ Updated information in related user data field ISAZ TIMS 6
    97 IEDD Field of type DATS IEDD DATS 8
    98 IEDZ Field of type TIMS IEDZ TIMS 6
    99 PEDD Forecast finish date of operation from confirmation CO_PEDD DATS 8
    100 PEDZ Earliest scheduled start: Execution (time) CO_PEDZ TIMS 6
    101 PUFFR Free float (basic) PUFFR_FREI DEC 3
    102 PUFGS Total float (basic) PUFFR_GESM DEC 3
    103 NTANF Constraint for activity start (Basic) VORGABESTD DATS 8
    104 NTANZ Constraint for activity start time (Basic) VORGABESTZ TIMS 6
    105 NTEND Constraint for finish of activity (Basic) VORGABEEND2 DATS 8
    106 NTENZ Basic finish time of the activity VORGABEENZ TIMS 6
    107 EWSTD Forecasted start date for the activity EWSTARTD DATS 8
    108 EWSTZ Forecast start time of the activity EWSTARTZ TIMS 6
    109 EWEND Forecast finish date EWENDED DATS 8
    110 EWENZ Forecast finish time for the activity EWENDEZ TIMS 6
    111 EWDAN Normal duration (from forecast) of activity EWDAN QUAN 5
    112 EWDNE Unit for forecast normal duration EWDNE UNIT 3 T006
    113 EWDAM Minimum duration (from forecast) for activity EWDAM QUAN 5
    114 EWDME Unit for forecast minimum duration EWDME UNIT 3 T006
    115 EWSTE Forecast date constraint on activity finish PS_RESTE CHAR 1
    116 EWSTA Forecast date constraint on activity start PS_RESTA CHAR 1
    117 WARTZ Text string 22 characters WARTEZEIT FLTP 16
    118 WRTZE 3-Byte field WTRZE UNIT 3
    119 RUEST Text string 22 characters RUEST FLTP 16
    120 RSTZE 3-Byte field RSTZE UNIT 3
    121 BEARZ Text string 22 characters BEARZEIT FLTP 16
    122 BEAZE Unit of measure for processing time BEAZE UNIT 3
    123 ABRUE Text string 22 characters ABRUE FLTP 16
    124 ARUZE 3-Byte field ARUZE UNIT 3
    125 LIEGZ Text string 22 characters LIEGEZEIT FLTP 16
    126 LIGZE 3-Byte field LIGZE UNIT 3
    127 TRANZ Text string 22 characters TRANSZEIT FLTP 16
    128 TRAZE 3-Byte field TRAZE UNIT 3
    129 ISERH Confirmed break time ISERH QUAN 9
    130 OFM01 Forecast Value for Updating of Standard Value CO_SCHAETZ QUAN 9
    131 OFM02 Forecast Value for Updating of Standard Value CO_SCHAETZ QUAN 9
    132 OFM03 Forecast Value for Updating of Standard Value CO_SCHAETZ QUAN 9
    133 OFM04 Forecast Value for Updating of Standard Value CO_SCHAETZ QUAN 9
    134 OFM05 Forecast Value for Updating of Standard Value CO_SCHAETZ QUAN 9
    135 OFM06 Forecast Value for Updating of Standard Value CO_SCHAETZ QUAN 9
    136 OFMNW Forecasted work (actual + remaining) OFMNW QUAN 7
    137 BZOFFB Reference date for start of sub-operation CP_OBZOFFB CHAR 2 TCA54
    138 EHOFFB Offset unit for start of prod. resource/tool usage CP_OEHOFFB UNIT 3 T006
    139 OFFSTB Character Field With Field Length 7 CP_OOFFSTB QUAN 5
    140 OFFSTE Character Field With Field Length 7 CP_OOFFSTE QUAN 5
    141 BZOFFE Reference date for finish of sub-operation CP_OBZOFFE CHAR 2 TCA54
    142 EHOFFE Offset unit for end of production resource/tool usage CP_OEHOFFE UNIT 3 T006
    143 FPAVD Earliest scheduled start date (forecast) FPAVD DATS 8
    144 FPAVZ Earliest scheduled start time (forecast) FPAVZ TIMS 6
    145 FPEDD Earliest scheduled finish date (forecast) FPEDD DATS 8
    146 FPEDZ Earliest scheduled finish time (forecast) FPEDZ TIMS 6
    147 SPAVD Latest scheduled start date (forecast) SPAVD DATS 8
    148 SPAVZ Latest scheduled start time (forecast) SPAVZ TIMS 6
    149 SPEDD Latest scheduled finish date (forecast) SPEDD DATS 8
    150 SPEDZ Latest scheduled finish time (forecast) SPEDZ TIMS 6
    151 BEAZP Unit of processing time (Forecast) BEAZEP UNIT 3
    152 PUFGP Total float (from forecast) PPUFF_GESM DEC 3
    153 PUFFP Free float (from forecast) PPUFF_FREI DEC 3
    154 BEARP Processing time (forecast) PBEARZEIT FLTP 16
    155 EPANF Earliest scheduled start: Execution (date) EPANF DATS 8
    156 EPANZ Earliest scheduled start: Execution (time) EPANZ TIMS 6
    157 EPEND Earliest scheduled start: Execution (date) EPEND DATS 8
    158 EPENZ Earliest scheduled start: Execution (time) EPENZ TIMS 6
    159 PDAU Forecasted duration of activity from confirmation PDAU QUAN 5
    160 PDAE Unit of the forecasted duration from the confirmation PDAE UNIT 3 T006
    161 KNOTE Nodes KNOTE CHAR 10 TVKN
    162 VSTZW Deadline function VSTZW CHAR 4 TVTZ
    163 VSTGA Deadline deviation reason VSTGA CHAR 4 TVTG
    164 QRASTZEHT Time Unit QRASTZEHT UNIT 3 *
    165 QRASTZFAK Time Factor QRASTZFAK DEC 5
    166 QRASTMENG Quantity Between Two Inspections QRASTMENG QUAN 13
    167 QRASTEREH Grid Unit of Measure QRASTEREH UNIT 3 *
    168 AUFKT Updated information in related user data field AFAKT DEC 3
    169 RMNGA Text field length 14 RMNGA QUAN 13
    170 ILE01 Unit of measure for the activity to be confirmed CO_ISMNGEH UNIT 3 *
    171 ILE02 Unit of measure for the activity to be confirmed CO_ISMNGEH UNIT 3 *
    172 ILE03 Unit of measure for the activity to be confirmed CO_ISMNGEH UNIT 3 *
    173 ILE04 Unit of measure for the activity to be confirmed CO_ISMNGEH UNIT 3 *
    174 ILE05 Unit of measure for the activity to be confirmed CO_ISMNGEH UNIT 3 *
    175 ILE06 Unit of measure for the activity to be confirmed CO_ISMNGEH UNIT 3 *
    176 RWFAK Rework factor (is not used yet) RWFAK DEC 5
    177 IPRZ1 Current quantity to be confirmed for the business process CO_IPRZS QUAN 13
    178 IPRE1 Unit of Meas. for Qty to Be Confirmed for Business Process RU_IPRZE UNIT 3 *
    179 IPRK1 Indicator: No Remaining Qty Expected for Business Process RU_IPRZK CHAR 1
    180 TAKT takt within a line segment LD_TAKT NUMC 4
    181 OPRZ1 Remaining quantity for business process OPRZ1 QUAN 13
    182 OPRE1 Unit for remaining quantity of business process OPRE1 UNIT 3 *
    183 PSPM_INDICATOR Indicates PMCS date influence activity scheduling PSPM_INDICATOR CHAR 1