Complete field list of SAP table EKKO – Purchasing Document Header
#1 MANDT – Client
#2 EBELN – Purchasing Document Number
#3 BUKRS – Company Code
#4 BSTYP – Purchasing Document Category
#5 BSART – Purchasing Document Type
#6 BSAKZ – Control indicator for purchasing document type
#7 LOEKZ – Deletion indicator in purchasing document
#8 STATU – Status of Purchasing Document
#9 AEDAT – Date on Which Record Was Created
#10 ERNAM – Name of Person Who Created the Object
#11 PINCR – Item Number Interval
#12 LPONR – Last Item Number
#13 LIFNR – Vendor’s account number
#14 SPRAS – Language Key
#15 ZTERM – Terms of Payment Key
#16 ZBD1T – Cash (Prompt Payment) Discount Days
#17 ZBD2T – Cash (Prompt Payment) Discount Days
#18 ZBD3T – Cash (Prompt Payment) Discount Days
#19 ZBD1P – Cash discount percentage 1
#20 ZBD2P – Cash Discount Percentage 2
#21 EKORG – Purchasing Organization
#22 EKGRP – Purchasing Group
#23 WAERS – Currency Key
#24 WKURS – Exchange Rate
#25 KUFIX – Indicator: Fixing of Exchange Rate
#26 BEDAT – Purchasing Document Date
#27 KDATB – Start of Validity Period
#28 KDATE – End of Validity Period
#29 BWBDT – Closing Date for Applications
#30 ANGDT – Deadline for Submission of Bid/Quotation
#31 BNDDT – Binding Period for Quotation
#32 GWLDT – Warranty Date
#33 AUSNR – Bid invitation number
#34 ANGNR – Quotation Number
#35 IHRAN – Quotation Submission Date
#36 IHREZ – Your Reference
#37 VERKF – Responsible Salesperson at Vendor’s Office
#38 TELF1 – Vendor’s Telephone Number
#39 LLIEF – Supplying Vendor
#40 KUNNR – Customer Number
#41 KONNR – Number of principal purchase agreement
#42 ABGRU – Field Not Used
#43 AUTLF – Complete Delivery Stipulated for Each Purchase Order
#44 WEAKT – Indicator: Goods Receipt Message
#45 RESWK – Supplying (issuing) plant in case of stock transport order
#46 LBLIF – Field not used
#47 INCO1 – Incoterms (Part 1)
#48 INCO2 – Incoterms (Part 2)
#49 KTWRT – Target Value for Header Area per Distribution
#50 SUBMI – Collective Number
#51 KNUMV – Number of the document condition
#52 KALSM – Procedure (Pricing, Output Control, Acct. Det., Costing,…)
#53 STAFO – Update group for statistics update
#54 LIFRE – Different Invoicing Party
#55 EXNUM – Number of foreign trade data in MM and SD documents
#56 UNSEZ – Our Reference
#57 LOGSY – Logical System
#58 UPINC – Item Number Interval for Subitems
#59 STAKO – Document with time-dependent conditions
#60 FRGGR – Release group
#61 FRGSX – Release Strategy
#62 FRGKE – Release Indicator: Purchasing Document
#63 FRGZU – Release State
#64 FRGRL – Release Not Yet Completely Effected
#65 LANDS – Country for Tax Return
#66 LPHIS – Indicator for scheduling agreement release documentation
#67 ADRNR – Address number
#68 STCEG_L – Country of Sales Tax ID Number
#69 STCEG – VAT Registration Number
#70 ABSGR – Reason for Cancellation
#71 ADDNR – Document number for additional
#72 KORNR – Correction of miscellaneous provisions
#73 MEMORY – Purchase order not yet complete
#74 PROCSTAT – Purchasing document processing state
#75 RLWRT – Total value at time of release
#76 REVNO – Version number in Purchasing
#77 SCMPROC – SCM Process That Created the Purchase Order
#78 REASON_CODE – Goods Receipt Reason Code
#79 MEMORYTYPE – Category of Incompleteness
#80 RETTP – Retention Indicator
#81 RETPC – Retention in Percent
#82 DPTYP – Down Payment Indicator
#83 DPPCT – Down Payment Percentage
#84 DPAMT – Down Payment Amount in Document Currency
#85 DPDAT – Due Date for Down Payment
#86 MSR_ID – Process Identification Number
#87 HIERARCHY_EXISTS – Part of a Contract Hierarchy
#88 THRESHOLD_EXISTS – Threshold Value for Exchange Rates Exists
#89 LEGAL_CONTRACT – Legal Contract Number
#90 DESCRIPTION – Contract Name
#91 RELEASE_DATE – Release Date of Contract
#92 VSART – Shipping type
#93 HANDOVERLOC – Location for a physical handover of goods
#94 SHIPCOND – Shipping Conditions
#95 INCOV – Incoterms Version
#96 INCO2_L – Incoterms Location 1
#97 INCO3_L – Incoterms Location 2
#98 FORCE_ID – Internal Key for Force Element
#99 FORCE_CNT – Internal (Version) Counter
#100 RELOC_ID – Relocation ID
#101 RELOC_SEQ_ID – Relocation Step ID
#102 SOURCE_LOGSYS – Logical System
#103 FSH_TRANSACTION – Transaction Number
#104 FSH_ITEM_GROUP – Item Group
#105 FSH_VAS_LAST_ITEM – Last VAS Item Number
#106 FSH_OS_STG_CHANGE – Order Scheduling Strategy specific fields change manually
#107 WEEK – Planning week/year (calendar)
#108 WEEKX – Character field of length 6
#109 VZSKZ – Interest calculation indicator
#110 FSH_SNST_STATUS – Snapshot Status
#111 POHF_TYPE – Document for Seasonal Purchase Order Processing
#112 EQ_EINDT – Delivery Date Header: All Items Have Same Delivery Date
#113 EQ_WERKS – Plant Header: All Items Have Same Receiving Plant
#114 FIXPO – Firm Deal Indicator
#115 EKGRP_ALLOW – Take Account of Purch. Group
#116 WERKS_ALLOW – Take Account of Plants
#117 CONTRACT_ALLOW – Take Account of Contracts
#118 PSTYP_ALLOW – Take Account of Item Categories
#119 FIXPO_ALLOW – Take Account of Fixed-Date Purchases Indicator
#120 KEY_ID_ALLOW – Consider Budget
#121 AUREL_ALLOW – Take Account of Alloc. Table Relevance
#122 DELPER_ALLOW – Take Account of Dlvy Period
#123 EINDT_ALLOW – Take Account of Delivery Date
#124 LTSNR_ALLOW – Include Vendor Subrange
#125 OTB_LEVEL – OTB Check Level
#126 OTB_COND_TYPE – OTB Condition Type
#127 KEY_ID – Unique Number of Budget
#128 OTB_VALUE – Required Budget
#129 OTB_CURR – OTB Currency
#130 OTB_RES_VALUE – Reserved Budget for OTB-Relevant Purchasing Document
#131 OTB_SPEC_VALUE – Special Release Budget
#132 SPR_RSN_PROFILE – Reason Profile for OTB Special Release
#133 BUDG_TYPE – Budget Type
#134 OTB_STATUS – OTB Check Status
#135 OTB_REASON – Reason Indicator for OTB Check Status
#136 CHECK_TYPE – Type of OTB Check
#137 CON_OTB_REQ – OTB-Relevant Contract
#138 CON_PREBOOK_LEV – OTB Indicator Level for Contracts
#139 CON_DISTR_LEV – Distribution Using Target Value or Item Data