MC13VD0ITM SAP (Extraction SD Billing Document BW: Document Item) Structure details
Dictionary Type: Structure
Description: Extraction SD Billing Document BW: Document Item
Description: Extraction SD Billing Document BW: Document Item
Structure field list including key, data, relationships and ABAP select examples
MC13VD0ITM 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 Billing Document 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_MC13VD0ITM TYPE MC13VD0ITM.
The MC13VD0ITM table consists of various fields, each holding specific information or linking keys about Extraction SD Billing Document BW: Document Item data available in SAP. These include VBELN (Sales and Distribution Document Number), POSNR (Item number of the SD document), AEDAT (Changed On), BUKRS (Company Code).. 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 MC13VD0ITM 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 | |
| POSNR | Item number of the SD document | POSNR | NUMC | 6 | Assigned to domain | POSNR | |||
| AEDAT | Changed On | AEDAT | DATS | 8 | DATUM | ||||
| BUKRS | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
| BZIRK | Sales district | BZIRK | CHAR | 6 | Assigned to domain | BZIRK | BZI | ||
| FKART | Billing Type | FKART | CHAR | 4 | Assigned to domain | FKART | |||
| FKDAT | Billing date for billing index and printout | FKDAT | DATS | 8 | DATUM | ||||
| FKTYP | Billing category | FKTYP | CHAR | 1 | FKTYP | ||||
| HWAER | Local Currency | HWAER | CUKY | 5 | Assigned to domain | WAERS | |||
| KDGRP | Customer group | KDGRP | CHAR | 2 | Assigned to domain | KDGRP | VKD | ||
| KUNAG | Sold-to party | KUNAG | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | VAG | |
| KUNRG | Payer | KUNRG | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | ||
| KURRF | Exchange rate for FI postings | KURRF | DEC | 9(5) | KURRF | ||||
| KURST | Exchange Rate Type | KURST | CHAR | 4 | Assigned to domain | KURST | KUT | ||
| STWAE | Statistics currency | STWAE | CUKY | 5 | Assigned to domain | WAERS | |||
| VBTYP | SD document category | VBTYP | CHAR | 1 | VBTYP | ||||
| 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 | |
| WAERK | SD Document Currency | WAERK | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
| AKTNR | COUPON | WAKTION | CHAR | 10 | Assigned to domain | ALPHA | WAKTION | WAK | |
| AUBEL | Sales Document | VBELN_VA | CHAR | 10 | Assigned to domain | ALPHA | VBELN | AUN | |
| AUPOS | Sales Document Item | POSNR_VA | NUMC | 6 | Assigned to domain | POSNR | APO | ||
| BONBA | Rebate basis 1 | BONBA | CURR | 13(2) | WERTV7 | ||||
| BONUS | Volume rebate group | BONUS | CHAR | 2 | Assigned to domain | BONUS | |||
| BRGEW | Gross weight | BRGEW_15 | QUAN | 15(3) | MENG15 | ||||
| BRTWR | Gross value of the billing item in document currency | BRTWR_FP | CURR | 15(2) | WERTV8 | ||||
| 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 | ||
| EAN11 | International Article Number (EAN/UPC) | EAN11 | CHAR | 18 | EAN11 | EAN11 | EAN | ||
| ERDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | DATUM | ||||
| FAREG | Rule in billing plan/invoice plan | FAREG | CHAR | 1 | FAREG | ||||
| FBUDA | Date on which services rendered | FBUDA | DATS | 8 | DATUM | ||||
| FKIMG | Actual Invoiced Quantity | FKIMG | QUAN | 13(3) | MENG13 | ||||
| FKLMG | Billing quantity in stockkeeping unit | FKLMG | QUAN | 13(3) | MENG13 | ||||
| GEWEI | Weight Unit | GEWEI | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
| KNUMA_AG | Sales deal | KNUMA_AG | CHAR | 10 | Assigned to domain | ALPHA | KNUMA | VK1 | VMBO |
| KOKRS | Controlling Area | KOKRS | CHAR | 4 | Assigned to domain | CACCD | CAC | ||
| KOSTL | Cost Center | KOSTL | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | KOS | |
| KURSK | Exchange Rate for Price Determination | KURSK | DEC | 9(5) | EXCRT | KURRF | |||
| KURSK_DAT | Translation Date | WWERT_D | DATS | 8 | DATUM | ||||
| 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 | |||
| 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 | ||||
| LGORT | Storage Location | LGORT_D | CHAR | 4 | Assigned to domain | LGORT | LAG | ||
| LMENG | Required quantity for mat.management in stockkeeping units | LMENG | QUAN | 13(3) | MENG13 | ||||
| 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 | ||||
| NETWR | Net value of the billing item in document currency | NETWR_FP | CURR | 15(2) | WERTV8 | ||||
| NTGEW | Net weight | NTGEW_15 | QUAN | 15(3) | MENG15 | ||||
| PKUNRE | Bill-to party | KUNRE | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | KUN | |
| PKUNWE | Ship-to party | KUNWE | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | ||
| POSAR | Item type | POSAR | CHAR | 1 | POSAR | ||||
| PRODH | Product hierarchy | PRODH_D | CHAR | 18 | Assigned to domain | PRODH | VPR | ||
| PROVG | Commission group | PROVG | CHAR | 2 | Assigned to domain | PROVG | |||
| PRSDT | Date for pricing and exchange rate | PRSDT | DATS | 8 | DATUM | ||||
| 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 | ||||
| SKFBP | Amount eligible for cash discount in document currency | SKFBP | CURR | 13(2) | WERTV7 | ||||
| SMENG | Scale quantity in base unit of measure | SMENG | QUAN | 13(3) | MENG13 | ||||
| SPARA | Division for order header | SPART_AK | CHAR | 2 | Assigned to domain | SPART | SPA | ||
| 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 | ||||
| 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 | ||||
| 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 | |||
| VKBUR | Sales Office | VKBUR | CHAR | 4 | Assigned to domain | VKBUR | VKB | ||
| VKGRP | Sales Group | VKGRP | CHAR | 3 | Assigned to domain | VKGRP | VKG | ||
| VOLEH | Volume unit | VOLEH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
| VOLUM | Volume | VOLUM_15 | 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 | ||
| WAVWR | Cost in document currency | WAVWR | CURR | 13(2) | WERTV7 | ||||
| WERKS | Plant | WERKS_D | CHAR | 4 | Assigned to domain | WERKS | WRK | H_T001W_C | |
| PS_POSID | Work Breakdown Structure Element (WBS Element) | PS_POSID | CHAR | 24 | PROJN | PS_POSID | PRO | ||
| ANZFKPOS | Number of billing items | MC_ANZFKPO | 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 |
| Key field | Non-key field |
How do I retrieve data from SAP structure MC13VD0ITM using ABAP code?
As MC13VD0ITM 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 MC13VD0ITM as there is no data to select.How to access SAP table MC13VD0ITM
Within an ECC or HANA version of SAP you can also view further information about MC13VD0ITM 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