SAP table EKPR (Transfer: MM Purchase Requisition)

SAP table EKPR has 4 primary key fields being MANDT,BANFN,BNFPO,ZEBKN.

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 T000 MANDT
RFTYP Reference procedure CHAR 5 0 AWTYP
BANFN Purchase Requisition Number CHAR 10 0 BANFN
RFORG Reference Organizational Units CHAR 10 0 AWORG
RFSYS Logical system of source document CHAR 10 0 AWSYS
BNFPO Item number of purchase requisition NUMC 5 0 EBAN BNFPO
ZEBKN Serial number for PReq account assignment segment NUMC 2 0 DZEBKN
ERDAT Date on which the record was created DATS 8 0 ERDAT
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
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
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
PARGB Trading partner's business area CHAR 4 0 PARGB
BADAT Requisition (request) date DATS 8 0 BADAT
LFDAT Delivery date DATS 8 0 LFDAT
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
IMKEY Internal Key for Real Estate Object CHAR 8 0 IMKEY
MATNR Material Number CHAR 40 0 MATNR
MATKL Material Group CHAR 9 0 MATKL
TXZ01 Short Text CHAR 40 0 TXZ01
MEINS Purchase requisition unit of measure UNIT 3 0 BAMEI
MENGE Purchase requisition quantity QUAN 13 3 BAMNG
BAWTW Purchase Requisition Value (Transaction Currency = TW) CURR 23 2 BAWTW
BAWHW Purchase Requisition Value (Local Currency = LC) CURR 23 2 BAWHW
BSMNG 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
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
LOEKZ Deletion Indicator in Purchasing Document CHAR 1 0 ELOEK
EBAKZ Purchase requisition closed CHAR 1 0 EBAKZ
LIFNR Desired Vendor CHAR 10 0 WLIEF
FLIEF Fixed Vendor CHAR 10 0 FLIEF
EKORG Purchasing organization CHAR 4 0 EKORG
DABRZ Reference date for settlement DATS 8 0 DABRBEZ
XBAPI Checkbox CHAR 1 0 XFELD
No
X Yes
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
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
MENGE_F Purchase Requisition Quantity Floating Point Number FLTP 16 16 BAMNG_F
BSMNG_F PO Quantity Floating Point Number FLTP 16 16 BSTMG_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
BUDGET_PD Budget Period CHAR 10 0 FM_BUDGET_PERIOD
MEASURE Funded Program CHAR 24 0 FM_MEASURE
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
PAOBJNR Profitability Segment Number (CO-PA) NUMC 10 0 RKEOBJNR
PRZNR Business Process CHAR 12 0 CO_PRZNR

EKPR foreign key relationships

Table Field Check Table Check Field
0 EKPR BNFPO EBAN Purchase Requisition BANFN
0 EKPR BNFPO EBAN Purchase Requisition BNFPO
1 EKPR MANDT T000 Clients MANDT