SAP Tables

Share |

EKKO SAP Table - Purchasing Document Header


EKKO is a standard SAP Table which is used to store Purchasing Document Header information. This is available within R/3 SAP systems depending on the version and release level. Below is the standard documentation available and a few details of the fields which make up this table. You can also view this information 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 ask a question or add useful hints, tips and screen shots specific to this SAP table dictionary 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 Number
.INCLUDEEKKODATAPurchasing Document Header: Data Part
BUKRSBUKRSCHAR4T001Company Code
BSTYPEBSTYPCHAR1Purchasing Document Category
BSARTESARTCHAR4T161Purchasing Document Type
BSAKZBSAKZCHAR1Control indicator for purchasing document type
LOEKZELOEKCHAR1Deletion Indicator in Purchasing Document
STATUESTAKCHAR1Status of Purchasing Document
AEDATERDATDATS8Date on Which Record Was Created
ERNAMERNAMCHAR12Name of Person who Created the Object
PINCRPINCRNUMC5Item Number Interval
LPONRLPONRNUMC5EKPOLast Item Number
LIFNRELIFNCHAR10LFA1Vendor Account Number
SPRASSPRASLANG1T002Language Key
ZTERMDZTERMCHAR4Terms of Payment Key
ZBD1TDZBDETDEC3Cash (Prompt Payment) Discount Days
ZBD2TDZBDETDEC3Cash (Prompt Payment) Discount Days
ZBD3TDZBDETDEC3Cash (Prompt Payment) Discount Days
ZBD1PDZBD1PDEC5(3)Cash Discount Percentage 1
ZBD2PDZBD2PDEC5(3)Cash Discount Percentage 2
EKORGEKORGCHAR4T024EPurchasing Organization
WAERSWAERSCUKY5TCURCCurrency Key
WKURSWKURSDEC9(5)Exchange Rate
KUFIXKUFIXCHAR1Indicator: Fixing of Exchange Rate
BEDATEBDATDATS8Purchasing Document Date
KDATBKDATBDATS8Start of Validity Period
KDATEKDATEDATS8End of Validity Period
BWBDTBWBDTDATS8Closing Date for Applications
ANGDTANGABDATS8Deadline for Submission of Bid/Quotation
BNDDTEBNDTDATS8Binding Period for Quotation
GWLDTMM_GWLDTDATS8Warranty Date
AUSNRAUSCHCHAR10EKKOBid invitation number
ANGNRANGNRCHAR10Quotation Number
IHRANIHRANDATS8Quotation Submission Date
IHREZIHREZCHAR12Your Reference
VERKFEVERKCHAR30Responsible Salesperson at Vendor's Office
TELF1TELF0CHAR16Vendor's Telephone Number
LLIEFLLIEFCHAR10LFA1Supplying Vendor
KUNNRKUNNRCHAR10KNA1Customer Number
KONNRKONNRCHAR10EKKONumber of Principal Purchase Agreement
ABGRUABDUMCHAR2Field Not Used
AUTLFKMPLFCHAR1Complete Delivery Stipulated for Each Purchase Order
WEAKTWEAKTCHAR1Indicator: Goods Receipt Message
RESWKRESWKCHAR4T001WSupplying (Issuing) Plant in Stock Transport Order
LBLIFLBLIFCHAR10LFA1Field not used
INCO1INCO1CHAR3TINCIncoterms (Part 1)
INCO2INCO2CHAR28Incoterms (Part 2)
KTWRTKTWRTCURR15(2)Target Value for Header Area per Distribution
SUBMISUBMICHAR10Collective Number
KNUMVKNUMVCHAR10Number of the document condition
KALSMKALSM_DCHAR6T683Procedure (Pricing, Output Control, Acct. Det., Costing,...)
STAFOSTAFOCHAR6
*
Update group for statistics update
LIFRELIFRECHAR10LFA1Different Invoicing Party
EXNUMEXNUMCHAR10EIKPNumber of foreign trade data in MM and SD documents
UNSEZUNSEZCHAR12Our Reference
LOGSYLOGSYSTEMCHAR10
*
Logical System
UPINCUPINCNUMC5Item Number Interval for Subitems
STAKOSTAKOCHAR1Document with time-dependent conditions
FRGGRFRGGRCHAR2T16FGRelease group
FRGSXFRGSXCHAR2T16FSRelease Strategy
FRGKEFRGKECHAR1T16FBRelease Indicator: Purchasing Document
FRGZUFRGZUCHAR8Release status
FRGRLFRGRLCHAR1Release Not Yet Completely Effected
LANDSLAND1_STMLCHAR3T005Country for Tax Return
LPHISLPHISCHAR1Indicator for scheduling agreement release documentation
ADRNRAD_ADDRNUMCHAR10
*
Address number
STCEG_LSTCEG_LCHAR3
*
Country of Sales Tax ID Number
STCEGSTCEGCHAR20VAT Registration Number
ABSGRABSGRNUMC2T165RReason for Cancellation
ADDNRADDI_BELNRCHAR10Document number for additional
KORNRKORNRCHAR1Correction of miscellaneous provisions
MEMORYMEMERCHAR1Purchase order not yet complete
PROCSTATMEPROCSTATECHAR2Purchasing document processing state
RLWRTRLWRTCURR15(2)Total value at time of release
REVNOREVNOCHAR8Version number in Purchasing
SCMPROCSCMPROCCHAR1SCM Process That Created the Purchase Order
REASON_CODE/SAPPSPRO/_GR_REASON_CODECHAR4Goods Receipt Reason Code
MEMORYTYPEMEMORYTYPECHAR1Category of Incompleteness
RETTPRETTPCHAR1Retention Indicator
RETPCRETPZDEC5(2)Retention in Percent
DPTYPME_DPTYPCHAR4Down Payment Indicator
DPPCTME_DPPCNTDEC5(2)Down Payment Percentage
DPAMTME_DPAMNTCURR11(2)Down Payment Amount in Document Currency
DPDATME_DPDDATDATS8Due Date for Down Payment
MSR_IDMSR_PROCESS_IDCHAR10Process Identification Number
HIERARCHY_EXISTSHIERARCHY_EXISTSCHAR1Part of a Contract Hierarchy
THRESHOLD_EXISTSEX_RATE_THRESHOLDCHAR1Threshold Value for Exchange Rates Exists
LEGAL_CONTRACTLEGAL_CONTRACT_IDCHAR40Legal Contract Number
DESCRIPTIONCONTRACT_DESCRIPTIONCHAR40Contract Name
RELEASE_DATERELEASE_DATEDATS8Release Date of Contract
VSARTVERSARTCHAR2
*
Shipping type
HANDOVERLOCHANDOVER_LOCCHAR10Location for a physical handover of goods
SHIPCONDVSBEDCHAR2
*
Shipping Conditions
.APPEND/ISDFPS/EKKODATAAppend to EKKO for DFPS
.INCLUDE/ISDFPS/ST_FDP_RELRelocation: Structure for Enhancing Logistics Documents
FORCE_ID/ISDFPS/FORCE_IDCHAR32Internal Key for Force Element
FORCE_CNT/ISDFPS/FORCE_CNTNUMC6Internal (Version) Counter
RELOC_ID/ISDFPS/RELOC_IDCHAR10/ISDFPS/RELRelocation ID
RELOC_SEQ_ID/ISDFPS/RELOC_SEQ_IDCHAR4/ISDFPS/RELSEQRelocation Step ID
.APPENDFPIA_A_INTEKKO enhancement for IoA solution
.INCLUDEFPIA_S_INTERESTInclude structure for EKKO
VZSKZVZSKZCHAR2
*
Interest calculation indicator
.APPENDWRF_PBAS_EKKO_ADDON_STYEKKO Enhancement Seasonal Procurement: Procurement
.INCLUDEWRF_POHF_EKKO_ADDON_STYEKKO Enhancement: PO Handling
POHF_TYPEWRF_POHF_TYPECHAR1Document for Seasonal Purchase Order Processing
EQ_EINDTWRF_POHF_EQ_EINDTDATS8Delivery Date Header: All Items Have Same Delivery Date
EQ_WERKSWRF_POHF_EQ_EWERKCHAR4
*
Plant Header: All Items Have Same Receiving Plant
FIXPOWRF_POHF_FIXPOCHAR1Firm Deal Indicator
.INCLUDEWRF_POHF_GROUP_CRITERIA_STYStructure for Grouping Criteria
EKGRP_ALLOWWRF_POHF_EKGRP_ALLOWCHAR1Take Account of Purch. Group
WERKS_ALLOWWRF_POHF_WERKS_ALLOWCHAR1Take Account of Plants
CONTRACT_ALLOWWRF_POHF_CONTRACT_ALLOWCHAR1Take Account of Contracts
PSTYP_ALLOWWRF_POHF_PSTYP_ALLOWCHAR1Take Account of Item Categories
FIXPO_ALLOWWRF_POHF_FIXPO_ALLOWCHAR1Take Account of Fixed-Date Purchases Indicator
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_STYEKKO Enhancement: OTB
OTB_LEVELWRF_POTB_CHECK_LEVELCHAR1OTB Check Level
OTB_COND_TYPEWRF_POTB_COND_TYPECHAR4
*
OTB Condition Type
.INCLUDEWRF_POTB_FEEDBACK_STYOTB-Relevant Data
KEY_IDWRF_BUDG_KEY_IDNUMC16Unique Number of Budget
OTB_VALUEWRF_POTB_VALUECURR17(2)Required Budget
.INCLUDEWRF_POTB_CURRENCY_STYOTB Currency
OTB_CURRWRF_POTB_CURRENCYCUKY5
*
OTB Currency
OTB_RES_VALUEWRF_POTB_RES_VALUECURR17(2)Reserved Budget for OTB-Relevant Purchasing Document
OTB_SPEC_VALUEWRF_POTB_SPECIAL_VALUECURR17(2)Special Release Budget
SPR_RSN_PROFILEWRF_POTB_SPR_RSN_PROFILECHAR4Reason Profile for OTB Special Release
BUDG_TYPEWRF_BUDG_TYPECHAR2Budget Type
OTB_STATUSWRF_POTB_STATUSCHAR1OTB Check Status
OTB_REASONWRF_POTB_STATUS_REASONCHAR3Reason Indicator for OTB Check Status
CHECK_TYPEWRF_BUDG_OTB_CHECKCHAR1Type of OTB Check
.INCLUDEWRF_PCON_EKKO_ADDON_STYAdd-On Data for Contracts
CON_OTB_REQWRF_POTB_CON_REQCHAR1OTB-Relevant Contract
CON_PREBOOK_LEVWRF_POTB_PREBOOK_LEVELCHAR1OTB Indicator Level for Contracts
CON_DISTR_LEVWRF_POTB_DISTRIB_LEVELCHAR1Distribution Using Target Value or Item Data


Key field
Non-key field




comments powered by Disqus