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