MC11VA0SCL SAP (Extraction SD Sales BW: Document Schedule Line) Structure details
Description: Extraction SD Sales BW: Document Schedule Line
Structure field list including key, data, relationships and ABAP select examples
MC11VA0SCL 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 Schedule Line" 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_MC11VA0SCL TYPE MC11VA0SCL.
The MC11VA0SCL table consists of various fields, each holding specific information or linking keys about Extraction SD Sales BW: Document Schedule Line 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), UVALL (General Incompletion Status of Item).. 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 MC11VA0SCL 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 | |||
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 | ||||
BMENG | Confirmed Quantity | BMENG | QUAN | 13(3) | MENG13 | ||||
CMENG | Corrected quantity in sales unit | CMENG | QUAN | 13(3) | MENG13 | ||||
EDATU | Schedule line date | EDATU | DATS | 8 | DATUM | ||||
ETENR | Delivery Schedule Line Number | ETENR | NUMC | 4 | Assigned to domain | ETENR | |||
ETTYP | Schedule line category | ETTYP | CHAR | 2 | Assigned to domain | ETTYP | |||
LDDAT | Loading Date | LDDAT | DATS | 8 | DATUM | ||||
LIFSP | Schedule line blocked for delivery | LIFSP_EP | CHAR | 2 | Assigned to domain | LIFSP | |||
LMENG | Required quantity for mat.management in stockkeeping units | LMENG | QUAN | 13(3) | MENG13 | ||||
MBDAT | Material Staging/Availability Date | MBDAT | DATS | 8 | DATUM | ||||
MEINS | Base Unit of Measure | MEINS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
TDDAT | Transportation Planning Date | TDDAT_D | DATS | 8 | DATUM | ||||
VRKME | Sales unit | VRKME | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
WADAT | Goods Issue Date | WADAT | DATS | 8 | DATUM | ||||
WLDATBE | Desired del. date in confirmed schedule lines | WLDATBE | DATS | 8 | DATUM | ||||
WMENG | Order quantity in sales units | WMENG | QUAN | 13(3) | MENG13 | ||||
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 | ||||
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 | ||
KMEIN | Condition unit | KMEIN | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
KPEIN | Condition pricing unit | KPEIN | DEC | 5 | KPEIN | ||||
LGORT | Storage Location | LGORT_D | CHAR | 4 | Assigned to domain | LGORT | LAG | ||
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 | |
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 | |||
NETPR | Net price | NETPR | CURR | 11(2) | WERTV6 | ||||
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 | ||||
ROUTE | Route | ROUTE | CHAR | 6 | Assigned to domain | ROUTE | |||
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 | ||
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 | ||||
VDATU | Date of update for statistics updating | MC_VDATUM | DATS | 8 | DATUM | ||||
VGTYP | Document category of preceding SD document | VBTYP_V | CHAR | 1 | VBTYP | ||||
VOLEH | Volume unit | VOLEH | 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 | ||
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 | ||
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 | ||||
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 | ||
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 | ||||
FACELOC | Customer-Facing Location | FACELOC | CHAR | 20 | LOCNR | ||||
FLOCTYPE | Type of Customer-Facing Location | FLOCTYPE | CHAR | 4 | LOCTYP | ||||
EXECLOC | Executing Location | EXECLOC | CHAR | 20 | LOCNR | ||||
ELOCTYPE | Type of Executing Location | ELOCTYPE | CHAR | 4 | LOCTYP | ||||
LOGSYS | Logical system | LOGSYS | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | ||
VWPOS | Item usage | VWPOS | CHAR | 4 | Assigned to domain | VWPOS | |||
STOCKLOC | First Inventory-Managing Location | STOCKLOC | CHAR | 20 | LOCNR | ||||
SLOCTYPE | Type of First Inventory-Managing Location | SLOCTYPE | CHAR | 4 | LOCTYP |
Key field | Non-key field |
How do I retrieve data from SAP structure MC11VA0SCL using ABAP code?
As MC11VA0SCL 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 MC11VA0SCL as there is no data to select.How to access SAP table MC11VA0SCL
Within an ECC or HANA version of SAP you can also view further information about MC11VA0SCL 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