SAP table EKBP (Transfer: MM Purchase Order (Ordering Statistics))

SAP table EKBP has 7 primary key fields being MANDT,EBELN,EBELP,ZEKKN,ETENR,STUNR,ZAEHK.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 MANDT
RFTYP Reference procedure CHAR 5 0 AWTYP
EBELN Purchasing Document Number CHAR 10 0 EBELN
RFORG Reference Organizational Units CHAR 10 0 AWORG
RFSYS Logical system of source document CHAR 10 0 AWSYS
EBELP Item Number of Purchasing Document NUMC 5 0 EBELP
ZEKKN Sequential Number of Account Assignment NUMC 2 0 DZEKKN
ETENR Schedule Line Number NUMC 4 0 ETENR
STUNR Step Number NUMC 3 0 STUNR
ZAEHK Condition Counter NUMC 3 0 DZAEHK
BLDAT Document Date DATS 8 0 CO_BLDAT
BSART Order Type (Purchasing) CHAR 4 0 BSART
BSTYP Purchasing Document Category CHAR 1 0 BSTYP
A Request for quotation
B Purchase requisition
C Central Contract
F Purchase order
I Info record
K Contract
L Scheduling agreement
N Central Request for Quotation
O Quotation
Q Service entry sheet
R Request for Quotation
S Simplified service entry sheet
T Central Quotation
W Source list
PSTYP Item category in purchasing document CHAR 1 0 PSTYP
KAPPL Application CHAR 2 0 KAPPL
KSCHL Condition Type CHAR 4 0 KSCHL
KNTYP Condition Category (Examples: Tax, Freight, Price, Cost) CHAR 1 0 KNTYP
$ TaxJurCode trigger (without license check KNVL)
& AFS Value-Added Services
+ Tax exemption license via conditions
- Total charges (only IS-OIL)
0 Charges - condition records (only IS-OIL)
1 Tax JurDic level 1 (with license check KNVL)
2 Tax JurDic level 2
3 Tax JurDic level 3
4 Tax JurDic level 4
5 Customer reserve 5
6 Customer reserve 6
7 Customer reserve 7
8 Customer reserve 8
9 Customer reserve 9
A Packaging
a Reserved (fixed extra pay)
B Delivery costs
b Transfer Price for Group Valuation
C Insurance
c Transfer price for profit centers
d Confirmed purchase net price/value
D Tax
E Cash discount
e Down payment request/down payment clearing
f Free goods - inclusive
F Freight
G Internal price
g Payment
H Basic price
h Profit Center Cost
I Price for intercompany billing
i Ship & Debit 1 (IBU HiTec)
J Customer expected price / customer value (excl.tax)
j Ship & Debit 2 (IBU HiTec)
K Base amount excluding tax
L Generally new when copying
l TP-ILV: Base Tarif That Covers Costs
M Sales tax w/license-checking (VAT)
m SSR Discount (only IS-Oil)
N Input Tax not Deductible
n Profit Center Internal Price (Route)
o AFS Season Determination
O Variants
P Base amount including tax
p SSR Partner Commission (only IS-OIL)
Q Costing
R Invoice list condition
S Standard cost
T Moving cost
U Discount/surcharge for precious metals
V Price component
W Expected sales price (including tax)
X Customer reserve X
Y Customer reserve Y
Z Customer reserve Z
TWAER Transaction Currency CUKY 5 0 TWAER
LIFNR Vendor's account number CHAR 10 0 ELIFN
VBUND Company ID of Trading Partner CHAR 6 0 RASSC
PARGB Trading partner's business area CHAR 4 0 PARGB
BEDAT Order date of schedule line DATS 8 0 ETBDT
EINDT Item delivery date DATS 8 0 EINDT
RFTYP_PRE Previous document: Reference procedure CHAR 5 0 AWTYP_PRE
RFORG_PRE Reference Organizational Units CHAR 10 0 AWORG
BANFN Purchase Requisition Number CHAR 10 0 BANFN
BNFPO Item number of purchase requisition NUMC 5 0 BNFPO
KOKRS Controlling Area CHAR 4 0 KOKRS
BUKRS Company Code CHAR 4 0 BUKRS
GSBER Business Area CHAR 4 0 GSBER
SAKTO G/L Account Number CHAR 10 0 SAKNR
VRGNG CO Business Transaction CHAR 4 0 CO_VORGANG
HRKFT Origin Group as Subdivision of Cost Element CHAR 4 0 HRKFT
KOSTL Cost Center CHAR 10 0 KOSTL
AUFNR Order Number CHAR 12 0 AUFNR
PS_PSP_PNR Work Breakdown Structure Element (WBS Element) NUMC 8 0 PS_PSP_PNR
NPLNR Network Number for Account Assignment CHAR 12 0 NPLNR
AUFPL Routing number of operations in the order NUMC 10 0 CO_AUFPL
APLZL Internal counter NUMC 8 0 CIM_COUNT
VBELN Sales and Distribution Document Number CHAR 10 0 VBELN
VBELP Sales Document Item NUMC 6 0 POSNR_VA
ANLN1 Main Asset Number CHAR 12 0 ANLN1
ANLN2 Asset Subnumber CHAR 4 0 ANLN2
WKURS Exchange Rate DEC 9 5 WKURS
KUFIX Indicator for Fixed Exchange Rate CHAR 1 0 KUFIX
ZTERM Terms of payment key CHAR 4 0 DZTERM
ZBD1T Cash discount days 1 DEC 3 0 DZBD1T
ZBD2T Cash discount days 2 DEC 3 0 DZBD2T
ZBD3T Net Payment Terms Period DEC 3 0 DZBD3T
ZBD1P Cash discount percentage 1 DEC 5 3 DZBD1P
ZBD2P Cash Discount Percentage 2 DEC 5 3 DZBD2P
FDGRP Planning Group CHAR 10 0 FDGRP
FDLEV Planning Level CHAR 2 0 FDLEV
MATNR Material Number CHAR 40 0 MATNR
MATKL Material Group CHAR 9 0 MATKL
SGTXT Segment text CHAR 50 0 CO_SGTXT
MEINS Purchase Order Unit of Measure UNIT 3 0 BSTME
WEPOS Goods Receipt Indicator CHAR 1 0 WEPOS
WEUNB Goods Receipt, Non-Valuated CHAR 1 0 WEUNB
REPOS Invoice receipt indicator CHAR 1 0 REPOS
BEMNG Purchase Order Quantity QUAN 13 3 BSTMG
BEWTW Real Total Value (Purchase Order Currency = TC) CURR 23 2 BEWTW
BEWHW Real Total Value (Local Currency = LC) CURR 23 2 BEWHW
WEMNG Quantity of Goods Received QUAN 13 3 WEMNG
WEWTW Goods Receipt Value (Purchase Order Currency = TC) CURR 23 2 WEWTW
WEWHW Goods Receipt Value (Local Currency = LC) CURR 23 2 WEWHW
REMNG Quantity invoiced QUAN 13 3 REMNG
REWTW Real Invoice Value (Purchase Order Currency = TC) CURR 23 2 REWTW
REWHW Real Invoice Value (Local Currency = LC) CURR 23 2 REWHW
AAWTW Down Payment Request Value (Purchase Order Currency = TC) CURR 23 2 AAWTW
AAWHW Down Payment Request Value (Local Currency = LC) CURR 23 2 AAWHW
AZWTW Down Payment Value (Purchase Order Currency = TC) CURR 23 2 AZWTW
AZWHW Down Payment Value (Local Currency = LC) CURR 23 2 AZWHW
AKWTW Payment on Account (Purchase Order Currency = TC) CURR 23 2 AKWTW
AKWHW Payment on Account (Local Currency = LC) CURR 23 2 AKWHW
ZAWTW Payment (Purchase Order Currency = TC) CURR 23 2 AUWTW
ZAWHW Payment (Local Currency = LC) CURR 23 2 AUWHW
ELIKZ "Delivery Completed" Indicator CHAR 1 0 ELIKZ
EREKZ Final Invoice Indicator CHAR 1 0 EREKZ
KZVBR Consumption posting CHAR 1 0 KZVBR
No consumption
A Asset
E Sales order
P Project
V Consumption
SOBKZ Special Stock Indicator CHAR 1 0 SOBKZ
LOEKZ Deletion Indicator in Purchasing Document CHAR 1 0 ELOEK
RETPO Returns Item CHAR 1 0 RETPO
FIPOS Commitment Item CHAR 14 0 FIPOS
GEBER Fund CHAR 10 0 BP_GEBER
FISTL Funds Center CHAR 16 0 FISTL
GRANT_NBR Grant CHAR 20 0 GM_GRANT_NBR
XNEWP Checkbox CHAR 1 0 XFELD
No
X Yes
IMKEY Internal Key for Real Estate Object CHAR 8 0 IMKEY
DABRZ Reference date for settlement DATS 8 0 DABRBEZ
ZFBDT Baseline Date for Due Date Calculation DATS 8 0 DZFBDT
ANZAHLKZ Down payment request CHAR 1 0 ANZAHLKZ
FRGRL Release Not Yet Completely Effected CHAR 1 0 FRGRL
XBAPI Checkbox CHAR 1 0 XFELD
No
X Yes
PWHWO Payment Commitment (Local Currency = LC) CURR 23 2 PWHWO
PWTWO Payment Commitment (Transaction Currency = TC) CURR 23 2 PWTWO
CWHWO Cost Commitments (Local Currency = LC) CURR 23 2 CWHWO
CWTWO Cost Commitments (Transaction Currency = TC) CURR 23 2 CWTWO
FM_TRANS_DATE FM Transaction Date DATS 8 0 FM_TRANS_DATE
FM_TRANS_PERI Period NUMC 3 0 CO_PERIO
DUMMY_INCL_EEW_COBL Custom Fields: Dummy for Use in Extension Includes CHAR 1 0 CFD_DUMMY
KBLNR Document Number for Earmarked Funds CHAR 10 0 * KBLNR
KBLPOS Earmarked Funds: Document Item NUMC 3 0 * KBLPOS
FKBER Functional Area CHAR 16 0 FKBER
MEMORY Purchase order not yet complete CHAR 1 0 MEMER
FPL_EXISTS Checkbox CHAR 1 0 XFELD
No
X Yes
BWTAR Valuation Type CHAR 10 0 BWTAR_D
WERKS Plant CHAR 4 0 WERKS_D
PACKNO Package number NUMC 10 0 PACKNO
INTROW Internal line number for limits NUMC 10 0 INTROW
MAPNO Mapping Field f. PACKNO, INTROW at Item Level for Commitment NUMC 4 0 MAPNO
WEMNG_P PSM: Goods Quantity Received QUAN 13 3 WEMNG_P
WEWTW_P PSM: Goods Receipt Value (Purchase Order Currency = TC) CURR 13 2 WEWTW_P
WEWHW_P PSM: Goods Receipt Value (Local Currency = LC) CURR 13 2 WEWHW_P
REMNG_P PSM: Invoice Receipt Quantity QUAN 13 3 REMNG_P
REWTW_P PSM: Effective Invoice Value (Purchase Order Currency = TW) CURR 13 2 REWTW_P
REWHW_P PSM: Effective Invoice Value (Local Currency = LC) CURR 13 2 REWHW_P
WEMNG_PF PSM: Goods Receipt Quantity Floating Point FLTP 16 16 WEMNG_PF
REMNG_PF PSM: Invoice Receipt Quantity Floating Point FLTP 16 16 REMNG_PF
MEASURE Funded Program CHAR 24 0 FM_MEASURE
BEMNG_F PO Quantity Floating Point Number FLTP 16 16 BSTMG_F
WEMNG_F Goods Receipt Quantity Floating Point FLTP 16 16 WEMNG_F
REMNG_F Invoice Receipt Quantity Floating Point FLTP 16 16 REMNG_F
VRTKZ Distribution Indicator for Multiple Account Assignment CHAR 1 0 VRTKZ
Single Account Assignment
1 Distrib. on Quantity Basis
2 Distribution by Percentage
3 Distribution by Amount
WEWHW_REV Revaluation Good Receipt Value (Local Currency = LC) CURR 23 2 WEWHW_REV
REWHW_REV Revaluation of Effective Invoice Value (Local Currency =LC) CURR 23 2 REWHW_REV
AZWHW_REV Revaluation Down Payment Value (Local Currency = LC) CURR 23 2 AZWHW_REV
AAWHW_REV Revalution Down Payment Request Value (Local Currency = LC) CURR 23 2 AAWHW_REV
BUDGET_PD Budget Period CHAR 10 0 FM_BUDGET_PERIOD
FM_SPLIT Line Is Result of Account Assignment Drilldown CHAR 1 0 FMSP_SPLIT_RESULT_FLAG
FMFGUS_KEY United States Federal Government Fields CHAR 22 0 FMFG_US_KEY
SERVICE_DOC_TYPE Service Document Type CHAR 4 0 FCO_SRVDOC_TYPE
SERVICE_DOC_ID Service Document ID CHAR 10 0 FCO_SRVDOC_ID
SERVICE_DOC_ITEM_ID Service Document Item ID NUMC 6 0 FCO_SRVDOC_ITEM_ID
PAOBJNR Profitability Segment Number (CO-PA) NUMC 10 0 RKEOBJNR
PRZNR Business Process CHAR 12 0 CO_PRZNR
/SAPF15/STATUS Status for F15 Relevance Funds Management Document CHAR 2 0 /SAPF15/STATUS_FMIT
F15
-
VE
VV