SAP ABAP Table MC11V_0SCL (Extraction SD Sales BW: Allocation Schedule Line)
Hierarchy
☛
SAP_APPL (Software Component) Logistics and Accounting
⤷ LO-LIS (Application Component) Logistics Information System (LIS)
⤷ MCEX (Package) Extraction Interface LIS-BW
⤷ LO-LIS (Application Component) Logistics Information System (LIS)
⤷ MCEX (Package) Extraction Interface LIS-BW
Basic Data
Table Category | INTTAB | Structure |
Structure | MC11V_0SCL | Table Relationship Diagram |
Short Description | Extraction SD Sales BW: Allocation Schedule Line |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | ROCANCEL | ROCANCEL | BOOLE | CHAR | 1 | 0 | Indicator: Cancel Data Record | ||
2 | .INCLUDE | 0 | 0 | Extraction SD Sales BW: Allocation Schedule Line VBUK | |||||
3 | VBELN | VBELN | VBELN | CHAR | 10 | 0 | Sales and Distribution Document Number | * | |
4 | .INCLUDE | 0 | 0 | Extraction SD Sales BW: Allocation Schedule Line MCVBUP | |||||
5 | ABSTA | ABSTA_VB | STATV | CHAR | 1 | 0 | Rejection status for SD item | ||
6 | POSNR | POSNR | POSNR | NUMC | 6 | 0 | Item number of the SD document | * | |
7 | .INCLUDE | 0 | 0 | Extraction SD Sales BW: Allocation Schedule Line MCVBEP | |||||
8 | BMENG | BMENG | MENG13 | QUAN | 13 | 3 | Confirmed quantity | ||
9 | EDATU | EDATU | DATUM | DATS | 8 | 0 | Schedule line date | ||
10 | ETENR | ETENR | ETENR | NUMC | 4 | 0 | Schedule line | * | |
11 | ETTYP | ETTYP | ETTYP | CHAR | 2 | 0 | Item Cat. in Schedule Line | * | |
12 | LDDAT | LDDAT | DATUM | DATS | 8 | 0 | Loading Date | ||
13 | LIFSP | LIFSP_EP | LIFSP | CHAR | 2 | 0 | Schedule line blocked for delivery | * | |
14 | MBDAT | MBDAT | DATUM | DATS | 8 | 0 | Material Staging/Availability Date | ||
15 | OLFMNG | OLFMNG | MENG13 | QUAN | 13 | 3 | Open quantity to be delivered (in sales unit) | ||
16 | TDDAT | TDDAT_D | DATUM | DATS | 8 | 0 | Transportation Planning Date | ||
17 | VRKME | VRKME | MEINS | UNIT | 3 | 0 | Sales unit | * | |
18 | WADAT | WADAT | DATUM | DATS | 8 | 0 | Goods Issue Date | ||
19 | WLDATBE | WLDATBE | DATUM | DATS | 8 | 0 | Desired del. date in confirmed schedule lines | ||
20 | WMENG | WMENG | MENG13 | QUAN | 13 | 3 | Order quantity in sales units | ||
21 | .INCLUDE | 0 | 0 | Extraction SD Sales BW: Allocation Schedule Line MCVBAK | |||||
22 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | * | |
23 | FAKSK | FAKSK | FAKSP | CHAR | 2 | 0 | Billing block in SD document | * | |
24 | HWAER | HWAER | WAERS | CUKY | 5 | 0 | Local Currency | * | |
25 | KUNNR | KUNAG | KUNNR | CHAR | 10 | 0 | Sold-to party | * | |
26 | KURST | KURST | KURST | CHAR | 4 | 0 | Exchange Rate Type | * | |
27 | KVGR1 | KVGR1 | KVGR1 | CHAR | 3 | 0 | Customer group 1 | * | |
28 | KVGR2 | KVGR2 | KVGR2 | CHAR | 3 | 0 | Customer group 2 | * | |
29 | KVGR3 | KVGR3 | KVGR3 | CHAR | 3 | 0 | Customer group 3 | * | |
30 | KVGR4 | KVGR4 | KVGR4 | CHAR | 3 | 0 | Customer group 4 | * | |
31 | KVGR5 | KVGR5 | KVGR5 | CHAR | 3 | 0 | Customer group 5 | * | |
32 | LIFSK | LIFSK | LIFSP | CHAR | 2 | 0 | Delivery block (document header) | * | |
33 | STWAE | STWAE | WAERS | CUKY | 5 | 0 | Statistics currency | * | |
34 | VBTYP | VBTYP | VBTYP | CHAR | 1 | 0 | SD document category | ||
35 | VKBUR | VKBUR | VKBUR | CHAR | 4 | 0 | Sales office | * | |
36 | VKGRP | VKGRP | VKGRP | CHAR | 3 | 0 | Sales group | * | |
37 | VKORG | VKORG | VKORG | CHAR | 4 | 0 | Sales Organization | * | |
38 | VTWEG | VTWEG | VTWEG | CHAR | 2 | 0 | Distribution Channel | * | |
39 | .INCLUDE | 0 | 0 | Extraction SD Sales BW: Allocation Schedule Line MCVBAP | |||||
40 | CHARG | CHARG_D | CHARG | CHAR | 10 | 0 | Batch Number | * | |
41 | EAN11 | EAN11 | EAN11 | CHAR | 18 | 0 | International Article Number (EAN/UPC) | ||
42 | ERDAT | ERDAT | DATUM | DATS | 8 | 0 | Date on which the record was created | ||
43 | FAKSP | FAKSP_AP | FAKSP | CHAR | 2 | 0 | Billing block for item | * | |
44 | GEWEI | GEWEI | MEINS | UNIT | 3 | 0 | Weight Unit | * | |
45 | MATKL | MATKL | MATKL | CHAR | 9 | 0 | Material Group | * | |
46 | MATNR | MATNR | MATNR | CHAR | 18 | 0 | Material Number | * | |
47 | MEINS | MEINS | MEINS | UNIT | 3 | 0 | Base Unit of Measure | * | |
48 | MVGR1 | MVGR1 | MVGR1 | CHAR | 3 | 0 | Material group 1 | * | |
49 | MVGR2 | MVGR2 | MVGR2 | CHAR | 3 | 0 | Material group 2 | * | |
50 | MVGR3 | MVGR3 | MVGR3 | CHAR | 3 | 0 | Material group 3 | * | |
51 | MVGR4 | MVGR4 | MVGR4 | CHAR | 3 | 0 | Material group 4 | * | |
52 | MVGR5 | MVGR5 | MVGR5 | CHAR | 3 | 0 | Material group 5 | * | |
53 | PKUNRE | KUNRE | KUNNR | CHAR | 10 | 0 | Bill-to party | * | |
54 | PKUNRG | KUNRG | KUNNR | CHAR | 10 | 0 | Payer | * | |
55 | PKUNWE | KUNWE | KUNNR | CHAR | 10 | 0 | Ship-to party | * | |
56 | PRODH | PRODH_D | PRODH | CHAR | 18 | 0 | Product Hierarchy | * | |
57 | PSPDNR | SPDNR | LIFNR | CHAR | 10 | 0 | Carrier | * | |
58 | PVRTNR | VRTNR | PERNR | NUMC | 8 | 0 | Sales employee | ||
59 | ROUTE | ROUTE | ROUTE | CHAR | 6 | 0 | Route | * | |
60 | SHKZG | SHKZG_VA | XFELD | CHAR | 1 | 0 | Returns Item | ||
61 | SPART | SPART | SPART | CHAR | 2 | 0 | Division | * | |
62 | STADAT | STADAT | DATUM | DATS | 8 | 0 | Statistics date | ||
63 | STCUR | STCUR_AP | KURRF | DEC | 9 | 5 | Exchange rate for statistics (Exch.rate at time of creation) | ||
64 | UMVKN | UMVKN | UMBSN | DEC | 5 | 0 | Denominator (divisor) for conversion of sales qty. into SKU | ||
65 | UMVKZ | UMVKZ | UMBSZ | DEC | 5 | 0 | Numerator (factor) for conversion of sales quantity into SKU | ||
66 | VOLEH | VOLEH | MEINS | UNIT | 3 | 0 | Volume unit | * | |
67 | VSTEL | VSTEL | VSTEL | CHAR | 4 | 0 | Shipping Point/Receiving Point | * | |
68 | WAERK | WAERK | WAERS | CUKY | 5 | 0 | SD document currency | * | |
69 | WERKS | WERKS_EXT | WERKS | CHAR | 4 | 0 | Plant (Own or External) | * | |
70 | .INCLUDE | 0 | 0 | Extraction SD Sales BW: Allocation Schedule Line MCVBKD | |||||
71 | BZIRK | BZIRK | BZIRK | CHAR | 6 | 0 | Sales district | * | |
72 | INCO1 | INCO1 | INCO1 | CHAR | 3 | 0 | Incoterms (part 1) | * | |
73 | INCO2 | INCO2 | INCO2 | CHAR | 28 | 0 | Incoterms (part 2) | ||
74 | KDGRP | KDGRP | KDGRP | CHAR | 2 | 0 | Customer group | * | |
75 | KURSK | KURSK | KURRF | DEC | 9 | 5 | Exchange Rate for Pricing and Statistics | ||
76 | SPARA | SPART_AK | SPART | CHAR | 2 | 0 | Division for order header | * | |
77 | PS_POSID | PS_POSID | PS_POSID | CHAR | 24 | 0 | Work Breakdown Structure Element (WBS Element) | ||
78 | B_DELAY | MCBW_B_DELAY | MCZAEHLER | DEC | 9 | 0 | BW Extraction SD/LE: Confirmation Delivery | ||
79 | VSMNG | VSMNG | MENG13 | QUAN | 13 | 3 | Delivered quantity in sales units | ||
80 | MCBW_WWERT | MCBW_WWERT | WERTV10 | CURR | 19 | 2 | BW: Value of Requested Quantity | ||
81 | MCBW_BWERT | MCBW_BWERT | WERTV10 | CURR | 19 | 2 | BW: Value of Confirmed Quantity | ||
82 | MCBW_VSWRT | MCBW_VSWRT | WERTV10 | CURR | 19 | 2 | BW: Delivered Value for Schedule Line | ||
83 | MCBW_OLFWRT | MCBW_OLFWRT | WERTV10 | CURR | 19 | 2 | BW: Open Sales Order Value for Schedule Line | ||
84 | MCBW_NETPR_AVKM | MCBW_NETPR_AVKM | WERTV6 | CURR | 11 | 2 | BW: Net Price Referring to Sales Quantity for Order Item | ||
85 | PERIV | PERIV | PERIV | CHAR | 2 | 0 | Fiscal Year Variant | * | |
86 | MCEX_APCAMPAIGN | MCEX_APCAMPAIGN | SYSUUID_C | CHAR | 32 | 0 | Campaign of referred sales order item for BW-Extraction | ||
87 | APOPLANNED | APOPLANNED | APOPLANNED | CHAR | 1 | 0 | Planning in APO |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |