EKKO is a standard Purchasing Transparent Table in SAP MM application, which stores Purchasing Document Header data. Below you can view the Table Structure, columns(fields), SAP Wiki pages, discussion threads, related TCodes, FMs, ABAP Reports, BW Datasources, and Authorization Objects for EKKO. You can use the transaction code SE16 to view the data in this table, and SE11 TCode for the table structure and definition.

EKKO — Meta Data

Description: Purchasing Document Header
Main Category: MM
Sub Category: Purchasing
Table type: Transparent Table (TRANSP)

EKKO — Table Structure, Fields(Columns) and Definitions

    Position Column Name Description Primary Key Data Type Length Check Table
    1 MANDT Client X CLNT 3 T000
    2 EBELN Purchasing Doc. X CHAR 10
    3 .INCLUDE 0
    4 BUKRS Company Code CHAR 4 T001
    5 BSTYP Doc. Category CHAR 1
    6 BSART Document Type CHAR 4 T161
    7 BSAKZ Control indicator for purchasing document type CHAR 1
    8 LOEKZ Deletion flag for BOMs CHAR 1
    9 STATU Status CHAR 1
    10 AEDAT Changed on DATS 8
    11 ERNAM Created by CHAR 12
    12 LASTCHANGEDATETIME Draft Last Changed On DEC 21
    13 PINCR Item Number Interval NUMC 5
    14 LPONR Last Item Number NUMC 5 EKPO
    15 LIFNR Vendor CHAR 10 LFA1
    16 SPRAS Language Key LANG 1 T002
    17 ZTERM Payt terms CHAR 4
    18 ZBD1T Days DEC 3
    19 ZBD2T Days DEC 3
    20 ZBD3T Days net DEC 3
    21 ZBD1P Cash discount 1 DEC 5
    22 ZBD2P Cash discount 2 DEC 5
    23 EKORG Purchasing Org. CHAR 4 T024E
    24 EKGRP Purch. Group CHAR 3 T024
    25 WAERS Currency CUKY 5 TCURC
    26 WKURS Exchange Rate DEC 9
    27 KUFIX Indicator: Fixing of Exchange Rate CHAR 1
    28 BEDAT Document Date DATS 8
    29 KDATB Validity Start DATS 8
    30 KDATE Validity End DATS 8
    31 BWBDT Closing Date for Applications DATS 8
    32 ANGDT Valid from DATS 8
    33 BNDDT Valid to DATS 8
    34 GWLDT Warranty Date DATS 8
    35 AUSNR Bank statement number CHAR 10 EKKO
    36 ANGNR Quotation Number CHAR 10
    37 IHRAN Quotation Submission Date DATS 8
    38 IHREZ Your Reference CHAR 12
    39 VERKF Responsible Salesperson at Vendor's Office CHAR 30
    40 TELF1 First telephone number CHAR 16
    41 LLIEF Suppl. Vendor CHAR 10 LFA1
    42 KUNNR Customer CHAR 10 KNA1
    43 KONNR Agreement CHAR 10 EKKO
    44 ABGRU RejectionReason CHAR 2
    45 AUTLF Complete delivery defined for each sales order? CHAR 1
    46 WEAKT Indicator: Goods Receipt Message CHAR 1
    47 RESWK Supplying Plant CHAR 4 T001W
    48 LBLIF Receiv. vendor CHAR 10 LFA1
    49 INCO1 Incoterms CHAR 3 TINC
    50 INCO2 Incoterms 2 CHAR 28
    51 KTWRT Target Value for Header Area per Distribution CURR 15
    52 SUBMI Collective Number CHAR 10
    53 KNUMV Number of the document condition CHAR 10
    54 KALSM Procedure (Pricing CHAR 6 T683
    55 STAFO Update group for statistics update CHAR 6 *
    56 LIFRE Invoicing Pty CHAR 10 LFA1
    57 EXNUM Number of foreign trade data in MM and SD documents CHAR 10 EIKP
    58 UNSEZ Our Reference CHAR 12
    59 LOGSY Logical System CHAR 10 *
    60 UPINC Item Number Interval for Subitems NUMC 5
    61 STAKO Document with time-dependent conditions CHAR 1
    62 FRGGR Release group CHAR 2 T16FG
    63 FRGSX Release Strategy CHAR 2 T16FS
    64 FRGKE Release Indicator: Purchasing Document CHAR 1 T16FB
    65 FRGZU Release State CHAR 8
    66 FRGRL Release Not Yet Completely Effected CHAR 1
    67 LANDS Country for Tax Return CHAR 3 T005
    68 LPHIS Indicator for scheduling agreement release documentation CHAR 1
    69 ADRNR Address CHAR 10 *
    70 STCEG_L Country of Sales Tax ID Number CHAR 3 *
    71 STCEG VAT registration number CHAR 20
    72 ABSGR Reason for Cancellation NUMC 2 T165R
    73 ADDNR Document number for additional CHAR 10
    74 KORNR Correction of miscellaneous provisions CHAR 1
    75 MEMORY Purchase order not yet complete CHAR 1
    76 PROCSTAT Purchasing document processing state CHAR 2
    77 RLWRT Total value at time of release CURR 15
    78 REVNO Version number in Purchasing CHAR 8
    79 SCMPROC SCM Process That Created the Purchase Order CHAR 1
    80 REASON_CODE Goods Receipt Reason Code CHAR 4
    81 MEMORYTYPE Category of Incompleteness CHAR 1
    82 RETTP Retention Indicator CHAR 1
    83 RETPC Retention in Percent DEC 5
    84 DPTYP Down Payment Indicator CHAR 4
    85 DPPCT Down Payment Percentage DEC 5
    86 DPAMT Down Payment Amount in Document Currency CURR 11
    87 DPDAT Due Date for Down Payment DATS 8
    88 MSR_ID Process Identification Number CHAR 10
    89 HIERARCHY_EXISTS Part of a Contract Hierarchy CHAR 1
    90 THRESHOLD_EXISTS Threshold Value for Exchange Rates Exists CHAR 1
    91 LEGAL_CONTRACT test legal contract CHAR 40
    92 DESCRIPTION Description for Item CHAR 40
    93 RELEASE_DATE Release Date of Operational Sys. for Commission Notification DATS 8
    94 VSART Shipping type CHAR 2 *
    95 HANDOVERLOC Location for a physical handover of goods CHAR 10
    96 SHIPCOND Shipping Conditions CHAR 2 *
    97 .INCLUDE 0
    98 INCOV Incoterms Version CHAR 4 TINCV
    99 INCO2_L Incoterms Location 1 CHAR 70
    100 INCO3_L Incoterms Location 2 CHAR 70
    101 GRWCU Updated information in related user data field CUKY 5 *
    102 .INCLUDE 0
    103 INTRA_REL Updated information in related user data field CHAR 1
    104 INTRA_EXCL Updated information in related user data field CHAR 1
    105 QTN_ERLST_SUBMSN_DATE DATS 8
    106 FOLLOWON_DOC_CAT CHAR 1
    107 FOLLOWON_DOC_TYPE CHAR 4 *
    108 .INCLUDE 0
    109 DUMMY_EKKO_INCL_EEW_PS CHAR 1
    110 .INCLUDE 0
    111 EXTERNALSYSTEM Updated information in related user data field CHAR 60
    112 EXTERNALREFERENCEID Updated information in related user data field CHAR 70
    113 EXT_REV_TMSTMP Updated information in related user data field DEC 21
    114 ISEOPBLOCKED Deletion indicator in purchasing document CHAR 1
    115 ISAGED CHAR 1
    116 .INCLU--AP 0
    117 .INCLUDE 0
    118 FORCE_ID Internal Key for Force Element CHAR 32
    119 FORCE_CNT Internal (Version) Counter NUMC 6
    120 RELOC_ID Relocation ID CHAR 10 /ISDFPS/REL
    121 RELOC_SEQ_ID Relocation Step ID CHAR 4 /ISDFPS/RELSEQ
    122 SOURCE_LOGSYS Logical System CHAR 10 *
    123 .INCLU--AP 0
    124 FSH_TRANSACTION Transaction Number CHAR 10
    125 FSH_ITEM_GROUP Item Group NUMC 5
    126 FSH_VAS_LAST_ITEM Last VAS Item Number NUMC 5
    127 FSH_OS_STG_CHANGE Order Scheduling Strategy specific fields change manually CHAR 1
    128 .INCLU--AP 0
    129 OIEXGNUM Exchange agreement number CHAR 10
    130 OIEXGTYP Exchange type CHAR 4 *
    131 OIAEVGTYPE Evergreen type CHAR 1
    132 .INCLU--AP 0
    133 .INCLUDE 0
    134 OIPIPEVAL Validation indicator for pipeline fields (X=ON CHAR 1
    135 OIC_LIFNR Account Number of Vendor or Creditor CHAR 10 LFA1
    136 .INCLUDE 0
    137 OIC_DCITYC Destination city code CHAR 4 T005G
    138 OIC_DCOUNC Destination county code CHAR 3 T005E
    139 OIC_DREGIO Destination region CHAR 3 T005S
    140 OIC_DLAND1 Destination country CHAR 3 T005
    141 OIC_OCITYC Origin city code CHAR 4 T005G
    142 OIC_OCOUNC Origin county code CHAR 3 T005E
    143 OIC_OREGIO Origin region CHAR 3 T005S
    144 OIC_OLAND1 Origin country CHAR 3 T005
    145 OIC_PORGIN Tax origin CHAR 15
    146 OIC_PDESTN Tax destination CHAR 15
    147 OIC_PTRIP Pipeline trip number (external) CHAR 16
    148 OIC_PBATCH Pipeline operators external batch number CHAR 16
    149 OIC_MOT IS-OIL MAP external details mode of transport CHAR 2 TVTR
    150 OIC_AORGIN Alternate origin CHAR 15
    151 OIC_ADESTN Alternate destination CHAR 15
    152 OIC_TRUCKN Truck number CHAR 10
    153 OIA_BASELO Base location CHAR 15
    154 .INCLUDE 0
    155 OID_EXTBOL External bill of lading CHAR 16
    156 OID_MISCDL Miscellaneous delivery number CHAR 16
    157 .INCLU--AP 0
    158 TMS_REF_UUID Updated information in related user data field CHAR 22
    159 .INCLUDE 0
    160 .INCLU--AP 0
    161 .INCLUDE 0
    162 ZAPCGK Updated information in related user data field NUMC 4 /ILE/TV01
    163 APCGK_EXTEND Extended key for annexing package NUMC 10
    164 ZBAS_DATE Updated information in related user data field DATS 8
    165 ZADATTYP Updated information in related user data field CHAR 1
    166 ZSTART_DAT Updated information in related user data field DATS 8
    167 Z_DEV Updated information in related user data field DEC 6
    168 ZINDANX Updated information in related user data field CHAR 1
    169 ZLIMIT_DAT Updated information in related user data field DATS 8
    170 NUMERATOR Numerator for Conversion to Base UOM CHAR 20
    171 .INCLUDE 0
    172 HASHCAL_BDAT DATS 8
    173 HASHCAL CHAR 1
    174 NEGATIVE negative correct. statement CHAR 1
    175 HASHCAL_EXISTS Purchasing organization CHAR 4 *
    176 KNOWN_INDEX CHAR 1
    177 .INCLU--AP 0
    178 POSTAT Flag for the S1POSTAT message CHAR 1
    179 .INCLU--AP 0
    180 .INCLUDE 0
    181 VZSKZ Interest Calculation Indicator CHAR 2 *
    182 .INCLU--AP 0
    183 FSH_SNST_STATUS Snapshot Status CHAR 2
    184 .INCLU--AP 0
    185 .INCLUDE 0
    186 PROCE Approval Percentage NUMC 9 PFM_01TD04
    187 CONC Updated information in related user data field CHAR 5 PFM_01TP12
    188 CONT Position in AABP CHAR 5 PFM_01TP13
    189 COMP CHAR 5 PFM_01TP14
    190 OUTR Updated information in related user data field CHAR 5 PFM_01TP15
    191 DESP Updated information in related user data field CHAR 100
    192 DESP_DAT Date DATS 8
    193 DESP_CARGO Updated information in related user data field CHAR 5 PFM_01TP16
    194 PARE Updated information in related user data field CHAR 100
    195 PARE_DAT Date DATS 8
    196 PARE_CARGO Updated information in related user data field CHAR 5 PFM_01TP16
    197 PFM_CONTRACT Updated information in related user data field NUMC 8
    198 .INCLU--AP 0
    199 .INCLUDE 0
    200 POHF_TYPE Document for Seasonal Purchase Order Processing CHAR 1
    201 EQ_EINDT Delivery Date Header: All Items Have Same Delivery Date DATS 8
    202 EQ_WERKS Plant Header: All Items Have Same Receiving Plant CHAR 4 *
    203 FIXPO Firm Deal Indicator CHAR 1
    204 .INCLUDE 0
    205 EKGRP_ALLOW Take Account of Purch. Group CHAR 1
    206 WERKS_ALLOW Take Account of Plants CHAR 1
    207 CONTRACT_ALLOW Take Account of Contracts CHAR 1
    208 PSTYP_ALLOW Take Account of Item Categories CHAR 1
    209 FIXPO_ALLOW Take Account of Fixed-Date Purchases Indicator CHAR 1
    210 KEY_ID_ALLOW Consider Budget CHAR 1
    211 AUREL_ALLOW Take Account of Alloc. Table Relevance CHAR 1
    212 DELPER_ALLOW Take Account of Dlvy Period CHAR 1
    213 EINDT_ALLOW Take Account of Delivery Date CHAR 1
    214 LTSNR_ALLOW Include Vendor Subrange CHAR 1
    215 .INCLUDE 0
    216 OTB_LEVEL OTB Check Level CHAR 1
    217 OTB_COND_TYPE OTB Condition Type CHAR 4 *
    218 .INCLUDE 0
    219 KEY_ID Budget Number NUMC 16
    220 OTB_VALUE Required Budget CURR 17
    221 .INCLUDE 0
    222 OTB_CURR OTB Currency CUKY 5 *
    223 OTB_RES_VALUE Reserved Budget CURR 17
    224 OTB_SPEC_VALUE Special Release CURR 17
    225 SPR_RSN_PROFILE OTB Reason Profile CHAR 4
    226 BUDG_TYPE Budget Type CHAR 2
    227 OTB_STATUS OTB Status CHAR 1
    228 OTB_REASON Reason CHAR 3
    229 CHECK_TYPE Type of OTB Check CHAR 1
    230 .INCLUDE 0
    231 CON_OTB_REQ OTB-Relevant Contract CHAR 1
    232 CON_PREBOOK_LEV OTB Indicator Level for Contracts CHAR 1
    233 CON_DISTR_LEV Distribution Using Target Value or Item Data CHAR 1

SAP Help, Wiki Resources, and Forum Discussions on EKKO

Click the above link for the full list of resources and help pages, only the first few are posted below


Related Tables

TABLE Description Functional Area
EKPO Purchasing Document Item MM - Purchasing
LFA1 Vendor Master (General Section) FI - Financial Accounting
EKBE History per Purchasing Document MM - Purchasing
MARA General Material Data Logistics - Material Master
EKET Scheduling Agreement Schedule Lines MM - Purchasing
KONV Conditions (Transaction Data) SD - Conditions
MAKT Material Descriptions Logistics - Material Master

Transaction Codes for SAP Table EKKO

TCODE Description Functional Area
SPRO Customizing - Edit Project Basis - Customizing Project Management (IMG)
ME21N Create Purchase Order MM - Purchasing
ME22N Change Purchase Order MM - Purchasing
ME23N Display Purchase Order MM - Purchasing
MIGO Goods Movement MM - Inventory Management
SLIS FI-SL Spec.Purpose Ledg. Info.System FI - Information System
SE11 ABAP Dictionary Maintenance Basis - Dictionary Maintenance
MIRO Enter Incoming Invoice MM - Invoice Verification

FMs for SAP Table EKKO

FM Description Functional Area
REUSE_ALV_GRID_DISPLAY Output of a simple list (single-line) Basis - SAP List Viewer
READ_TEXT SAPscript: Read text BC - SAPscript
BAPI_PO_CREATE1 Create Purchase Order MM - Purchasing
REUSE_ALV_COMMENTARY_WRITE List body comment block output BC - SAP List Viewer
REUSE_ALV_EVENTS_GET Returns table of possible events for a list type BC - SAP List Viewer
REUSE_ALV_FIELDCATALOG_MERGE Create field catalog from dictionary structure or internal table BC - SAP List Viewer
BAPI_PO_CHANGE Change Purchase Order MM - Purchasing
BAPI_TRANSACTION_COMMIT Execute external Commit when using BAPIs Basis - ALE Integration Technology

ABAP Reports for SAP Table EKKO

ABAP REPORT Description Functional Area
SAPMM06E Module Pool: PO History MM - Purchasing
SAPFM06P Print Program for Purchasing Documents MM - Purchasing
RSCONN01 SAPconnect: Start Send Process Basis - Communication Services: Mail, Fax, SMS, Telephony
SPRSL TEXT 630 - Workbench Tools: Editors
BDCRECX1 Include f Basis - UI Services, Screen, Batch Input
RSNASTSO Output Control Processing Program: Call up SAP Office SD - Output Determination
BCALV_TEST_GRID_EVENTS Program BCALV_TEST_GRID_EVENTS Basis - SAP List Viewer
SAPMSSY0 System Exits Basis - Syntax, Compiler, Runtime

BW Datasources for SAP Table EKKO

BW DATASOURCE Description Functional Area
2LIS_02_ITM Purchasing Data (Item Level) MM - Materials Management
2LIS_02_SCL Purchasing Data (Schedule Line Level) MM - Materials Management
2LIS_02_HDR Purchasing Data (Header Level) MM - Materials Management
2LIS_03_BF Goods Movements From Inventory Management MM - Materials Management
2LIS_03_BX Stock Initialization for Inventory Management MM - Materials Management
2LIS_11_VAITM Sales Document Item Data SD - Sales and Distribution
0VENDOR_ATTR Vendor Number MM - Materials Management
2LIS_03_UM Revaluations MM - Materials Management

Authorization Objects for SAP Table EKKO

AUTHORIZATION OBJECT Description Functional Area
I_TCODE PM: Transaction Code
E_GRID Authorization Object for Grid
S_CARRID Authorization Object for Airlines
C_LINE LD: Processing Lines
M_BEST_EKG Purchasing Group in Purchase Order
S_TCODE Transaction Code Check at Transaction Start
M_BEST_EKO Purchasing Organization in Purchase Order