Follow us on LinkedIn for your next SAP project

SAP Table EKKO

Purchasing Document Header

EKKO (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 EKKO to other SAP tables.

A purchasing document has a header and one or more line items. The header is stored in table EKKO the line items are stored in table EKPO. The two tables can be linked together based on the purchasing document number (field EBELN). The header contains information relevant to the whole document. The items specify the materials or services to be procured. For example, information about the vendor and the document number is contained in the document header, and the material description and the order quantity are specified in each item.

The purchasing document table contains different categories of documents that share the same document structure but do not necessarily have the same business purpose. The document category is defined in field EKKO.BSTYP. The following document categories can be found in tables EKKO/EKPO:

Request for quotation (RFQ)

Transmits a requirement defined in a requisition for a material or service to potential vendors. The purpose is to ask vendors to send in quotations.

Quotation

Contains the prices and conditions received from the vendor and is the basis for vendor selection.

Purchase order (PO)

The buying entity�s request or instruction to a vendor (external supplier) to supply certain materials or render/perform certain services/works, formalizing a purchase transaction.

Contract

In the SAP Purchasing component, a type of "outline agreement", or longer-term buying arrangement. The contract is a binding commitment to procure a certain material or service from a vendor over a certain period of time.

Scheduling agreement

Another type of "outline agreement", or longer-term buying arrangement. Scheduling agreements provide for the creation of delivery schedules specifying purchase quantities, delivery dates, and possibly also precise times of delivery over a predefined period.

One other purchasing document type are purchase requisitions. These are documents that are internal to the organization and are not stored in the purchasing document table but in table EBAN

EKKO table fields

Field Data element Checktable Datatype Length Decimals Possible values
MANDT
Client
MANDT T000
CLNT
3 0
EBELN
Purchasing Document Number
EBELN
CHAR
10 0
BUKRS
Company Code
BUKRS T001
CHAR
4 0
BSTYP
Purchasing Document Category
EBSTYP
CHAR
1 0
BSART
Purchasing Document Type
ESART T161
CHAR
4 0
BSAKZ
Control indicator for purchasing document type
BSAKZ
CHAR
1 0
LOEKZ
Deletion Indicator in Purchasing Document
ELOEK
CHAR
1 0
STATU
Status of Purchasing Document
ESTAK
CHAR
1 0
AEDAT
Date on Which Record Was Created
ERDAT
DATS
8 0
ERNAM
Name of Person who Created the Object
ERNAM
CHAR
12 0
PINCR
Item Number Interval
PINCR
NUMC
5 0
LPONR
Last Item Number
LPONR EKPO
NUMC
5 0
LIFNR
Vendor Account Number
ELIFN LFA1
CHAR
10 0
SPRAS
Language Key
SPRAS T002
LANG
1 0
ZTERM
Terms of Payment Key
DZTERM
CHAR
4 0
ZBD1T
Cash (Prompt Payment) Discount Days
DZBDET
DEC
3 0
ZBD2T
Cash (Prompt Payment) Discount Days
DZBDET
DEC
3 0
ZBD3T
Cash (Prompt Payment) Discount Days
DZBDET
DEC
3 0
ZBD1P
Cash Discount Percentage 1
DZBD1P
DEC
5 3
ZBD2P
Cash Discount Percentage 2
DZBD2P
DEC
5 3
EKORG
Purchasing Organization
EKORG T024E
CHAR
4 0
EKGRP
Purchasing Group
BKGRP T024
CHAR
3 0
WAERS
Currency Key
WAERS TCURC
CUKY
5 0
WKURS
Exchange Rate
WKURS
DEC
9 5
KUFIX
Indicator: Fixing of Exchange Rate
KUFIX
CHAR
1 0
BEDAT
Purchasing Document Date
EBDAT
DATS
8 0
KDATB
Start of Validity Period
KDATB
DATS
8 0
KDATE
End of Validity Period
KDATE
DATS
8 0
BWBDT
Closing Date for Applications
BWBDT
DATS
8 0
ANGDT
Deadline for Submission of Bid/Quotation
ANGAB
DATS
8 0
BNDDT
Binding Period for Quotation
EBNDT
DATS
8 0
GWLDT
Warranty Date
MM_GWLDT
DATS
8 0
AUSNR
Bid invitation number
AUSCH EKKO
CHAR
10 0
ANGNR
Quotation Number
ANGNR
CHAR
10 0
IHRAN
Quotation Submission Date
IHRAN
DATS
8 0
IHREZ
Your Reference
IHREZ
CHAR
12 0
VERKF
Responsible Salesperson at Vendor's Office
EVERK
CHAR
30 0
TELF1
Vendor's Telephone Number
TELF0
CHAR
16 0
LLIEF
Supplying Vendor
LLIEF LFA1
CHAR
10 0
KUNNR
Customer Number
KUNNR KNA1
CHAR
10 0
KONNR
Number of Principal Purchase Agreement
KONNR EKKO
CHAR
10 0
ABGRU
Field Not Used
ABDUM
CHAR
2 0
AUTLF
Complete Delivery Stipulated for Each Purchase Order
KMPLF
CHAR
1 0
WEAKT
Indicator: Goods Receipt Message
WEAKT
CHAR
1 0
RESWK
Supplying (Issuing) Plant in Stock Transport Order
RESWK T001W
CHAR
4 0
LBLIF
Field not used
LBLIF LFA1
CHAR
10 0
INCO1
Incoterms (Part 1)
INCO1 TINC
CHAR
3 0
INCO2
Incoterms (Part 2)
INCO2
CHAR
28 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
KALSM
Procedure (Pricing, Output Control, Acct. Det., Costing,...)
KALSM_D T683
CHAR
6 0
STAFO
Update group for statistics update
STAFO
CHAR
6 0
LIFRE
Different Invoicing Party
LIFRE LFA1
CHAR
10 0
EXNUM
Number of foreign trade data in MM and SD documents
EXNUM EIKP
CHAR
10 0
UNSEZ
Our Reference
UNSEZ
CHAR
12 0
LOGSY
Logical System
LOGSYSTEM
CHAR
10 0
UPINC
Item Number Interval for Subitems
UPINC
NUMC
5 0
STAKO
Document with time-dependent conditions
STAKO
CHAR
1 0
FRGGR
Release group
FRGGR T16FG
CHAR
2 0
FRGSX
Release Strategy
FRGSX T16FS
CHAR
2 0
FRGKE
Release Indicator: Purchasing Document
FRGKE T16FB
CHAR
1 0
FRGZU
Release status
FRGZU
CHAR
8 0
FRGRL
Release Not Yet Completely Effected
FRGRL
CHAR
1 0
LANDS
Country for Tax Return
LAND1_STML T005
CHAR
3 0
LPHIS
Indicator for scheduling agreement release documentation
LPHIS
CHAR
1 0
ADRNR
Address number
AD_ADDRNUM
CHAR
10 0
STCEG_L
Country of Sales Tax ID Number
STCEG_L
CHAR
3 0
STCEG
VAT Registration Number
STCEG
CHAR
20 0
ABSGR
Reason for Cancellation
ABSGR T165R
NUMC
2 0
ADDNR
Document number for additional
ADDI_BELNR
CHAR
10 0
KORNR
Correction of miscellaneous provisions
KORNR
CHAR
1 0
MEMORY
Purchase order not yet complete
MEMER
CHAR
1 0
PROCSTAT
Purchasing document processing state
MEPROCSTATE
CHAR
2 0
RLWRT
Total value at time of release
RLWRT
CURR
15 2
REVNO
Version number in Purchasing
REVNO
CHAR
8 0
SCMPROC
SCM Process That Created the Purchase Order
SCMPROC
CHAR
1 0
REASON_CODE
Goods Receipt Reason Code
/SAPPSPRO/_GR_REASON_CODE
CHAR
4 0
MEMORYTYPE
Category of Incompleteness
MEMORYTYPE
CHAR
1 0
RETTP
Retention Indicator
RETTP
CHAR
1 0
RETPC
Retention in Percent
RETPZ
DEC
5 2
DPTYP
Down Payment Indicator
ME_DPTYP
CHAR
4 0
DPPCT
Down Payment Percentage
ME_DPPCNT
DEC
5 2
DPAMT
Down Payment Amount in Document Currency
ME_DPAMNT
CURR
11 2
DPDAT
Due Date for Down Payment
ME_DPDDAT
DATS
8 0
MSR_ID
Process Identification Number
MSR_PROCESS_ID
CHAR
10 0
HIERARCHY_EXISTS
Part of a Contract Hierarchy
HIERARCHY_EXISTS
CHAR
1 0
THRESHOLD_EXISTS
Threshold Value for Exchange Rates Exists
EX_RATE_THRESHOLD
CHAR
1 0
LEGAL_CONTRACT
Legal Contract Number
LEGAL_CONTRACT_ID
CHAR
40 0
DESCRIPTION
Contract Name
CONTRACT_DESCRIPTION
CHAR
40 0
RELEASE_DATE
Release Date of Contract
RELEASE_DATE
DATS
8 0
VSART
Shipping type
VERSART
CHAR
2 0
HANDOVERLOC
Location for a physical handover of goods
HANDOVER_LOC
CHAR
10 0
FORCE_ID
Internal Key for Force Element
/ISDFPS/FORCE_ID
CHAR
32 0
FORCE_CNT
Internal (Version) Counter
/ISDFPS/FORCE_CNT
NUMC
6 0
RELOC_ID
Relocation ID
/ISDFPS/RELOC_ID /ISDFPS/REL
CHAR
10 0
RELOC_SEQ_ID
Relocation Step ID
/ISDFPS/RELOC_SEQ_ID /ISDFPS/RELSEQ
CHAR
4 0
SOURCE_LOGSYS
Logical system
LOGSYS
CHAR
10 0
OIEXGNUM
Exchange agreement number
OIA_EXGNUM
CHAR
10 0
OIEXGTYP
Exchange type
OIA_EXGTYP
CHAR
4 0
OIAEVGTYPE
Evergreen type
OIA_EVTYPE
CHAR
1 0
OIPIPEVAL
Validation indicator for pipeline fields (X=ON, blank=OFF)
OID_PIPEV
CHAR
1 0
OIC_LIFNR
Account Number of Vendor or Creditor
LIFNR LFA1
CHAR
10 0
OIC_DCITYC
Destination city code
OIC_DCITYC T005G
CHAR
4 0
OIC_DCOUNC
Destination county code
OIC_DCOUNC T005E
CHAR
3 0
OIC_DREGIO
Destination region
OIC_DREGIO T005S
CHAR
3 0
OIC_DLAND1
Destination country
OIC_DLAND1 T005
CHAR
3 0
OIC_OCITYC
Origin city code
OIC_OCITYC T005G
CHAR
4 0
OIC_OCOUNC
Origin county code
OIC_OCOUNC T005E
CHAR
3 0
OIC_OREGIO
Origin region
OIC_OREGIO T005S
CHAR
3 0
OIC_OLAND1
Origin country
OIC_OLAND1 T005
CHAR
3 0
OIC_PORGIN
Tax origin
OIC_PORGIN
CHAR
15 0
OIC_PDESTN
Tax destination
OIC_PDESTN
CHAR
15 0
OIC_PTRIP
Pipeline trip number (external)
OIC_PTRIP
CHAR
16 0
OIC_PBATCH
OIC_PBATCH
CHAR
16 0
OIC_MOT
IS-OIL MAP external details mode of transport
OIC_MOT TVTR
CHAR
2 0
OIC_AORGIN
Alternate origin
OIC_AORGIN
CHAR
15 0
OIC_ADESTN
Alternate destination
OIC_ADESTN
CHAR
15 0
OIC_TRUCKN
Truck number
OIC_TRUCKN
CHAR
10 0
OIA_BASELO
Base location
OIA_BASELO
CHAR
15 0
OID_EXTBOL
External bill of lading
OID_EXTBOL
CHAR
16 0
OID_MISCDL
Miscellaneous delivery number
OID_MISCDL
CHAR
16 0
VZSKZ
Interest calculation indicator
VZSKZ
CHAR
2 0
POHF_TYPE
Document for Seasonal Purchase Order Processing
WRF_POHF_TYPE
CHAR
1 0
EQ_EINDT
Delivery Date Header: All Items Have Same Delivery Date
WRF_POHF_EQ_EINDT
DATS
8 0
EQ_WERKS
Plant Header: All Items Have Same Receiving Plant
WRF_POHF_EQ_EWERK
CHAR
4 0
FIXPO
Firm Deal Indicator
WRF_POHF_FIXPO
CHAR
1 0
EKGRP_ALLOW
Take Account of Purch. Group
WRF_POHF_EKGRP_ALLOW
CHAR
1 0
WERKS_ALLOW
Take Account of Plants
WRF_POHF_WERKS_ALLOW
CHAR
1 0
CONTRACT_ALLOW
Take Account of Contracts
WRF_POHF_CONTRACT_ALLOW
CHAR
1 0
PSTYP_ALLOW
Take Account of Item Categories
WRF_POHF_PSTYP_ALLOW
CHAR
1 0
FIXPO_ALLOW
Take Account of Fixed-Date Purchases Indicator
WRF_POHF_FIXPO_ALLOW
CHAR
1 0
KEY_ID_ALLOW
Consider Budget
WRF_POHF_KEY_ID_ALLOW
CHAR
1 0
AUREL_ALLOW
Take Account of Alloc. Table Relevance
WRF_POHF_AUREL_ALLOW
CHAR
1 0
DELPER_ALLOW
Take Account of Dlvy Period
WRF_POHF_DELPER_ALLOW
CHAR
1 0
EINDT_ALLOW
Take Account of Delivery Date
WRF_POHF_EINDT_ALLOW
CHAR
1 0
LTSNR_ALLOW
Include Vendor Subrange
WRF_POHF_LTSNR_ALLOW
CHAR
1 0
OTB_LEVEL
OTB Check Level
WRF_POTB_CHECK_LEVEL
CHAR
1 0
OTB_COND_TYPE
OTB Condition Type
WRF_POTB_COND_TYPE
CHAR
4 0
KEY_ID
Unique Number of Budget
WRF_BUDG_KEY_ID
NUMC
16 0
OTB_VALUE
Required Budget
WRF_POTB_VALUE
CURR
17 2
OTB_CURR
OTB Currency
WRF_POTB_CURRENCY
CUKY
5 0
OTB_RES_VALUE
Reserved Budget for OTB-Relevant Purchasing Document
WRF_POTB_RES_VALUE
CURR
17 2
OTB_SPEC_VALUE
Special Release Budget
WRF_POTB_SPECIAL_VALUE
CURR
17 2
SPR_RSN_PROFILE
Reason Profile for OTB Special Release
WRF_POTB_SPR_RSN_PROFILE
CHAR
4 0
BUDG_TYPE
Budget Type
WRF_BUDG_TYPE
CHAR
2 0
OTB_STATUS
OTB Check Status
WRF_POTB_STATUS
CHAR
1 0
OTB_REASON
Reason Indicator for OTB Check Status
WRF_POTB_STATUS_REASON
CHAR
3 0
CHECK_TYPE
Type of OTB Check
WRF_BUDG_OTB_CHECK
CHAR
1 0
CON_OTB_REQ
OTB-Relevant Contract
WRF_POTB_CON_REQ
CHAR
1 0
CON_PREBOOK_LEV
OTB Indicator Level for Contracts
WRF_POTB_PREBOOK_LEVEL
CHAR
1 0
CON_DISTR_LEV
Distribution Using Target Value or Item Data
WRF_POTB_DISTRIB_LEVEL
CHAR
1 0

EKKO foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
EKKO ABSGR EKKO MANDT T165R
Reason for Cancellation
MANDT
EKKO ABSGR EKKO ABSGR T165R
Reason for Cancellation
ABSGR
EKKO AUSNR EKKO MANDT EKKO
Purchasing Document Header
MANDT
EKKO AUSNR EKKO AUSNR EKKO
Purchasing Document Header
EBELN
EKKO BSART EKKO BSTYP T161
Purchasing Document Types
BSTYP
EKKO BSART EKKO BSART T161
Purchasing Document Types
BSART
EKKO BSART EKKO MANDT T161
Purchasing Document Types
MANDT
EKKO BUKRS EKKO BUKRS T001
Company Codes
BUKRS
EKKO BUKRS EKKO MANDT T001
Company Codes
MANDT
EKKO EKGRP EKKO MANDT T024
Purchasing Groups
MANDT
EKKO EKGRP EKKO EKGRP T024
Purchasing Groups
EKGRP
EKKO EKORG EKKO MANDT T024E
Purchasing Organizations
MANDT
EKKO EKORG EKKO EKORG T024E
Purchasing Organizations
EKORG
EKKO EXNUM EKKO MANDT EIKP
Foreign Trade: Export/Import Header Data
MANDT
EKKO EXNUM EKKO EXNUM EIKP
Foreign Trade: Export/Import Header Data
EXNUM
EKKO FRGGR EKKO MANDT T16FG
Release Groups
MANDT
EKKO FRGGR EKKO FRGGR T16FG
Release Groups
FRGGR
EKKO FRGKE EKKO MANDT T16FB
Release Indicator: Purchasing Document
MANDT
EKKO FRGKE EKKO FRGKE T16FB
Release Indicator: Purchasing Document
FRGKE
EKKO FRGSX EKKO MANDT T16FS
Release Strategies
MANDT
EKKO FRGSX EKKO FRGGR T16FS
Release Strategies
FRGGR
EKKO FRGSX EKKO FRGSX T16FS
Release Strategies
FRGSX
EKKO INCO1 EKKO MANDT TINC
Customers: Incoterms
MANDT
EKKO INCO1 EKKO INCO1 TINC
Customers: Incoterms
INCO1
EKKO KALSM EKKO MANDT T683
Pricing procedures
MANDT
EKKO KALSM T681V KVEWE T683
Pricing procedures
KVEWE
EKKO KALSM T681A KAPPL T683
Pricing procedures
KAPPL
EKKO KALSM EKKO KALSM T683
Pricing procedures
KALSM
EKKO KONNR EKKO MANDT EKKO
Purchasing Document Header
MANDT
EKKO KONNR EKKO KONNR EKKO
Purchasing Document Header
EBELN
EKKO KUNNR EKKO MANDT KNA1
General Data in Customer Master
MANDT
EKKO KUNNR EKKO KUNNR KNA1
General Data in Customer Master
KUNNR
EKKO LANDS EKKO LANDS T005
Countries
LAND1
EKKO LANDS EKKO MANDT T005
Countries
MANDT
EKKO LBLIF EKKO LBLIF LFA1
Vendor Master (General Section)
LIFNR
EKKO LBLIF EKKO MANDT LFA1
Vendor Master (General Section)
MANDT
EKKO LIFNR EKKO MANDT LFA1
Vendor Master (General Section)
MANDT
EKKO LIFNR EKKO LIFNR LFA1
Vendor Master (General Section)
LIFNR
EKKO LIFRE EKKO MANDT LFA1
Vendor Master (General Section)
MANDT
EKKO LIFRE EKKO LIFRE LFA1
Vendor Master (General Section)
LIFNR
EKKO LLIEF EKKO LLIEF LFA1
Vendor Master (General Section)
LIFNR
EKKO LLIEF EKKO MANDT LFA1
Vendor Master (General Section)
MANDT
EKKO LPONR EKKO EBELN EKPO
Purchasing Document Item
EBELN
EKKO LPONR EKKO LPONR EKPO
Purchasing Document Item
EBELP
EKKO LPONR EKKO MANDT EKPO
Purchasing Document Item
MANDT
EKKO MANDT EKKO MANDT T000
Clients
MANDT
EKKO OIC_DCITYC EKKO OIC_DCITYC T005G
City
CITYC
EKKO OIC_DCITYC SYST MANDT T005G
City
MANDT
EKKO OIC_DCITYC EKKO OIC_DLAND1 T005G
City
LAND1
EKKO OIC_DCITYC EKKO OIC_DREGIO T005G
City
REGIO
EKKO OIC_DCOUNC EKKO OIC_DLAND1 T005E
County
LAND1
EKKO OIC_DCOUNC EKKO OIC_DREGIO T005E
County
REGIO
EKKO OIC_DCOUNC EKKO OIC_DCOUNC T005E
County
COUNC
EKKO OIC_DCOUNC SYST MANDT T005E
County
MANDT
EKKO OIC_DLAND1 SYST MANDT T005
Countries
MANDT
EKKO OIC_DLAND1 EKKO OIC_DLAND1 T005
Countries
LAND1
EKKO OIC_DREGIO EKKO OIC_DLAND1 T005S
Taxes: Region (Province) Key
LAND1
EKKO OIC_DREGIO EKKO OIC_DREGIO T005S
Taxes: Region (Province) Key
BLAND
EKKO OIC_DREGIO SYST MANDT T005S
Taxes: Region (Province) Key
MANDT
EKKO OIC_LIFNR SYST MANDT LFA1
Vendor Master (General Section)
MANDT
EKKO OIC_LIFNR EKKO OIC_LIFNR LFA1
Vendor Master (General Section)
LIFNR
EKKO OIC_MOT SYST MANDT TVTR
Routes: Modes of Transport
MANDT
EKKO OIC_MOT EKKO OIC_MOT TVTR
Routes: Modes of Transport
VKTRA
EKKO OIC_OCITYC SYST MANDT T005G
City
MANDT
EKKO OIC_OCITYC EKKO OIC_OLAND1 T005G
City
LAND1
EKKO OIC_OCITYC EKKO OIC_OREGIO T005G
City
REGIO
EKKO OIC_OCITYC EKKO OIC_OCITYC T005G
City
CITYC
EKKO OIC_OCOUNC EKKO OIC_OREGIO T005E
County
REGIO
EKKO OIC_OCOUNC EKKO OIC_OCOUNC T005E
County
COUNC
EKKO OIC_OCOUNC SYST MANDT T005E
County
MANDT
EKKO OIC_OCOUNC EKKO OIC_OLAND1 T005E
County
LAND1
EKKO OIC_OLAND1 SYST MANDT T005
Countries
MANDT
EKKO OIC_OLAND1 EKKO OIC_OLAND1 T005
Countries
LAND1
EKKO OIC_OREGIO SYST MANDT T005S
Taxes: Region (Province) Key
MANDT
EKKO OIC_OREGIO EKKO OIC_OLAND1 T005S
Taxes: Region (Province) Key
LAND1
EKKO OIC_OREGIO EKKO OIC_OREGIO T005S
Taxes: Region (Province) Key
BLAND
EKKO RELOC_ID SYST MANDT /ISDFPS/REL
Definition of Relocation
MANDT
EKKO RELOC_ID EKKO RELOC_ID /ISDFPS/REL
Definition of Relocation
RELOC_ID
EKKO RELOC_SEQ_ID SYST MANDT /ISDFPS/RELSEQ
Definition of Relocation Steps
MANDT
EKKO RELOC_SEQ_ID EKKO RELOC_SEQ_ID /ISDFPS/RELSEQ
Definition of Relocation Steps
RELOC_SEQ_ID
EKKO RESWK EKKO MANDT T001W
Plants/Branches
MANDT
EKKO RESWK EKKO RESWK T001W
Plants/Branches
WERKS
EKKO SPRAS EKKO SPRAS T002
Language Keys (Component BC-I18)
SPRAS
EKKO WAERS EKKO WAERS TCURC
Currency Codes
WAERS
EKKO WAERS EKKO MANDT TCURC
Currency Codes
MANDT