SAP ABAP Table MCEKET (Purchasing Document Delivery Schedule)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ MCE (Package) R/3 application development: Purchasing Information System
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ MCE (Package) R/3 application development: Purchasing Information System
Basic Data
Table Category | INTTAB | Structure |
Structure | MCEKET | Table Relationship Diagram |
Short Description | Purchasing Document Delivery Schedule |
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 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | EBELN | EBELN | EBELN | CHAR | 10 | 0 | Purchasing Document Number | EKKO | |
3 | EBELP | EBELP | EBELP | NUMC | 5 | 0 | Item Number of Purchasing Document | EKPO | |
4 | ETENR | EETEN | EETEN | NUMC | 4 | 0 | Delivery Schedule Line Counter | EKET | |
5 | EINDT | EINDT | DATUM | DATS | 8 | 0 | Item delivery date | ||
6 | SLFDT | SLFDT | DATUM | DATS | 8 | 0 | Statistics-Relevant Delivery Date | ||
7 | MENGE_R | MC_MENGE_R | MENGV15_3 | QUAN | 15 | 3 | Order quantity (returns) | ||
8 | MENGE | ETMEN | MENGE | QUAN | 13 | 3 | Scheduled Quantity | ||
9 | UZEIT | UZEIT | UZEIT | TIMS | 6 | 0 | Time | ||
10 | MAHNZ | MAHNZ | PACK2 | DEC | 3 | 0 | Number of Reminders/Expediters | ||
11 | BEDAT | ETBDT | DATUM | DATS | 8 | 0 | Order date of schedule line | ||
12 | WEMNG_R | MC_WEMNG_R | MENGV15_3 | QUAN | 15 | 3 | Goods receipt quantity of returns | ||
13 | WEMNG | WEMNG | MENG13 | QUAN | 13 | 3 | Quantity of goods received | ||
14 | LPEIN | LPEIN | PRGBZ | CHAR | 1 | 0 | Category of delivery date | * | |
15 | WAMNG | WAMNG | MENG13 | QUAN | 13 | 3 | Issued quantity | ||
16 | GLMNG | GLMNG | MENG13 | QUAN | 13 | 3 | Quantity Delivered (Stock Transfer) | ||
17 | DABMG | DABMG | MENGE | QUAN | 13 | 3 | Quantity Reduced (MRP) | ||
18 | BANFN | BANFN | BANFN | CHAR | 10 | 0 | Purchase requisition number | ||
19 | BNFPO | BNFPO | BNFPO | NUMC | 5 | 0 | Item number of purchase requisition | * | |
20 | CHARG | CHARG_D | CHARG | CHAR | 10 | 0 | Batch Number | * | |
21 | .INCLUDE | 0 | 0 | Additional Fields: Purchasing Document Schedule Lines | |||||
22 | REMNG_R | MC_REMNG_R | MENGV15_3 | QUAN | 15 | 3 | Invoice receipt quantity of returns | ||
23 | REMNG | REMNG | MENG13 | QUAN | 13 | 3 | Quantity invoiced | ||
24 | REWRT_R | MC_REWRT_R | WERTV8 | CURR | 15 | 2 | Invoice amount: Returns | ||
25 | REWRT | REWRT | WRTV7 | CURR | 13 | 2 | Invoice value in local currency | ||
26 | BZGWR | MC_BZGWR | CURR | 13 | 2 | Delivery costs for order from invoice in LC | |||
27 | BZGMG | MC_BZGMG | MENG13 | QUAN | 13 | 3 | Quantity resulting in delivery costs for purchase order | ||
28 | WEWRT_R | MC_WEWRT_R | WERTV8 | CURR | 15 | 2 | Goods receipt value of returns in local currency | ||
29 | WEWRT | WEWRT | WERT7 | CURR | 13 | 2 | Value of goods received in local currency | ||
30 | BZGWW | MC_BZGWW | WRTV7 | CURR | 13 | 2 | Delivery costs for order from goods receipt in LC | ||
31 | .INCLUDE | 0 | 0 | Enhancements of MCEKET through MMS | |||||
32 | BBZMNG | MCW_BBZMNG | MENGV15_3 | QUAN | 15 | 3 | Order stock receipts quantity in BUn | ||
33 | BBZGEO | MCW_BBZGEO | WERTV10 | CURR | 19 | 2 | Order stock receipts at cost | ||
34 | BBZGVO | MCW_BBZGVO | WERTV10 | CURR | 19 | 2 | Order stock receipts at retail | ||
35 | BBZGVP | MCW_BBZGVP | WERTV10 | CURR | 19 | 2 | Order stock receipts at retail with tax | ||
36 | BBZGEW | MCW_BBZGEW | MENGV15_3 | QUAN | 15 | 3 | Order stock receipts weight | ||
37 | BBZVOL | MCW_BBZVOL | MENGV15_3 | QUAN | 15 | 3 | Order stock receipts volume | ||
38 | BBAMNG | MCW_BBAMNG | MENGV15_3 | QUAN | 15 | 3 | Order stock issues quantity in BUn | ||
39 | BBAGEO | MCW_BBAGEO | WERTV10 | CURR | 19 | 2 | Order stock issues at cost | ||
40 | BBAGVO | MCW_BBAGVO | WERTV10 | CURR | 19 | 2 | Order stock issues at retail | ||
41 | BBAGVP | MCW_BBAGVP | WERTV10 | CURR | 19 | 2 | Order stock issues at retail with tax | ||
42 | BBAGEW | MCW_BBAGEW | MENGV15_3 | QUAN | 15 | 3 | Order stock issues weight | ||
43 | BBAVOL | MCW_BBAVOL | MENGV15_3 | QUAN | 15 | 3 | Order stock issues volume | ||
44 | DBWMNG | MCW_DBWMNG | MENGV15_3 | QUAN | 15 | 3 | Delta purchase order/goods receipt quantity in BUn | ||
45 | DBWGEO | MCW_DBWGEO | WERTV10 | CURR | 19 | 2 | Delta purchase order/goods receipt at cost | ||
46 | DBWGVO | MCW_DBWGVO | WERTV10 | CURR | 19 | 2 | Delta purchase order/goods receipt at retail | ||
47 | DBWGVP | MCW_DBWGVP | WERTV10 | CURR | 19 | 2 | Delta purchase order/goods receipt at retail with tax | ||
48 | DBWGEW | MCW_DBWGEW | MENGV15_3 | QUAN | 15 | 3 | Delta purchase order/goods receipt weight | ||
49 | DBWVOL | MCW_DBWVOL | MENGV15_3 | QUAN | 15 | 3 | Delta purchase order/goods receipt volume | ||
50 | BIWMNG | MCW_BIWMNG | MENGV15_3 | QUAN | 15 | 3 | RIS/Reporting Server - Transfer base quantity | ||
51 | BIWGEO | MCW_BIWGEO | WERTV10 | CURR | 19 | 2 | RIS/Reporting Server - Transfer cost price | ||
52 | BIWGVO | MCW_BIWGVO | WERTV10 | CURR | 19 | 2 | RIS/Reporting Server - Transfer retail price | ||
53 | BIWGVP | MCW_BIWGVP | WERTV10 | CURR | 19 | 2 | RIS/Reporting Server - Transfer retail price with tax | ||
54 | KZWI1 | KZWI1 | WERTV7 | CURR | 13 | 2 | Subtotal 1 from pricing procedure for condition | ||
55 | KZWI2 | KZWI2 | WERTV7 | CURR | 13 | 2 | Subtotal 2 from pricing procedure for condition | ||
56 | KZWI3 | KZWI3 | WERTV7 | CURR | 13 | 2 | Subtotal 3 from pricing procedure for condition | ||
57 | KZWI4 | KZWI4 | WERTV7 | CURR | 13 | 2 | Subtotal 4 from pricing procedure for condition | ||
58 | KZWI5 | KZWI5 | WERTV7 | CURR | 13 | 2 | Subtotal 5 from pricing procedure for condition | ||
59 | KZWI6 | KZWI6 | WERTV7 | CURR | 13 | 2 | Subtotal 6 from pricing procedure for condition | ||
60 | NETWR | NETWR | WERTV8 | CURR | 15 | 2 | Net Value in Document Currency | ||
61 | BRTWR | BRTWR | WERT11 | CURR | 11 | 2 | Gross value | ||
62 | ERZET | ERZET | UZEIT | TIMS | 6 | 0 | Entry time | ||
63 | HSUPKZ | MCW_SUPKZ | SUPKZ | CHAR | 1 | 0 | Auxiliary statistics update indicator | ||
64 | .INCLUDE | 0 | 0 | W&S: Enhancement MCEKET | |||||
65 | LEDAT | MCL_LEDAT | DATUM | DATS | 8 | 0 | Delivery creation date at schedule line level | ||
66 | .INCLUDE | 0 | 0 | User Structure: Purchasing Document Schedule Lines | |||||
67 | DUMMY | DUMMY | DUMMY | CHAR | 1 | 0 | Dummy function in length 1 | ||
68 | .INCLU--AP | 0 | 0 | MCEKET Enhancement Seasonal Procurement: Procurement | |||||
69 | .INCLUDE | 0 | 0 | EKET Enhancement: OTB | |||||
70 | .INCLUDE | 0 | 0 | OTB-Relevant Data | |||||
71 | KEY_ID | WRF_BUDG_KEY_ID | WRF_BUDG_KEY_ID | NUMC | 16 | 0 | Unique Number of Budget | ||
72 | OTB_VALUE | WRF_POTB_VALUE | WRF_POTB_VALUE | CURR | 17 | 2 | Required Budget | ||
73 | .INCLUDE | 0 | 0 | OTB Currency | |||||
74 | OTB_CURR | WRF_POTB_CURRENCY | WAERS | CUKY | 5 | 0 | OTB Currency | * | |
75 | OTB_RES_VALUE | WRF_POTB_RES_VALUE | WRF_POTB_RES_VALUE | CURR | 17 | 2 | Reserved Budget for OTB-Relevant Purchasing Document | ||
76 | OTB_SPEC_VALUE | WRF_POTB_SPECIAL_VALUE | WRF_POTB_SPECIAL_VALUE | CURR | 17 | 2 | Special Release Budget | ||
77 | SPR_RSN_PROFILE | WRF_POTB_SPR_RSN_PROFILE | WRF_POTB_SPR_RSN_PROFILE | CHAR | 4 | 0 | Reason Profile for OTB Special Release | ||
78 | BUDG_TYPE | WRF_BUDG_TYPE | WRF_BUDG_TYPE | CHAR | 2 | 0 | Budget Type | ||
79 | OTB_STATUS | WRF_POTB_STATUS | WRF_POTB_STATUS | CHAR | 1 | 0 | OTB Check Status | ||
80 | OTB_REASON | WRF_POTB_STATUS_REASON | WRF_POTB_STATUS_REASON | CHAR | 3 | 0 | Reason Indicator for OTB Check Status | ||
81 | CHECK_TYPE | WRF_BUDG_OTB_CHECK | WRF_BUDG_OTB_CHECK | CHAR | 1 | 0 | Type of OTB Check | ||
82 | .INCLUDE | 0 | 0 | EKET Enhancement: Scheduling | |||||
83 | .INCLUDE | 0 | 0 | Fields That Are Stored in Appl. Doc. e.g. Order List | |||||
84 | DL_ID | WRF_PSCD_DL_ID | SYSUUID_22 | CHAR | 22 | 0 | Date Line ID (GUID) | ||
85 | HANDOVER_DATE | WRF_PSCD_HANDOVER_DATE | DATS | DATS | 8 | 0 | Transfer Date | ||
86 | NO_SCEM | WRF_PSCD_NO_SCEM | CHAR1_X | CHAR | 1 | 0 | Purchase Order Not Transferred to SCEM | ||
87 | DNG_DATE | WRF_PCTR_DNG_DATE | DATUM | DATS | 8 | 0 | Creation Date of Reminder Message Record | ||
88 | DNG_TIME | WRF_PCTR_DNG_TIME | UZEIT | TIMS | 6 | 0 | Creation Time of Reminder Message Record | ||
89 | CNCL_ANCMNT_DONE | WRF_PCTR_CNCL_ANCMT_DONE | CHAR1_X | CHAR | 1 | 0 | Cancellation Threat Made | ||
90 | DATESHIFT_NUMBER | WRF_PCTR_DATESHIFT_NUMBER | DEC3 | DEC | 3 | 0 | Number of Current Date Shifts | ||
91 | .INCLU--AP | 0 | 0 | Append for BW Transfer | |||||
92 | .INCLUDE | 0 | 0 | Enhancement Structure MCEKET for BW Transfer | |||||
93 | BWMNG | MCBW_MBE | MENGV15_3 | QUAN | 15 | 3 | BW: Quantity in Order Unit | ||
94 | BWGEOO | MCBW_GEOO | WERTV10 | CURR | 19 | 2 | BW: Cost Value in Order Currency | ||
95 | BWGEO | MCBW_GEO | WERTV10 | CURR | 19 | 2 | BW: Cost Value in Local Currency | ||
96 | BWGVO | MCBW_GVO | WERTV10 | CURR | 19 | 2 | BW: Retail Value in Local Currency | ||
97 | BWGVP | MCBW_GVP | WERTV10 | CURR | 19 | 2 | BW: Retail Value with Tax in Local Currency | ||
98 | BWSUPKZ | SUPKZ | SUPKZ | CHAR | 1 | 0 | Statistics update indicator (post in/post out) | ||
99 | BWKZWI1 | KZWI1 | WERTV7 | CURR | 13 | 2 | Subtotal 1 from pricing procedure for condition | ||
100 | BWKZWI2 | KZWI2 | WERTV7 | CURR | 13 | 2 | Subtotal 2 from pricing procedure for condition | ||
101 | BWKZWI3 | KZWI3 | WERTV7 | CURR | 13 | 2 | Subtotal 3 from pricing procedure for condition | ||
102 | BWKZWI4 | KZWI4 | WERTV7 | CURR | 13 | 2 | Subtotal 4 from pricing procedure for condition | ||
103 | BWKZWI5 | KZWI5 | WERTV7 | CURR | 13 | 2 | Subtotal 5 from pricing procedure for condition | ||
104 | BWKZWI6 | KZWI6 | WERTV7 | CURR | 13 | 2 | Subtotal 6 from pricing procedure for condition | ||
105 | BWNETWR | MC_BNETWR | WERT7 | CURR | 13 | 2 | Net order value in order currency | ||
106 | BWBRTWR | MC_BBRTWR | WERT7 | CURR | 13 | 2 | Gross order value in order currency | ||
107 | BWERZET | ERZET | UZEIT | TIMS | 6 | 0 | Entry time | ||
108 | BWEFFWR | MC_EFFWR | WERTV8 | CURR | 15 | 2 | Effective order value | ||
109 | RTBWMNG | RTMCBW_MBE | MENGV15_3 | QUAN | 15 | 3 | BW: Amount in Order Unit for Retail Content | ||
110 | RTBWGEO | RTMCBW_GEO | WERTV10 | CURR | 19 | 2 | BW: Cost Value in Local Currency for Retail Content | ||
111 | RTBWGVO | RTMCBW_GVO | WERTV10 | CURR | 19 | 2 | BW: Retail Value in Local Currency for Retail Content | ||
112 | RTBWGVP | RTMCBW_GVP | WERTV10 | CURR | 19 | 2 | BW: Retail Value with Tax in Local Currency |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | MCEKET | EBELN | EKKO | EBELN | |||
2 | MCEKET | EBELP | EKPO | EBELP | |||
3 | MCEKET | ETENR | EKET | ETENR | |||
4 | MCEKET | MANDT | T000 | MANDT |
History
Last changed by/on | SAP | 20110901 |
SAP Release Created in |