1. Home
  2. Resources
  3. SAP Tables
  4. EK08RB - Purchase Order History for Invoice Verification

SAP Table EK08RB

Purchase Order History for Invoice Verification

EK08RB (Purchase Order History for Invoice Verification) 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 EK08RB to other SAP tables.

EK08RB 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
ANZAL Total Down Payments in Local Currency ANZAL CURR 13 2
BPBSM Ordered quantity in order price unit BPBSM QUAN 13 3
BPWES Quantity in GR blocked stock in order price unit BPWES QUAN 13 3
EINDT Item Delivery Date EINDT DATS 8 0
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
FPLNR Invoicing plan number IPLNR CHAR 10 0
INCO1 Incoterms (Part 1) INCO1 TINC CHAR 3 0
INCO2 Incoterms (Part 2) INCO2 CHAR 28 0
LFBNR Document No. of a Reference Document LFBNR CHAR 10 0
LFGJA Fiscal Year of Current Period LFGJA NUMC 4 0
LFPOS Item of a Reference Document LFPOS NUMC 4 0
MWSKZ Tax on sales/purchases code MWSKZ T007A CHAR 2 0
NETPR Net price NETPR CURR 11 2
PEINH Price Unit PEINH DEC 5 0
SCHPR Indicator: Estimated Price SCHPR CHAR 1 0
X Yes
NULL No
SSQSS QA Control Key SSQSS CHAR 8 0
STATU RFQ status ASTAT CHAR 1 0
NULL No Quotation Exists/Not Created via Sales
A Quotation Exists in Case of RFQ Item
F Created via Production Order
V Created via Sales document
W Created via Allocation Table
TXZ01 Short Text TXZ01 CHAR 40 0
VETEN Delivery Schedule Line Number ETENR NUMC 4 0
WEBRE Indicator: GR-Based Invoice Verification WEBRE CHAR 1 0
X Yes
NULL No
WESBS Goods Receipt Blocked Stock in Order Unit WESBS QUAN 13 3
XERSY Evaluated Receipt Settlement (ERS) XERSY CHAR 1 0
X Yes
NULL No
XSKRL Indicator: Line item not liable to cash discount? XSKRL CHAR 1 0
X Yes
NULL No
XUBNKR Indicates: Not relevant for unplanned delivery costs? XUBNKR CHAR 1 0
X Yes
NULL No
KORNR Correction of miscellaneous provisions KORNR CHAR 1 0
NULL No corrections of miscellaneous provisions
1 Correction of misc. provisions in invoice verification
EBONF Item Not Relevant to Subseq. (Period-End Rebate) Settlement EBONF CHAR 1 0
X Yes
NULL No
FKNUM Shipment Cost Number FKNUM CHAR 10 0
FKPOS Shipment costs item FKPOS NUMC 6 0
FKPTY Item category shipment costs FKPTY CHAR 4 0
EXTI1 External identification 1 EXTI1 CHAR 20 0
EXLIN Item Number Length EXLIN CHAR 40 0
EXSNR External Sorting EXSNR NUMC 5 0
EHTYP External Hierarchy Category EHTYP TMSRM_EHTYP CHAR 4 0
RETSUM_FC Total of Retention Amounts in Document Currency RET_SUM_FC CURR 13 2
RETSUM_LC Total of Retention Amounts in Company Code Currency RET_SUM_LC CURR 13 2
RETSUMP_FC Total Retention Amount Posted To Date in Document Currency RET_SUM_POST_FC CURR 13 2
RETSUMP_LC Total Retention Amount Posted in Company Code Currency RET_SUM_POST_LC CURR 13 2
RETPC Retention in Percent RETPZ DEC 5 2
RETTP Retention Indicator RETTP CHAR 1 0
NULL Not Applicable
H Applicable (Header Level)
I Applicable (Item Level)
B Secured by Bond
TRMRISK_RELEVANT Risk Relevancy in Purchasing PUR_TRM_RISK_RELEVANCY CHAR 2 0
NULL Not specified
C Relevant for Commodity TRM Integration
/BEV1/NEGEN_ITEM Indicator: Item Is Generated /BEV1/NEGEN_ITEM_FLAG CHAR 1 0
X Yes
NULL No
/BEV1/NESTRUCCAT Structure Category for Material Relationship /BEV1/NESTRUC_CAT CHAR 1 0
NULL No structure
F Full Product
S Structured Empties
MBLNR Number of Material Document MBLNR CHAR 10 0
MJAHR Material Document Year MJAHR NUMC 4 0
MBLPO Item in Material Document MBLPO NUMC 4 0
KNUMVK Number of the document condition KNUMV CHAR 10 0
KNUMV Number of the document condition KNUMV CHAR 10 0
KNUMVR Number of the document condition KNUMV CHAR 10 0
SATNR Cross-Plant Configurable Material SATNR MARA CHAR 18 0
EAN11 International Article Number (EAN/UPC) EAN11 CHAR 18 0
IDNLF Material Number Used by Vendor IDNLF CHAR 35 0
AKTNR Promotion WAKTION WAKH CHAR 10 0
UPVOR Subitems Exist UPVOR CHAR 1 0
UPTYP Subitem Category, Purchasing Document UPTYP TMSI1 CHAR 1 0
UEBPO Higher-Level Item in Purchasing Documents UEBPO EKPO NUMC 5 0
SRVPOS Service number SRVPOS CHAR 18 0
PACKNO Package Number of Service PACKNO_EKBE NUMC 10 0
INTROW Line Number of Service INTROW_EKBE NUMC 10 0
LEBRE Indicator for Service-Based Invoice Verification LEBRE CHAR 1 0
X Yes
NULL No
BEKKN Number of PO Account Assignment BEKKN NUMC 2 0
PLN_PACKNO Source package number PLN_PACKNO NUMC 10 0
PLN_INTROW Entry: Planned package line PLN_INTROW NUMC 10 0

EK08RB foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
EK08RB AKTNR WAKH MANDT WAKH Promotion Header Data, IS-R MANDT
EK08RB AKTNR EK08RB AKTNR WAKH Promotion Header Data, IS-R AKTNR
EK08RB EHTYP SYST MANDT TMSRM_EHTYP SRM Hierarchy Types MANDT
EK08RB EHTYP EK08RB EHTYP TMSRM_EHTYP SRM Hierarchy Types EHTYP
EK08RB ETYPE EK08RB ETYPE T8JG Valid Investment Group ETYPE
EK08RB ETYPE * T8JG Valid Investment Group FDATE
EK08RB ETYPE SYST MANDT T8JG Valid Investment Group MANDT
EK08RB ETYPE GJV_OBJDAT BUKRS T8JG Valid Investment Group BUKRS
EK08RB ETYPE EK08RB VNAME T8JG Valid Investment Group VNAME
EK08RB INCO1 SY MANDT TINC Customers: Incoterms MANDT
EK08RB INCO1 EK08RB INCO1 TINC Customers: Incoterms INCO1
EK08RB MWSKZ T007A MANDT T007A Tax Keys MANDT
EK08RB MWSKZ T007A KALSM T007A Tax Keys KALSM
EK08RB MWSKZ EK08RB MWSKZ T007A Tax Keys MWSKZ
EK08RB SATNR MARA MANDT MARA General Material Data MANDT
EK08RB SATNR EK08RB SATNR MARA General Material Data MATNR
EK08RB UEBPO EKPO MANDT EKPO Purchasing Document Item MANDT
EK08RB UEBPO EKPO EBELN EKPO Purchasing Document Item EBELN
EK08RB UEBPO EK08RB UEBPO EKPO Purchasing Document Item EBELP
EK08RB UPTYP EK08RB UPTYP TMSI1 Sub-Item Category in Purchasing UPTYP
EK08RB UPTYP TMSI1 MANDT TMSI1 Sub-Item Category in Purchasing MANDT
EK08RB ZZREGION SYST MANDT ZREG User Defined Regions MANDT
EK08RB ZZREGION EK08RB ZZREGION ZREG User Defined Regions ZZREGION
EK08RB ZZSPREG SYST MANDT ZZSPREG Check table for ZZSPREG = Special Region MANDT
EK08RB ZZSPREG EK08RB ZZSPREG ZZSPREG Check table for ZZSPREG = Special Region ZZSPREG
EK08RB ZZSTATE SYST MANDT T005S Taxes: Region (Province) Key MANDT
EK08RB ZZSTATE * T005S Taxes: Region (Province) Key LAND1
EK08RB ZZSTATE EK08RB ZZSTATE T005S Taxes: Region (Province) Key BLAND
EK08RB ZZUSERFLD1 SYST MANDT ZFU1 Check Table for User Field 1 MANDT
EK08RB ZZUSERFLD1 EK08RB ZZUSERFLD1 ZFU1 Check Table for User Field 1 ZZUSERFLD1