SAP Tables

Share | EKKO SAP Table - Purchasing Document Header EKKO is a standard SAP Table available within R/3 SAP systems depending on your version and release level. Below is the standard documentation available for this table and a few details of the fields which make up this table. You can view this information and more if you enter the Table name EKKO into the relevant SAP transaction such as SE11 or SE80. You can also view the data contained in this database table via these transactions or alternatively use transaction SE16 Delivery Class = A - Application table containing master and transaction data Within the comments section below there is also an opportunity for you to add useful hints, tips and information specific to this SAP object. This means that you and other users will be able to find these details quickly by simply searching on the object name EKKO or its description. Dictionary fields for SAP Table EKKO Field Data Element Data Type length Checktable Description MANDT MANDT CLNT 000003 T000 Client EBELN EBELN CHAR 000010 Purchasing Document BUKRS BUKRS CHAR 000004 T001 Company Code BSTYP EBSTYP CHAR 000001 Purch. Doc. Category BSART ESART CHAR 000004 T161 Purchasing Doc. Type BSAKZ BSAKZ CHAR 000001 Control indicator LOEKZ ELOEK CHAR 000001 Deletion Indicator STATU ESTAK CHAR 000001 Status AEDAT ERDAT DATS 000008 Created on ERNAM ERNAM CHAR 000012 Created by PINCR PINCR NUMC 000005 Item Number Interval LPONR LPONR NUMC 000005 EKPO Last Item LIFNR ELIFN CHAR 000010 LFA1 Vendor SPRAS SPRAS LANG 000001 T002 Language Key ZTERM DZTERM CHAR 000004 ZBD1T DZBDET DEC 000003 ZBD2T DZBDET DEC 000003 ZBD3T DZBDET DEC 000003 ZBD1P DZBD1P DEC 000005 ZBD2P DZBD2P DEC 000005 EKORG EKORG CHAR 000004 T024E Purch. Organization EKGRP BKGRP CHAR 000003 T024 Purchasing Group WAERS WAERS CUKY 000005 TCURC Currency WKURS WKURS DEC 000009 Exchange Rate KUFIX KUFIX CHAR 000001 Exchange Rate Fixed BEDAT EBDAT DATS 000008 Document Date KDATB KDATB DATS 000008 Validity Per. Start KDATE KDATE DATS 000008 Validity Period End BWBDT BWBDT DATS 000008 Application Close ANGDT ANGAB DATS 000008 Quotation Deadline BNDDT EBNDT DATS 000008 Binding Period GWLDT MM_GWLDT DATS 000008 Warranty AUSNR AUSCH CHAR 000010 EKKO Bid invitation ANGNR ANGNR CHAR 000010 Quotation IHRAN IHRAN DATS 000008 Quotation Date IHREZ IHREZ CHAR 000012 Your Reference VERKF EVERK CHAR 000030 Salesperson TELF1 TELF0 CHAR 000016 Telephone LLIEF LLIEF CHAR 000010 LFA1 Supplying Vendor KUNNR KUNNR CHAR 000010 KNA1 Customer KONNR KONNR CHAR 000010 EKKO Outline Agreement ABGRU ABDUM CHAR 000002 AUTLF KMPLF CHAR 000001 Complete Delivery WEAKT WEAKT CHAR 000001 GR Message RESWK RESWK CHAR 000004 T001W Supplying Plant LBLIF LBLIF CHAR 000010 LFA1 Receiving vendor INCO1 INCO1 CHAR 000003 TINC Incoterms INCO2 INCO2 CHAR 000028 Incoterms (Part 2) KTWRT KTWRT CURR 000015 Target Val. (Header) SUBMI SUBMI CHAR 000010 Collective Number KNUMV KNUMV CHAR 000010 Doc. condition no. KALSM KALSM_D CHAR 000006 T683 Procedure STAFO STAFO CHAR 000006 * Update group (stats) LIFRE LIFRE CHAR 000010 LFA1 Invoicing Party EXNUM EXNUM CHAR 000010 EIKP Number of foreign trade data UNSEZ UNSEZ CHAR 000012 Our Reference LOGSY LOGSYSTEM CHAR 000010 * Logical System UPINC UPINC NUMC 000005 Subitem Interval STAKO STAKO CHAR 000001 Time-dep. conditions FRGGR FRGGR CHAR 000002 T16FG Release group FRGSX FRGSX CHAR 000002 T16FS Release Strategy FRGKE FRGKE CHAR 000001 T16FB Release indicator FRGZU FRGZU CHAR 000008 Release status FRGRL FRGRL CHAR 000001 Subject to release LANDS LAND1_STML CHAR 000003 T005 Cntry for tax return LPHIS LPHIS CHAR 000001 Rel. documentation ADRNR AD_ADDRNUM CHAR 000010 * Address number STCEG_L STCEG_L CHAR 000003 * Country sls.tax no. STCEG STCEG CHAR 000020 VAT Registration No. ABSGR ABSGR NUMC 000002 T165R Reason for Canc. ADDNR ADDI_BELNR CHAR 000010 Document number KORNR KORNR CHAR 000001 Corr. misc. provis. MEMORY MEMER CHAR 000001 Incomplete PROCSTAT MEPROCSTATE CHAR 000002 Purch. doc. proc. state RLWRT RLWRT CURR 000015 Total val. upon release REVNO REVNO CHAR 000008 Version SCMPROC SCMPROC CHAR 000001 SCMPROC REASON_CODE /SAPPSPRO/_GR_REASON_CODE CHAR 000004 Reason Code MEMORYTYPE MEMORYTYPE CHAR 000001 Incompleteness RETTP RETTP CHAR 000001 Retention RETPC RETPZ DEC 000005 Retention in Percent DPTYP ME_DPTYP CHAR 000004 Down Payment DPPCT ME_DPPCNT DEC 000005 Down Payt Percentage DPAMT ME_DPAMNT CURR 000011 Down Payment Amount DPDAT ME_DPDDAT DATS 000008 Due Date for Down Payment MSR_ID MSR_PROCESS_ID CHAR 000010 Process ID No. HIERARCHY_EXISTS HIERARCHY_EXISTS CHAR 000001 Part of a Contract Hierarchy THRESHOLD_EXISTS EX_RATE_THRESHOLD CHAR 000001 Threshold Value for Exchange Rates LEGAL_CONTRACT LEGAL_CONTRACT_ID CHAR 000040 Legal Contract Number DESCRIPTION CONTRACT_DESCRIPTION CHAR 000040 Contract Name RELEASE_DATE RELEASE_DATE DATS 000008 Release Date of Contract FORCE_ID /ISDFPS/FORCE_ID CHAR 000032 GUID 32 FORCE_CNT /ISDFPS/FORCE_CNT NUMC 000006 Counter RELOC_ID /ISDFPS/RELOC_ID CHAR 000010 /ISDFPS/REL Relocation ID RELOC_SEQ_ID /ISDFPS/RELOC_SEQ_ID CHAR 000004 /ISDFPS/RELSEQ Relocation Step ID VZSKZ VZSKZ CHAR 000002 * Interest indicator POHF_TYPE WRF_POHF_TYPE CHAR 000001 Document Category EQ_EINDT WRF_POHF_EQ_EINDT DATS 000008 Same Delivery Date EQ_WERKS WRF_POHF_EQ_EWERK CHAR 000004 * Same Plant FIXPO WRF_POHF_FIXPO CHAR 000001 Firm Deal Indicator EKGRP_ALLOW WRF_POHF_EKGRP_ALLOW CHAR 000001 Take Account of Purch. Group WERKS_ALLOW WRF_POHF_WERKS_ALLOW CHAR 000001 Take Account of Plnt CONTRACT_ALLOW WRF_POHF_CONTRACT_ALLOW CHAR 000001 Take Account of Contract PSTYP_ALLOW WRF_POHF_PSTYP_ALLOW CHAR 000001 Take Account of Item Categ. FIXPO_ALLOW WRF_POHF_FIXPO_ALLOW CHAR 000001 Take Account of Fixed-Date Purchases KEY_ID_ALLOW WRF_POHF_KEY_ID_ALLOW CHAR 000001 Consider Budget AUREL_ALLOW WRF_POHF_AUREL_ALLOW CHAR 000001 Take Account of Alloc. Table Relevance DELPER_ALLOW WRF_POHF_DELPER_ALLOW CHAR 000001 Take Account of Dlvy Period EINDT_ALLOW WRF_POHF_EINDT_ALLOW CHAR 000001 Take Account of Delivery Date OTB_LEVEL WRF_POTB_CHECK_LEVEL CHAR 000001 OTB Check Level OTB_COND_TYPE WRF_POTB_COND_TYPE CHAR 000004 * OTB Condition Type KEY_ID WRF_BUDG_KEY_ID NUMC 000016 Budget Number OTB_VALUE WRF_POTB_VALUE CURR 000017 Required Budget OTB_CURR WRF_POTB_CURRENCY CUKY 000005 * OTB Currency OTB_RES_VALUE WRF_POTB_RES_VALUE CURR 000017 Reserved Budget OTB_SPEC_VALUE WRF_POTB_SPECIAL_VALUE CURR 000017 Special Release Budget SPR_RSN_PROFILE WRF_POTB_SPR_RSN_PROFILE CHAR 000004 OTB Reason Profile for Special Release BUDG_TYPE WRF_BUDG_TYPE CHAR 000002 Budget Type OTB_STATUS WRF_POTB_STATUS CHAR 000001 OTB Check Status OTB_REASON WRF_POTB_STATUS_REASON CHAR 000003 Reason CHECK_TYPE WRF_BUDG_OTB_CHECK CHAR 000001 Type of OTB Check CON_OTB_REQ WRF_POTB_CON_REQ CHAR 000001 OTB-Relevant Contract CON_PREBOOK_LEV WRF_POTB_PREBOOK_LEVEL CHAR 000001 Indicator Level for Contracts CON_DISTR_LEV WRF_POTB_DISTRIB_LEVEL CHAR 000001 Distrib. Using Target Value or Item Data EKKN_SHP EKKODATA