SAP Table EK08BN

Delivery Costs for Invoice Verification (New)

EK08BN (Delivery Costs for Invoice Verification (New)) 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 EK08BN to other SAP tables.

EK08BN table fields

Field Data element Checktable Datatype Length Decimals
ANLN1 Main Asset Number ANLN1 CHAR 12 0
ANLN2 Asset Subnumber ANLN2 CHAR 4 0
APLZL Internal counter CIM_COUNT NUMC 8 0
AREWR GR/IR account clearing value in local currency AREWR CURR 13 2
AREWW Clearing value on GR/IR clearing account (transac. currency) AREWW CURR 13 2
AUFNR Order Number AUFNR CHAR 12 0
AUFPL Routing number of operations in the order CO_AUFPL NUMC 10 0
BASME Base unit of measure F_MEINS UNIT 3 0
BEDAT Purchase Order Date BEDAT DATS 8 0
BEGRU Authorization Group BEGRU CHAR 4 0
BEWAE Purchase order currency BSTWA CUKY 5 0
EKGRP Purchasing Group BKGRP CHAR 3 0
BPMNG Quantity in Purchase Order Price Unit BPMNG QUAN 13 3
BPRME Order Price Unit (Purchasing) BPRME UNIT 3 0
BPUMN Denominator for Conv. of Order Price Unit into Order Unit BPUMN DEC 5 0
BPUMZ Numerator for Conversion of Order Price Unit into Order Unit BPUMZ DEC 5 0
BPWEM Goods Receipt Quantity in Purchase Order Price Unit BPWEM QUAN 13 3
BPREM Invoice receipt quantity in order price unit BPREM QUAN 13 3
BSMNG Quantity Ordered Against this Purchase Requisition BSMNG QUAN 13 3
BUDAT Posting Date in the Document BUDAT DATS 8 0
BUKRS Company Code BUKRS CHAR 4 0
BWTAR Valuation Type BWTAR_D CHAR 10 0
BWTTY Valuation Category BWTTY_D CHAR 1 0
BZDAT Asset value date BZDAT DATS 8 0
EBELN Purchase Order Number BSTNR CHAR 10 0
EBELP Item Number of Purchasing Document EBELP NUMC 5 0
FIPOS Commitment Item FIPOS CHAR 14 0
FISTL Funds Center FISTL CHAR 16 0
FKBER Functional Area FKBER CHAR 16 0
GEBER Fund FM_FUND CHAR 10 0
GRANT_NBR Grant GM_GRANT_NBR CHAR 20 0
GSBER Business Area GSBER CHAR 4 0
KBLNR Document Number for Earmarked Funds KBLNR_FI CHAR 10 0
KBLPOS Earmarked Funds: Document Item KBLPOS NUMC 3 0
HWAER Local Currency HWAER CUKY 5 0
IMKEY Internal Key for Real Estate Object IMKEY CHAR 8 0
KDAUF Sales Order Number KDAUF CHAR 10 0
KDPOS Item Number in Sales Order KDPOS NUMC 6 0
KNTTP Account Assignment Category KNTTP CHAR 1 0
KOSTL Cost Center KOSTL CHAR 10 0
KO_GSBER Business area reported to the partner GSBER_GP CHAR 4 0
KO_PARGB assumed business area of the business partner PARGB_GP CHAR 4 0
KO_PRCTR Profit Center PRCTR CHAR 10 0
KO_PPRCTR Partner Profit Center PPRCTR CHAR 10 0
KSTRG Cost Object KSTRG CHAR 12 0
KUFIX Indicator: Fixing of Exchange Rate KUFIX CHAR 1 0
X Yes
NULL No
KZBAA Indicator: valuation type is set automatically KZBAA CHAR 1 0
X Yes
NULL No
KZBWS Valuation of Special Stock KZBWS CHAR 1 0
NULL No stock valuation
M Separate valuation with ref. to sales document/project
A Valuation without reference to sales document
KZVBF Valuation type "external procurement" mandatory KZVBF CHAR 1 0
X Yes
NULL No
LANDS Country from where output is sent (issuing country) LANDS CHAR 3 0
MATKL Material Group MATKL CHAR 9 0
MATNR Material Number MATNR CHAR 18 0
MEINS Purchase Order Unit of Measure BSTME UNIT 3 0
MEPRF Price Determination (Pricing) Date Control MEPRF CHAR 1 0
NULL No Control
1 Purchase Order Date
2 Delivery Date
3 Current Date
4 Manual
5 GR Date
MTART Material Type MTART CHAR 4 0
NETWR Net order value in document currency BSTWR CURR 13 2
NOQUANTITY No quantity logic (document item without quantity) NOQUANTITY CHAR 1 0
X Yes
NULL No
NPLNR Network Number for Account Assignment NPLNR CHAR 12 0
PAOBJNR Profitability Segment Number (CO-PA) RKEOBJNR NUMC 10 0
PERNR Personnel Number PERNR_D NUMC 8 0
PRCTR Profit Center PRCTR CHAR 10 0
PS_PSP_PNR Work Breakdown Structure Element (WBS Element) PS_PSP_PNR NUMC 8 0
PSTYP Item Category in Purchasing Document PSTYP CHAR 1 0
RECID Recovery Indicator JV_RECIND CHAR 2 0
REEWR Invoice Value Entered (in Local Currency) REEWR CURR 13 2
REFWR Invoice value in foreign currency REFWR CURR 13 2
REMNG Quantity invoiced REMNG QUAN 13 3
RETPO Returns Item RETPO CHAR 1 0
X Yes
NULL No
REWRT Invoice value in local currency REWRT CURR 13 2
REWWR Invoice Amount in Foreign Currency REWWR CURR 13 2
SAKNR G/L Account Number SAKNR CHAR 10 0
SOBKZ Special Stock Indicator SOBKZ CHAR 1 0
TXJCD Tax Jurisdiction TXJCD CHAR 15 0
UMREN Denominator for conversion to base units of measure UMREN DEC 5 0
UMREZ Numerator for Conversion to Base Units of Measure UMREZ DEC 5 0
VBWAF Default: valuation type "external procurement" VBWAF CHAR 10 0
VPTNR Partner account number JV_PART CHAR 10 0
WAERS Currency Key WAERS CUKY 5 0
WEMNG Quantity of Goods Received WEMNG QUAN 13 3
WEPOS Goods Receipt Indicator WEPOS CHAR 1 0
X Yes
NULL No
WERKS Plant WERKS_D CHAR 4 0
WEUNB Goods Receipt, Non-Valuated WEUNB CHAR 1 0
X Yes
NULL No
WEWRT Value of goods received in local currency WEWRT CURR 13 2
WEWWR Value of goods received in foreign currency WEWWR CURR 13 2
WENWR Accepted net value of service in foreign currency WENWR CURR 13 2
XBLNR Number of External Delivery Note LFSNR1 CHAR 16 0
ZEKKN Sequential Number of Account Assignment DZEKKN NUMC 2 0
LSMNG Quantity from Delivery Note MRM_LSMNG QUAN 13 3
LSMEH Unit of Measure From Delivery Note LSMEH UNIT 3 0
DABRZ Reference Date for Settlement DABRBEZ DATS 8 0
EMATN Material Number Corresponding to Manufacturer Part Number EMATN CHAR 18 0
KDATB Start of Validity Period KDATB DATS 8 0
KDATE End of Validity Period KDATE DATS 8 0
SUMLIMIT Overall Limit SUMLIMIT CURR 13 2
SUMNOLIM No Limit NOLIMIT CHAR 1 0
ACTVALUE Total Value of Unplanned Entered Services ACTVALUE CURR 13 2
WEMMG Non-valuated goods receipt quantity WEMMG QUAN 13 3
BPWMM Non-valuated goods receipt quantity in order price unit BPWMM QUAN 13 3
LSTAR Activity Type LSTAR CHAR 6 0
PRZNR Business Process CO_PRZNR CHAR 12 0
WENAM Goods receipt entered by WENAM CHAR 12 0
AFNAM Name of Requisitioner/Requester AFNAM CHAR 12 0
REBEL Referenced document REBEL CHAR 10 0
REPOS Invoice Receipt Indicator REPOS CHAR 1 0
X Yes
NULL No
AREWB Clearing Value on GR/IR Account in PO Currency AREWB CURR 13 2
TWRKZ Partial Invoice Indicator TWRKZ CHAR 1 0
NULL No multiple account assignment
1 Apportion IR quantities to GR quantities one after another
2 Apportion IR quantities to GR quantities proportionately
REWRB Invoice Amount in PO Currency REWRB CURR 13 2
WEWRB Value of Goods Received in PO Currency WEWRB CURR 13 2
XBESW Indicator: Update in PO Currency XBESW CHAR 1 0
X Yes
NULL No
WESBB Valuated Goods Receipt Blocked Stock in Order Unit WESBB QUAN 13 3
BPWEB Quantity in Valuated GR Blocked Stock in Order Price Unit BPWEB QUAN 13 3
KUDIF Exchange Rate Difference Amount KUDIF CURR 13 2
BSMNG_F Quantity Share Account Assignment Line for Item SHARE_F FLTP 16 16
REMNG_F Quantity Share Account Assignment Line for Item SHARE_F FLTP 16 16
WEMNG_F Quantity Share Account Assignment Line for Item SHARE_F FLTP 16 16
BPREM_F Quantity Share Account Assignment Line for Item SHARE_F FLTP 16 16
BPWEM_F Quantity Share Account Assignment Line for Item SHARE_F FLTP 16 16
XHISTMA Update Multiple Account Assignment EKBE_MA, EKBZ_MA XHISTMA CHAR 1 0
XUNPL Unplanned Account Assignment from Invoice Verification XUNPL CHAR 1 0
X Yes
NULL No
VRTKZ Distribution indicator for multiple account assignment VRTKZ CHAR 1 0
NULL Single account assignment
1 Distrib. on quantity basis
2 Distribution by percentage
WKURS_IR Exchange Rate WKURS DEC 9 5
WKURS_GR Exchange Rate WKURS DEC 9 5
MEASURE Funded Program FM_MEASURE CHAR 24 0
BUDGET_PD FM: Budget Period FM_BUDGET_PERIOD CHAR 10 0
LAST_GR_DATE Last Goods Receipt Date LAST_GR_DATE DATS 8 0
LAST_DELIV_DATE Last Allowed Delivery Date LAST_DELIV_DATE DATS 8 0
AA_FINAL_IND Final Account Assignment Indicator AA_FINAL_IND CHAR 1 0
X Yes
NULL No
AA_FINAL_QTY Final Account Assignment Quantity AA_FINAL_QTY QUAN 13 3
AA_FINAL_QTY_F Final Account Assignment Quantity (Floating Point Number) AA_FINAL_QTY_F FLTP 16 16
PARKED_QTY Parked Invoice Quantity PARKED_QTY QUAN 13 3
PARKED_QTY_F Parked Invoice Quantity (Floating Point Number) PARKED_QTY_F FLTP 16 16
CHARG Batch Number CHARG_D CHAR 10 0
XDINV Indicator for Differential Invoicing XDINV CHAR 1 0
XCPRF Checkbox for Commodity Repricing in Invoice Verification XCPRF CHAR 1 0
FINAL_INV_EXIST Differential Invoicing: Final Invoice Exists FINAL_INV_EXIST CHAR 1 0
PRICING_QTY_GR Goods Receipt Quantity in Purchase Order Price Unit BPWEM QUAN 13 3
KUDIF_GR Exchange Rate Difference Amount KUDIF CURR 13 2
KUDIF_IR Exchange Rate Difference Amount KUDIF CURR 13 2
VNAME Joint Venture JV_NAME CHAR 6 0
EGRUP Equity group JV_EGROUP CHAR 3 0
ETYPE Equity type JV_ETYPE T8JG CHAR 3 0
NEBTR Net Payment Amount NEBTR CURR 13 2
OIEXGNUM Exchange agreement number OIA_EXGNUM CHAR 10 0
OIMATPST Posting rules for material OIA_MATPST CHAR 1 0
1 Material external
2 Mat. and taxes internal
3 Mat. internal, taxes external
OIA_IPMVAT VAT on internally-posted material OIA_IPMVAT CHAR 1 0
NULL No VAT calculation
X VAT calculation with subtotal V of pricing procedure
OIVATH Amount in Local Currency DMBTR CURR 13 2
OIVATF Amount in document currency WRBTR CURR 13 2
OINETTNG Netting indicator OIA_NETTNG CHAR 1 0
X Netting active
NULL Netting not active
OINETCYC Netting cycle (FI blocking indicator) OIA_NETCYC CHAR 1 0
OIEXGTYP Exchange type OIA_EXGTYP CHAR 4 0
OIMATCYC Invoicing cycle for purchase material costs OIA_MATCYC NUMC 1 0
OITAXGRP Excise Duty Group OIH_TAXGRP CHAR 2 0
OIHANTYP Excise Duty Handling Type OIH_HANTYP CHAR 2 0
OITAXFROM Excise duty tax key for 'from' location OIH_TAXFRO CHAR 2 0
OITAXTO Excise duty tax key for 'to' location OIH_TAXTO CHAR 2 0
OIPRICIE ED pricing: external (indicator) OIH_PRICIE CHAR 1 0
X Yes
NULL No
OIFULTAX Excise duty tax value at the full rate OIH_FULTAX CURR 13 2
OITXVAL0 Excise duty tax value 0 OIH_TXVAL0 CURR 13 2
OITXVAL1 Excise duty tax value 1 OIH_TXVAL1 CURR 13 2
OITXVAL2 Excise duty tax value 2 OIH_TXVAL2 CURR 13 2
OITXVAL3 Excise duty tax value 3 OIH_TXVAL3 CURR 13 2
OITXVAL4 Excise duty tax value 4 OIH_TXVAL4 CURR 13 2
OITXVAL5 Excise duty tax value 5 OIH_TXVAL5 CURR 13 2
OITXVAL6 Excise duty tax value 6 OIH_TXVAL6 CURR 13 2
OIOILCON Oil content in a material as a percentage OIH_OILCON DEC 5 2
0 Range of permissible values for Mineral Oil Content %
OITAXCON Excise duty tax from pricing conditions OIH_TAXCON CURR 13 2
OITAXVAL Excise duty value in material inventory account OIH_TAXVAL CURR 13 2
OIOILCON2 Oil content of a material as a percentage (2) OIH_OILCN2 DEC 5 2
0 Range of permissible values for Mineral Oil Content %
OIUOMQT Base quantity for excise duty rate (e.g.per 1 or 100 UoM) OIH_UOMQT UNIT 3 0
OITAXQT Excise duty tax quantity in STBME OIH_TAXQT QUAN 13 3
OIFUTQT Future tax quantity OIH_FUTQT QUAN 13 3
OIFUTTX Future tax value OIH_FUTTX CURR 13 2
OIFUTDT Future tax date OIH_FUTDT DATS 8 0
OIFUTQT2 Future tax quantity 2 OIH_FUTQT2 QUAN 13 3
OIFUTTX2 Future tax value 2 OIH_FUTTX2 CURR 13 2
ROIFUTDT2 Future tax date 2 OIH_FUTDT2 DATS 8 0
OIEDCLT Excise duty clearing value total OIH_EDCLT CURR 13 2
OIWEEDWR Excise duty value - goods receipt OIH_WEEDWR CURR 13 2
OIREEDWR Excise duty value - invoice receipt OIH_REEDWR CURR 13 2
FRBNR Number of Bill of Lading at Time of Goods Receipt FRBNR1 CHAR 16 0
KMEIN Condition unit KMEIN UNIT 3 0
KSCHL Condition Type KSCHL CHAR 4 0
KVSL1 Account key KVSL1 CHAR 3 0
KVSL2 Account key - accruals / provisions KVSL2 CHAR 3 0
LIFNR Account Number of Vendor or Creditor LIFNR CHAR 10 0
STUNR Step number STUNR NUMC 3 0
XBPRM New Input Values XFLAG CHAR 1 0
NULL Blank
. Radio button
X Selection
ZAEHK Condition counter DZAEHK NUMC 2 0
REBUZ Item in Material Document MBLPO NUMC 4 0
VNETW Net value of condition (predefined externally) VNETWR CURR 13 2
VMENG Quantity of Goods Received WEMNG QUAN 13 3
BNKTK Copy delivery costs from shipment costs document VF_BNKTK CHAR 1 0
NULL No copy from shipment cost documents
X Copy from shipment cost documents
XMACC Multiple Account Assignment XMACC CHAR 1 0
OIORBTR Fee amount before clearing (original amount, document curr.) OIA_ORBTR CURR 13 2
KONNR Number of Principal Purchase Agreement KONNR CHAR 10 0
OIA_FE Indicator: update fee order history OIA_FE CHAR 1 0
X Yes
NULL No
OIA_FD Indicator: fee is on detail level OIA_FD CHAR 1 0
X Yes
NULL No
OIACPOL Fee accounting policy indicator OIA_ACPOL CHAR 1 0
1 Fees included in inventory
2 Fees posted to expense account
3 Fees posted to revenue account
WKURS Exchange Rate WKURS DEC 9 5
OIRATE Exchange rate (for foreign currencies) OIA_RATE FLTP 16 16
LFBNR Number of goods receipt document WEBLN CHAR 10 0
LFPOS Item of a Reference Document LFPOS NUMC 4 0
TXZ01 Short Text TXZ01 CHAR 40 0
GJAHR Fiscal Year GJAHR NUMC 4 0
OINEGPSTG Negative posting line (exchange fees) OIA_NGPSTL CHAR 1 0
X Yes
NULL No
WRBTR Amount in document currency WRBTR CURR 13 2
KNUMV Number of the document condition KNUMV CHAR 10 0
OIA_ZTERM Terms of Payment Key DZTERM CHAR 4 0
OIA_SPLTIV Indicator for split invoice verification OIA_SPLTIV CHAR 1 0
NULL No split invoice verification
X Split invoice verification
OIINVCYC Invoice cycle OIA_INVCYC NUMC 1 0
MWSKZ Tax on sales/purchases code MWSKZ CHAR 2 0
KBETR Rate (condition amount or percentage) KBETR CURR 11 2
KRECH Calculation type for condition KRECH CHAR 1 0
A Percentage
B Fixed amount
C Quantity
D Gross weight
E Net weight
F Volume
G Formula
H Percentage included
I Percentage (travel expenses)
K Per mille
J Per mille
L Points
M Quantity - monthy price
N Quantity - yearly price
O Quantity - daily price
P Quantity - weekly price
Q Commodity Price
R Distance-dependent
S Number of shipping units
T Multi-dimensional
U Percentage FIN (CRM Only)
KPEIN Condition pricing unit KPEIN DEC 5 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
OICONDWAERS Currency Key WAERS CUKY 5 0
LFGJA Fiscal Year of Current Period LFGJA NUMC 4 0

EK08BN foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
EK08BN ETYPE GJV_OBJDAT BUKRS T8JG Valid Investment Group BUKRS
EK08BN ETYPE EK08BN VNAME T8JG Valid Investment Group VNAME
EK08BN ETYPE EK08BN ETYPE T8JG Valid Investment Group ETYPE
EK08BN ETYPE * T8JG Valid Investment Group FDATE
EK08BN ETYPE SYST MANDT T8JG Valid Investment Group MANDT
EK08BN ZZREGION SYST MANDT ZREG User Defined Regions MANDT
EK08BN ZZREGION EK08BN ZZREGION ZREG User Defined Regions ZZREGION
EK08BN ZZSPREG SYST MANDT ZZSPREG Check table for ZZSPREG = Special Region MANDT
EK08BN ZZSPREG EK08BN ZZSPREG ZZSPREG Check table for ZZSPREG = Special Region ZZSPREG
EK08BN ZZSTATE SYST MANDT T005S Taxes: Region (Province) Key MANDT
EK08BN ZZSTATE * T005S Taxes: Region (Province) Key LAND1
EK08BN ZZSTATE EK08BN ZZSTATE T005S Taxes: Region (Province) Key BLAND
EK08BN ZZUSERFLD1 SYST MANDT ZFU1 Check Table for User Field 1 MANDT
EK08BN ZZUSERFLD1 EK08BN ZZUSERFLD1 ZFU1 Check Table for User Field 1 ZZUSERFLD1