SAP Table EKKO

Purchasing Document Header

What Is the SAP EKKO Table?

SAP EKKO Table stores purchasing document header data in SAP, including purchase orders. It contains information that applies to the whole document, such as supplier, company code, purchasing organization, purchasing group, document type, currency and other information that controls the document header.

EKKO stores header-level information, while EKPO stores individual items. A purchase order can contain several items, but it has one header record in EKKO.

Purchasing Document information is maintained across several tables, including:

  • EKKO: Purchasing Document Header Data
  • EKPO: Purchasing Document Item Data
  • EKET: Delivery Schedule Lines
  • EKBE: Purchase Order History

For Example:

Purchase Order 4500000001 is created for supplier S0001 to purchase two materials.

The supplier, company code, and document currency are maintained in EKKO table. The material numbers, quantities, item prices are maintained in the EKPO table. Its Goods Receipt and Invoice receipt history information can be reviewed in EKBE.

SAP consultants, users and support teams use EKKO to review purchase order header details and troubleshoot purchasing-related issues.

Quick overview

SAP table EKKO
Short description Purchasing Document Header
Table type Transparent table
Primary key MANDT (Client), EBELN (Purchasing Document Number)
Client-dependent Yes

At a glance

Module
Materials Management MM
Application component
PURCHASING MM-PUR

Technical details

Delivery class
A (Application table: master and transaction data)
Data class
APPL1 (Transaction Data, Transparent Tables)
Package
Purchasing (ME)

Primary key fields

Field Description Data element Type Length
MANDT Client MANDT CLNT 3
EBELN Purchasing Document Number EBELN CHAR 10

Table fields

196 fields

196 fields

Field Description Data element Domain Type Length Decimals Check table
MANDT Key Client MANDT MANDT CLNT 3 — T000
EBELN Key Purchasing Document Number EBELN EBELN CHAR 10 —
BUKRS Company Code BUKRS BUKRS CHAR 4 — T001
BSTYP Purchasing Document Category EBSTYP EBSTYP CHAR 1 —
BSART Purchasing Document Type ESART BSART CHAR 4 — T161
BSAKZ Control indicator for purchasing document type BSAKZ BSAKZ CHAR 1 —
LOEKZ Deletion Indicator in Purchasing Document ELOEK ELOEK CHAR 1 —
STATU Status of Purchasing Document ESTAK ESTAK CHAR 1 —
AEDAT Creation Date of Purchasing Document MMPUR_ERDAT DATUM DATS 8 —
ERNAM User of person who created a purchasing document MMPUR_ERNAM USNAM CHAR 12 —
LASTCHANGEDATETIME Change Time Stamp CHANGEDATETIME TZNTSTMPL DEC 21 7
PINCR Item Number Interval PINCR PINCR NUMC 5 —
LPONR Last Item Number LPONR EBELP NUMC 5 — EKPO
LIFNR Supplier's Account Number ELIFN LIFNR CHAR 10 — LFA1
SPRAS Language Key SPRAS SPRAS LANG 1 — T002
ZTERM Terms of Payment Key DZTERM ZTERM CHAR 4 —
ZBD1T Cash (Prompt Payment) Discount Days DZBDET ZBDXT DEC 3 0
ZBD2T Cash (Prompt Payment) Discount Days DZBDET ZBDXT DEC 3 0
ZBD3T Cash (Prompt Payment) Discount Days DZBDET ZBDXT DEC 3 0
ZBD1P Cash Discount Percentage 1 DZBD1P PRZ23 DEC 5 3
ZBD2P Cash Discount Percentage 2 DZBD2P PRZ23 DEC 5 3
EKORG Purchasing Organization EKORG EKORG CHAR 4 — T024E
EKGRP Purchasing Group BKGRP EKGRP CHAR 3 — T024
WAERS Currency Key WAERS WAERS CUKY 5 — TCURC
WKURS Exchange Rate WKURS KURSP DEC 9 5
KUFIX Indicator for Fixed Exchange Rate KUFIX XFELD CHAR 1 —
BEDAT Purchasing Document Date EBDAT DATUM DATS 8 —
KDATB Start of Validity Period KDATB DATUM DATS 8 —
KDATE End of Validity Period KDATE DATUM DATS 8 —
BWBDT Closing Date for Applications BWBDT DATUM DATS 8 —
ANGDT Deadline for Submission of Bid/Quotation ANGAB DATUM DATS 8 —
BNDDT Binding Period for Quotation EBNDT DATUM DATS 8 —
GWLDT Warranty Date MM_GWLDT DATUM DATS 8 —
AUSNR Bid invitation number AUSCH EBELN CHAR 10 — EKKO
ANGNR Quotation Number ANGNR ANGNR CHAR 10 —
IHRAN Quotation Submission Date IHRAN DATUM DATS 8 —
IHREZ Your Reference IHREZ TEXT12 CHAR 12 —
VERKF Responsible Salesperson at Supplier's Office EVERK TEXT30 CHAR 30 —
TELF1 Supplier's Telephone Number TELF0 TEXT16 CHAR 16 —
LLIEF Goods Supplier LLIEF LIFNR CHAR 10 — LFA1
KUNNR Customer Number KUNNR KUNNR CHAR 10 — KNA1
ACTIVE_ID Active Purchasing Document EBELN_AD EBELN CHAR 10 —
KONNR Number of principal purchase agreement KONNR EBELN CHAR 10 — EKKO
ABGRU Field Not Used ABDUM CHAR2 CHAR 2 —
AUTLF Complete Delivery Stipulated for Each Purchase Order KMPLF XFELD CHAR 1 —
WEAKT Indicator: Goods Receipt Message WEAKT XFELD CHAR 1 —
RESWK Supplying (issuing) plant in case of stock transport order RESWK WERKS CHAR 4 — T001W
LBLIF Field not used LBLIF LIFNR CHAR 10 — LFA1
INCO1 Incoterms (Part 1) INCO1 INCO1 CHAR 3 — TINC
INCO2 Incoterms (Part 2) INCO2 INCO2 CHAR 28 —
KTWRT Target Value for Header Area per Distribution KTWRT WERT15 CURR 15 2
DISTRIBUTIONTYPE Distribution Type for Purchasing Document MMPUR_DISTR_TYPE MMPUR_DISTRTYPE CHAR 1 —
SUBMI Collective Number SUBMI CHAR10 CHAR 10 —
KNUMV Number of the Document Condition KNUMV KNUMV CHAR 10 —
KALSM Procedure (Pricing, Output Control, Acct. Det., Costing,...) KALSM_D KALSM CHAR 6 — T683
STAFO Update Group for statistics update STAFO STAFO CHAR 6 —
LIFRE Different Invoicing Party LIFRE LIFNR CHAR 10 — LFA1
EXNUM Number of foreign trade data in MM and SD documents EXNUM EXNUM CHAR 10 — EIKP
UNSEZ Our Reference UNSEZ TEXT12 CHAR 12 —
LOGSY Logical System LOGSYSTEM LOGSYS CHAR 10 —
UPINC Item Number Interval for Subitems UPINC PINCR NUMC 5 —
STAKO Document with time-dependent conditions STAKO XFELD CHAR 1 —
FRGGR Release group FRGGR FRGGR CHAR 2 — T16FG
FRGSX Release Strategy FRGSX FRGSX CHAR 2 — T16FS
FRGKE Release Indicator: Purchasing Document FRGKE FRGKE CHAR 1 — T16FB
FRGZU Release State FRGZU FRGZU CHAR 8 —
FRGRL Release Not Yet Completely Effected FRGRL XFELD CHAR 1 —
LANDS Country/Region for Tax Report LAND1_STML LAND1 CHAR 3 — T005
LPHIS Indicator for scheduling agreement release documentation LPHIS XFELD CHAR 1 —
ADRNR Address Number AD_ADDRNUM AD_ADDRNUM CHAR 10 —
STCEG_L Country/Region of Sales Tax ID Number STCEG_L LAND1 CHAR 3 —
STCEG VAT Registration Number STCEG STCEG CHAR 20 —
ABSGR Reason for Cancellation ABSGR NUMC02 NUMC 2 — T165R
ADDNR Document number for additional ADDI_BELNR ADDI_BELNR CHAR 10 —
KORNR Correction of miscellaneous provisions KORNR KORNR CHAR 1 —
MEMORY Purchase order not yet complete MEMER XFELD CHAR 1 —
PROCSTAT Purchasing Document Processing State MEPROCSTATE MEPROCSTATE CHAR 2 —
PROCESS_INDICATOR Process Indicator for Purchase Order MMPUR_PROCESS_INDICATOR MMPUR_PROCESS_INDICATOR CHAR 3 —
RLWRT Total value at time of release RLWRT WERT15 CURR 15 2
CR_STAT Change Request Status CR_STAT CR_STAT CHAR 2 —
REVNO Version number in Purchasing REVNO REVNO CHAR 8 —
SCMPROC SCM Process That Created the Purchase Order SCMPROC CHAR1 CHAR 1 —
REASON_CODE Goods Receipt Reason Code /SAPPSPRO/_GR_REASON_CODE /SAPPSPRO/_GR_REASON_CODE CHAR 4 —
MEMORYTYPE Category of Incompleteness MEMORYTYPE MM_MEMORYTYPE CHAR 1 —
RETTP Retention Indicator RETTP RET_TYPE CHAR 1 —
RETPC Retention in Percent RETPZ PRZ32 DEC 5 2
DPTYP Down Payment Indicator ME_DPTYP ME_DPTYPE_DOMAIN CHAR 4 —
DPPCT Down Payment Percentage ME_DPPCNT PRZ32 DEC 5 2
DPAMT Down Payment Amount in Document Currency ME_DPAMNT WERT11 CURR 11 2
DPDAT Due Date for Down Payment ME_DPDDAT DATS DATS 8 —
MSR_ID Process Identification Number MSR_PROCESS_ID MSR_PROCESS_ID CHAR 10 —
HIERARCHY_EXISTS Part of a Contract Hierarchy HIERARCHY_EXISTS XFELD CHAR 1 —
GROUPING_ID Grouping ID for Company Codes MMPUR_D_CC_GROUPING_ID MMPUR_D_CC_GROUPING_ID CHAR 3 —
PARENT_ID ID of the Parent Document MMPUR_PARENT_DOCUMENT_ID EBELN CHAR 10 —
THRESHOLD_EXISTS Threshold Value for Exchange Rates Exists EX_RATE_THRESHOLD XFELD CHAR 1 —
LEGAL_CONTRACT Legal Contract Number LEGAL_CONTRACT_ID CHAR040 CHAR 40 —
DESCRIPTION Contract Name CONTRACT_DESCRIPTION TEXT40 CHAR 40 —
RELEASE_DATE Release Date of Contract RELEASE_DATE DATUM DATS 8 —
VSART Shipping Type VERSART VERSART CHAR 2 —
HANDOVERLOC Location for a physical handover of goods HANDOVER_LOC HANDOVER_LOC CHAR 10 —
SHIPCOND Shipping Conditions VSBED VSBED CHAR 2 —
HAS_CATALOG_RELEVANT_ITEMS Indicator for Purchasing Document with Catalog Item(s) MMPUR_DOC_IS_CATALOG_RELEVANT ABAP_BOOLEAN CHAR 1 —
INCOV Incoterms Version INCOV INCOV CHAR 4 — TINCV
INCO2_L Incoterms Location 1 INCO2_L INCO_L CHAR 70 —
INCO3_L Incoterms Location 2 INCO3_L INCO_L CHAR 70 —
INCO2_KEY Incoterm Location 1 - Place of Destination /SCMTMS/INC_LOC_1_KEY /SCMTMS/LOCUUID RAW 16 —
INCO3_KEY Incoterm Location 2 - Place of Delivery /SCMTMS/INC_LOC_2_KEY /SCMTMS/LOCUUID RAW 16 —
INCO4_KEY Incoterm - Deviating Place of Destination /SCMTMS/INC_DEV_PLACE_DEST_KEY /SCMTMS/LOCUUID RAW 16 —
GRWCU Currency of statistical values for foreign trade GRWCU WAERS CUKY 5 —
INTRA_REL Relevant for Intrastat Reporting INTRA_REL XFELD CHAR 1 —
INTRA_EXCL Exclude from Intrastat Reporting INTRA_EXCL XFELD CHAR 1 —
TOTAL_STATUS_PCS Product Compliance Supplier Check Status (All Items) MMPUR_PC_TOTAL_STATUS_PCS MMPUR_PC_TOTAL_STATUS_PCS CHAR 1 —
TOTAL_STATUS_PMA Product Marketability Status (All Items) MMPUR_PC_TOTAL_STATUS_PMA MMPUR_PC_TOTAL_STATUS_PMA CHAR 1 —
TOTAL_STATUS_DG Dangerous Goods Status (All Items) MMPUR_PC_TOTAL_STATUS_DG MMPUR_PC_TOTAL_STATUS_DG CHAR 1 —
TOTAL_STATUS_SDS Safety Data Sheet Status (All Items) MMPUR_PC_TOTAL_STATUS_SDS MMPUR_PC_TOTAL_STATUS_SDS CHAR 1 —
QTN_ERLST_SUBMSN_DATE The date as of which Quotations can be submitted QTN_ERLST_SUBMSN_DATE DATUM DATS 8 —
FOLLOWON_DOC_CAT Follow-On Purchasing Document Category FOLLOWONDOCCAT EBSTYP CHAR 1 —
FOLLOWON_DOC_TYPE Follow-On Purchasing Document Type FOLLOWONDOCTYPE BSART CHAR 4 —
DUMMY_EKKO_INCL_EEW_PS Data Element for Extensibility of Purchasing Document Header EKKO_INCL_EEW EKKO_INCL_EEW CHAR 1 —
EXTERNALSYSTEM ID of External Reference System MMPUR_EXTREFERENCESYSTEMID SLD_BSKEY CHAR 60 —
EXTERNALREFERENCEID External Reference ID MMPUR_EXTERNALREFERENCEID MMPUR_EXTREFID CHAR 70 —
EXT_REV_TMSTMP Timestamp for Revision of External Calls MM_EXT_REV_TMSTMP TZNTSTMPL DEC 21 7
ISEOPBLOCKED Business Purpose Completed EOPBLOCKED EOPBLOCKED CHAR 1 —
ISAGED Document is aged MMPUR_ISAGED XFELD CHAR 1 —
FORCE_ID Internal Key for Force Element /ISDFPS/FORCE_ID SYSUUID_C CHAR 32 —
FORCE_CNT Internal (Version) Counter /ISDFPS/FORCE_CNT NUMC6 NUMC 6 —
RELOC_ID Relocation ID /ISDFPS/RELOC_ID /ISDFPS/RELOC_ID CHAR 10 — /ISDFPS/REL
RELOC_SEQ_ID Relocation Step ID /ISDFPS/RELOC_SEQ_ID /ISDFPS/RELOC_SEQ_ID CHAR 4 — /ISDFPS/RELSEQ
SOURCE_LOGSYS Logical system LOGSYS LOGSYS CHAR 10 —
FSH_TRANSACTION Transaction Number FSH_TRANSACTION FSH_TRANSACTION CHAR 10 —
FSH_ITEM_GROUP Item Group FSH_ITEM_GROUP FSH_ITEM_GROUP NUMC 5 —
FSH_VAS_LAST_ITEM Last VAS Item Number FSH_VAS_LAST_ITEM FSH_VAS_ITEM NUMC 5 —
FSH_OS_STG_CHANGE Order Scheduling Strategy Fields Changed Manually FSH_OS_STG_CHANGE FLAG CHAR 1 —
TMS_REF_UUID Reference UUID of Transportation Management TMS_REF_UUID SYSUUID_22 CHAR 22 —
/DMBE/PAYMENTDEEMED Deemed Payment Date /DMBE/EM_DEEMEDDATE /DMBE/DM_DEEMEDDATE DATS 8 —
/DMBE/DEALNUMBER Deal Number /DMBE/EM_SMART_ID /DMBE/DM_SMART_ID CHAR 12 —
/DMBE/EVGIDRENEWAL Evergreen Renewal Period /DMBE/EM_EVERGREEN_ID /DMBE/DM_EVERGREEN_ID CHAR 4 —
/DMBE/EVGIDCANCEL Evergreen Cancellation Period /DMBE/EM_EVGIDCANCEL /DMBE/DM_EVERGREEN_ID CHAR 4 —
ZAPCGK Annexing package key /ILE/TAPCGK /ILE/TAPCGK NUMC 4 — /ILE/TV01
APCGK_EXTEND Extended key for annexing package /ILE/TAPCGK_EXT NUMC10 NUMC 10 —
ZBAS_DATE Base Date /ILE/TBASDATE DATUM DATS 8 —
ZADATTYP Annexing Date Type /ILE/TADATTYP /ILE/TDATETYP CHAR 1 —
ZSTART_DAT Annexing start date /ILE/TASDAT DATUM DATS 8 —
Z_DEV deviation percentage /ILE/TMPERC /ILE/TDEC3_3 DEC 6 3
ZINDANX indicator for annexed order type /ILE/TMANIND XFELD CHAR 1 —
ZLIMIT_DAT Annexing limit date (purchasing) /ILE/TALDAT DATUM DATS 8 —
NUMERATOR IL Annexing Numerator /ILE/NUMERATOR CHAR20 CHAR 20 —
HASHCAL_BDAT "The general acountant method" New base date. /ILE/HASHCAL_BDAT DATS DATS 8 —
HASHCAL Accountant general method /ILE/MTG_CHASHCAL /ILE/MTG_CHASHCAL CHAR 1 —
NEGATIVE Do not allow negative annexing /ILE/NEGATIVE_ANNEXING /ILE/NEGATIVE_ANNEXING CHAR 1 —
HASHCAL_EXISTS Purchasing Organization EKORG EKORG CHAR 4 —
KNOWN_INDEX Known Index indicator in /ILE/T_ANNEXING_CALCULATION Func /ILE/KNOWN_INDEX_ANX XFELD CHAR 1 —
POSTAT Flag for the S1POSTAT message ADSPC_POSTAT ADSPC_FLAG CHAR 1 —
VZSKZ Interest Indicator VZSKZ VZSKZ CHAR 2 —
FSH_SNST_STATUS Snapshot Status FSH_SNST_STATUS FSH_SNST_STATUS CHAR 2 —
PROCE Procedure number PFM_01NUMPROCEDIMENTO PFM_01NUMPROCEDIMENTO NUMC 9 — PFM_01TD04
CONC Adjustment/contest PFM_01CONCURSO PFM_01CONCURSO CHAR 5 — PFM_01TP12
CONT Contract PFM_01CONTRATO PFM_01CONTRATO CHAR 5 — PFM_01TP13
COMP Legal competence PFM_01COMPETENCIA PFM_01COMPETENCIA CHAR 5 — PFM_01TP14
OUTR Miscellaneous PFM_01OUTROS PFM_01OUTROS CHAR 5 — PFM_01TP15
DESP Despatch PFM_01DESPACHO TEXT100 CHAR 100 —
DESP_DAT Date DATUM DATUM DATS 8 —
DESP_CARGO Job PFM_01CARGO PFM_01CARGO CHAR 5 — PFM_01TP16
PARE Assessment PFM_01PARECER TEXT100 CHAR 100 —
PARE_DAT Date DATUM DATUM DATS 8 —
PARE_CARGO Job PFM_01CARGO PFM_01CARGO CHAR 5 — PFM_01TP16
PFM_CONTRACT PTFM: Contract in Purchasing process PFM_CONTRACT PS_POSNR NUMC 8 —
POHF_TYPE Document for Seasonal Purchase Order Processing WRF_POHF_TYPE WRF_POHF_TYPE CHAR 1 —
EQ_EINDT Delivery Date Header: All Items Have Same Delivery Date WRF_POHF_EQ_EINDT DATUM DATS 8 —
EQ_WERKS Plant Header: All Items Have Same Receiving Plant WRF_POHF_EQ_EWERK WERKS CHAR 4 —
FIXPO Firm Deal Indicator WRF_POHF_FIXPO WRF_POHF_FIXPO_X CHAR 1 —
EKGRP_ALLOW Take Account of Purch. Group WRF_POHF_EKGRP_ALLOW WRF_POHF_CHAR_1_2 CHAR 1 —
WERKS_ALLOW Take Account of Plants WRF_POHF_WERKS_ALLOW WRF_POHF_CHAR_1_2 CHAR 1 —
CONTRACT_ALLOW Take Account of Contracts WRF_POHF_CONTRACT_ALLOW WRF_POHF_CHAR_1_2 CHAR 1 —
PSTYP_ALLOW Take Account of Item Categories WRF_POHF_PSTYP_ALLOW WRF_POHF_CHAR_1_2 CHAR 1 —
FIXPO_ALLOW Take Account of Fixed-Date Purchases Indicator WRF_POHF_FIXPO_ALLOW WRF_POHF_CHAR_1_2 CHAR 1 —
KEY_ID_ALLOW Consider Budget WRF_POHF_KEY_ID_ALLOW WRF_POHF_CHAR_1_2 CHAR 1 —
AUREL_ALLOW Take Account of Alloc. Table Relevance WRF_POHF_AUREL_ALLOW WRF_POHF_CHAR_1_2 CHAR 1 —
DELPER_ALLOW Take Account of Dlvy Period WRF_POHF_DELPER_ALLOW WRF_POHF_CHAR_1_2 CHAR 1 —
EINDT_ALLOW Take Account of Delivery Date WRF_POHF_EINDT_ALLOW WRF_POHF_CHAR_1_2 CHAR 1 —
LTSNR_ALLOW Include Vendor Subrange WRF_POHF_LTSNR_ALLOW WRF_POHF_CHAR_1_2 CHAR 1 —
OTB_LEVEL OTB Check Level WRF_POTB_CHECK_LEVEL WRF_POTB_CHECK_LEVEL CHAR 1 —
OTB_COND_TYPE OTB Condition Type WRF_POTB_COND_TYPE KSCHL CHAR 4 —
KEY_ID Unique Number of Budget WRF_BUDG_KEY_ID WRF_BUDG_KEY_ID NUMC 16 —
OTB_VALUE Required Budget WRF_POTB_VALUE WRF_POTB_VALUE CURR 17 2
OTB_CURR OTB Currency WRF_POTB_CURRENCY WAERS CUKY 5 —
OTB_RES_VALUE Reserved Budget for OTB-Relevant Purchasing Document WRF_POTB_RES_VALUE WRF_POTB_RES_VALUE CURR 17 2
OTB_SPEC_VALUE Special Release Budget WRF_POTB_SPECIAL_VALUE WRF_POTB_SPECIAL_VALUE CURR 17 2
SPR_RSN_PROFILE Reason Profile for OTB Special Release WRF_POTB_SPR_RSN_PROFILE WRF_POTB_SPR_RSN_PROFILE CHAR 4 —
BUDG_TYPE Budget Type WRF_BUDG_TYPE WRF_BUDG_TYPE CHAR 2 —
OTB_STATUS OTB Check Status WRF_POTB_STATUS WRF_POTB_STATUS CHAR 1 —
OTB_REASON Reason Indicator for OTB Check Status WRF_POTB_STATUS_REASON WRF_POTB_STATUS_REASON CHAR 3 —
CHECK_TYPE Type of OTB Check WRF_BUDG_OTB_CHECK WRF_BUDG_OTB_CHECK CHAR 1 —
CON_OTB_REQ OTB-Relevant Contract WRF_POTB_CON_REQ CHAR1_X CHAR 1 —
CON_PREBOOK_LEV OTB Indicator Level for Contracts WRF_POTB_PREBOOK_LEVEL WRF_POTB_PREBOOK_LEVEL CHAR 1 —
CON_DISTR_LEV Distribution Using Target Value or Item Data WRF_POTB_DISTRIB_LEVEL WRF_POTB_DISTRIB_LEVEL CHAR 1 —

SAP EKKO Table Availability

SAP product Verified release/system Table availability Verified on
SAP S/4HANA 2023 - On-Premise - Initial Shipment Stack Available

Editorial and verification

Content editor
ERPSAP Content Team
Verified against
SAP S/4HANA 2023 On-Premise system
Last updated
October 12, 2026

The information on this SAP EKKO table page is based on the verified SAP S/4HANA 2023 on-premise system identified above. Table definitions, fields, and availability may differ across SAP releases and customer-specific systems.