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