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

SAP Help, Wiki, Q&A and other resources for AFVV

Click the above link for the full list of resources and help pages, only the first few are posted below

  • データソース - 作業区 (作業) | SAP Help Portal

    作業区の作業データソースでは、計画製造と実績製造、計画と実績の開始/完了日時、発生した不良、廃棄数量などに関するすべての情報を (作業区レベル、資源レベル、および作業レベルで) 指定して、ユーザ定義指標を定義します。

    https://help.sap.com/docs/SAP_DIGITAL_MANUFACTURING_CLOUD/de1d05db7d6e42f6ac2ba773dd5fd555/9670b4739601486b9df1e378ac1d5e8a-96.html?locale=ja-JP

  • Data Source - Work Center (Resource) - SAP Help Portal

     Table of Contents Menu 

    https://help.sap.com/viewer/de1d05db7d6e42f6ac2ba773dd5fd555/latest/en-US/1e1e1067e21e48f59a4ccc5bdde06c35.html

  • Data Source - Work Center Details (Labor) - SAP Help Portal

     Table of Contents Menu 

    https://help.sap.com/viewer/de1d05db7d6e42f6ac2ba773dd5fd555/latest/en-US/f1d007c272074fc1b01408dedb23cf68.html

  • データソース - 指図順序精度 | SAP Help Portal

    指図順序精度データソースでは、順序がある指図の数、指図の総数、計画に従った後続順序がある指図の数、カスタム指標を定義するための指図組合せの総数に関する各種情報を指定します。

    https://help.sap.com/docs/SAP_DIGITAL_MANUFACTURING_CLOUD/de1d05db7d6e42f6ac2ba773dd5fd555/2e4f1561b7af4e18b3a4e23aa5c3a59d-97.html?locale=ja-JP

  • Data Source - Work Center (Operation) - SAP Help Portal

     Table of Contents Menu 

    "to_timestamp(AFVV.FSAVD || AFVV.FSAVZ)"

    https://help.sap.com/viewer/de1d05db7d6e42f6ac2ba773dd5fd555/latest/en-US/9670b4739601486b9df1e378ac1d5e8a.html

  • Data Source - Work Center (Resource) | SAP Help Portal

    The work center data source specifies all information (at work center/resource level) about the planned vs actual production, planned vs actual start and completion time, defects raised, scrapped quantity, and so on to define custom measures.

    https://help.sap.com/docs/SAP_DIGITAL_MANUFACTURING_CLOUD/de1d05db7d6e42f6ac2ba773dd5fd555/1e1e1067e21e48f59a4ccc5bdde06c35-95.html

  • データソース - 作業区 (資源) | SAP Help Portal

    作業区データソースでは、計画製造と実績製造、計画と実績の開始/完了日時、発生した不良、廃棄数量などに関するすべての情報を (作業区レベル/資源レベルで) 指定して、ユーザ定義指標を定義します。

    https://help.sap.com/docs/SAP_DIGITAL_MANUFACTURING_CLOUD/de1d05db7d6e42f6ac2ba773dd5fd555/1e1e1067e21e48f59a4ccc5bdde06c35-95.html?locale=ja-JP

  • Data Source - Work Center Details (Labor) | SAP Help Portal

    The work center data source specifies information about the planned vs actual labor, as reported in the ERP system.

    https://help.sap.com/docs/SAP_DIGITAL_MANUFACTURING_CLOUD/de1d05db7d6e42f6ac2ba773dd5fd555/2e4f1561b7af4e18b3a4e23aa5c3a59d.html?locale=ja-JP

  • Defect Count - SAP Help Portal

     Table of Contents Menu 

    "Work center whose actual finish date/time (AFVV.iedd and AFVV.iedz) is within the from and to date/time or current date/time of plant selected from the UI."

    https://help.sap.com/viewer/de1d05db7d6e42f6ac2ba773dd5fd555/latest/en-US/44a494ca1e9247c09a00917955b42401.html

  • Defect Per Unit - SAP Help Portal

     Table of Contents Menu 

    "Quantity Produced (AFVV.LMNGA) at that work center (last/milestone operation)"

    https://help.sap.com/viewer/de1d05db7d6e42f6ac2ba773dd5fd555/latest/en-US/8fa1fe67fdbd408385d4ecb56a15462a.html

  • View the full list of resources, SAP Help/Wiki pages and Q&A for AFVV


Related Tables

TABLE Description Functional Area
AFVC Operation within an order PP - Production Orders
AFKO Order header data PP orders PP - Production Orders
AUFK Order master data CO - Overhead Cost Orders
AFRU Order Confirmations PP - Confirmations
AFPO Order item PP - Production Orders

Transaction Codes for SAP Table AFVV

TCODE Description Functional Area
SE11 ABAP Dictionary Maintenance Basis - Dictionary Maintenance
AFAB Post depreciation FI - Basic Functions
COOIS Production Order Information System PP - Production Orders
COSS Transport of C Tables PP - Production Orders
KSSK Temp. Alloc.: Actual Stat. Key Fig. CO - Activity Types
VBKD Bonus Buy: Condition Types SD - Free Goods

FMs for SAP Table AFVV

FM Description Functional Area
REUSE_ALV_COMMENTARY_WRITE List body comment block output BC - SAP List Viewer
REUSE_ALV_EVENTS_GET Returns table of possible events for a list type BC - SAP List Viewer
REUSE_ALV_GRID_DISPLAY Output of a simple list (single-line) Basis - SAP List Viewer
READ_TEXT SAPscript: Read text BC - SAPscript
REUSE_ALV_LIST_DISPLAY Output a simple list (single line or several lines) BC - SAP List Viewer
REUSE_ALV_FIELDCATALOG_MERGE Create field catalog from dictionary structure or internal table BC - SAP List Viewer

ABAP Reports for SAP Table AFVV

ABAP REPORT Description Functional Area
BUILD_FIELDCAT Include ZHPM_STOCK_CHECK
RSEOUT00 Process All Selected IDocs (EDI) Basis - ALE Integration Technology
RBDAPP01 Inbound Processing of IDocs Ready for Transfer Basis - ALE Integration Technology
RSPC_MONITOR Monitoring of Selected Process Chains (Last Run) BW - Data Staging
ALSYSAL Program for Object Type SYSALERT: System Alert Basis - Monitoring
RSWUWFML Send Mails for Work Items Basis - SAP Business Workflow

BW Datasources for SAP Table AFVV

BW DATASOURCE Description Functional Area
2LIS_04_P_ARBPL Work Center View from PP/PP-PI PP - Production Planning and Control
2LIS_17_I3OPER Plant Maintenance Order Process PM - Plant Maintenance
2LIS_04_P_MATNR Material View from PP/PP-PI PP - Production Planning and Control

Authorization Objects for SAP Table AFVV

AUTHORIZATION OBJECT Description Functional Area
S_TABU_DIS Table Maintenance (via standard tools such as SM30)
CMS_RBL Authorization object for receivable in CMS
ECM_CTXT Engineering Change Management: Context
S_RFC Authorization Check for RFC Access
CRM_CATT Authorization for CRM eCATT Based Unit Testing
CMS_CAG Authorization object for CAG

Most searched SAP Production Planning and Control Tables