MC11VA0ITM SAP (Extraction SD Sales BW: Document Item) Structure details
Description: Extraction SD Sales BW: Document Item
Structure field list including key, data, relationships and ABAP select examples
MC11VA0ITM 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 "Extraction SD Sales BW: Document Item" 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_MC11VA0ITM TYPE MC11VA0ITM.
The MC11VA0ITM table consists of various fields, each holding specific information or linking keys about Extraction SD Sales BW: Document Item data available in SAP. These include VBELN (Sales and Distribution Document Number), ABSTA (Rejection status for SD item), POSNR (Item number of the SD document), RFGSA (Overall status of reference).. 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:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP MC11VA0ITM 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 |
ROCANCEL | Indicator: Cancel Data Record | ROCANCEL | CHAR | 1 | BOOLE | ||||
VBELN | Sales and Distribution Document Number | VBELN | CHAR | 10 | Assigned to domain | ALPHA | VBELN | AUN | |
ABSTA | Rejection status for SD item | ABSTA_VB | CHAR | 1 | STATV | ||||
POSNR | Item number of the SD document | POSNR | NUMC | 6 | Assigned to domain | POSNR | |||
RFGSA | Overall status of reference | RFGSA | CHAR | 1 | STATV | ||||
RFSTA | Reference status | RFSTA | CHAR | 1 | STATV | ||||
UVALL | General Incompletion Status of Item | UVALL_UP | CHAR | 1 | STATV | ||||
UVFAK | Item Incompletion Status with Respect to Billing | UVFAK_UP | CHAR | 1 | STATV | ||||
UVPRS | Pricing for item is incomplete | UVPRS_UP | CHAR | 1 | STATV | ||||
UVVLK | Incompletion status of the item with regard to delivery | UVVLK_UP | CHAR | 1 | STATV | ||||
ANGDT | Quotation/Inquiry is valid from | ANGDT_V | DATS | 8 | DATUM | ||||
AUART | Sales Document Type | AUART | CHAR | 4 | Assigned to domain | AUART | AUART | AAT | |
AUGRU | Order reason (reason for the business transaction) | AUGRU | CHAR | 3 | Assigned to domain | AUGRU | |||
BNDDT | Date until which bid/quotation is binding (valid-to date) | BNDDT | DATS | 8 | DATUM | ||||
BUKRS | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
FAKSK | Billing block in SD document | FAKSK | CHAR | 2 | Assigned to domain | FAKSP | |||
HWAER | Local Currency | HWAER | CUKY | 5 | Assigned to domain | WAERS | |||
KUNNR | Sold-to party | KUNAG | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | VAG | |
KURST | Exchange Rate Type | KURST | CHAR | 4 | Assigned to domain | KURST | KUT | ||
KVGR1 | Customer group 1 | KVGR1 | CHAR | 3 | Assigned to domain | KVGR1 | |||
KVGR2 | Customer group 2 | KVGR2 | CHAR | 3 | Assigned to domain | KVGR2 | |||
KVGR3 | Customer group 3 | KVGR3 | CHAR | 3 | Assigned to domain | KVGR3 | |||
KVGR4 | Customer group 4 | KVGR4 | CHAR | 3 | Assigned to domain | KVGR4 | |||
KVGR5 | Customer group 5 | KVGR5 | CHAR | 3 | Assigned to domain | KVGR5 | |||
LIFSK | Delivery block (document header) | LIFSK | CHAR | 2 | Assigned to domain | LIFSP | |||
STWAE | Statistics currency | STWAE | CUKY | 5 | Assigned to domain | WAERS | |||
VBTYP | SD document category | VBTYP | CHAR | 1 | VBTYP | ||||
VKBUR | Sales Office | VKBUR | CHAR | 4 | Assigned to domain | VKBUR | VKB | ||
VKGRP | Sales Group | VKGRP | CHAR | 3 | Assigned to domain | VKGRP | VKG | ||
VKORG | Sales Organization | VKORG | CHAR | 4 | Assigned to domain | VKORG | VKO | C_VKORG | |
VTWEG | Distribution Channel | VTWEG | CHAR | 2 | Assigned to domain | VTWEG | VTW | C_VTWEG | |
ABGRU | Reason for rejection of quotations and sales orders | ABGRU_VA | CHAR | 2 | Assigned to domain | ABGRU_VA | |||
AEDAT | Changed On | AEDAT | DATS | 8 | DATUM | ||||
AWAHR | Order probability of the item | AWAHR | NUMC | 3 | AWAHR | ||||
BRGEW | Gross Weight of the Item | BRGEW_AP | QUAN | 15(3) | MENG15 | ||||
BWAPPLNM | Application Component | RSAPPLNM | CHAR | 30 | RSAPPLNM | ||||
BWVORG | SAP BW transaction key | MCW_BWVORG | NUMC | 3 | NUM3 | ||||
CHARG | Batch Number | CHARG_D | CHAR | 10 | Assigned to domain | CHARG | CHA | ||
CMKUA | Credit data exchange rate for requested delivery date | CMKUA | DEC | 9(5) | KURRF | ||||
EAN11 | International Article Number (EAN/UPC) | EAN11 | CHAR | 18 | EAN11 | EAN11 | EAN | ||
ERDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | DATUM | ||||
ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
ERZET | Entry time | ERZET | TIMS | 6 | UZEIT | ||||
FAKSP | Billing block for item | FAKSP_AP | CHAR | 2 | Assigned to domain | FAKSP | |||
GEWEI | Weight Unit | GEWEI | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
KBMENG | Cumulative confirmed quantity in sales unit | KBMENG | QUAN | 15(3) | MENG15 | ||||
KLMENG | Cumulative confirmed quantity in base unit | KLMENG | QUAN | 15(3) | MENG15 | ||||
KMEIN | Condition unit | KMEIN | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
KNUMA_AG | Sales deal | KNUMA_AG | CHAR | 10 | Assigned to domain | ALPHA | KNUMA | VK1 | VMBO |
KPEIN | Condition pricing unit | KPEIN | DEC | 5 | KPEIN | ||||
KWMENG | Cumulative Order Quantity in Sales Units | KWMENG | QUAN | 15(3) | MENG15 | ||||
KZWI1 | Subtotal 1 from pricing procedure for condition | KZWI1 | CURR | 13(2) | WERTV7 | ||||
KZWI2 | Subtotal 2 from pricing procedure for condition | KZWI2 | CURR | 13(2) | WERTV7 | ||||
KZWI3 | Subtotal 3 from pricing procedure for condition | KZWI3 | CURR | 13(2) | WERTV7 | ||||
KZWI4 | Subtotal 4 from pricing procedure for condition | KZWI4 | CURR | 13(2) | WERTV7 | ||||
KZWI5 | Subtotal 5 from pricing procedure for condition | KZWI5 | CURR | 13(2) | WERTV7 | ||||
KZWI6 | Subtotal 6 from pricing procedure for condition | KZWI6 | CURR | 13(2) | WERTV7 | ||||
LFMNG | Minimum delivery quantity in delivery note processing | MINLF | QUAN | 13(3) | MENG13 | ||||
LGORT | Storage Location | LGORT_D | CHAR | 4 | Assigned to domain | LGORT | LAG | ||
LSMENG | Cumulative required delivery qty (all dlv-relev.sched.lines) | LSMENG | QUAN | 15(3) | MENG15 | ||||
MATKL | Material Group | MATKL | CHAR | 9 | Assigned to domain | MATKL | MKL | S_WBWG | |
MATNR | Material Number | MATNR | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | S_MAT1 |
MATWA | Material entered | MATWA | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | |
MEINS | Base Unit of Measure | MEINS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
MVGR1 | Material group 1 | MVGR1 | CHAR | 3 | Assigned to domain | MVGR1 | |||
MVGR2 | Material group 2 | MVGR2 | CHAR | 3 | Assigned to domain | MVGR2 | |||
MVGR3 | Material group 3 | MVGR3 | CHAR | 3 | Assigned to domain | MVGR3 | |||
MVGR4 | Material group 4 | MVGR4 | CHAR | 3 | Assigned to domain | MVGR4 | |||
MVGR5 | Material group 5 | MVGR5 | CHAR | 3 | Assigned to domain | MVGR5 | |||
MWSBP | Tax amount in document currency | MWSBP | CURR | 13(2) | WERTV7 | ||||
NETPR | Net price | NETPR | CURR | 11(2) | WERTV6 | ||||
NETWR | Net value of the order item in document currency | NETWR_AP | CURR | 15(2) | WERTV8 | ||||
NTGEW | Net Weight of the Item | NTGEW_AP | QUAN | 15(3) | MENG15 | ||||
PABLA | Unloading point of the ship-to party | PABLA | CHAR | 25 | TEXT25 | ||||
PKUNRE | Bill-to party | KUNRE | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | KUN | |
PKUNRG | Payer | KUNRG | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | ||
PKUNWE | Ship-to party | KUNWE | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | ||
PRODH | Product hierarchy | PRODH_D | CHAR | 18 | Assigned to domain | PRODH | VPR | ||
PSPDNR | Forwarding agent | SPDNR | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | ||
PSTYV | Sales document item category | PSTYV | CHAR | 4 | Assigned to domain | PSTYV | |||
PVRTNR | Sales employee | VRTNR | NUMC | 8 | PERNR | PREMV | |||
PZPERS | Person responsible | DZPERS | NUMC | 8 | PERNR | ||||
ROOT_DATE | Date of the Root Item | TDD_ROOT_DATE | DATS | 8 | DATUM | ||||
ROOT_HEAD | Document Number of the Root Header | TDD_ROOT_HEAD | CHAR | 10 | Assigned to domain | ALPHA | VBELN | ||
ROOT_ITEM | Item Number of the Root Item | TDD_ROOT_ITEM | NUMC | 6 | Assigned to domain | POSNR | |||
ROUTE | Route | ROUTE | CHAR | 6 | Assigned to domain | ROUTE | |||
SOBKZ | Special Stock Indicator | SOBKZ | CHAR | 1 | Assigned to domain | SOBKZ | |||
SPART | Division | SPART | CHAR | 2 | Assigned to domain | SPART | SPA | C_SPART | |
STADAT | Statistics date | STADAT | DATS | 8 | DATUM | ||||
STCUR | Exchange rate for statistics (Exch.rate at time of creation) | STCUR_AP | DEC | 9(5) | KURRF | ||||
SUGRD | Reason for material substitution | SUGRD | CHAR | 4 | Assigned to domain | SUGRD | VDG | ||
UEBTK | Unlimited overdelivery allowed | UEBTK_V | CHAR | 1 | XFELD | ||||
UEBTO | Overdelivery Tolerance Limit | UEBTO | DEC | 3(1) | PRZ21 | ||||
UMVKN | Denominator (Divisor) for Conversion of Sales Qty into SKU | UMVKN | DEC | 5 | UMBSN | ||||
UMVKZ | Numerator (factor) for conversion of sales quantity into SKU | UMVKZ | DEC | 5 | UMBSZ | ||||
UMZIN | Factor for converting sales units to base units (target qty) | UMZIN | DEC | 5 | UMBSN | ||||
UMZIZ | Factor for converting sales units to base units (target qty) | UMZIZ | DEC | 5 | UMBSZ | ||||
UNTTO | Underdelivery Tolerance Limit | UNTTO | DEC | 3(1) | PRZ21 | ||||
VDATU | Date of update for statistics updating | MC_VDATUM | DATS | 8 | DATUM | ||||
VGBEL | Document number of the reference document | VGBEL | CHAR | 10 | Assigned to domain | ALPHA | VBELN | ||
VGPOS | Item number of the reference item | VGPOS | NUMC | 6 | Assigned to domain | POSNR | |||
VGTYP | Document category of preceding SD document | VBTYP_V | CHAR | 1 | VBTYP | ||||
VOLEH | Volume unit | VOLEH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
VOLUM | Volume of the item | VOLUM_AP | QUAN | 15(3) | MENG15 | ||||
VRKME | Sales unit | VRKME | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
VSTEL | Shipping Point/Receiving Point | VSTEL | CHAR | 4 | Assigned to domain | VSTEL | VST | ||
WAERK | SD Document Currency | WAERK | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
WAVWR | Cost in document currency | WAVWR | CURR | 13(2) | WERTV7 | ||||
WERKS | Plant (Own or External) | WERKS_EXT | CHAR | 4 | Assigned to domain | WERKS | WRK | SH_T001W_EXTS | |
ZIEME | Target quantity UoM | DZIEME | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
ZMENG | Target quantity in sales units | DZMENG | QUAN | 13(3) | MENG13 | ||||
ZWERT | Target Value for Outline Agreement in Document Currency | DZWERT | CURR | 13(2) | WERT7 | ||||
BZIRK | Sales district | BZIRK | CHAR | 6 | Assigned to domain | BZIRK | BZI | ||
FBUDA | Date on which services rendered | FBUDA | DATS | 8 | DATUM | ||||
FKDAT | Billing date for billing index and printout | FKDAT | DATS | 8 | DATUM | ||||
INCO1 | Incoterms (Part 1) | INCO1 | CHAR | 3 | Assigned to domain | INCO1 | |||
INCO2 | Incoterms (Part 2) | INCO2 | CHAR | 28 | INCO2 | ||||
KDGRP | Customer group | KDGRP | CHAR | 2 | Assigned to domain | KDGRP | VKD | ||
KTGRD | Account assignment group for this customer | KTGRD | CHAR | 2 | Assigned to domain | KTGRD | |||
KURSK | Exchange Rate for Price Determination | KURSK | DEC | 9(5) | EXCRT | KURRF | |||
KURSK_DAT | Translation Date | WWERT_D | DATS | 8 | DATUM | ||||
PRSDT | Date for pricing and exchange rate | PRSDT | DATS | 8 | DATUM | ||||
WAKTION | COUPON | WAKTION | CHAR | 10 | Assigned to domain | ALPHA | WAKTION | WAK | |
WMINR | Product catalog number | WMINR | CHAR | 10 | Assigned to domain | WMINR | WMI | WPC1 | |
WAERK_VBAK | SD Document Currency | WAERK | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
SPARA | Division for order header | SPART_AK | CHAR | 2 | Assigned to domain | SPART | SPA | ||
VGTYP_AK | Sales Document Category of Reference Doc. in Order Header | MC_VBTYPAK | CHAR | 1 | VBTYP | ||||
PS_POSID | Work Breakdown Structure Element (WBS Element) | PS_POSID | CHAR | 24 | PROJN | PS_POSID | PRO | ||
ANZAUPO | Number of order items | MC_ANZAUPO | DEC | 9 | MCZAEHLER | ||||
PERIV | Fiscal Year Variant | PERIV | CHAR | 2 | Assigned to domain | PERIV | |||
MCEX_APCAMPAIGN | Campaign of referred sales order item for BW-Extraction | MCEX_APCAMPAIGN | CHAR | 32 | SYSUUID_C | ||||
APOPLANNED | Planning in APO | APOPLANNED | CHAR | 1 | APOPLANNED | ||||
MCBW_NETPR_AVKM | BW: Net Price Referring to Sales Quantity for Order Item | MCBW_NETPR_AVKM | CURR | 11(2) | WERTV6 |
Key field | Non-key field |
How do I retrieve data from SAP structure MC11VA0ITM using ABAP code?
As MC11VA0ITM 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 MC11VA0ITM as there is no data to select.How to access SAP table MC11VA0ITM
Within an ECC or HANA version of SAP you can also view further information about MC11VA0ITM 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