AFVV is a SAP table coming under CRM module and BBPCRM component.View details, Fields & related tables of AFVV in SAP.
- Table description : DB structure of the quantities/dates/values in the operation
- Module : CRM-CIC
- Parent Module : CRM
- Package : CO
- Software Component : BBPCRM
Here is some free PDF files that you can download free for your reference.
Download Now
Definitions
What is SAP ?SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.
What is table in SAP ?Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.
SAP AFVV Table Fields structure
| Field | Note | Data Element | Domain |
|---|---|---|---|
| MANDT | Client | MANDT | MANDT |
| AUFPL | Routing number of operations in the order | CO_AUFPL | AUFPL |
| APLZL | General counter for order | CO_APLZL | CO_APLZL |
| .INCLUDE | Include structure of the operation quantities/dates/values | ||
| MEINH | Unit of measure for activity | VORME | MEINS |
| UMREN | Denominator for converting rtg and op units of measure | CP_UMREN | UMBSN |
| UMREZ | Numerator for converting task list and oper. un. of measure | CP_UMREZ | UMBSZ |
| BMSCH | Base Quantity | BMSCH | BMSCH |
| ZMERH | Break | DZMERH | VGWRT |
| ZEIER | Unit for the break time | DZEIER | MEINS |
| VGE01 | Unit of measure for the standard value | VGWRTEH | MEINS |
| VGW01 | Standard Value | VGWRT | VGWRT |
| VGE02 | Unit of measure for the standard value | VGWRTEH | MEINS |
| VGW02 | Standard Value | VGWRT | VGWRT |
| VGE03 | Unit of measure for the standard value | VGWRTEH | MEINS |
| VGW03 | Standard Value | VGWRT | VGWRT |
| VGE04 | Unit of measure for the standard value | VGWRTEH | MEINS |
| VGW04 | Standard Value | VGWRT | VGWRT |
| VGE05 | Unit of measure for the standard value | VGWRTEH | MEINS |
| VGW05 | Standard Value | VGWRT | VGWRT |
| VGE06 | Unit of measure for the standard value | VGWRTEH | MEINS |
| VGW06 | Standard Value | VGWRT | VGWRT |
| ZEIMU | Unit for the minimum overlap time | DZEIMU | MEINS |
| ZMINU | Minimum overlap time | DZMINU | VGWRT |
| MINWE | Minimum Send-Ahead Quantity | MINWEI | MINWEI |
| ZEIMB | Unit for the minimum processing time | DZEIMB | MEINS |
| ZMINB | Minimum processing time | DZMINB | VGWRT |
| ZEILM | Unit for the maximum wait time | DZEILM | MEINS |
| ZLMAX | Maximum wait time | DZLMAX | VGWRT |
| ZEILP | Unit for the required wait time | DZEILP | MEINS |
| ZLPRO | Minimum wait time | DZLPRO | VGWRT |
| ZEIWN | Unit for the standard queue time | DZEIWN | MEINS |
| ZWNOR | Standard queue time | DZWNOR | VGWRT |
| ZEIWM | Unit for the minumum queue time | DZEIWM | MEINS |
| ZWMIN | Minimum queue time | DZWMIN | VGWRT |
| ZEITN | Unit for the standard move time | DZEITN | MEINS |
| ZTNOR | Standard move time | DZTNOR | VGWRT |
| ZEITM | Unit for the minimum move time | DZEITM | MEINS |
| ZTMIN | Minimum move time | DZTMIN | VGWRT |
| PLIFZ | Planned delivery time in days | PLIFZ | DEC3 |
| DAUNO | Normal duration of the activity | DAUNOR | DAUER_4_1 |
| DAUNE | Normal duration/unit | DAUNORE | MEINS |
| DAUMI | Minimum activity duration | DAUMIN | DAUER_4_1 |
| DAUME | Unit for the minimum duration | DAUMINE | MEINS |
| EINSA | Constraint on the basic start date for the activity | EINSCHRA | RESTRIKSTR |
| EINSE | Constraint on the finish date of the activity | EINSCHRE | RESTRIKEND |
| ARBEI | Work involved in the activity | ARBEIT | ARBEIT |
| ARBEH | Unit for work | ARBEITE | MEINS |
| MGVRG | Operation Quantity | MGVRG | MENG13 |
| ASVRG | Operation scrap | ASVRG | MENG13 |
| LMNGA | Total Yield Confirmed | LMNGA | MENG13 |
| XMNGA | Total scrap quantity confirmed | XMNGA | MENG13 |
| GMNGA | Confirmed yield in order unit of measure | GMNGA | MENG13 |
| ISM01 | Previously confirmed activity | CO_RUMNG | MENG13 |
| ISM02 | Previously confirmed activity | CO_RUMNG | MENG13 |
| ISM03 | Previously confirmed activity | CO_RUMNG | MENG13 |
| ISM04 | Previously confirmed activity | CO_RUMNG | MENG13 |
| ISM05 | Previously confirmed activity | CO_RUMNG | MENG13 |
| ISM06 | Previously confirmed activity | CO_RUMNG | MENG13 |
| ISMNW | Actual work | CO_ISMNW | MENG13 |
| FSAVD | Earliest scheduled start: Execution (date) | FSAVD | DATUM |
| FSAVZ | Earliest scheduled start: Execution (time) | FSAVZ | ATIME |
| FSSBD | Earliest scheduled start: Processing (date) | FSSBD | DATUM |
| FSSBZ | Earliest scheduled start: Processing (time) | FSSBZ | ATIME |
| FSSAD | Earliest scheduled start: Teardown (date) | FSSAD | DATUM |
| FSSAZ | Earliest scheduled start: Teardown (time) | FSSAZ | ATIME |
| FSEDD | Earliest scheduled finish: Execution (date) | FSEDD | DATUM |
| FSEDZ | Earliest scheduled finish: Execution (time) | FSEDZ | ATIME |
| FSSLD | Earliest scheduled start: Wait (date) | FSSLD | DATUM |
| FSSLZ | Earliest scheduled start: Wait (time) | FSSLZ | ATIME |
| FSELD | Earliest scheduled finish: Wait (date) | FSELD | DATUM |
| FSELZ | Earliest scheduled finish: Wait (time) | FSELZ | ATIME |
| SSAVD | Latest scheduled start: Execution (date) | SSAVD | DATUM |
| SSAVZ | Latest scheduled start: Execution (time) | SSAVZ | ATIME |
| SSSBD | Latest scheduled start: Processing (date) | SSSBD | DATUM |
| SSSBZ | Latest scheduled start: Processing (time) | SSSBZ | ATIME |
| SSSAD | Latest scheduled start: Teardown (date) | SSSAD | DATUM |
| SSSAZ | Latest scheduled start: Teardown (time) | SSSAZ | ATIME |
| SSEDD | Latest scheduled finish: Execution (date) | SSEDD | DATUM |
| SSEDZ | Latest scheduled finish: Execution (time) | SSEDZ | ATIME |
| SSSLD | Latest scheduled start: Wait time (date) | SSSLD | DATUM |
| SSSLZ | Latest scheduled start: Wait time | SSSLZ | ATIME |
| SSELD | Latest scheduled finish: Wait time (date) | SSELD | DATUM |
| SSELZ | Latest scheduled finish: Wait time | SSELZ | ATIME |
| ISAVD | Actual operation start (date) | ISAVD | DATUM |
| IEAVD | Actual finish of operation (date) | IEAVD | DATUM |
| ISDD | Actual start: Execution (date) | ISDD | DATUM |
| ISDZ | Actual start: Execution/setup (time) | ISDZ | ATIME |
| IERD | Actual finish: Setup (date) | IERD | DATUM |
| IERZ | Actual finish: Setup (time) | IERZ | ATIME |
| ISBD | Actual start: Processing (date) | ISBD | DATUM |
| ISBZ | Actual start: Processing (time) | ISBZ | ATIME |
| IEBD | Actual finish: Processing (date) | IEBD | DATUM |
| IEBZ | Actual processing finish (time) | IEBZ | ATIME |
| ISAD | Actual start: Teardown (date) | ISAD | DATUM |
| ISAZ | Actual start: Teardown (time) | ISAZ | ATIME |
| IEDD | Actual finish: Execution (date) | IEDD | DATUM |
| IEDZ | Actual finish: Execution (time) | IEDZ | ATIME |
| PEDD | Forecast finish date of operation from confirmation | CO_PEDD | DATUM |
| PEDZ | Forecast finish time of operation from confirmation | CO_PEDZ | ATIME |
| PUFFR | Free float | PUFFR_FREI | PUFFER |
| PUFGS | Total float | PUFFR_GESM | PUFFER |
| NTANF | Constraint for activity start (Basic) | VORGABESTD | VORGABESTR |
| NTANZ | Constraint for activity start time (Basic) | VORGABESTZ | ATIME |
| NTEND | Constraint for finish of activity (Basic) | VORGABEEND | VORGABEEND |
| NTENZ | Basic finish time of the activity | VORGABEENZ | ATIME |
| EWSTD | Forecasted start date for the activity | EWSTARTD | DATUM |
| EWSTZ | Forecast start time of the activity | EWSTARTZ | ATIME |
| EWEND | Forecast finish date | EWENDED | DATUM |
| EWENZ | Forecast finish time for the activity | EWENDEZ | ATIME |
| EWDAN | Normal duration (from forecast) of activity | EWDAN | DAUER_4_1 |
| EWDNE | Unit for forecast normal duration | EWDNE | MEINS |
| EWDAM | Minimum duration (from forecast) for activity | EWDAM | DAUER_4_1 |
| EWDME | Unit for forecast minimum duration | EWDME | MEINS |
| EWSTE | Forecast date constraint on activity finish | PS_RESTE | RESTRIKEND |
| EWSTA | Forecast date constraint on activity start | PS_RESTA | RESTRIKSTR |
| WARTZ | Queue time used for scheduling | WARTEZEIT | CX_ZEIT |
| WRTZE | Unit of measure for queue time | WTRZE | EINHEIT |
| RUEST | Setup time | RUEST | CX_ZEIT |
| RSTZE | Unit of measure for setup time | RSTZE | EINHEIT |
| BEARZ | Processing time | BEARZEIT | CX_ZEIT |
| BEAZE | Unit of measure for processing time | BEAZE | EINHEIT |
| ABRUE | Teardown | ABRUE | CX_ZEIT |
| ARUZE | Unit of measure for teardown | ARUZE | EINHEIT |
| LIEGZ | Wait time used for scheduling | LIEGEZEIT | CX_ZEIT |
| LIGZE | Unit of measure for wait time | LIGZE | EINHEIT |
| TRANZ | Move time used for scheduling | TRANSZEIT | CX_ZEIT |
| TRAZE | Unit of measure for move time | TRAZE | EINHEIT |
| ISERH | Confirmed break time | ISERH | VGWRT |
| OFM01 | Forecast value used to update the standard value | CO_SCHAETZ | VGWRT |
| OFM02 | Forecast value used to update the standard value | CO_SCHAETZ | VGWRT |
| OFM03 | Forecast value used to update the standard value | CO_SCHAETZ | VGWRT |
| OFM04 | Forecast value used to update the standard value | CO_SCHAETZ | VGWRT |
| OFM05 | Forecast value used to update the standard value | CO_SCHAETZ | VGWRT |
| OFM06 | Forecast value used to update the standard value | CO_SCHAETZ | VGWRT |
| OFMNW | Forecasted work (actual + remaining) | OFMNW | ARBEIT |
| BZOFFB | Reference date for start of sub-operation | CP_OBZOFFB | CP_BZOFF |
| EHOFFB | Unit for offset to start | CP_OEHOFFB | MEINS |
| OFFSTB | Offset to sub-operation start | CP_OOFFSTB | VNZTV |
| OFFSTE | Offset to sub-operation finish | CP_OOFFSTE | VNZTV |
| BZOFFE | Reference date for finish of sub-operation | CP_OBZOFFE | CP_BZOFF |
| EHOFFE | Unit for offset to finish | CP_OEHOFFE | MEINS |
| FPAVD | Earliest scheduled start date (forecast) | FPAVD | DATUM |
| FPAVZ | Earliest scheduled start time (forecast) | FPAVZ | ATIME |
| FPEDD | Earliest scheduled finish date (forecast) | FPEDD | DATUM |
| FPEDZ | Earliest scheduled finish time (forecast) | FPEDZ | ATIME |
| SPAVD | Latest scheduled start date (forecast) | SPAVD | DATUM |
| SPAVZ | Latest scheduled start time (forecast) | SPAVZ | ATIME |
| SPEDD | Latest scheduled finish date (forecast) | SPEDD | DATUM |
| SPEDZ | Latest scheduled finish time (forecast) | SPEDZ | ATIME |
| BEAZP | Unit of processing time (Forecast) | BEAZEP | EINHEIT |
| PUFGP | Total float (from forecast) | PPUFF_GESM | PUFFER |
| PUFFP | Free float (from forecast) | PPUFF_FREI | PUFFER |
| BEARP | Processing time (forecast) | PBEARZEIT | CX_ZEIT |
| EPANF | Dispatched start date for operation | EPANF | DATUM |
| EPANZ | Dispatched start time for operation | EPANZ | ATIME |
| EPEND | Dispatched finish date | EPEND | DATUM |
| EPENZ | Dispatched finish time | EPENZ | ATIME |
| PDAU | Forecasted duration of activity from confirmation | PDAU | DAUER_4_1 |
| PDAE | Unit of the forecasted duration from the confirmation | PDAE | MEINS |
| KNOTE | Transportation Connection Points | KNOTE | KNOTN |
| VSTZW | Deadline function | VSTZW | VSTZW |
| VSTGA | Deadline deviation reason | VSTGA | VSTGA |
| QRASTZEHT | Time Unit | QRASTZEHT | MEINS |
| QRASTZFAK | Time Factor | QRASTZFAK | QPROBEFAK |
| QRASTMENG | Quantity Between Two Inspections | QRASTMENG | MENG13 |
| QRASTEREH | Grid Unit of Measure | QRASTEREH | MEINS |
| AUFKT | Execution Factor | AFAKT | AFAKT |
| RMNGA | Total confirmed rework quantity | RMNGA | MENG13 |
| ILE01 | Unit of measure for the activity to be confirmed | CO_ISMNGEH | MEINS |
| ILE02 | Unit of measure for the activity to be confirmed | CO_ISMNGEH | MEINS |
| ILE03 | Unit of measure for the activity to be confirmed | CO_ISMNGEH | MEINS |
| ILE04 | Unit of measure for the activity to be confirmed | CO_ISMNGEH | MEINS |
| ILE05 | Unit of measure for the activity to be confirmed | CO_ISMNGEH | MEINS |
| ILE06 | Unit of measure for the activity to be confirmed | CO_ISMNGEH | MEINS |
| RWFAK | Rework factor (is not used yet) | RWFAK | AUSCHUFAK |
| IPRZ1 | Confirmed quantity/work for business process | CO_IPRZS | MENGV13 |
| IPRE1 | Unit of measurement for conf. quantity for business process | RU_IPRZE | MEINS |
| IPRK1 | No remaining quantity expected for business process | RU_IPRZK | XFELD |
| TAKT | takt within a line segment | LD_TAKT | LD_TAKT |
| OPRZ1 | Remaining quantity for business process | OPRZ1 | MENGV13 |
| OPRE1 | Unit for remaining quantity of business process | OPRE1 | MEINS |
AFVV related tables
| Table | Note |
|---|---|
| AFBP | CIM order: Batch print requests |
| AFFL | Work order sequence |
| AFKO | Order Header Data PP Orders |
| AFPO | Order item |
| AFSPOPR | Split Operations in an Order Split |
| AFSPREL | Relation Between Orders in an Order Split |
| AFVC | Operation within an order |
| AFVU | DB structure of the user fields of the operation |
| AFVV | DB structure of the quantities/dates/values in the operation |
| DRAD_PORDER | Attributes for Links: Document to Production Order |
| FAPW | Index of production-/issuing plant for production order |
| FTIND | Missing parts index |
| ORDCOM | Communication control Operation download |
| ORDLY | Table of delays for production order |
| T024F | Production scheduler |
| T399X | Parameters dependent on order type |
| T441C | Profile - availability check |
| T441CT | Texts for Profile "Display Availability Check" |
| T490 | Transactions PP - orders - order category |
| T496B | CIM order: Assigning document types to reference doc. types |