MCAFVGV SAP (Versions: Order Procedure) Table details
Dictionary Type: Table
Description: Versions: Order Procedure
Description: Versions: Order Procedure
Table field list including key, data, relationships and ABAP select examples
MCAFVGV is a standard SAP Table which is used to store Versions: Order Procedure data and is available within R/3 SAP systems depending on the version and release level.
The MCAFVGV table consists of various fields, each holding specific information or linking keys about Versions: Order Procedure data available in SAP. These include SSOUR (Statistic(s) origin), VRSIO (Version number in the information structure), AUFNR (Order Number), AUFPL (Routing number of operations in the order).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP MCAFVGV table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
SSOUR | Statistic(s) origin | SSOUR | CHAR | 4 | SSOUR | ||||
VRSIO | Version number in the information structure | VRSIO | CHAR | 3 | Assigned to domain | VRSIO | MCV | ||
AUFNR | Order Number | AUFNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | ANR | |
AUFPL | Routing number of operations in the order | CO_AUFPL | NUMC | 10 | AUFPL | ||||
APLZL | Internal counter | CIM_COUNT | NUMC | 8 | CIM_COUNT | ||||
ZAEHL | Internal counter | CIM_COUNT | NUMC | 8 | CIM_COUNT | ||||
PLNFL | Sequence | PLNFOLGE | CHAR | 6 | ALPHA | PLNFOLGE | |||
VORNR | Operation/Activity Number | VORNR | CHAR | 4 | NUMCV | VORNR | VGN | ||
ARBID | Object ID | OBJEKTID | NUMC | 8 | NUM08 | PON | |||
KAPAR | Capacity category | KAPART | CHAR | 3 | Assigned to domain | KAPART | CAA | ||
KAPID | Capacity ID | KAPID | NUMC | 8 | Assigned to domain | KAPID | |||
ARBPL | Work center | ARBPL | CHAR | 8 | ARBPL | AGR | |||
WERKS | Plant | WERKS_D | CHAR | 4 | Assigned to domain | WERKS | WRK | H_T001W_C | |
STEUS | Control key | STEUS | CHAR | 4 | Assigned to domain | STEUS | |||
OBJNR | Object number | J_OBJNR | CHAR | 22 | Assigned to domain | J_OBJNR | ONR | ||
MEINH | Unit of Measure for Activity/Operation | VORME | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
UMREN | Denominator for conversion to base units of measure | UMREN | DEC | 5 | UMBSN | ||||
UMREZ | Numerator for Conversion to Base Units of Measure | UMREZ | DEC | 5 | UMBSZ | ||||
BMSCH | Base Quantity | BMSCH | QUAN | 13(3) | BMSCH | ||||
VERTL | Distribution function for capacity requirements | VERTEILUNG | CHAR | 2 | Assigned to domain | VERTEILUNG | |||
KALID | Factory Calendar | WFCID | CHAR | 2 | Assigned to domain | WFCID | FCI | ||
MGVRG | Operation quantity | MC_MGVRG | QUAN | 15(3) | MENGV15 | ||||
ASVRG | Operation scrap | MC_ASVRG | QUAN | 15(3) | MENGV15 | ||||
LMNGA | Total quantity confirmed | MC_LMNGA | QUAN | 15(3) | MENGV15 | ||||
XMNGA | Total scrap quantity confirmed | MC_XMNGA | QUAN | 15(3) | MENGV15 | ||||
GMNGA | Total Delivered Lot Size | MC_GMNGA | QUAN | 15(3) | MENGV15 | ||||
SSADD | Latest target input date | SSADD | DATS | 8 | DATUM | ||||
IADD | Actual input date | IADD | DATS | 8 | DATUM | ||||
FSAVD | Earliest scheduled start: Execution (date) | FSAVD | DATS | 8 | DATUM | ||||
SSAVD | Latest scheduled start: Execution (date) | SSAVD | DATS | 8 | DATUM | ||||
ISDD | Actual start: Execution (date) | ISDD | DATS | 8 | DATUM | ||||
ISAVD | Actual operation start (date) | ISAVD | DATS | 8 | DATUM | ||||
FSEDD | Earliest scheduled finish: Execution (date) | FSEDD | DATS | 8 | DATUM | ||||
SSEDD | Latest scheduled finish: Execution (date) | SSEDD | DATS | 8 | DATUM | ||||
IEDD | Actual finish: Execution (date) | IEDD | DATS | 8 | DATUM | EDR | |||
IEAVD | Actual finish of operation (date) | IEAVD | DATS | 8 | DATUM | ||||
N_IEAVD | Actual finish of operation (date) | IEAVD | DATS | 8 | DATUM | ||||
WARTZ | Queue time used for scheduling | MC_WARTZ | QUAN | 7(1) | DAUER_6_1V | ||||
WRTZE | Unit of measure for queue time | WTRZE | UNIT | 3 | CUNIT | EINHEIT | |||
RUEST | Scheduled setup time | MC_RUEST | QUAN | 7(1) | DAUER_6_1V | ||||
RSTZE | Unit of measure for setup time | RSTZE | UNIT | 3 | CUNIT | EINHEIT | |||
BEARZ | Scheduled processing time | MC_BEARZ | QUAN | 7(1) | DAUER_6_1V | ||||
BEAZE | Unit of measure for processing time | BEAZE | UNIT | 3 | CUNIT | EINHEIT | |||
ABRUE | Scheduled teardown time | MC_ABRUE | QUAN | 7(1) | DAUER_6_1V | ||||
ARUZE | Unit of measure for teardown | ARUZE | UNIT | 3 | CUNIT | EINHEIT | |||
LIEGZ | Wait time used for scheduling | MC_LIEGZ | QUAN | 7(1) | DAUER_6_1V | ||||
V_LIEGZ | Wait time used for scheduling | MC_LIEGZ | QUAN | 7(1) | DAUER_6_1V | ||||
LIGZE | Unit of measure for wait time | LIGZE | UNIT | 3 | CUNIT | EINHEIT | |||
TRANZ | Move time used for scheduling | MC_TRANZ | QUAN | 7(1) | DAUER_6_1V | ||||
KRUES | Scheduled cap. requirements for the op. segment 'setup' | MC_KRUES | QUAN | 7(1) | DAUER_6_1V | ||||
KBEAS | Scheduled cap. requirements for the op. segment 'processing' | MC_KBEAS | QUAN | 7(1) | DAUER_6_1V | ||||
KABRS | Scheduled cap. requirements for the op. segment teardown | MC_KABRS | QUAN | 7(1) | DAUER_6_1V | ||||
KEINH | Unit of of measure for displaying capacity requirements | CY_KEINH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
TRAZE | Unit of measure for move time | TRAZE | UNIT | 3 | CUNIT | EINHEIT | |||
DFZEH | Unit of measure for execution time | DFZEH | UNIT | 3 | CUNIT | EINHEIT | |||
S_DFZ | Target execution time | S_DFZ | QUAN | 7(1) | DAUER_6_1V | ||||
I_DFZ | Actual execution time | I_DFZ | QUAN | 7(1) | DAUER_6_1V | ||||
KAPKZ | SFIS indicator for cumulative updating of capacity data | KAPKZ | CHAR | 1 | X | ||||
A | Dummy function in length 1 | DUMMY | CHAR | 1 | DUMMY | ||||
VDATU | Date of update for statistics updating | MC_VDATUM | DATS | 8 | DATUM | ||||
DUMMY | Dummy function in length 1 | DUMMY | CHAR | 1 | DUMMY |
Key field | Non-key field |
How do I retrieve data from SAP table MCAFVGV using ABAP code
The following ABAP code Example will allow you to do a basic selection on MCAFVGV to SELECT all data from the tableDATA: WA_MCAFVGV TYPE MCAFVGV.
SELECT SINGLE *
FROM MCAFVGV
INTO CORRESPONDING FIELDS OF WA_MCAFVGV
WHERE...
How to access SAP table MCAFVGV
Within an ECC or HANA version of SAP you can also view further information about MCAFVGV and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects