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