SAP table IRBKPF (Logistics Invoice Verification, Invoice Documents)

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
BELNR Document Number of an Invoice Document CHAR 10 0 RE_BELNR
GJAHR Fiscal Year NUMC 4 0 GJAHR
BLART Document Type CHAR 2 0 T003 BLART
BLDAT Document Date in Document DATS 8 0 BLDAT
BUDAT Posting Date in the Document DATS 8 0 BUDAT
USNAM User Name CHAR 12 0 USNAM
TCODE Transaction Code CHAR 20 0 TSTC TCODE
CPUDT Day On Which Accounting Document Was Entered DATS 8 0 CPUDT
CPUTM Time of Entry TIMS 6 0 CPUTM
VGART Transaction Type in AG08 (Internal Document Type) CHAR 2 0 M8VGA
BL Material debit
KP Account maintenance
KS Account maintenance reversal
MI Material ledger initialization
ML Material ledger settlement
PF Std cost estim. release
PR Price change
RD Logistics invoice
RP Invoice receipt
RS Logistics invoice, cancel
XBLNR Reference Document Number CHAR 16 0 XBLNR1
BUKRS Company Code CHAR 4 0 T001 BUKRS
LIFNR Vendor's account number CHAR 10 0 ELIFN
WAERS Currency Key CUKY 5 0 TCURC WAERS
KURSF Exchange rate DEC 9 5 KURSF
RMWWR Gross Invoice Amount in Document Currency CURR 13 2 RMWWR
BEZNK Unplanned Delivery Costs CURR 13 2 BEZNK
WMWST1 Tax Amount in Document Currency with +/- Sign CURR 13 2 FWSTEV
MWSKZ1 Tax Code CHAR 2 0 T007A MWSKZ_MRM
WMWST2 Tax Amount in Document Currency with +/- Sign CURR 13 2 FWSTEV
MWSKZ2 Tax Code CHAR 2 0 T007A MWSKZ_MRM
ZTERM Terms of payment key CHAR 4 0 DZTERM
ZBD1T Cash discount days 1 DEC 3 0 DZBD1T
ZBD1P Cash discount percentage 1 DEC 5 3 DZBD1P
ZBD2T Cash discount days 2 DEC 3 0 DZBD2T
ZBD2P Cash Discount Percentage 2 DEC 5 3 DZBD2P
ZBD3T Net Payment Terms Period DEC 3 0 DZBD3T
WSKTO Cash Discount Amount in Document Currency CURR 13 2 WSKTO_CS
XRECH Indicator: post invoice CHAR 1 0 XRECHC
BKTXT Document Header Text CHAR 25 0 BKTXT
SAPRL SAP Release CHAR 4 0 SAPRL
LOGSYS Logical system CHAR 10 0 LOGSYS
XMWST Calculate Tax Automatically CHAR 1 0 XMWST
STBLG Reversal document number CHAR 10 0 RE_STBLG
STJAH Fiscal year of reversal document NUMC 4 0 RE_STJAH
SOLLB Gross target invoice amount in local currency CURR 13 2 SMWWR
SOLLN Net target invoice amount in document currency CURR 13 2 SNWWR
MAKZB Manually accepted gross invoice difference CURR 13 2 MAKZB_D
MAKZN Manually accepted net difference amount CURR 13 2 MAKZN
DIFFB Invoice Verification difference including tax CURR 13 2 REPDIF
DIFFN Document Balance CURR 13 2 RPDIFN
LIEFFMW Tax in Supplier Error CURR 13 2 LIEFFMW
LIEFFN Supplier Error (Exclusive of Tax) CURR 13 2 LIEFFN
SMWSKZ1 Tax Code CHAR 2 0 T007A MWSKZ_MRM
SMWST1 Tax Amount in Document Currency with +/- Sign CURR 13 2 FWSTEV
LIEFF1 Supplier Error (Inclusive Tax) CURR 13 2 LIEFF_MRM
MWLIEFF1 Obsolete: Tax in Supplier Error CURR 13 2 LMWST
MAKZMW1 Tax Amount Accepted Manually CURR 13 2 MAKZMW
MWDIFFB1 Invoice Verification difference including tax CURR 13 2 REPDIF
FWNAV1 Tax Amount in Document Currency with +/- Sign CURR 13 2 FWSTEV
MWBNK1 Tax Amount in Document Currency with +/- Sign CURR 13 2 FWSTEV
SMWSKZ2 Tax Code CHAR 2 0 T007A MWSKZ_MRM
SMWST2 Tax Amount in Document Currency with +/- Sign CURR 13 2 FWSTEV
LIEFF2 Supplier Error (Inclusive Tax) CURR 13 2 LIEFF_MRM
MWLIEFF2 Obsolete: Tax in Supplier Error CURR 13 2 LMWST
MAKZMW2 Tax Amount Accepted Manually CURR 13 2 MAKZMW
MWDIFFB2 Invoice Verification difference including tax CURR 13 2 REPDIF
FWNAV2 Tax Amount in Document Currency with +/- Sign CURR 13 2 FWSTEV
MWBNK2 Tax Amount in Document Currency with +/- Sign CURR 13 2 FWSTEV
ANZRPV No. of invoice verification attempts NUMC 3 0 ANZRPV
REPART Indicator: Invoice Verification Type CHAR 1 0 REPART
Online verification
1 Time point 1 - background verification
2 Time point 2 - background verification
3 No verification
RBSTAT Invoice document status CHAR 1 0 RBSTAT
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
REPDAT Invoice Verification date DATS 8 0 REPDAT
REPTIM Invoice Verification time TIMS 6 0 REPTIM
LFDATABLI Delivery date DATS 8 0 LFDAT
LFDATBISLI Delivery date DATS 8 0 LFDAT
LFDATABRT Delivery date of return DATS 8 0 LFDATRET
LFDATBISRT Delivery date of return DATS 8 0 LFDATRET
XZUORDLI Indicates delivery item allocation CHAR 1 0 XZUORDLI
XZUORDRT Indicates returns allocation CHAR 1 0 XZUORDRT
KZBNK Planned Delivery Costs Indicator CHAR 1 0 XBNK
TBTKZ Indicator: Subsequent Debit/Credit CHAR 1 0 TBTKZ
ESRNR ISR subscriber number CHAR 11 0 ESRNR
ESRPZ POR check digit CHAR 2 0 ESRPZ
ESRRE ISR/QR Reference Number CHAR 27 0 ESRRE
QSSHB Withholding Tax Base Amount CURR 13 2 QSSHB_CS
QSFBT Withholding Tax-Exempt Amount (in Document Currency) CURR 13 2 QSFBT_CS
QSSKZ Withholding Tax Code CHAR 2 0 T059Q QSSKZ
DIEKZ Service Indicator (Foreign Payment) CHAR 1 0 DIEKZ
LANDL Supplying Country/Region CHAR 3 0 T005 LANDL
LZBKZ State Central Bank Indicator CHAR 3 0 T015L LZBKZ
ANZRPO Number of selected invoice items NUMC 6 0 ANZRPO
ANZUNF Number of unsolved errors NUMC 6 0 ANZUNF
ZFBDT Baseline Date for Due Date Calculation DATS 8 0 DZFBDT
MONAT Fiscal period NUMC 2 0 MONAT
ZLSCH Payment Method CHAR 1 0 T042Z DZLSCH
XRKUE Invoice Automatically Reduced CHAR 1 0 XRKUE
RCHGART Obsolete: Invoice type for inv. verification: do NOT use CHAR 4 0 RCHGART
Goods invoice
1 Invoice for delivery costs
2 Goods invoice with delivery costs
XBEST Checkbox: Allocations CHAR 1 0 XZUORD
XFRBR Checkbox: Allocations CHAR 1 0 XZUORD
XLIFS Checkbox: Allocations CHAR 1 0 XZUORD
XWERK Checkbox: Allocations CHAR 1 0 XZUORD
TXKRS Exchange Rate for Taxes DEC 9 5 TXKRS_BKPF
XRKUER ID: Autom. inv. reduction allowed? CHAR 1 0 XRKUER
TAKZPB Absolute Positive Upper Acceptance Limit CURR 13 2 TAKZPB
TAKZPP Percentage Positive Upper Acceptance Limit DEC 4 2 TAKZPP
TAKZNB Negative Small Difference CURR 13 2 TAKZNB
TAKZNP Percentage Negative Lower Acceptance Limit DEC 4 2 TAKZNP
TRKPB Autom. invoice reduction: absolute upper limit CURR 13 2 TRKPB
TRKPP Autom. invoice reduction: percentage upper limit DEC 4 2 TRKPP
REPARTALT Indicator: Invoice Verification Type CHAR 1 0 REPART
Online verification
1 Time point 1 - background verification
2 Time point 2 - background verification
3 No verification
RBSTATALT Invoice document status CHAR 1 0 RBSTAT
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
ANZRPVALT No. of invoice verification attempts NUMC 3 0 ANZRPV
KZKORREKT Select CHAR 1 0 MARKE
XMANRK Indicator for manually reduced invoices CHAR 1 0 XMANRK
XUNFEH Indicator for unclarified errors CHAR 1 0 XUNFEH
XERL Indicates that Invoice Verification has been completed CHAR 1 0 KZERL
XERLALT Indicates that Invoice Verification has been completed CHAR 1 0 KZERL
LNAME1 Name 1 CHAR 35 0 NAME1_GP
SKTODAT Latest date when full cash discount still possible DATS 8 0 RM08_SKDAT
LKZRK Indicates invoice reduction CHAR 1 0 KZRK
RKLIMIT Limit for reducing an invoice in Invoice Verification CURR 13 2 RKLIMIT
PRPLIMIT Positive Invoice Verification tolerance limit CURR 13 2 PRPLIMIT
NRPLIMIT Negative Invoice Verification tolerance limit CURR 13 2 NRPLIMIT
MARKE Select CHAR 1 0 MARKE
XKPFCHG Select CHAR 1 0 MARKE

IRBKPF foreign key relationships

Table Field Check Table Check Field
0 IRBKPF BLART T003 Document Types MANDT
1 IRBKPF BUKRS T001 Company Codes BUKRS
0 IRBKPF LANDL T005 Countries MANDT
0 IRBKPF LANDL T005 Countries LAND1
1 IRBKPF LZBKZ T015L SCB Ratios LZBKZ
0 IRBKPF MANDT T000 Clients MANDT
1 IRBKPF MWSKZ1 T007A Tax Keys KALSM
1 IRBKPF MWSKZ1 T007A Tax Keys MWSKZ
0 IRBKPF MWSKZ2 T007A Tax Keys KALSM
0 IRBKPF MWSKZ2 T007A Tax Keys MWSKZ
1 IRBKPF QSSKZ T059Q Withholding Tax MANDT
1 IRBKPF QSSKZ T059Q Withholding Tax LAND1
1 IRBKPF QSSKZ T059Q Withholding Tax QSSKZ
0 IRBKPF SMWSKZ1 T007A Tax Keys KALSM
0 IRBKPF SMWSKZ1 T007A Tax Keys MWSKZ
1 IRBKPF SMWSKZ2 T007A Tax Keys KALSM
1 IRBKPF SMWSKZ2 T007A Tax Keys MWSKZ
0 IRBKPF TCODE TSTC SAP Transaction Codes TCODE
1 IRBKPF WAERS TCURC Currency Codes MANDT
1 IRBKPF WAERS TCURC Currency Codes WAERS
0 IRBKPF ZLSCH T042Z Payment Methods for Automatic Payment MANDT
0 IRBKPF ZLSCH T042Z Payment Methods for Automatic Payment LAND1
0 IRBKPF ZLSCH T042Z Payment Methods for Automatic Payment ZLSCH