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

Contribute (Add Comments)
Within the comments section below there is also an opportunity for you to add useful hints, tips and screen shots 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
FieldData ElementData Typelength (Decimals)ChecktableDescription
MANDTMANDTCLNT3T000Client
EBELNEBELNCHAR10Purchasing Document
.INCLUDEEKKODATA
BUKRSBUKRSCHAR4T001Company Code
BSTYPEBSTYPCHAR1Purch. Doc. Category
BSARTESARTCHAR4T161Purchasing Doc. Type
BSAKZBSAKZCHAR1Control indicator
LOEKZELOEKCHAR1Deletion Indicator
STATUESTAKCHAR1Status
AEDATERDATDATS8Created on
ERNAMERNAMCHAR12Created by
PINCRPINCRNUMC5Item Number Interval
LPONRLPONRNUMC5EKPOLast Item
LIFNRELIFNCHAR10LFA1Vendor
SPRASSPRASLANG1T002Language Key
ZTERMDZTERMCHAR4 
ZBD1TDZBDETDEC3 
ZBD2TDZBDETDEC3 
ZBD3TDZBDETDEC3 
ZBD1PDZBD1PDEC5(3) 
ZBD2PDZBD2PDEC5(3) 
EKORGEKORGCHAR4T024EPurch. Organization
EKGRPBKGRPCHAR3T024Purchasing Group
WAERSWAERSCUKY5TCURCCurrency
WKURSWKURSDEC9(5)Exchange Rate
KUFIXKUFIXCHAR1Exchange Rate Fixed
BEDATEBDATDATS8Document Date
KDATBKDATBDATS8Validity Per. Start
KDATEKDATEDATS8Validity Period End
BWBDTBWBDTDATS8Application Close
ANGDTANGABDATS8Quotation Deadline
BNDDTEBNDTDATS8Binding Period
GWLDTMM_GWLDTDATS8Warranty
AUSNRAUSCHCHAR10EKKOBid invitation
ANGNRANGNRCHAR10Quotation
IHRANIHRANDATS8Quotation Date
IHREZIHREZCHAR12Your Reference
VERKFEVERKCHAR30Salesperson
TELF1TELF0CHAR16Telephone
LLIEFLLIEFCHAR10LFA1Supplying Vendor
KUNNRKUNNRCHAR10KNA1Customer
KONNRKONNRCHAR10EKKOOutline Agreement
ABGRUABDUMCHAR2
AUTLFKMPLFCHAR1Complete Delivery
WEAKTWEAKTCHAR1GR Message
RESWKRESWKCHAR4T001WSupplying Plant
LBLIFLBLIFCHAR10LFA1Receiving vendor
INCO1INCO1CHAR3TINCIncoterms
INCO2INCO2CHAR28Incoterms (Part 2)
KTWRTKTWRTCURR15(2)Target Val. (Header)
SUBMISUBMICHAR10Collective Number
KNUMVKNUMVCHAR10Doc. condition no.
KALSMKALSM_DCHAR6T683Procedure
STAFOSTAFOCHAR6
*
Update group (stats)
LIFRELIFRECHAR10LFA1Invoicing Party
EXNUMEXNUMCHAR10EIKPNumber of foreign trade data
UNSEZUNSEZCHAR12Our Reference
LOGSYLOGSYSTEMCHAR10
*
Logical System
UPINCUPINCNUMC5Subitem Interval
STAKOSTAKOCHAR1Time-dep. conditions
FRGGRFRGGRCHAR2T16FGRelease group
FRGSXFRGSXCHAR2T16FSRelease Strategy
FRGKEFRGKECHAR1T16FBRelease indicator
FRGZUFRGZUCHAR8Release status
FRGRLFRGRLCHAR1Subject to release
LANDSLAND1_STMLCHAR3T005Cntry for tax return
LPHISLPHISCHAR1Rel. documentation
ADRNRAD_ADDRNUMCHAR10
*
Address number
STCEG_LSTCEG_LCHAR3
*
Country sls.tax no.
STCEGSTCEGCHAR20VAT Registration No.
ABSGRABSGRNUMC2T165RReason for Canc.
ADDNRADDI_BELNRCHAR10Document number
KORNRKORNRCHAR1Corr. misc. provis.
MEMORYMEMERCHAR1Incomplete
PROCSTATMEPROCSTATECHAR2Purch. doc. proc. state
RLWRTRLWRTCURR15(2)Total val. upon release
REVNOREVNOCHAR8Version
SCMPROCSCMPROCCHAR1SCMPROC
REASON_CODE/SAPPSPRO/_GR_REASON_CODECHAR4Reason Code
MEMORYTYPEMEMORYTYPECHAR1Incompleteness
RETTPRETTPCHAR1Retention
RETPCRETPZDEC5(2)Retention in Percent
DPTYPME_DPTYPCHAR4Down Payment
DPPCTME_DPPCNTDEC5(2)Down Payt Percentage
DPAMTME_DPAMNTCURR11(2)Down Payment Amount
DPDATME_DPDDATDATS8Due Date for Down Payment
MSR_IDMSR_PROCESS_IDCHAR10Process ID No.
HIERARCHY_EXISTSHIERARCHY_EXISTSCHAR1Part of a Contract Hierarchy
THRESHOLD_EXISTSEX_RATE_THRESHOLDCHAR1Threshold Value for Exchange Rates
LEGAL_CONTRACTLEGAL_CONTRACT_IDCHAR40Legal Contract Number
DESCRIPTIONCONTRACT_DESCRIPTIONCHAR40Contract Name
RELEASE_DATERELEASE_DATEDATS8Release Date of Contract
VSARTVERSARTCHAR2
*
Shipping type
HANDOVERLOCHANDOVER_LOCCHAR10Handover Location
SHIPCONDVSBEDCHAR2
*
Shipping Conditions
.APPEND/ISDFPS/EKKODATA
.INCLUDE/ISDFPS/ST_FDP_REL
FORCE_ID/ISDFPS/FORCE_IDCHAR32GUID 32
FORCE_CNT/ISDFPS/FORCE_CNTNUMC6Counter
RELOC_ID/ISDFPS/RELOC_IDCHAR10/ISDFPS/RELRelocation ID
RELOC_SEQ_ID/ISDFPS/RELOC_SEQ_IDCHAR4/ISDFPS/RELSEQRelocation Step ID
.INCLUDECI_EKKODB
.APPENDFPIA_A_INT
.INCLUDEFPIA_S_INTEREST
VZSKZVZSKZCHAR2
*
Interest indicator
.APPENDWRF_PBAS_EKKO_ADDON_STY
.INCLUDEWRF_POHF_EKKO_ADDON_STY
POHF_TYPEWRF_POHF_TYPECHAR1Document Category
EQ_EINDTWRF_POHF_EQ_EINDTDATS8Same Delivery Date
EQ_WERKSWRF_POHF_EQ_EWERKCHAR4
*
Same Plant
FIXPOWRF_POHF_FIXPOCHAR1Firm Deal Indicator
.INCLUDEWRF_POHF_GROUP_CRITERIA_STY
EKGRP_ALLOWWRF_POHF_EKGRP_ALLOWCHAR1Take Account of Purch. Group
WERKS_ALLOWWRF_POHF_WERKS_ALLOWCHAR1Take Account of Plnt
CONTRACT_ALLOWWRF_POHF_CONTRACT_ALLOWCHAR1Take Account of Contract
PSTYP_ALLOWWRF_POHF_PSTYP_ALLOWCHAR1Take Account of Item Categ.
FIXPO_ALLOWWRF_POHF_FIXPO_ALLOWCHAR1Take Account of Fixed-Date Purchases
KEY_ID_ALLOWWRF_POHF_KEY_ID_ALLOWCHAR1Consider Budget
AUREL_ALLOWWRF_POHF_AUREL_ALLOWCHAR1Take Account of Alloc. Table Relevance
DELPER_ALLOWWRF_POHF_DELPER_ALLOWCHAR1Take Account of Dlvy Period
EINDT_ALLOWWRF_POHF_EINDT_ALLOWCHAR1Take Account of Delivery Date
.INCLUDEWRF_POTB_EKKO_ADDON_STY
OTB_LEVELWRF_POTB_CHECK_LEVELCHAR1OTB Check Level
OTB_COND_TYPEWRF_POTB_COND_TYPECHAR4
*
OTB Condition Type
.INCLUDEWRF_POTB_FEEDBACK_STY
KEY_IDWRF_BUDG_KEY_IDNUMC16Budget Number
OTB_VALUEWRF_POTB_VALUECURR17(2)Required Budget
.INCLUDEWRF_POTB_CURRENCY_STY
OTB_CURRWRF_POTB_CURRENCYCUKY5
*
OTB Currency
OTB_RES_VALUEWRF_POTB_RES_VALUECURR17(2)Reserved Budget
OTB_SPEC_VALUEWRF_POTB_SPECIAL_VALUECURR17(2)Special Release Budget
SPR_RSN_PROFILEWRF_POTB_SPR_RSN_PROFILECHAR4OTB Reason Profile for Special Release
BUDG_TYPEWRF_BUDG_TYPECHAR2Budget Type
OTB_STATUSWRF_POTB_STATUSCHAR1OTB Check Status
OTB_REASONWRF_POTB_STATUS_REASONCHAR3Reason
CHECK_TYPEWRF_BUDG_OTB_CHECKCHAR1Type of OTB Check
.INCLUDEWRF_PCON_EKKO_ADDON_STY
CON_OTB_REQWRF_POTB_CON_REQCHAR1OTB-Relevant Contract
CON_PREBOOK_LEVWRF_POTB_PREBOOK_LEVELCHAR1Indicator Level for Contracts
CON_DISTR_LEVWRF_POTB_DISTRIB_LEVELCHAR1Distrib. Using Target Value or Item Data







comments powered by Disqus