SAP table RBKPB (Invoice Document Header (Batch Invoice Verification))

SAP table RBKPB has 3 primary key fields being MANDT,BELNR,GJAHR.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

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
NUMPG Number of pages of invoice NUMC 3 0 J_1ANOPG
RPZIELN Total of Items Selected CURR 13 2 RPZIELN
RPZIELMW VAT Portion of Target Invoice Amount in Document Currency CURR 13 2 RPZIELMW
DIFFN Document Balance CURR 13 2 RPDIFN
DIFFMW Sales Tax Portion of the Invoice Verification Difference CURR 13 2 DIFFMW
UBNKMW Sales tax portion of unplanned delivery costs CURR 13 2 UBNKMW
ANZRPV No. of invoice verification attempts NUMC 3 0 ANZRPV
REPDAT Invoice Verification date DATS 8 0 REPDAT
REPTIM Invoice Verification time TIMS 6 0 REPTIM
ANZUNF Number of unsolved errors NUMC 6 0 ANZUNF
ANZLIF Number of Supplier Errors NUMC 6 0 ANZLIF
ANZRPO Number of selected invoice items NUMC 6 0 ANZRPO
XKORREKT Indicates if the invoice is correct CHAR 1 0 XKORREKT
XNOTIZ Indicates Whether a Note Exists CHAR 1 0 XNOTIZ
ANZLSM Indicator: More Than One Item with Different Del. Note. Qty CHAR 1 0 ANZLSM
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
XBNK Planned Delivery Costs Indicator CHAR 1 0 XBNK
XWARE Goods Invoice/Service Indicator CHAR 1 0 XWARE
TBTKZ Indicator: Subsequent Debit/Credit CHAR 1 0 TBTKZ
XBEST Checkbox: Allocations CHAR 1 0 XZUORD
XLIFS Checkbox: Allocations CHAR 1 0 XZUORD
XFRBR Checkbox: Allocations CHAR 1 0 XZUORD
XWERK Checkbox: Allocations CHAR 1 0 XZUORD
XERFB Checkbox: Allocations CHAR 1 0 XZUORD
SELIF Number of the Selection Supplier CHAR 10 0 * SELIF
BNKSEL Type of delivery cost selection CHAR 1 0 BNKSEL
1 Select delivery costs for conditions supplier
2 Select delivery costs for supplier in PO
3 Select delivery costs for PO supplier & conditions supplier
XRECHL Posting logic for delivery items (invoice/credit memo) CHAR 1 0 XRECHL
XRECHR Posting logic for returns items (invoice/credit memo) CHAR 1 0 XRECHR
XNEGDIFF Check for Negative Variances CHAR 1 0 EDINEGDIFF
XTRAN Checkbox: Allocations CHAR 1 0 XZUORD
XTMTRAN Checkbox: Allocations CHAR 1 0 XZUORD
XCONTRACT Contract Selection with SRM Contract Number CHAR 1 0 XSRMCONTRACT
XTM Checkbox: Allocations CHAR 1 0 XZUORD
XERFB_NEW Checkbox: Allocations CHAR 1 0 XZUORD
RET_DUE_PROP Due Date for Retention (Default) DATS 8 0 RET_DUE_PROP
REPART Obsolete: indicator for inv. verification type: do NOT use CHAR 1 0 REPARTO
RBSTAT Obsolete: Invoice document status: do NOT use CHAR 1 0 RBSTATO
MAKZN Obsolete: man.-accepted net invoice diff. amount: do NOT use CURR 13 2 MAKZNO
XRKUE Obsolete: automatic invoice reduction: do NOT use! CHAR 1 0 XRKUE_O
ESRNR Obsolete: ISR subscriber number: do NOT use CHAR 11 0 ESRNR_O
ESRPZ Obsolete: ISR check digit: do NOT use CHAR 2 0 ESRPZ_O
ESRRE Obsolete: ISR reference number: do NOT use CHAR 27 0 ESRRE_O
QSSHB Old: Withholding tax base amount: do NOT use CURR 13 2 QSSHB_O
QSFBT Obsolete: amount exempt of withholding tax: do NOT use CURR 13 2 QSFBT_O
QSSKZ Obsolete: Withholding tax indicator: do NOT use CHAR 2 0 T059Q QSSKZ_O
DIEKZ Obsolete: service indicator: do NOT use CHAR 1 0 DIEKZ_O
LANDL Obsolete: supplying country: do NOT use! CHAR 3 0 T005 LANDL_O
LZBKZ Obsolete: state central bank indicator: do NOT use CHAR 3 0 T015L LZBKZ_O
TXKRS Obsolete: exchange rate for taxes: do NOT use DEC 9 5 TXKRS_O
XAVER Obsolete, no longer used CHAR 1 0 XAVER
0 No exclusion
1 Exclusion at delivery note/PO/plant level
2 Exclusion at material level
KZZUORDLI Obsolete: ID for delivery allocation: do NOT use! CHAR 1 0 KZZUORDLI
KZZUORDRT Obsolete: ID for returns allocation: do NOT use! CHAR 1 0 KZZUORDRT
KZBNK Obsolete: ID for planned delivery costs: do NOT use! CHAR 1 0 KZBNK
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
BNLIF Obsolete: No. of Supplier Invoicing Del. Costs: do NOT use CHAR 10 0 LFA1 BNLIF
LIEFF Obsolete: Supplier Error incl. VAT: do NOT use! CURR 13 2 LIEFFB_O
SMWSKZ1 Obsolete: sales tax code CHAR 2 0 T007A MWSKZ_MRMO
SMWST1 Obsolete: tax amount in document currency - do NOT use! CURR 13 2 FWSTEV_OLD
LIEFF1 Obsolete: amount with +/- sign - do NOT use CURR 13 2 BETRAG_OLD
MWLIEFF1 Obsolete: Tax in Supplier Error CURR 13 2 LMWST
MAKZMW1 Obsolete: amount with +/- sign - do NOT use CURR 13 2 BETRAG_OLD
MWDIFFB1 Obsolete: amount with +/- sign - do NOT use CURR 13 2 BETRAG_OLD
FWNAV1 Obsolete: tax amount in document currency - do NOT use! CURR 13 2 FWSTEV_OLD
MWBNK1 Obsolete: tax amount in document currency - do NOT use! CURR 13 2 FWSTEV_OLD
SMWSKZ2 Obsolete: sales tax code CHAR 2 0 T007A MWSKZ_MRMO
SMWST2 Obsolete: tax amount in document currency - do NOT use! CURR 13 2 FWSTEV_OLD
LIEFF2 Obsolete: amount with +/- sign - do NOT use CURR 13 2 BETRAG_OLD
MWLIEFF2 Obsolete: Tax in Supplier Error CURR 13 2 LMWST
MAKZMW2 Obsolete: amount with +/- sign - do NOT use CURR 13 2 BETRAG_OLD
MWDIFFB2 Obsolete: amount with +/- sign - do NOT use CURR 13 2 BETRAG_OLD
FWNAV2 Obsolete: tax amount in document currency - do NOT use! CURR 13 2 FWSTEV_OLD
MWBNK2 Obsolete: tax amount in document currency - do NOT use! CURR 13 2 FWSTEV_OLD
SOLLN Obsolete: amount with +/- sign - do NOT use CURR 13 2 BETRAG_OLD
SOLLB Obsolete: amount with +/- sign - do NOT use CURR 13 2 BETRAG_OLD
MAKZB Obsolete: amount with +/- sign - do NOT use CURR 13 2 BETRAG_OLD
LIEFFN Obsolete: amount with +/- sign - do NOT use CURR 13 2 BETRAG_OLD
DIFFB Obsolete: amount with +/- sign - do NOT use CURR 13 2 BETRAG_OLD
ZFBDT Not used. Base date for due-date calculation DATS 8 0 BDFAE_OLD
MONAT Outdated: Fiscal period - do NOT use!!! NUMC 2 0 MONAT_OLD
ZLSCH Outdated: Payment method - do NOT use!!! CHAR 1 0 * WZLSC_OLD
PREPAY_AREWR Clearing Value to Prepayment Clearing Account in LC CURR 13 2 WRF_PREPAY_AREWR
PREPAY_HWAER Local Currency CUKY 5 0 * WRF_PREPAY_HWAER
PREPAY_AREWW Clearing Value to Prepayment Clearing Account in TC CURR 13 2 WRF_PREPAY_AREWW
PREPAY_WAERS Document Currency CUKY 5 0 * WRF_PREPAY_WAERS
PREPAY_KURSF Exchange Rate of Prepayment Document DEC 9 5 WRF_PREPAY_KURSF
PREPAY_KUFIX Flag: Fixed Exchange Rate in Prepayment Document CHAR 1 0 WRF_PREPAY_KUFIX
PREPAY_LIFNR Supplier Account Number in Prepayment Document CHAR 10 0 * WRF_PREPAY_LIFNR
GST_PART GST Partner CHAR 10 0 J_1IG_PARTNER
PLC_SUP Place of Supply CHAR 3 0 * J_1IG_REGION

RBKPB foreign key relationships

Table Field Check Table Check Field
0 RBKPB BNLIF LFA1 Supplier Master (General Section) MANDT
0 RBKPB BNLIF LFA1 Supplier Master (General Section) LIFNR
1 RBKPB LANDL T005 Countries MANDT
1 RBKPB LANDL T005 Countries LAND1
0 RBKPB LZBKZ T015L SCB Ratios LZBKZ
1 RBKPB QSSKZ T059Q Withholding Tax MANDT
1 RBKPB QSSKZ T059Q Withholding Tax LAND1
1 RBKPB QSSKZ T059Q Withholding Tax QSSKZ
0 RBKPB SMWSKZ1 T007A Tax Keys KALSM
0 RBKPB SMWSKZ1 T007A Tax Keys MWSKZ
1 RBKPB SMWSKZ2 T007A Tax Keys KALSM
1 RBKPB SMWSKZ2 T007A Tax Keys MWSKZ