1. Home
  2. Resources
  3. SAP Tables
  4. WB2_IV_DATA - Data From Incoming Invoices

SAP Table WB2_IV_DATA

Data From Incoming Invoices

WB2_IV_DATA (Data From Incoming Invoices) 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 WB2_IV_DATA to other SAP tables.

WB2_IV_DATA table fields

Field Data element Checktable Datatype Length Decimals
DOC_KEY Document Key WB2_DOC_KEY CHAR 42 0
ITEM_KEY Item Key WB2_ITEM_KEY CHAR 16 0
BELNR Accounting Document Number BELNR_D CHAR 10 0
GJAHR Fiscal Year GJAHR NUMC 4 0
BUZEI Document Item in Invoice Document RBLGP NUMC 6 0
RBKP WB2_RBKP STRU 0 0
MANDT Client MANDT CLNT 3 0
BELNR Document Number of an Invoice Document RE_BELNR CHAR 10 0
GJAHR Fiscal Year GJAHR NUMC 4 0
BLART Document Type BLART CHAR 2 0
BLDAT Document Date in Document BLDAT DATS 8 0
BUDAT Posting Date in the Document BUDAT DATS 8 0
USNAM User name USNAM CHAR 12 0
TCODE Transaction Code TCODE CHAR 20 0
CPUDT Day On Which Accounting Document Was Entered CPUDT DATS 8 0
CPUTM Time of Entry CPUTM TIMS 6 0
VGART Transaction Type in AG08 (Internal Document Type) M8VGA CHAR 2 0
RP Invoice receipt
KP Account maintenance
KS Account maintenance reversal
PR Price change
BL Material debit
PF Std cost estim. release
RD Logistics invoice
ML Material ledger settlement
MI Material ledger initialization
RS Logistics invoice, cancel
XBLNR Reference Document Number XBLNR1 CHAR 16 0
BUKRS Company Code BUKRS CHAR 4 0
LIFNR Different Invoicing Party LIFRE CHAR 10 0
WAERS Currency Key WAERS CUKY 5 0
KURSF Exchange rate KURSF DEC 9 5
RMWWR Gross invoice amount in document currency RMWWR CURR 13 2
BEZNK Unplanned delivery costs BEZNK CURR 13 2
WMWST1 Tax Amount in Document Currency with +/- Sign FWSTEV CURR 13 2
MWSKZ1 Tax code MWSKZ_MRM1 CHAR 2 0
WMWST2 Obsolete: tax amount in document currency - do NOT use! FWSTEV_OLD CURR 13 2
MWSKZ2 Obsolete: sales tax code MWSKZ_MRMO CHAR 2 0
ZTERM Terms of Payment Key DZTERM CHAR 4 0
ZBD1T Cash discount days 1 DZBD1T DEC 3 0
ZBD1P Cash Discount Percentage 1 DZBD1P DEC 5 3
ZBD2T Cash discount days 2 DZBD2T DEC 3 0
ZBD2P Cash Discount Percentage 2 DZBD2P DEC 5 3
ZBD3T Net Payment Terms Period DZBD3T DEC 3 0
WSKTO Cash discount amount in document currency WSKTO CURR 13 2
XRECH Indicator: post invoice XRECH CHAR 1 0
X Yes
NULL No
. No
BKTXT Document Header Text BKTXT CHAR 25 0
SAPRL SAP Release SAPRL CHAR 4 0
LOGSYS Logical system LOGSYS CHAR 10 0
XMWST Calculate tax automatically XMWST CHAR 1 0
X Yes
NULL No
STBLG Reversal document number RE_STBLG CHAR 10 0
STJAH Fiscal year of reversal document RE_STJAH NUMC 4 0
MWSKZ_BNK Tax Code MWSKZ_MRM CHAR 2 0
TXJCD_BNK Tax Jurisdiction TXJCD CHAR 15 0
IVTYP Origin of a Logistics Invoice Verification Document IVTYP CHAR 1 0
NULL Online
1 ERS
2 ERS Zero Document
3 Batch Run
4 EDI
5 Cancellation
6 Invoicing Plan
7 Transfer Prices
8 Revaluation
9 WEB Invoice
B BAPI Invoice
A Invoice from Parking Function
C Account Maintenance
D SRM Invoice
E BAPI Account Maintenance
G SOA A2A
H SOA B2B
I Ariba Invoice
XRBTX Indicator: more than one tax code XRBTX CHAR 1 0
X Yes
NULL No
REPART Indicator: Invoice Verification Type REPART CHAR 1 0
NULL Online verification
1 Time point 1 - background verification
2 Time point 2 - background verification
3 No verification
RBSTAT Invoice document status RBSTAT CHAR 1 0
1 Defined for background verification
2 Deleted
3 With Errors
4 Correct (posted, not completed)
5 Posted
A Parked
B Parked and completed
C Parked and held
D Entered and held
E Parked and released
KNUMVE Document condition - own conditions KNUMVE CHAR 10 0
KNUMVL Document condition - vendor error KNUMVL CHAR 10 0
ARKUEN Automatic Invoice Reduction Amount (Net) ARKUEN CURR 13 2
ARKUEMW Sales Tax Portion of Automatic Invoice Reduction Amount ARKUEMW CURR 13 2
MAKZN Manually accepted net difference amount MAKZN CURR 13 2
MAKZMW Tax Amount Accepted Manually MAKZMW CURR 13 2
LIEFFN Vendor error (exclusive of tax) LIEFFN CURR 13 2
LIEFFMW Tax in vendor error LIEFFMW CURR 13 2
XAUTAKZ Indicates automatically accepted invoices XAUTAKZ CHAR 1 0
X Yes
NULL No
ESRNR ISR Subscriber Number ESRNR CHAR 11 0
ESRPZ ISR Check Digit ESRPZ CHAR 2 0
ESRRE ISR Reference Number ESRRE CHAR 27 0
QSSHB Withholding Tax Base Amount QSSHB CURR 13 2
QSFBT Withholding Tax-Exempt Amount (in Document Currency) QSFBT CURR 13 2
QSSKZ Withholding Tax Code QSSKZ CHAR 2 0
DIEKZ Service Indicator (Foreign Payment) DIEKZ CHAR 1 0
LANDL Supplying Country LANDL CHAR 3 0
LZBKZ State Central Bank Indicator LZBKZ CHAR 3 0
TXKRS Exchange Rate for Taxes TXKRS_BKPF DEC 9 5
EMPFB Payee/Payer EMPFB CHAR 10 0
BVTYP Partner Bank Type BVTYP CHAR 4 0
HBKID Short Key for a House Bank HBKID CHAR 5 0
ZUONR Assignment Number DZUONR CHAR 18 0
ZLSPR Payment Block Key DZLSPR CHAR 1 0
ZLSCH Payment Method DZLSCH CHAR 1 0
ZFBDT Baseline Date for Due Date Calculation DZFBDT DATS 8 0
KIDNO Payment Reference KIDNO CHAR 30 0
REBZG Invoice Reference: Document Number for Invoice Reference AWREF_REB CHAR 10 0
REBZJ Fiscal Year of the Relevant Invoice (for Credit Memo) REBZJ NUMC 4 0
XINVE Indicator: Capital Goods Affected? XINVE CHAR 1 0
X Yes
NULL No
EGMLD Reporting Country for Delivery of Goods within the EU EGMLD_BSEZ CHAR 3 0
XEGDR Indicator: Triangular deal within the EU ? XEGDR CHAR 1 0
X Yes
NULL No
VATDATE Tax Reporting Date VATDATE DATS 8 0
HKONT General Ledger Account HKONT CHAR 10 0
J_1BNFTYPE Nota Fiscal Type J_1BNFTYPE CHAR 2 0
BRNCH Branch Number J_1ABRNCH CHAR 4 0
ERFPR Entry profile: Logistics Invoice Verification ERFPR CHAR 12 0
SECCO Section Code SECCO CHAR 4 0
NAME1 Name 1 NAME1_GP CHAR 35 0
NAME2 Name 2 NAME2_GP CHAR 35 0
NAME3 Name 3 NAME3_GP CHAR 35 0
NAME4 Name 4 NAME4_GP CHAR 35 0
PSTLZ Postal Code PSTLZ CHAR 10 0
ORT01 City ORT01_GP CHAR 35 0
LAND1 Country Key LAND1_GP CHAR 3 0
STRAS House number and street STRAS_GP CHAR 35 0
PFACH PO Box PFACH CHAR 10 0
PSTL2 P.O. Box Postal Code PSTL2 CHAR 10 0
PSKTO Account Number of Bank Account At Post Office PSKTO CHAR 16 0
BANKN Bank account number BANKN CHAR 18 0
BANKL Bank number BANKL CHAR 15 0
BANKS Bank country key BANKS CHAR 3 0
STCD1 Tax Number 1 STCD1 CHAR 16 0
STCD2 Tax Number 2 STCD2 CHAR 11 0
STKZU Liable for VAT STKZU CHAR 1 0
X Yes
NULL No
STKZA Indicator: Business Partner Subject to Equalization Tax? STKZA CHAR 1 0
NULL Not subject to equalization tax
X Subject to equalization tax
REGIO Region (State, Province, County) REGIO CHAR 3 0
BKONT Bank Control Key BKONT CHAR 2 0
DTAWS Instruction key for data medium exchange DTAWS CHAR 2 0
DTAMS Indicator for Data Medium Exchange DTAMS CHAR 1 0
1 Single data record not to be forwarded to the Bundesbank
0 Single data record can be forwarded to the Bundesbank
NULL Use house bank default value
SPRAS Character field of length 1 CHAR_LG_01 CHAR 1 0
XCPDK Indicator: Is the account a one-time account? XCPDK CHAR 1 0
X Yes
NULL No
EMPFG Payee code EMPFG CHAR 16 0
FITYP Tax type J_1AFITP_D CHAR 2 0
STCDT Tax Number Type J_1ATOID CHAR 2 0
STKZN Natural Person STKZN CHAR 1 0
X Natural person
NULL Legal person
STCD3 Tax Number 3 STCD3 CHAR 18 0
STCD4 Tax Number 4 STCD4 CHAR 18 0
BKREF Reference specifications for bank details BKREF CHAR 20 0
J_1KFREPRE Name of Representative REPRES CHAR 10 0
J_1KFTBUS Type of Business GESTYP CHAR 30 0
J_1KFTIND Type of Industry INDTYP CHAR 30 0
ANRED Title ANRED CHAR 15 0
STCEG VAT Registration Number STCEG CHAR 20 0
ERNAME Entered by external system user ERNAME CHAR 12 0
REINDAT Invoice Receipt Date REINDAT DATS 8 0
UZAWE Payment Method Supplement UZAWE CHAR 2 0
FDLEV Planning level FDLEV CHAR 2 0
FDTAG Planning date FDTAG DATS 8 0
ZBFIX Fixed Payment Terms DZBFIX CHAR 1 0
NULL No fixing
1 1st cash disc.percentage rate or cash disc.amount is fixed
2 2nd cash discount percentage rate is fixed
FRGKZ Indicator: Release Required DFRGKZ CHAR 1 0
X Yes
NULL No
ERFNAM Name of the Processor Who Entered the Object ERFNAM CHAR 12 0
BUPLA Business Place BUPLA CHAR 4 0
FILKD Account Number of the Branch FILKD CHAR 10 0
GSBER Business Area GSBER CHAR 4 0
LOTKZ Lot Number for Documents LOTKZ CHAR 10 0
SGTXT Item Text SGTXT CHAR 50 0
INV_TRAN Transaction in Logistics Invoice Verification INV_TRAN CHAR 1 0
1 Invoice
2 Credit Memo
3 Subsequent Debit
4 Subsequent Credit
5 Provisional Invoice
6 Differential Invoice
7 Final Invoice
8 Provisional Invoice/Differential Invoice
PREPAY_STATUS Prepayment Status WRF_PREPAY_STATUS CHAR 1 0
NULL Invoice Not Relevant for Prepayment
A Relevant, Invoice Not Saved Yet
B Relevant; No Prepayment Document due to Error
C Relevant; Prepayment Document under Conditions
D Prepayment Document Was Posted
PREPAY_AWKEY Invoice Document Number Created for Prepayment WRF_PREPAY_AWKEY CHAR 20 0
ASSIGN_STATUS Is the invoice in the assignment test process? WRF_MRM_ASSIGN_STATUS CHAR 1 0
NULL Undefined
A Goods Receipt for Settlement Found
B Within Assignment Test
C End of Assignment Test Period Reached
D Error Occurred
E Error Within the BAdI Implementation
F Processed Manually Before End of Assignment Test
N Never in Assignment Test
ASSIGN_NEXT_DATE Date of Next Assignment Test WRF_MRM_ASSIGN_NEXT_DATE DATS 8 0
ASSIGN_END_DATE End Date of Assignment Test Period WRF_MRM_ASSIGN_END_DATE DATS 8 0
COPY_BY_BELNR Invoice Document Number of Original Invoice COPY_BY_BELNR CHAR 10 0
COPY_BY_YEAR Fiscal Year of Original Invoice COPY_BY_YEAR NUMC 4 0
COPY_TO_BELNR Invoice Document Number of Copied Invoice COPY_TO_BELNR CHAR 10 0
COPY_TO_YEAR Fiscal Year of Copied Invoice COPY_TO_YEAR NUMC 4 0
COPY_USER User That Reversed and Copied the Invoice COPY_USER CHAR 12 0
KURSX Market Data Exchange Rate GLE_FXR_DTE_RATEX28 DEC 28 14
WWERT Translation Date WWERT_D DATS 8 0
XREF3 Reference key for line item XREF3 CHAR 20 0
FILTERED_OUT_GT Filtered Out WB2_FILTERED_OUT CHAR 1 0
EXTERNAL_NO_GT Trading Contract: External Document Number TKONN_EX CHAR 30 0
SCENARIO_GT Business Scenario WB2_BUSINESS_SCENARIO CHAR 2 0
RSEG WB2_RSEG STRU 0 0
MANDT Client MANDT CLNT 3 0
BELNR Accounting Document Number BELNR_D CHAR 10 0
GJAHR Fiscal Year GJAHR NUMC 4 0
BUZEI Document Item in Invoice Document RBLGP NUMC 6 0
EBELN Purchasing Document Number EBELN CHAR 10 0
EBELP Item Number of Purchasing Document EBELP NUMC 5 0
ZEKKN Sequential Number of Account Assignment DZEKKN NUMC 2 0
MATNR Material Number MATNR CHAR 18 0
BWKEY Valuation Area BWKEY CHAR 4 0
BWTAR Valuation Type BWTAR_D CHAR 10 0
BUKRS Company Code BUKRS CHAR 4 0
WERKS Plant WERKS_D CHAR 4 0
WRBTR Amount in document currency WRBTR CURR 13 2
SHKZG Debit/Credit Indicator SHKZG CHAR 1 0
H Credit
S Debit
MWSKZ Tax on sales/purchases code MWSKZ CHAR 2 0
TXJCD Tax Jurisdiction TXJCD CHAR 15 0
MENGE Quantity MENGE_D QUAN 13 3
BSTME Purchase Order Unit of Measure BSTME UNIT 3 0
BPMNG Quantity in Purchase Order Price Unit BPMNG QUAN 13 3
BPRME Order Price Unit (Purchasing) BPRME UNIT 3 0
LBKUM Total Valuated Stock LBKUM QUAN 13 3
VRKUM Total valuated stock in the previous posting period VRKUM QUAN 13 3
MEINS Base Unit of Measure MEINS UNIT 3 0
PSTYP Item Category in Purchasing Document PSTYP CHAR 1 0
KNTTP Account Assignment Category KNTTP CHAR 1 0
BKLAS Valuation Class BKLAS CHAR 4 0
EREKZ Final Invoice Indicator EREKZ CHAR 1 0
X Yes
NULL No
EXKBE Indicator: update purchase order history XEKBE CHAR 1 0
X Yes
NULL No
XEKBZ Indicator: Update Purchase Order Delivery Costs XEKBZ CHAR 1 0
X Yes
NULL No
TBTKZ Indicator: subsequent debit/credit TBTKZ CHAR 1 0
SPGRP Blocking reason: price SPGRP CHAR 1 0
X Yes
NULL No
SPGRM Blocking reason: quantity SPGRM CHAR 1 0
X Yes
NULL No
SPGRT Blocking Reason: Date SPGRT CHAR 1 0
X Yes
NULL No
SPGRG Blocking reason: order price quantity SPGRG CHAR 1 0
X Yes
NULL No
SPGRV Blocking reason: project budget SPGRV CHAR 1 0
X Yes
NULL No
SPGRQ Manual Blocking Reason SPGRQ CHAR 1 0
X Yes
NULL No
SPGRS Blocking Reason: Item Amount SPGRS CHAR 1 0
X Yes
NULL No
SPGRC Block.reason: quality SPGRC CHAR 1 0
X Yes
NULL No
SPGREXT Blocking Reason Enhancement Fields SPGREXT CHAR 1 0
X Yes
NULL No
BUSTW Posting string for values BUSTW CHAR 4 0
XBLNR Reference Document Number XBLNR1 CHAR 16 0
XRUEB Indicator: Document is posted to a previous period XRUEB CHAR 1 0
X Yes
NULL No
BNKAN Delivery costs' share of item value BNK_ANTEIL CURR 13 2
KSCHL Condition Type KSCHL CHAR 4 0
SALK3 Value of Total Valuated Stock SALK3 CURR 13 2
VMSAL Value of total valuated stock in previous period VMSAL CURR 13 2
XLIFO LIFO/FIFO-Relevant XLIFO CHAR 1 0
X LIFO and FIFO Relevant
NULL Not LIFO/FIFO Relevant
1 LIFO-relevant
2 FIFO-relevant
3 LIFO- and FIFO-relevant (obsolete)
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
MATBF Material in Respect of Which Stock is Managed MATBF CHAR 18 0
RBMNG Qty invoiced in vendor invoice in PO order units RBMNG QUAN 13 3
BPRBM Qty invoiced in vendor invoice in PO price units BPRBM QUAN 13 3
RBWWR Invoice amount in document currency of vendor invoice RBWWR CURR 13 2
LFEHL Type of vendor error LFEHL CHAR 1 0
NULL No vendor error
1 Price error
2 Conditions error
3 Quantity error
4 Quantity error + price error
5 Quantity error + condition error
GRICD Activity Code for Gross Income Tax J_1AGICD_D CHAR 2 0
GRIRG Region (State, Province, County) REGIO CHAR 3 0
GITYP Distribution Type for Employment Tax J_1ADTYP_D CHAR 2 0
PACKNO Package Number of Service PACKNO_EKBE NUMC 10 0
INTROW Line Number of Service INTROW_EKBE NUMC 10 0
SGTXT Item Text SGTXT CHAR 50 0
XSKRL Indicator: Line item not liable to cash discount? XSKRL CHAR 1 0
X Yes
NULL No
KZMEK Correction indicator KZMEKORR CHAR 1 0
NULL No error
1 Unclarified error: park invoice
2 Vendor error: reduce invoice
MRMOK Indicator: invoice item processed MRMOK CHAR 1 0
X Yes
NULL No
STUNR Step number STUNR NUMC 3 0
ZAEHK Condition counter DZAEHK NUMC 2 0
STOCK_POSTING Stock Posting of Line from an Incoming Invoice STOCK_POSTING CURR 13 2
STOCK_POSTING_PP Stock Posting of Line from an Incoming Invoice, Prev. Period STOCK_POSTING_PP CURR 13 2
STOCK_POSTING_PY Stock Posting of Line from an Incoming Invoice, Prev. Year STOCK_POSTING_PY CURR 13 2
WEREC Clearing Indicator for GR/IR Posting for External Services MMWEREC CHAR 1 0
X Yes
NULL No
LIFNR Account Number of Vendor or Creditor LIFNR CHAR 10 0
FRBNR Number of Bill of Lading at Time of Goods Receipt FRBNR1 CHAR 16 0
XHISTMA Update Multiple Account Assignment EKBE_MA, EKBZ_MA XHISTMA CHAR 1 0
COMPLAINT_REASON Complaints Reason in an Invoice COMPLAINT_REASON CHAR 2 0
RETAMT_FC Retention Amount in Document Currency RET_AMT_FC CURR 13 2
RETPC Retention in Percent RETPZ DEC 5 2
RETDUEDT Due Date for Retention RET_DUE_DATE DATS 8 0
XRETTAXNET Tax Reduction for Retention RET_TAXNET CHAR 1 0
X Yes
NULL No
RE_ACCOUNT Cash Ledger: Expense or Revenue Account FAGL_RE_ACCOUNT CHAR 10 0
ERP_CONTRACT_ID Number of Principal Purchase Agreement KONNR CHAR 10 0
ERP_CONTRACT_ITM Item Number of Principal Purchase Agreement KTPNR NUMC 5 0
SRM_CONTRACT_ID Central Contract SRM_CONTRACT_ID CHAR 10 0
SRM_CONTRACT_ITM Central Contract Item Number SRM_CONTRACT_ITEM NUMC 10 0
CONT_PSTYP Item Category in Purchasing Document PSTYP CHAR 1 0
SRVMAPKEY Item Key for eSOA Messages SRVMAPKEY NUMC 10 0
CHARG Batch Number CHARG_D CHAR 10 0
INV_ITM_ORIGIN Origin of an Invoice Item INV_ITM_ORIGIN CHAR 1 0
NULL Inv.Ver.: Item Newly Created
A Diff.Inv.: Item Newly Created
B Diff.Inv.: Item Copied from Preceding Invoice
INVREL Grouping Characteristic for Invoice Verification INVREL NUMC 6 0
XDINV Indicator for Differential Invoicing XDINV CHAR 1 0
DIFF_AMOUNT Difference Amount (in Document Currency) DIFFERENCE_AMOUNT CURR 13 2
XCPRF Checkbox for Commodity Repricing in Invoice Verification XCPRF CHAR 1 0
LICNO Internal License Number J_1ILICNO NUMC 10 0
ZEILE Item Number J_1IZEILE NUMC 4 0
SCENARIO_GT Business Scenario WB2_BUSINESS_SCENARIO CHAR 2 0
FILTERED_OUT_GT Filtered Out WB2_FILTERED_OUT CHAR 1 0
NOT_REF_QUAN_GT Open Quantity WB2_NOT_REF_QUAN QUAN 15 3
NOT_REF_QUAN_UNIT_GT Open Quantity Unit WB2_NOT_REF_QUAN_UNIT UNIT 3 0
EXTERNAL_NO_GT Trading Contract: External Document Number TKONN_EX CHAR 30 0
RBKP_WAERS_GT Currency Key WAERS CUKY 5 0
T001_WAERS_GT Currency Key WAERS CUKY 5 0
MARA_MEINS_GT Base Unit of Measure MEINS UNIT 3 0
ASSOC_QUAN_B Assoc. Mngt: Actually Associated Quantity of an Item WB2_ASSOCIATED_QUAN QUAN 15 3
UNIT_OF_QUAN_B Base Unit of Measure MEINS UNIT 3 0
ASSOC_QUAN_S Assoc. Mngt: Actually Associated Quantity of an Item WB2_ASSOCIATED_QUAN QUAN 15 3
UNIT_OF_QUAN_S Base Unit of Measure MEINS UNIT 3 0
ASSOC_QUAN_P Assoc. Mngt: Actually Associated Quantity of an Item WB2_ASSOCIATED_QUAN QUAN 15 3
UNIT_OF_QUAN_P Base Unit of Measure MEINS UNIT 3 0
PORTFOLIO Global Trade: (Internal) Portfolio Number WB2_PORTFOLIO CHAR 10 0