1. Home
  2. Resources
  3. SAP Tables
  4. EKBP - Transfer: MM Purchase Order (Ordering Statistics)

SAP Table EKBP

Transfer: MM Purchase Order (Ordering Statistics)

EKBP (Transfer: MM Purchase Order (Ordering Statistics)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link EKBP to other SAP tables.

EKBP table fields

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

EKBP foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
EKBP ZZREGION SYST MANDT ZREG User Defined Regions MANDT
EKBP ZZREGION EKBP ZZREGION ZREG User Defined Regions ZZREGION
EKBP ZZSPREG SYST MANDT ZZSPREG Check table for ZZSPREG = Special Region MANDT
EKBP ZZSPREG EKBP ZZSPREG ZZSPREG Check table for ZZSPREG = Special Region ZZSPREG
EKBP ZZSTATE SYST MANDT T005S Taxes: Region (Province) Key MANDT
EKBP ZZSTATE * T005S Taxes: Region (Province) Key LAND1
EKBP ZZSTATE EKBP ZZSTATE T005S Taxes: Region (Province) Key BLAND
EKBP ZZUSERFLD1 EKBP ZZUSERFLD1 ZFU1 Check Table for User Field 1 ZZUSERFLD1
EKBP ZZUSERFLD1 SYST MANDT ZFU1 Check Table for User Field 1 MANDT