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