SAP Table MCEKKO

Purchasing Document Header

MCEKKO (Purchasing Document Header) 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 to other SAP tables.

MCEKKO table fields

Field Data element Checktable Datatype Length Decimals
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 foreign key relationships

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