MCVKENNZ1 SAP (SIS: Key Figures with Different Technical Features) Structure details
Description: SIS: Key Figures with Different Technical Features
Structure field list including key, data, relationships and ABAP select examples
MCVKENNZ1 is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "SIS: Key Figures with Different Technical Features" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_MCVKENNZ1 TYPE MCVKENNZ1.
The MCVKENNZ1 table consists of various fields, each holding specific information or linking keys about SIS: Key Figures with Different Technical Features data available in SAP. These include RENETWR (Net value of incoming returns), OAUWE (Open net value of orders), UMNETWR (Net value of invoiced sales), GUNETWR (Net value of credit memos).. 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 MCVKENNZ1 structure 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 |
AENETWR | Net value of incoming orders | MC_AENETWR | CURR | 19(2) | WERTV10 | ||||
RENETWR | Net value of incoming returns | MC_RENETWR | CURR | 19(2) | WERTV10 | ||||
OAUWE | Open net value of orders | MC_OAUWE | CURR | 19(2) | WERTV10 | ||||
UMNETWR | Net value of invoiced sales | MC_UMNETWR | CURR | 19(2) | WERTV10 | ||||
GUNETWR | Net value of credit memos | MC_GUNETWR | CURR | 19(2) | WERTV10 | ||||
AEKZWI1 | Incoming orders: gross | MC_AEKZWI1 | CURR | 17(2) | WERTV9 | ||||
AEKZWI2 | Incoming orders: net 1 | MC_AEKZWI2 | CURR | 17(2) | WERTV9 | ||||
AEKZWI3 | Incoming orders: net 2 | MC_AEKZWI3 | CURR | 17(2) | WERTV9 | ||||
AEKZWI4 | Incoming orders: freight | MC_AEKZWI4 | CURR | 17(2) | WERTV9 | ||||
AEKZWI5 | Incoming orders: pricing subtotal 5 | MC_AEKZWI5 | CURR | 17(2) | WERTV9 | ||||
AEKZWI6 | Incoming orders: pricing subtotal 6 | MC_AEKZWI6 | CURR | 17(2) | WERTV9 | ||||
REKZWI1 | Incoming returns: gross | MC_REKZWI1 | CURR | 17(2) | WERTV9 | ||||
REKZWI2 | Incoming returns: net 1 | MC_REKZWI2 | CURR | 17(2) | WERTV9 | ||||
REKZWI3 | Incoming returns: net 2 | MC_REKZWI3 | CURR | 17(2) | WERTV9 | ||||
REKZWI4 | Incoming returns: freight | MC_REKZWI4 | CURR | 17(2) | WERTV9 | ||||
REKZWI5 | Incoming returns: pricing subtotal 5 | MC_REKZWI5 | CURR | 17(2) | WERTV9 | ||||
REKZWI6 | Incoming returns: pricing subtotal 6 | MC_REKZWI6 | CURR | 17(2) | WERTV9 | ||||
UMKZWI1 | Invoiced sales: gross | MC_UMKZWI1 | CURR | 17(2) | WERTV9 | ||||
UMKZWI2 | Invoiced sales: net 1 | MC_UMKZWI2 | CURR | 17(2) | WERTV9 | ||||
UMKZWI3 | Invoiced sales: net 2 | MC_UMKZWI3 | CURR | 17(2) | WERTV9 | ||||
UMKZWI4 | Invoice freight charges | MC_UMKZWI4 | CURR | 17(2) | WERTV9 | ||||
UMKZWI5 | Billing document: pricing subtotal 5 | MC_UMKZWI5 | CURR | 17(2) | WERTV9 | ||||
UMKZWI6 | Billing document: pricing subtotal 6 | MC_UMKZWI6 | CURR | 17(2) | WERTV9 | ||||
GUKZWI1 | Credit memos: gross | MC_GUKZWI1 | CURR | 17(2) | WERTV9 | ||||
GUKZWI2 | Credit memos: net 1 | MC_GUKZWI2 | CURR | 17(2) | WERTV9 | ||||
GUKZWI3 | Credit memos: net 2 | MC_GUKZWI3 | CURR | 17(2) | WERTV9 | ||||
GUKZWI4 | Credit memos: freight | MC_GUKZWI4 | CURR | 17(2) | WERTV9 | ||||
GUKZWI5 | Credit memos: pricing subtotal 5 | MC_GUKZWI5 | CURR | 17(2) | WERTV9 | ||||
GUKZWI6 | Credit memos: pricing subtotal 6 | MC_GUKZWI6 | CURR | 17(2) | WERTV9 | ||||
ANZAU | Number of orders | MC_ANZAU | DEC | 9 | MCZAEHLER | ||||
ANZRE | Number of returns/credit memo requests | MC_ANZRE | DEC | 9 | MCZAEHLER | ||||
ANZAUPOS | Number of order items | MC_ANZAUPO | DEC | 9 | MCZAEHLER | ||||
ANZREPOS | No.of returns items | MC_ANZREPO | DEC | 9 | MCZAEHLER | ||||
AEMENGE | Incoming orders quantity | MC_AEMENGE | QUAN | 15(3) | MENGV15_3 | ||||
REMENGE | Returns Quantity | MC_REMENGE | QUAN | 15(3) | MENGV15_3 | ||||
OAUME | Open orders quantity in base unit of measure | MC_OAUME | QUAN | 15(3) | MENGV15_3 | ||||
UMMENGE | Sales quantity | MC_UMMENGE | QUAN | 15(3) | MENGV15_3 | ||||
GUMENGE | Credit memos quantity | MC_GUMENGE | QUAN | 15(3) | MENGV15_3 | ||||
NTGEW | Net weight of deliveries | MC_LINTGEW | QUAN | 15(3) | MENGV15_3 | ||||
BRGEW | Gross weight of deliveries | MC_LIBRGEW | QUAN | 15(3) | MENGV15_3 | ||||
VOLUM | Volume of deliveries | MC_LIVOLUM | QUAN | 15(3) | MENGV15_3 | ||||
ARBLA | Labor Required for Deliveries on Hand | MC_LIARBLA | DEC | 5(2) | DECV5_2 | ||||
RLNTGEW | Net weight of returns deliveries | MC_RLNTGEW | QUAN | 15(3) | MENGV15_3 | ||||
RLBRGEW | Gross weight of returns deliveries | MC_RLBRGEW | QUAN | 15(3) | MENGV15_3 | ||||
RLVOLUM | Volume of returns delivery | MC_RLVOLUM | QUAN | 15(3) | MENGV15_3 | ||||
RLARBLA | Labor required for returns deliveries on hand | MC_RLARBLA | DEC | 5(2) | DECV5_2 | ||||
STWAE | Statistics currency | STWAE | CUKY | 5 | Assigned to domain | WAERS | |||
BASME | Base Unit of Measure | MEINS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
GEWEI | Weight Unit | GEWEI | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
VOLEH | Volume unit | VOLEH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
HWAER | Local Currency | HWAER | CUKY | 5 | Assigned to domain | WAERS | |||
CMWAE | Currency key of credit control area | WAERS_CM | CUKY | 5 | Assigned to domain | WAERS | |||
AEWAVWR | Cost of incoming orders | MC_AEWAVWR | CURR | 19(2) | WERTV10 | ||||
REWAVWR | Incoming returns: cost | MC_REWAVWR | CURR | 19(2) | WERTV10 | ||||
UMWAVWR | Cost of invoiced sales | MC_UMWAVWR | CURR | 19(2) | WERTV10 | ||||
GUWAVWR | Credit memos: cost | MC_GUWAVWR | CURR | 19(2) | WERTV10 | ||||
KWERT | Accumulated condition value in local currency | MC_KWERT | CURR | 19(2) | WERTV10 | ||||
AUWRT | Rebate: Rebate payments in local currency | MC_AUWRT | CURR | 19(2) | WERTV10 | ||||
RUWRT | Rebate: Accrued value in local currency | MC_RUWRT | CURR | 19(2) | WERTV10 | ||||
BONBA | Rebate: Accumulated sales volume in local currency | MC_BONBA | CURR | 19(2) | WERTV10 | ||||
OEIME | Open order credit quantity (schedule lines) | MC_OEIME | QUAN | 15(3) | MENGV15_3 | ||||
OEIKW | Open sales order credit value (schedule lines) | MC_OEIKW | CURR | 19(2) | WERTV10 | ||||
OLIME | Open delivery quantity | MC_OLIME | QUAN | 15(3) | MENGV15_3 | ||||
OLIKW | Open delivery credit value | MC_OLIKW | CURR | 19(2) | WERTV10 | ||||
OFAME | Open billing document quantity | MC_OFAME | QUAN | 15(3) | MENGV15_3 | ||||
OFAKW | Open billing document credit value | MC_OFAKW | CURR | 19(2) | WERTV10 | ||||
DUMMY | Dummy function in length 1 | DUMMY | CHAR | 1 | DUMMY | ||||
.INCLU--AP | 0 | ||||||||
KAWRT | Cumulated condition base value | MC_KAWRT | CURR | 19(2) | WERTV10 | ||||
AUNR1 | Sales Document | VBELN_VA | CHAR | 10 | Assigned to domain | ALPHA | VBELN | AUN | |
ANZKONV1 | Number of a condition in the document | MC_ANZKONV | DEC | 9 | MCZAEHLER | ||||
AUNR2 | Sales Document | VBELN_VA | CHAR | 10 | Assigned to domain | ALPHA | VBELN | AUN | |
ANZKONV2 | Number of a condition in the document | MC_ANZKONV | DEC | 9 | MCZAEHLER | ||||
AUNR3 | Sales Document | VBELN_VA | CHAR | 10 | Assigned to domain | ALPHA | VBELN | AUN | |
ANZKONV3 | Number of a condition in the document | MC_ANZKONV | DEC | 9 | MCZAEHLER | ||||
LIEFFZ | Cumulative qty for delivery/MAIS in base unit of measure | MC_LIEFFZ | QUAN | 15(3) | MENGV15_3 | ||||
ENTNFZ | Cumulative quantity for goods withdrawal in base unit | MC_ENTNFZ | QUAN | 15(3) | MENGV15_3 | ||||
RRWRT | Rebate: Accruals reversed on the basis of local currency | MC_RRWRT | CURR | 19(2) | WERTV10 | ||||
AEMENGE_D | Quantity of incoming orders - delata updating | AEMENGE_D | QUAN | 15(3) | MENGV15_3 | ||||
AENETWR_D | Net value of incoming orders - delta updating | AENETWR_D | CURR | 19(2) | WERTV10 | ||||
AEKZWI1_D | Gross incoming orders - delta updating | AEKZWI1_D | CURR | 17(2) | WERTV9 | ||||
AEKZWI2_D | Net incoming orders 1 - delta updating | AEKZWI2_D | CURR | 17(2) | WERTV9 | ||||
AEKZWI3_D | Net incoming orders 2 - delta updating | AEKZWI3_D | CURR | 17(2) | WERTV9 | ||||
AEKZWI4_D | Incoming orders (freight) - delta updating | AEKZWI4_D | CURR | 17(2) | WERTV9 | ||||
AEKZWI5_D | Incoming orders PrSub 5 - delta updating | AEKZWI5_D | CURR | 17(2) | WERTV9 | ||||
AEKZWI6_D | Incoming orders PrSub 6 - delta updating | AEKZWI6_D | CURR | 17(2) | WERTV9 | ||||
AEWAVWR_D | Cost of incoming orders - delta updating | AEWAVWR_D | CURR | 19(2) | WERTV10 | ||||
OEIMEB | Open order qty. based on confirmation date of sched. line | OEIMEB | QUAN | 15(3) | MENGV15_3 | ||||
OEIMEW | Open order qty. based on desired del. date of sched. line | OEIMEW | QUAN | 15(3) | MENGV15_3 | ||||
OEIWEB | Open order value based on confirmation date of sched. line | OEIWEB | CURR | 19(2) | WERTV10 | ||||
OEIWEW | Open order value based on desired del. date of sched. line | OEIWEW | CURR | 19(2) | WERTV10 | ||||
OEIMEB_D | Open order quantity based on conf. date of sched. line-delta | OEIMEB_D | QUAN | 15(3) | MENGV15_3 | ||||
OEIMEW_D | Open order qty. based on desired del.date of sch.line- delta | OEIMEW_D | QUAN | 15(3) | MENGV15_3 | ||||
OEIWEB_D | Open order val. based on conf. date of sched. line - delta | OEIWEB_D | CURR | 19(2) | WERTV10 | ||||
OEIWEW_D | Open ord. val. based on desired del. date sched.line - delta | OEIWEW_D | CURR | 19(2) | WERTV10 | ||||
AEMENGB | Qty. incoming orders based on confirm. date of sched. line | AEMENGB | QUAN | 15(3) | MENGV15_3 | ||||
AEMENGB_D | QtyIO based on confirmation date of sched. line - DeltaUpdat | AEMENGB_D | QUAN | 15(3) | MENGV15_3 | ||||
LGMNG | Delivery quantity in base unit of measure | MC_LGMNG | QUAN | 15(3) | MENGV15_3 | ||||
LGMNG_D | Delivery qty in base unit of measure - Delta update | MC_LGMNG_D | QUAN | 15(3) | MENGV15_3 | ||||
UMNETWR_D | Invoiced sales net value - Delta update | UMNETWR_D | CURR | 19(2) | WERTV10 | ||||
UMWAVWR_D | Invoiced sales stock value - Delta update | UMWAVWR_D | CURR | 19(2) | WERTV10 | ||||
KCREQ | Customer requirements | KCREQ | QUAN | 13(3) | MENG13 | ||||
KCQTY | Product allocation qty | KCQTY | QUAN | 13(3) | MENG13 | ||||
KUDMD | Requirements not covered | KUDMD | QUAN | 13(3) | MENG13 | ||||
KLTBK | Open product allocation qty | KLTBK | QUAN | 13(3) | MENG13 | ||||
KCUBL | Default division | KCUBL | QUAN | 13(3) | MENG13 | ||||
KOFLG | Indicator | KOFLG | CHAR | 1 | FLAG | ||||
ZWERT | Target value in outline agreement (in contract currency) | MC_ZWERT | CURR | 17(2) | WERTV9 | ||||
OAAUWE | Open released net value of order for value contract | MC_OAAUWE | CURR | 17(2) | WERTV9 | ||||
OALIWE | Open released net value of delivery for value contract | MC_OALIWE | CURR | 17(2) | WERTV9 | ||||
AFAKWE | Released net value of billing document for contract | MC_AFAKWE | CURR | 17(2) | WERTV9 | ||||
AEFREQ | Incoming orders: frequency | MC_AEFREQ | DEC | 15(3) | DECV15_3 | ||||
AEFREQB | Incoming orders: frequency acc. to conf. date of sched. line | MC_AEFREQB | DEC | 15(3) | DECV15_3 | ||||
OEFREQB | Open incoming orders: freq acc. to conf. date of sched. line | MC_OEFREQB | DEC | 15(3) | DECV15_3 | ||||
OEFREQW | Open incoming orders: freq acc. to desired dlv. date of SL | MC_OEFREQW | DEC | 15(3) | DECV15_3 | ||||
LGFREQ | Delivery frequency in base unit of measure | MC_LGFREQ | DEC | 15(3) | DECV15_3 |
Key field | Non-key field |
How do I retrieve data from SAP structure MCVKENNZ1 using ABAP code?
As MCVKENNZ1 is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on MCVKENNZ1 as there is no data to select.How to access SAP table MCVKENNZ1
Within an ECC or HANA version of SAP you can also view further information about MCVKENNZ1 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