MCAFPOV SAP (Versions: Order Item) Table details
Dictionary Type: Table
Description: Versions: Order Item
Description: Versions: Order Item
Table field list including key, data, relationships and ABAP select examples
MCAFPOV is a standard SAP Table which is used to store Versions: Order Item data and is available within R/3 SAP systems depending on the version and release level.
The MCAFPOV table consists of various fields, each holding specific information or linking keys about Versions: Order Item data available in SAP. These include SSOUR (Statistic(s) origin), VRSIO (Version number in the information structure), AUFNR (Order Number), POSNR (Order Item Number).. 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 MCAFPOV 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 | |
POSNR | Order Item Number | CO_POSNR | NUMC | 4 | CO_POSNR | ||||
MATNR | Material Number for Order | CO_MATNR | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | |
PWERK | Planning plant for the order | CO_PWERK | CHAR | 4 | Assigned to domain | WERKS | |||
ETRMP | Opening date of the planned order | CO_ETRMP | DATS | 8 | DATUM | ||||
STRMP | Start date of the planned order | CO_STRMP | DATS | 8 | DATUM | ||||
LTRMP | Delivery date from planned order | CO_LTRMP | DATS | 8 | DATUM | ||||
LTRMI | Actual delivery/finish date | CO_LTRMI | DATS | 8 | DATUM | ||||
PAMNG | Fixed quantity of scrap from production | MC_AVMNG | QUAN | 15(3) | MENGV15_3 | ||||
PGMNG | Total planned order quantity | MC_GSMNG | QUAN | 15(3) | MENGV15_3 | ||||
MEINS | Base Unit of Measure | LAGME | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
PSAMG | Scrap quantity in item | MC_PSAMG | QUAN | 15(3) | MENGV15_3 | ||||
PSMNG | Order item quantity | MC_PSMNG | QUAN | 15(3) | MENGV15_3 | ||||
WEMNG | Quantity of goods received | MC_WEMNG | QUAN | 15(3) | MENGV15_3 | ||||
IAMNG | Actual scrap quantity from an order item | MC_IAMNG | QUAN | 15(3) | MENGV15_3 | ||||
AMEIN | Unit of measure for in-house production | CO_AUFME | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
UMREZ | Numerator for Conversion to Base Units of Measure | UMREZ | DEC | 5 | UMBSZ | ||||
UMREN | Denominator for conversion to base units of measure | UMREN | DEC | 5 | UMBSN | ||||
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 | ||||
KEINH | Unit of of measure for displaying capacity requirements | CY_KEINH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
KSUMS | Total target capacity requirements | MC_KSUMS | QUAN | 7(1) | DAUER_6_1V | ||||
PLNUM | Planned order number | PLNUM | CHAR | 10 | Assigned to domain | ALPHA | PLNUM | PAF | |
KDAUF | Sales order number | CO_KDAUF | CHAR | 10 | Assigned to domain | ALPHA | VBELN | AUN | |
KDPOS | Sales order item | CO_KDPOS | NUMC | 6 | Assigned to domain | POSNR | AUP | ||
KDEIN | Delivery Schedule for Sales Order | KDEIN | NUMC | 4 | NUM04 | ||||
LGORT | Storage Location | LGORT_D | CHAR | 4 | Assigned to domain | LGORT | LAG | ||
SAFNR | Run schedule header number | SA_AUFNR | CHAR | 12 | Assigned to domain | ALPHA | SA_AUFNR | ||
VERID | Production Version | VERID | CHAR | 4 | Assigned to domain | VERID | VER | ||
SERNR | BOM explosion number | SERNR | CHAR | 8 | Assigned to domain | SERNR | |||
CHARG | Batch Number | CHARG_D | CHAR | 10 | Assigned to domain | CHARG | CHA | ||
GSBER | Business Area | GSBER | CHAR | 4 | Assigned to domain | GSBER | GSB | ||
SOPNR | SOP order number | SAFNR | CHAR | 10 | SAFNR | ||||
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 | ||||
DFZEXEH | Unit for execution time (exact) | DFZEXEH | UNIT | 3 | CUNIT | EINHEIT | |||
S_DFZ_EX | Target execution time (exact) | S_DFZ_EX | QUAN | 12(2) | DAUER_10_2V | ||||
I_DFZ_EX | Actual execution time (exact) | I_DFZ_EX | QUAN | 12(2) | DAUER_10_2V | ||||
S_DLZ_EX | Target lead time (exact) | S_DLZ_EX | QUAN | 12(2) | DAUER_10_2V | ||||
I_DLZ_EX | Actual lead time (exact) | I_DLZ_EX | QUAN | 12(2) | DAUER_10_2V |
Key field | Non-key field |
How do I retrieve data from SAP table MCAFPOV using ABAP code
The following ABAP code Example will allow you to do a basic selection on MCAFPOV to SELECT all data from the tableDATA: WA_MCAFPOV TYPE MCAFPOV.
SELECT SINGLE *
FROM MCAFPOV
INTO CORRESPONDING FIELDS OF WA_MCAFPOV
WHERE...
How to access SAP table MCAFPOV
Within an ECC or HANA version of SAP you can also view further information about MCAFPOV 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