SAP table RBKP (Document Header: Invoice Receipt)

SAP table RBKP 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
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 Different Invoicing Party CHAR 10 0 LFA1 LIFRE
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
TXDAT Date for Determining Tax Rates DATS 8 0 TXDAT
TXDAT_FROM Valid-From Date of the Tax Rate DATS 8 0 FOT_TXDAT_FROM
WMWST1 Tax Amount in Document Currency with +/- Sign CURR 13 2 FWSTEV
MWSKZ1 Tax code CHAR 2 0 TMRM007A MWSKZ_MRM1
WMWST2 Obsolete: tax amount in document currency - do NOT use! CURR 13 2 FWSTEV_OLD
MWSKZ2 Obsolete: sales tax code CHAR 2 0 T007A MWSKZ_MRMO
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 XRECH
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
MWSKZ_BNK Tax Code CHAR 2 0 T007A MWSKZ_MRM
TXJCD_BNK Tax Jurisdiction CHAR 15 0 * TXJCD
IVTYP Origin of a Logistics Invoice Verification Document CHAR 1 0 IVTYP
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
A Invoice from Parking Function
B BAPI Invoice
C Account Maintenance
D SRM Invoice
E BAPI Account Maintenance
G External Service
H SOA B2B
I Business Network
J Bus. Network (Parked)
K Consignment
L Recurring Supplier Invoice
M Intercompany Supplier Invoice
N Internal PaaS API
XRBTX Indicator: more than one tax code CHAR 1 0 XRBTX
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
KNUMVE Document condition - own conditions CHAR 10 0 KNUMVE
KNUMVL Document Condition - Supplier Error CHAR 10 0 KNUMVL
ARKUEN Automatic Invoice Reduction Amount (Net) CURR 13 2 ARKUEN
ARKUEMW Sales Tax Portion of Automatic Invoice Reduction Amount CURR 13 2 ARKUEMW
MAKZN Manually accepted net difference amount CURR 13 2 MAKZN
MAKZMW Tax Amount Accepted Manually CURR 13 2 MAKZMW
LIEFFN Supplier Error (Exclusive of Tax) CURR 13 2 LIEFFN
LIEFFMW Tax in Supplier Error CURR 13 2 LIEFFMW
XAUTAKZ Indicates automatically accepted invoices CHAR 1 0 XAUTAKZ
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
TXKRS Exchange Rate for Taxes DEC 9 5 TXKRS_BKPF
CTXKRS Rate for Tax Values in Reporting Currency DEC 9 5 CTXKRS
EMPFB Payee/Payer CHAR 10 0 EMPFB
BVTYP Partner bank type CHAR 4 0 BVTYP
HBKID Short Key for a House Bank CHAR 5 0 T012 HBKID
HKTID ID for Account Details CHAR 5 0 * HKTID
ZUONR Assignment number CHAR 18 0 DZUONR
ZLSPR Payment Block Key CHAR 1 0 T008 DZLSPR
ZLSCH Payment Method CHAR 1 0 T042Z DZLSCH
ZFBDT Baseline Date for Due Date Calculation DATS 8 0 DZFBDT
KIDNO Payment Reference CHAR 30 0 KIDNO
REBZG Invoice reference: Document number for invoice reference CHAR 10 0 AWREF_REB
REBZJ Fiscal Year of the Relevant Invoice (for Credit Memo) NUMC 4 0 REBZJ
XINVE Indicator: Capital Goods Affected? CHAR 1 0 XINVE
EGMLD Reporting Country/Region for Delivery of Goods Within the EU CHAR 3 0 * EGMLD_BSEZ
XEGDR Indicator: Triangular Deal Within the EU CHAR 1 0 XEGDR
VATDATE Tax Reporting Date DATS 8 0 VATDATE
HKONT General Ledger Account CHAR 10 0 * HKONT
MONAT Fiscal period NUMC 2 0 MONAT
J_1BNFTYPE Nota Fiscal Type CHAR 2 0 J_1BAA J_1BNFTYPE
BRNCH Branch Number CHAR 4 0 J_1BBRANCH J_1ABRNCH
ERFPR Entry profile: Logistics Invoice Verification CHAR 12 0 T169H ERFPR
SECCO Section Code CHAR 4 0 SECCODE SECCO
NAME1 Name 1 CHAR 35 0 NAME1_GP
NAME2 Name 2 CHAR 35 0 NAME2_GP
NAME3 Name 3 CHAR 35 0 NAME3_GP
NAME4 Name 4 CHAR 35 0 NAME4_GP
PSTLZ Postal Code CHAR 10 0 PSTLZ
ORT01 City CHAR 35 0 ORT01_GP
LAND1 Country/Region Key CHAR 3 0 LAND1_GP
STRAS Street and House Number CHAR 35 0 STRAS_GP
PFACH PO Box CHAR 10 0 PFACH
PSTL2 P.O. Box Postal Code CHAR 10 0 PSTL2
PSKTO PO Bank Current Acct No. or Building Society Ref. No. CHAR 16 0 PSKTO
BANKN Bank account number CHAR 18 0 BANKN
BANKL Bank Number CHAR 15 0 BANKL
BANKS Country/Region Key of Bank CHAR 3 0 * BANKS
STCD1 Tax Number 1 CHAR 16 0 STCD1
STCD2 Tax Number 2 CHAR 11 0 STCD2
STKZU Liable for VAT CHAR 1 0 STKZU
STKZA Indicator: Business Partner Subject to Equalization Tax? CHAR 1 0 STKZA
Not subject to equalization tax
X Subject to equalization tax
REGIO Region (State, Province, County) CHAR 3 0 * REGIO
BKONT Bank Control Key CHAR 2 0 BKONT
DTAWS Instruction Key for Data Medium Exchange CHAR 2 0 * DTAWS
DTAMS Report key for data medium exchange CHAR 1 0 DTAMS
Use house bank default value
0 Single data record can be forwarded to the Bundesbank
1 Single data record not to be forwarded to the Bundesbank
SPRAS Character field of length 1 CHAR 1 0 CHAR_LG_01
XCPDK Indicator: Is the account a one-time account? CHAR 1 0 XCPDK
EMPFG Payment Recipient Code CHAR 16 0 EMPFG
FITYP Tax type CHAR 2 0 * J_1AFITP_D
STCDT Tax Number Type CHAR 2 0 * J_1ATOID
STKZN Natural Person CHAR 1 0 STKZN
Legal person
X Natural person
STCD3 Tax Number 3 CHAR 18 0 STCD3
STCD4 Tax Number 4 CHAR 18 0 STCD4
BKREF Reference Details for Bank Details CHAR 20 0 BKREF
J_1KFREPRE Name of Representative CHAR 10 0 REPRES
J_1KFTBUS Type of Business CHAR 30 0 * GESTYP
J_1KFTIND Type of Industry CHAR 30 0 * INDTYP
ANRED Title CHAR 15 0 ANRED
STCEG VAT Registration Number CHAR 20 0 STCEG
STCD5 Tax Number 5 CHAR 60 0 STCD5
INTAD Internet address of partner company clerk CHAR 130 0 INTAD
GLO_RE1_OT Country/Region specific Ref. in the One Time Account Data CHAR 140 0 GLO_LOG_REF1_OT
ERNAME Entered by external system user CHAR 12 0 ERNAME
REINDAT Invoice Receipt Date DATS 8 0 REINDAT
UZAWE Payment method supplement CHAR 2 0 * UZAWE
FDLEV Planning Level CHAR 2 0 * FDLEV
FDTAG Planning Date DATS 8 0 FDTAG
ZBFIX Fixed Payment Terms CHAR 1 0 DZBFIX
FRGKZ Indicator: Release Required CHAR 1 0 DFRGKZ
ERFNAM Name of the Processor Who Entered the Object CHAR 12 0 ERFNAM
BUPLA Business Place CHAR 4 0 PBUSINESSPLACE BUPLA
FILKD Account Number of the Branch CHAR 10 0 FILKD
GSBER Business Area CHAR 4 0 * GSBER
LOTKZ Lot Number for Documents CHAR 10 0 LOTKZ
SGTXT Item Text CHAR 50 0 SGTXT
INV_TRAN Transaction in Logistics Invoice Verification CHAR 1 0 INV_TRAN
PREPAY_STATUS Prepayment Status CHAR 1 0 WRF_PREPAY_STATUS
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 CHAR 20 0 WRF_PREPAY_AWKEY
ASSIGN_STATUS Is the invoice in the assignment test process? CHAR 1 0 WRF_MRM_ASSIGN_STATUS
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 DATS 8 0 WRF_MRM_ASSIGN_NEXT_DATE
ASSIGN_END_DATE End Date of Assignment Test Period DATS 8 0 WRF_MRM_ASSIGN_END_DATE
COPY_BY_BELNR Invoice Document Number of Original Invoice CHAR 10 0 COPY_BY_BELNR
COPY_BY_YEAR Fiscal Year of Original Invoice NUMC 4 0 COPY_BY_YEAR
COPY_TO_BELNR Invoice Document Number of Copied Invoice CHAR 10 0 COPY_TO_BELNR
COPY_TO_YEAR Fiscal Year of Copied Invoice NUMC 4 0 COPY_TO_YEAR
COPY_USER User That Reversed and Copied the Invoice CHAR 12 0 COPY_USER
KURSX Market Data Exchange Rate DEC 28 14 GLE_FXR_DTE_RATEX28
WWERT Translation date DATS 8 0 WWERT_D
XREF3 Reference key for line item CHAR 20 0 XREF3
DUMMY_MMIV_SI_S_HEADER_EEW_PS MMIV_SI_S_HEADER_INCL_EEW CHAR 1 0 MMIV_SI_S_HEADER_INCL_EEW
BUSINESS_NETWORK_ORIGIN Origin of the Business Network Document CHAR 2 0 MRM_BUSINESS_NETWORK_ORIGIN
01 SAP Ariba
02 SAP Fieldglass
ISEOPBLOCKED Business Purpose Completed CHAR 1 0 EOPBLOCKED
Ongoing Business, Active Purpose
X Business Purpose Completed, End of Purpose Reached
LASTCHANGEDATETIME UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) DEC 21 7 TIMESTAMPL
GLO_REF1_HD Country/Region Specific Reference 1 in the Document CHAR 80 0 FAC_GLO_REF1_HD
GLO_DAT1_HD Country/Region Specific Date 1 in the Document DATS 8 0 FAC_GLO_DAT1_HD
GLO_REF2_HD Country/Region Specific Reference 2 in the Document CHAR 25 0 FAC_GLO_REF2_HD
GLO_DAT2_HD Country/Region Specific Date 2 in the Document DATS 8 0 FAC_GLO_DAT2_HD
GLO_REF3_HD Country/Region Specific Reference 3 in the Document CHAR 25 0 FAC_GLO_REF3_HD
GLO_DAT3_HD Country/Region Specific Date 3 in the Document DATS 8 0 FAC_GLO_DAT3_HD
GLO_REF4_HD Country/Region Specific Reference 4 in the Document CHAR 50 0 FAC_GLO_REF4_HD
GLO_DAT4_HD Country/Region Specific Date 4 in the Document DATS 8 0 FAC_GLO_DAT4_HD
GLO_REF5_HD Country/Region Specific Reference 5 in the Document CHAR 50 0 FAC_GLO_REF5_HD
GLO_DAT5_HD Country/Region Specific Date 5 in the Document DATS 8 0 FAC_GLO_DAT5_HD
GLO_BP1_HD Country/Region specific Business Partner 1 in the Document CHAR 10 0 * FAC_GLO_BP1_HD
GLO_BP2_HD Country/Region Specific Business Partner 2 in the Document CHAR 10 0 * FAC_GLO_BP2_HD
CIM_REPLICATIONTIMESTAMP UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) DEC 21 7 TIMESTAMPL
TMTYPE Transportation Management Version CHAR 1 0 MRM_TMTYPE
No Transportation Management (TM)
1 TM with Purchase Orders for External Services
2 TM with Purchase Orders for Lean Services
TAX_COUNTRY Tax Reporting Country/Region CHAR 3 0 FOT_TAX_COUNTRY
TAX_COUNTRY_BNK Tax Reporting Country/Region CHAR 3 0 FOT_TAX_COUNTRY
FULFILLDATE Tax Fulfillment Date DATS 8 0 FOT_FULFILLDATE
NODE_KEY GUID: MM Supplier Invoice in S-Innovations RAW 16 0 MRM_SI_GUID
PARENT_KEY GUID: MM Supplier Invoice in S-Innovations RAW 16 0 MRM_SI_GUID
ROOT_KEY GUID: MM Supplier Invoice in S-Innovations RAW 16 0 MRM_SI_GUID
J_1TPBUPL Branch Code CHAR 5 0 BCODE
LOGMX_UUID (obsolete) Mexico UUID CHAR 36 0 LOGMX_UUID
ANXTYPE Invoice Type CHAR 1 0 /ILE/TMTYP
ANXAMNT Annexation Amount CURR 13 2 /ILE/TMANXA
ANXPERC Annexation Percentage DEC 6 3 /ILE/TMANXP
ZVAT_INDC VAT indicator contain run date of vat file DATS 8 0 /ILE/TVAT_INDC
/ILE/PARK Select CHAR 1 0 MARKE
/ILE/HOLD Select CHAR 1 0 MARKE
/ILE/BAPI_SAVE Select CHAR 1 0 MARKE
GST_PART GST Partner CHAR 10 0 J_1IG_PARTNER
PLC_SUP Place of Supply CHAR 3 0 T005S J_1IG_REGION
IRN Invoice Reference Number CHAR 64 0 J_1IG_IRN
PYBASTYP Type of Payment Basis Document CHAR 2 0 SAFM_AP_PYBSTYP
PYBASNO Payment Basis Document Number CHAR 16 0 SAFM_AP_PYBSNO
PYBASDAT Payment Basis Document Date DATS 8 0 SAFM_AP_PYBSDAT
PYIBAN IBAN (International Bank Account Number) CHAR 34 0 IBAN
INWARDNO_HD Incoming Document Number CHAR 30 0 SAFM_AP_INWARD_NO
INWARDDT_HD Incoming Document Date DATS 8 0 SAFM_AP_INWARD_DT

RBKP foreign key relationships

Table Field Check Table Check Field
0 RBKP BLART T003 Document Types MANDT
1 RBKP BRNCH J_1BBRANCH Business Place BUKRS
1 RBKP BRNCH J_1BBRANCH Business Place BRANCH
1 RBKP BRNCH J_1BBRANCH Business Place BUPLA_TYPE
0 RBKP BUKRS T001 Company Codes BUKRS
1 RBKP BUPLA PBUSINESSPLACE Generated Table for View BUKRS
1 RBKP BUPLA PBUSINESSPLACE Generated Table for View BRANCH
0 RBKP ERFPR T169H Entry Profile MANDT
0 RBKP ERFPR T169H Entry Profile ERFPR
1 RBKP HBKID T012 House Banks BUKRS
0 RBKP J_1BNFTYPE J_1BAA Nota Fiscal type NFTYPE
1 RBKP LANDL T005 Countries MANDT
1 RBKP LANDL T005 Countries LAND1
0 RBKP LIFNR LFA1 Supplier Master (General Section) MANDT
0 RBKP LIFNR LFA1 Supplier Master (General Section) LIFNR
1 RBKP LZBKZ T015L SCB Ratios LZBKZ
0 RBKP MANDT T000 Clients MANDT
1 RBKP MWSKZ1 TMRM007A Tax Codes: Invoice Verification/Invoice Entry (FI) KALSM
1 RBKP MWSKZ1 TMRM007A Tax Codes: Invoice Verification/Invoice Entry (FI) MWSKZ
0 RBKP MWSKZ2 T007A Tax Keys KALSM
0 RBKP MWSKZ2 T007A Tax Keys MWSKZ
1 RBKP MWSKZ_BNK T007A Tax Keys KALSM
1 RBKP MWSKZ_BNK T007A Tax Keys MWSKZ
0 RBKP PLC_SUP T005S Taxes: Region (Province) Key LAND1
1 RBKP QSSKZ T059Q Withholding Tax MANDT
1 RBKP QSSKZ T059Q Withholding Tax LAND1
1 RBKP QSSKZ T059Q Withholding Tax QSSKZ
0 RBKP SECCO SECCODE Section Code MANDT
0 RBKP SECCO SECCODE Section Code BUKRS
0 RBKP SECCO SECCODE Section Code SECCODE
1 RBKP TCODE TSTC SAP Transaction Codes TCODE
0 RBKP WAERS TCURC Currency Codes MANDT
0 RBKP WAERS TCURC Currency Codes WAERS
1 RBKP ZLSCH T042Z Payment Methods for Automatic Payment MANDT
1 RBKP ZLSCH T042Z Payment Methods for Automatic Payment LAND1
1 RBKP ZLSCH T042Z Payment Methods for Automatic Payment ZLSCH
0 RBKP ZLSPR T008 Blocking Reasons for Automatic Payment Transcations MANDT
0 RBKP ZLSPR T008 Blocking Reasons for Automatic Payment Transcations ZAHLS