SAP Table EKKO stores Purchasing Document Headerdata

  

In this post, I will try and describe everything you need to know about the SAP ekko table. What it is, including what type of data it stores.

A list of fields which make up the table structure and on an S/4Hana System for EKKO what does this table look like.

And what relationships it has with other SAP tables.

Also see here for example ABAP code to select data from EKKO....Right lets get started!


SAP EKKO dictionary attributes

Object Name: EKKO
Dictionary Type: Transparent table
Description: Purchasing Document Header


EKKO field list

Field Data Element Data Type length (Dec) Check table Description Conversion Routine Domain Name MemoryID AppClass SHLP SHLP Field ConvExit
MANDTMANDTCLNT3(0) T000ClientMANDTTEST
EBELNEBELNCHAR10(0) Purchasing Document NumberEBELNBESMEMEKK_CEBELN
BUKRSBUKRSCHAR4(0) T001Company CodeBUKRSBUKFBC_T001BUKRS
BSTYPEBSTYPCHAR1(0) Purchasing Document CategoryEBSTYPME
BSARTESARTCHAR4(0) T161Purchasing Document TypeBSARTBSAME
BSAKZBSAKZCHAR1(0) Control indicator for purchasing document typeBSAKZME
LOEKZELOEKCHAR1(0) Deletion Indicator in Purchasing DocumentELOEKME
STATUESTAKCHAR1(0) Status of Purchasing DocumentESTAKME
AEDATERDATDATS8(0) Date on Which Record Was CreatedDATUMSAP
ERNAMERNAMCHAR12(0) Name of Person who Created the ObjectUSNAMSAP
PINCRPINCRNUMC5(0) Item Number IntervalPINCRME
LPONRLPONRNUMC5(0) EKPOLast Item NumberEBELPME
LIFNRELIFNCHAR10(0) LFA1Vendor Account NumberLIFNRLIFMEKRED_CLIFNR
SPRASSPRASLANG1(0) T002Language KeySPRASSPRSAPH_T002SPRAS
EKORGEKORGCHAR4(0) T024EPurchasing OrganizationEKORGEKOME
EKGRPBKGRPCHAR3(0) T024Purchasing GroupEKGRPEKGME
WAERSWAERSCUKY5(0) TCURCCurrency KeyWAERSFWSFB
WKURSWKURSDEC9(5) Exchange RateKURSPME
KUFIXKUFIXCHAR1(0) Indicator: Fixing of Exchange RateXFELDME
BEDATEBDATDATS8(0) Purchasing Document DateDATUMME
KDATBKDATBDATS8(0) Start of Validity PeriodDATUMME
KDATEKDATEDATS8(0) End of Validity PeriodDATUMME
BWBDTBWBDTDATS8(0) Closing Date for ApplicationsDATUMME
ANGDTANGABDATS8(0) Deadline for Submission of Bid/QuotationDATUMME
BNDDTEBNDTDATS8(0) Binding Period for QuotationDATUMME
GWLDTMM_GWLDTDATS8(0) Warranty DateDATUMVA
AUSNRAUSCHCHAR10(0) EKKOBid invitation numberEBELNBESME
ANGNRANGNRCHAR10(0) Quotation NumberANGNRME
IHRANIHRANDATS8(0) Quotation Submission DateDATUMME
IHREZIHREZCHAR12(0) Your ReferenceTEXT12V
VERKFEVERKCHAR30(0) Responsible Salesperson at Vendor's OfficeTEXT30ME
TELF1TELF0CHAR16(0) Vendor's Telephone NumberTEXT16ME
LLIEFLLIEFCHAR10(0) LFA1Supplying VendorLIFNRLLIME
KUNNRKUNNRCHAR10(0) KNA1Customer NumbersKUNNRKUNVC_KUNNRKUNNR
KONNRKONNRCHAR10(0) EKKONumber of Principal Purchase AgreementEBELNKTRME
ABGRUABDUMCHAR2(0) Field Not UsedCHAR2
AUTLFKMPLFCHAR1(0) Complete Delivery Stipulated for Each Purchase OrderXFELDVL
WEAKTWEAKTCHAR1(0) Indicator: Goods Receipt MessageXFELDME
RESWKRESWKCHAR4(0) T001WSupplying (Issuing) Plant in Stock Transport OrderWERKSME
LBLIFLBLIFCHAR10(0) LFA1Field not usedLIFNRLIFME
INCO1INCO1CHAR3(0) TINCIncoterms (Part 1)INCO1V
INCO2INCO2CHAR28(0) Incoterms (Part 2)INCO2V
KTWRTKTWRTCURR15(2) Target Value for Header Area per DistributionWERT15ME
SUBMISUBMICHAR10(0) Collective NumberCHAR10V
KNUMVKNUMVCHAR10(0) Number of the document conditionKNUMVVF
KALSMKALSM_DCHAR6(0) T683Procedure (Pricing, Output Control, Acct. Det., Costing,...)KALSMVF
STAFOSTAFOCHAR6(0) *Update group for statistics updateSTAFOMCFMCS
LIFRELIFRECHAR10(0) LFA1Different Invoicing PartyLIFNRLREME
EXNUMEXNUMCHAR10(0) EIKPNumber of foreign trade data in MM and SD documentsEXNUMVL
UNSEZUNSEZCHAR12(0) Our ReferenceTEXT12ME
LOGSYLOGSYSTEMCHAR10(0) *Logical SystemLOGSYS
UPINCUPINCNUMC5(0) Item Number Interval for SubitemsPINCRME
STAKOSTAKOCHAR1(0) Document with time-dependent conditionsXFELD
FRGGRFRGGRCHAR2(0) T16FGRelease groupFRGGR
FRGSXFRGSXCHAR2(0) T16FSRelease StrategyFRGSXME
FRGKEFRGKECHAR1(0) T16FBRelease Indicator: Purchasing DocumentFRGKE
FRGZUFRGZUCHAR8(0) Release statusFRGZUME
FRGRLFRGRLCHAR1(0) Release Not Yet Completely EffectedXFELD
LANDSLAND1_STMLCHAR3(0) T005Country for Tax ReturnLAND1
LPHISLPHISCHAR1(0) Indicator for scheduling agreement release documentationXFELD
ADRNRAD_ADDRNUMCHAR10(0) *Address numberAD_ADDRNUMADR
STCEG_LSTCEG_LCHAR3(0) *Country of Sales Tax ID NumberLAND1LNDFB
STCEGSTCEGCHAR20(0) VAT Registration NumberSTCEGFB
ABSGRABSGRNUMC2(0) T165RReason for CancellationNUMC02
ADDNRADDI_BELNRCHAR10(0) Document number for additionalADDI_BELNR
KORNRKORNRCHAR1(0) Correction of miscellaneous provisionsKORNR
MEMORYMEMERCHAR1(0) Purchase order not yet completeXFELD
PROCSTATMEPROCSTATECHAR2(0) Purchasing document processing stateMEPROCSTATE
RLWRTRLWRTCURR15(2) Total value at time of releaseWERT15
REVNOREVNOCHAR8(0) Version number in PurchasingREVNO
SCMPROCSCMPROCCHAR1(0) SCM Process That Created the Purchase OrderCHAR1
REASON_CODE/SAPPSPRO/_GR_REASON_CODECHAR4(0) Goods Receipt Reason Code/SAPPSPRO/_GR_REASON_CODE
MEMORYTYPEMEMORYTYPECHAR1(0) Category of IncompletenessMM_MEMORYTYPE
RETTPRETTPCHAR1(0) Retention IndicatorRET_TYPE
RETPCRETPZDEC5(2) Retention in PercentPRZ32
DPTYPME_DPTYPCHAR4(0) Down Payment IndicatorME_DPTYPE_DOMAIN
DPPCTME_DPPCNTDEC5(2) Down Payment PercentagePRZ32
DPAMTME_DPAMNTCURR11(2) Down Payment Amount in Document CurrencyWERT11
DPDATME_DPDDATDATS8(0) Due Date for Down PaymentDATS
MSR_IDMSR_PROCESS_IDCHAR10(0) Process Identification NumberMSR_PROCESS_ID
HIERARCHY_EXISTSHIERARCHY_EXISTSCHAR1(0) Part of a Contract HierarchyXFELD
THRESHOLD_EXISTSEX_RATE_THRESHOLDCHAR1(0) Threshold Value for Exchange Rates ExistsXFELD
LEGAL_CONTRACTLEGAL_CONTRACT_IDCHAR40(0) Legal Contract NumberCHAR040
DESCRIPTIONCONTRACT_DESCRIPTIONCHAR40(0) Contract NameTEXT40
RELEASE_DATERELEASE_DATEDATS8(0) Release Date of ContractDATUM
VSARTVERSARTCHAR2(0) *Shipping typeVERSARTVV
HANDOVERLOCHANDOVER_LOCCHAR10(0) Location for a physical handover of goodsHANDOVER_LOC
.INCLU--AP0(0)
FORCE_ID/ISDFPS/FORCE_IDCHAR32(0) Internal Key for Force ElementSYSUUID_C
FORCE_CNT/ISDFPS/FORCE_CNTNUMC6(0) Internal (Version) CounterNUMC6
RELOC_ID/ISDFPS/RELOC_IDCHAR10(0) /ISDFPS/RELRelocation ID/ISDFPS/RELOC_ID
RELOC_SEQ_ID/ISDFPS/RELOC_SEQ_IDCHAR4(0) /ISDFPS/RELSEQRelocation Step ID/ISDFPS/RELOC_SEQ_ID
SOURCE_LOGSYSLOGSYSCHAR10(0) *Logical systemLOGSYS
.INCLU--AP0(0)
PLCADSPCM_PLCCHAR1(0) PACKAGING LEVEL CODECHAR1
SMBADSPCM_SMBCHAR6(0) SUPPLY MANAG. BRANCH INDICATORCHAR6
ECCADSPCM_ECCCHAR7(0) EVIDENCE CONTROL CODECHAR7
IPPADSPCM_IPPCHAR9(0) INITIAL PROVISIONING PROJECT NUMBERCHAR9
CURADSPCM_CURCHAR3(0) CURRENCY CODECHAR3
ECOADSPCM_ECOCHAR13(0) Economic Conditions for Spec2000MCHAR13
PCOADSPCM_PCOCHAR3(0) PRICE CONDITIONCHAR3
DPTADSPCM_DPTCHAR15(0) DELIVERY POINTCHAR15
TOPADSPCM_TOPCHAR2(0) TYPE OF PRICECHAR2
SUSADSPCM_SUSCHAR5(0) SUPPLIERCHAR5
PCNADSPCM_PCNCHAR16(0) Prime Contract Number for Spec2000MCHAR16
TRUADSPCM_TRUCHAR20(0) CUSTOMER TAX REGISTRATION NUMBERCHAR20
PCYADSPCM_PCYCHAR3(0) Provisioning CategoryCHAR3
PCDADSPCM_PCDCHAR2(0) Procurement CodeCHAR2
PBNADSPCM_PBNCHAR14(0) Procurement Budget NumberCHAR14
AMNADSPCM_AMNCHAR3(0) AMENDMENT NUMBERCHAR3
DNOADSPCM_DNOCHAR12(0) DIVERSION NUMBERCHAR12
.INCLU--AP0(0)
POSTATADSPC_POSTATCHAR1(0) Flag for the S1POSTAT messageADSPC_FLAG
.INCLU--AP0(0)
VZSKZVZSKZCHAR2(0) *Interest calculation indicatorVZSKZFB
.INCLU--AP0(0)
POHF_TYPEWRF_POHF_TYPECHAR1(0) Document for Seasonal Purchase Order ProcessingWRF_POHF_TYPE
EQ_EINDTWRF_POHF_EQ_EINDTDATS8(0) Delivery Date Header: All Items Have Same Delivery DateDATUM
EQ_WERKSWRF_POHF_EQ_EWERKCHAR4(0) *Plant Header: All Items Have Same Receiving PlantWERKS
FIXPOWRF_POHF_FIXPOCHAR1(0) Firm Deal IndicatorWRF_POHF_FIXPO_X
EKGRP_ALLOWWRF_POHF_EKGRP_ALLOWCHAR1(0) Take Account of Purch. GroupWRF_POHF_CHAR_1_2
WERKS_ALLOWWRF_POHF_WERKS_ALLOWCHAR1(0) Take Account of PlantsWRF_POHF_CHAR_1_2
CONTRACT_ALLOWWRF_POHF_CONTRACT_ALLOWCHAR1(0) Take Account of ContractsWRF_POHF_CHAR_1_2
PSTYP_ALLOWWRF_POHF_PSTYP_ALLOWCHAR1(0) Take Account of Item CategoriesWRF_POHF_CHAR_1_2
FIXPO_ALLOWWRF_POHF_FIXPO_ALLOWCHAR1(0) Take Account of Fixed-Date Purchases IndicatorWRF_POHF_CHAR_1_2
KEY_ID_ALLOWWRF_POHF_KEY_ID_ALLOWCHAR1(0) Consider BudgetWRF_POHF_CHAR_1_2
AUREL_ALLOWWRF_POHF_AUREL_ALLOWCHAR1(0) Take Account of Alloc. Table RelevanceWRF_POHF_CHAR_1_2
DELPER_ALLOWWRF_POHF_DELPER_ALLOWCHAR1(0) Take Account of Dlvy PeriodWRF_POHF_CHAR_1_2
EINDT_ALLOWWRF_POHF_EINDT_ALLOWCHAR1(0) Take Account of Delivery DateWRF_POHF_CHAR_1_2
LTSNR_ALLOWWRF_POHF_LTSNR_ALLOWCHAR1(0) Include Vendor SubrangeWRF_POHF_CHAR_1_2
OTB_LEVELWRF_POTB_CHECK_LEVELCHAR1(0) OTB Check LevelWRF_POTB_CHECK_LEVEL
OTB_COND_TYPEWRF_POTB_COND_TYPECHAR4(0) *OTB Condition TypeKSCHL
KEY_IDWRF_BUDG_KEY_IDNUMC16(0) Unique Number of BudgetWRF_BUDG_KEY_ID
OTB_VALUEWRF_POTB_VALUECURR17(2) Required BudgetWRF_POTB_VALUE
OTB_CURRWRF_POTB_CURRENCYCUKY5(0) *OTB CurrencyWAERS
OTB_RES_VALUEWRF_POTB_RES_VALUECURR17(2) Reserved Budget for OTB-Relevant Purchasing DocumentWRF_POTB_RES_VALUE
OTB_SPEC_VALUEWRF_POTB_SPECIAL_VALUECURR17(2) Special Release BudgetWRF_POTB_SPECIAL_VALUE
SPR_RSN_PROFILEWRF_POTB_SPR_RSN_PROFILECHAR4(0) Reason Profile for OTB Special ReleaseWRF_POTB_SPR_RSN_PROFILE
BUDG_TYPEWRF_BUDG_TYPECHAR2(0) Budget TypeWRF_BUDG_TYPEWRF_POTB_BUDGET_TYPE_F4TYPE
OTB_STATUSWRF_POTB_STATUSCHAR1(0) OTB Check StatusWRF_POTB_STATUS
OTB_REASONWRF_POTB_STATUS_REASONCHAR3(0) Reason Indicator for OTB Check StatusWRF_POTB_STATUS_REASON
CHECK_TYPEWRF_BUDG_OTB_CHECKCHAR1(0) Type of OTB CheckWRF_BUDG_OTB_CHECK
CON_OTB_REQWRF_POTB_CON_REQCHAR1(0) OTB-Relevant ContractCHAR1_X
CON_PREBOOK_LEVWRF_POTB_PREBOOK_LEVELCHAR1(0) OTB Indicator Level for ContractsWRF_POTB_PREBOOK_LEVEL
CON_DISTR_LEVWRF_POTB_DISTRIB_LEVELCHAR1(0) Distribution Using Target Value or Item DataWRF_POTB_DISTRIB_LEVEL


View list of all tables