SAP Table MCEKKO_B

Reference Structure of MCEKKO for Function Module

MCEKKO_B (Reference Structure of MCEKKO for Function Module) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link MCEKKO_B to other SAP tables.

Source: MCEKKO_B (Reference Structure of MCEKKO for Function Module)

MCEKKO_B table fields

Field Data element Checktable Datatype Length Decimals
SUPKZ Statistics update indicator (post in/post out) SUPKZ CHAR 1 0
1 Old status: charge off (negative posting)
2 New status: record
3 Standard item in a return (SD only)
0 Returns item in standard order (SD only)
MANDT Client MANDT T000 CLNT 3 0
EBELN Purchasing Document Number EBELN EKKO CHAR 10 0
BUKRS Company Code BUKRS T001 CHAR 4 0
BSTYP Purchasing Document Category BSTYP CHAR 1 0
A Request for quotation
B Purchase requisition
F Purchase order
I Info record
K Contract
L Scheduling agreement
Q Service entry sheet
W Source list
BSART Purchasing Document Type ESART T161 CHAR 4 0
BSAKZ Control indicator for purchasing document type BSAKZ CHAR 1 0
T Transport
R Purchase requisition for outline agreement
LOEKZ Deletion Indicator in Purchasing Document ELOEK CHAR 1 0
LIFNR Vendor Account Number ELIFN LFA1 CHAR 10 0
EKORG Purchasing Organization EKORG T024E CHAR 4 0
EKGRP Purchasing Group BKGRP T024 CHAR 3 0
WAERS Purchase order currency BSTWA TCURC CUKY 5 0
WKURS Exchange Rate WKURS DEC 9 5
KUFIX Indicator: Fixing of Exchange Rate KUFIX CHAR 1 0
X Yes
NULL No
BEDAT Purchasing Document Date EBDAT DATS 8 0
LLIEF Supplying Vendor LLIEF LFA1 CHAR 10 0
KUNNR Customer Number KUNNR KNA1 CHAR 10 0
RESWK Supplying (Issuing) Plant in Stock Transport Order RESWK T001W CHAR 4 0
LBLIF Field not used LBLIF LFA1 CHAR 10 0
KTWRT Target Value for Header Area per Distribution KTWRT CURR 15 2
SUBMI Collective Number SUBMI CHAR 10 0
KNUMV Number of the document condition KNUMV CHAR 10 0
STAFO Update group for statistics update STAFO TMCB CHAR 6 0
LIFRE Different Invoicing Party LIFRE LFA1 CHAR 10 0
FRGRL Release Not Yet Completely Effected FRGRL CHAR 1 0
X Yes
NULL No
STAKO Document with time-dependent conditions STAKO CHAR 1 0
X Yes
NULL No
KALSM Procedure (Pricing, Output Control, Acct. Det., Costing,...) KALSM_D CHAR 6 0
KORNR Correction of miscellaneous provisions KORNR CHAR 1 0
NULL No corrections of miscellaneous provisions
1 Correction of misc. provisions in invoice verification
RESBU Company Code BUKRS CHAR 4 0
MEMORY Purchase order not yet complete MEMER CHAR 1 0
X Yes
NULL No
REVNO Version number in Purchasing REVNO CHAR 8 0
KONZS Group key KONZS CHAR 10 0
LAND1 Country key of vendor MCLANDL T005 CHAR 3 0
HWAER Local Currency HWAER CUKY 5 0
SYDAT Date on which the purchasing document was entered MC_ERFDAT DATS 8 0
KZKPF Indicator: header counter relevant (R/2->R/3 link) MC_KZKPF CHAR 1 0
X Yes
NULL No
BUDAT Posting date of goods received or invoice receipt for order MC_BUDAT DATS 8 0
ARECH Number of invoices for vendors MC_ARECH INT4 10 0
AGUTS Number of credit memos for vendors MC_AGUTS INT4 10 0
BTRTYPA Plant cat./ category of assortment owner MCW_VLFKZ CHAR 1 0
A Store
B Distribution Center
BRESWK Company code of supplying plant MCW_BRESWK CHAR 4 0
DUMMY Dummy function in length 1 DUMMY CHAR 1 0
MERK4 Characteristic Value ATWRT CHAR 30 0
MERK5 Characteristic Value ATWRT CHAR 30 0
MERK6 Characteristic Value ATWRT CHAR 30 0
MERK7 Characteristic Value ATWRT CHAR 30 0
ATINM4 Internal characteristic ATINN NUMC 10 0
ATINM5 Internal characteristic ATINN NUMC 10 0
ATINM6 Internal characteristic ATINN NUMC 10 0
ATINM7 Internal characteristic ATINN NUMC 10 0
ORGLOGSY Logical System LOGSYSTEM CHAR 10 0
LOGSY Logical System LOGSYSTEM CHAR 10 0
STATU Status of Purchasing Document ESTAK CHAR 1 0
A RFQ with Quotation
B Purchase Order from Automatic Conversion of Requisitions
C Purchase Order from Goods Receipt
D Purchase Order from Data Transfer
E Purchase Order from Allocation Table
F Purchase Order from Kanban
G Purchase Order from Store Order
H Purchase Order from DRP
I Purchase Order from BAPI
J Purchase Order from ALE Scenario
L Scheduling Agreement from CRM
S Collective Purchase Order
X Purchase Order Created via Function Module
1 Purchase Order from APO
9 Enjoy Purchase Order
K Purchase Order from BBP
2 Third-Party Order from CRM
3 Returns Order from Incorrect Delivery
M Purchasing Document from E-Sourcing
4 Subsequent Stock Transport Order for Additional Item
5 Incorrect Item Returns from Stock Transport Orders
T Purchase Order from Transportation Management
W Purchase Order Ignored for Collective Delivery Run
KDATB Start of Validity Period KDATB DATS 8 0
KDATE End of Validity Period KDATE DATS 8 0
ALIEF Number of deliveries MC_ALIEF DEC 9 0
RESBU_XX Dummy function in length 1 DUMMY CHAR 1 0

MCEKKO_B foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
MCEKKO_B BSART MCEKKO_B MANDT T161 Purchasing Document Types MANDT
MCEKKO_B BSART MCEKKO_B BSTYP T161 Purchasing Document Types BSTYP
MCEKKO_B BSART MCEKKO_B BSART T161 Purchasing Document Types BSART
MCEKKO_B BUKRS MCEKKO_B MANDT T001 Company Codes MANDT
MCEKKO_B BUKRS MCEKKO_B BUKRS T001 Company Codes BUKRS
MCEKKO_B EBELN MCEKKO_B MANDT EKKO Purchasing Document Header MANDT
MCEKKO_B EBELN MCEKKO_B EBELN EKKO Purchasing Document Header EBELN
MCEKKO_B EKGRP MCEKKO_B EKGRP T024 Purchasing Groups EKGRP
MCEKKO_B EKGRP MCEKKO_B MANDT T024 Purchasing Groups MANDT
MCEKKO_B EKORG MCEKKO_B EKORG T024E Purchasing Organizations EKORG
MCEKKO_B EKORG MCEKKO_B MANDT T024E Purchasing Organizations MANDT
MCEKKO_B KUNNR MCEKKO_B KUNNR KNA1 General Data in Customer Master KUNNR
MCEKKO_B KUNNR MCEKKO_B MANDT KNA1 General Data in Customer Master MANDT
MCEKKO_B LAND1 MCEKKO_B LAND1 T005 Countries LAND1
MCEKKO_B LAND1 MCEKKO MANDT T005 Countries MANDT
MCEKKO_B LBLIF MCEKKO_B MANDT LFA1 Vendor Master (General Section) MANDT
MCEKKO_B LBLIF MCEKKO_B LBLIF LFA1 Vendor Master (General Section) LIFNR
MCEKKO_B LIFNR MCEKKO_B MANDT LFA1 Vendor Master (General Section) MANDT
MCEKKO_B LIFNR MCEKKO_B LIFNR LFA1 Vendor Master (General Section) LIFNR
MCEKKO_B LIFRE MCEKKO_B MANDT LFA1 Vendor Master (General Section) MANDT
MCEKKO_B LIFRE MCEKKO_B LIFRE LFA1 Vendor Master (General Section) LIFNR
MCEKKO_B LLIEF MCEKKO_B LLIEF LFA1 Vendor Master (General Section) LIFNR
MCEKKO_B LLIEF MCEKKO_B MANDT LFA1 Vendor Master (General Section) MANDT
MCEKKO_B MANDT MCEKKO_B MANDT T000 Clients MANDT
MCEKKO_B RESWK MCEKKO_B MANDT T001W Plants/Branches MANDT
MCEKKO_B RESWK MCEKKO_B RESWK T001W Plants/Branches WERKS
MCEKKO_B STAFO MCEKKO_B MANDT TMCB Update groups MANDT
MCEKKO_B STAFO MCEKKO_B STAFO TMCB Update groups STAFO
MCEKKO_B WAERS MCEKKO_B WAERS TCURC Currency Codes WAERS
MCEKKO_B WAERS MCEKKO_B MANDT TCURC Currency Codes MANDT