1. Home
  2. Resources
  3. SAP Tables
  4. EKPR - Transfer: MM Purchase Requisition

SAP Table EKPR

Transfer: MM Purchase Requisition

EKPR (Transfer: MM Purchase Requisition) 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 EKPR to other SAP tables.

EKPR table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
RFTYP Reference Transaction AWTYP CHAR 5 0
BANFN Purchase Requisition Number BANFN CHAR 10 0
RFORG Reference Organizational Units AWORG CHAR 10 0
RFSYS Logical system of source document AWSYS CHAR 10 0
BNFPO Item Number of Purchase Requisition BNFPO EBAN NUMC 5 0
ZEBKN Serial number for PReq account assignment segment DZEBKN NUMC 2 0
ERDAT Date on Which Record Was Created ERDAT 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
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
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
PARGB Trading partner's business area PARGB CHAR 4 0
BADAT Requisition (Request) Date BADAT DATS 8 0
LFDAT Delivery date LFDAT DATS 8 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
IMKEY Internal Key for Real Estate Object IMKEY CHAR 8 0
MATNR Material Number MATNR CHAR 18 0
MATKL Material Group MATKL CHAR 9 0
TXZ01 Short Text TXZ01 CHAR 40 0
MEINS Purchase Requisition Unit of Measure BAMEI UNIT 3 0
MENGE Purchase Requisition Quantity BAMNG QUAN 13 3
BAWTW Purchase requisition value (transaction currency = TW) BAWTW CURR 13 2
BAWHW Purchase requisition value (local currency = LC) BAWHW CURR 13 2
BSMNG 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
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
LOEKZ Deletion Indicator in Purchasing Document ELOEK CHAR 1 0
EBAKZ Purchase Requisition Closed EBAKZ CHAR 1 0
X Yes
NULL No
LIFNR Desired Vendor WLIEF CHAR 10 0
FLIEF Fixed Vendor FLIEF CHAR 10 0
EKORG Purchasing Organization EKORG CHAR 4 0
DABRZ Reference Date for Settlement DABRBEZ DATS 8 0
XBAPI Checkbox XFELD CHAR 1 0
X Yes
NULL No
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
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
MENGE_F Purchase Requisition Quantity Floating Point Number BAMNG_F FLTP 16 16
BSMNG_F PO Quantity Floating Point Number BSTMG_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
BUDGET_PD FM: Budget Period FM_BUDGET_PERIOD CHAR 10 0
MEASURE Funded Program FM_MEASURE CHAR 24 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

EKPR foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
EKPR BNFPO EKPR MANDT EBAN Purchase Requisition MANDT
EKPR BNFPO EKPR BANFN EBAN Purchase Requisition BANFN
EKPR BNFPO EKPR BNFPO EBAN Purchase Requisition BNFPO
EKPR MANDT EKPR MANDT T000 Clients MANDT
EKPR ZZREGION EKPR ZZREGION ZREG User Defined Regions ZZREGION
EKPR ZZREGION SYST MANDT ZREG User Defined Regions MANDT
EKPR ZZSPREG SYST MANDT ZZSPREG Check table for ZZSPREG = Special Region MANDT
EKPR ZZSPREG EKPR ZZSPREG ZZSPREG Check table for ZZSPREG = Special Region ZZSPREG
EKPR ZZSTATE SYST MANDT T005S Taxes: Region (Province) Key MANDT
EKPR ZZSTATE * T005S Taxes: Region (Province) Key LAND1
EKPR ZZSTATE EKPR ZZSTATE T005S Taxes: Region (Province) Key BLAND
EKPR ZZUSERFLD1 SYST MANDT ZFU1 Check Table for User Field 1 MANDT
EKPR ZZUSERFLD1 EKPR ZZUSERFLD1 ZFU1 Check Table for User Field 1 ZZUSERFLD1