SAP table WB2_V_RBKP_RSEG2 (Generated Table for View)

SAP table WB2_V_RBKP_RSEG2 has 7 primary key fields being MANDT,BELNR,GJAHR,MANDT_I,BELNR_I,GJAHR_I,BUZEI_I.

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
MANDT_I Client CLNT 3 0 T000 MANDT
BELNR_I Document Number of an Accounting Document CHAR 10 0 BELNR_D
GJAHR_I Fiscal Year NUMC 4 0 GJAHR
BUZEI_I Document Item in Invoice Document NUMC 6 0 RBLGP
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
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
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
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
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
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
EBELN_I Purchasing Document Number CHAR 10 0 EKKO EBELN
EBELP_I Item Number of Purchasing Document NUMC 5 0 EKPO EBELP
ZEKKN_I Sequential Number of Account Assignment NUMC 2 0 DZEKKN
MATNR_I Material Number CHAR 40 0 MARA MATNR
BWKEY_I Valuation area CHAR 4 0 T001K BWKEY
BWTAR_I Valuation Type CHAR 10 0 T149D BWTAR_D
BUKRS_I Company Code CHAR 4 0 T001 BUKRS
WERKS_I Plant CHAR 4 0 T001W WERKS_D
WRBTR_I Amount in Document Currency CURR 13 2 WRBTR_CS
SHKZG_I Debit/Credit Indicator CHAR 1 0 SHKZG
H Credit
S Debit
MWSKZ_I Tax on sales/purchases code CHAR 2 0 T007A MWSKZ
TXJCD_I Tax Jurisdiction CHAR 15 0 TTXJ TXJCD
MENGE_I Quantity QUAN 13 3 MENGE_D
BSTME_I Purchase Order Unit of Measure UNIT 3 0 T006 BSTME
BPMNG_I Quantity in Purchase Order Price Unit QUAN 13 3 BPMNG
BPRME_I Order Price Unit (Purchasing) UNIT 3 0 T006 BPRME
LBKUM_I Total Valuated Stock QUAN 13 3 LBKUM
VRKUM_I Total valuated stock in the previous posting period QUAN 13 3 VRKUM
MEINS_I Base Unit of Measure UNIT 3 0 T006 MEINS
PSTYP_I Item category in purchasing document CHAR 1 0 T163 PSTYP
KNTTP_I Account Assignment Category CHAR 1 0 T163K KNTTP
BKLAS_I Valuation Class CHAR 4 0 T025 BKLAS
EREKZ_I Final Invoice Indicator CHAR 1 0 EREKZ
EXKBE_I Indicator: update purchase order history CHAR 1 0 XEKBE
XEKBZ_I Indicator: Update Purchase Order Delivery Costs CHAR 1 0 XEKBZ
TBTKZ_I Indicator: Subsequent Debit/Credit CHAR 1 0 TBTKZ
SPGRP_I Blocking Reason: Price CHAR 1 0 SPGRP
SPGRM_I Blocking Reason: Quantity CHAR 1 0 SPGRM
SPGRT_I Blocking Reason: Date CHAR 1 0 SPGRT
SPGRG_I Blocking Reason: Order Price Quantity CHAR 1 0 SPGRG
SPGRV_I Blocking Reason: Project Budget CHAR 1 0 SPGRV
SPGRQ_I Manual Blocking Reason CHAR 1 0 SPGRQ
SPGRS_I Blocking Reason: Item Amount CHAR 1 0 SPGRS
SPGRC_I Blocking Reason: Quality CHAR 1 0 SPGRC
BUSTW_I Posting String for Values CHAR 4 0 BUSTW
XBLNR_I Reference Document Number CHAR 16 0 XBLNR1
XRUEB_I Indicator: Document Is Posted to a Previous Period CHAR 1 0 XRUEB
BNKAN_I Delivery costs' share of item value CURR 13 2 BNK_ANTEIL
KSCHL_I Condition Type CHAR 4 0 KSCHL
SALK3_I Value of Total Valuated Stock CURR 13 2 SALK3
VMSAL_I Value of total valuated stock in previous period CURR 13 2 VMSAL
XLIFO_I LIFO/FIFO-Relevant CHAR 1 0 XLIFO
LFBNR_I Document No. of a Reference Document CHAR 10 0 LFBNR
LFGJA_I Fiscal Year of Current Period NUMC 4 0 LFGJA
LFPOS_I Item of a Reference Document NUMC 4 0 LFPOS
MATBF_I Material in Respect of Which Stock is Managed CHAR 40 0 MATBF
RBMNG_I Quantity Invoiced in Supplier Invoice in PO Order Units QUAN 13 3 RBMNG
BPRBM_I Quantity Invoiced in Supplier Invoice in PO Price Units QUAN 13 3 BPRBM
RBWWR_I Invoice Amount in Document Currency of Supplier Invoice CURR 13 2 RBWWR
LFEHL_I Type of Supplier Error CHAR 1 0 LFEHL
No supplier error
1 Price error
2 Conditions error
3 Quantity error
4 Quantity error + price error
5 Quantity error + condition error
GRICD_I Activity Code for Gross Income Tax CHAR 2 0 J_1AGICD J_1AGICD_D
GRIRG_I Region (State, Province, County) CHAR 3 0 T005S REGIO
GITYP_I Distribution Type for Employment Tax CHAR 2 0 J_1ADTYP J_1ADTYP_D
PACKNO_I Package Number of Service NUMC 10 0 PACKNO_EKBE
INTROW_I Line Number of Service NUMC 10 0 INTROW_EKBE
SGTXT_I Item Text CHAR 50 0 SGTXT
XSKRL_I Indicator: Line Item Not Liable to Cash Discount? CHAR 1 0 XSKRL
KZMEK_I Correction indicator CHAR 1 0 KZMEKORR
No error
1 Unclarified error: park invoice
2 Supplier error: reduce invoice
MRMOK_I Indicator: Invoice Item Processed CHAR 1 0 MRMOK
STUNR_I Step Number NUMC 3 0 STUNR
ZAEHK_I Condition Counter NUMC 3 0 DZAEHK

WB2_V_RBKP_RSEG2 foreign key relationships

Table Field Check Table Check Field
0 WB2_V_RBKP_RSEG2 BKLAS_I T025 Valuation Classes MANDT
0 WB2_V_RBKP_RSEG2 BKLAS_I T025 Valuation Classes BKLAS
1 WB2_V_RBKP_RSEG2 BLART T003 Document Types MANDT
0 WB2_V_RBKP_RSEG2 BRNCH J_1BBRANCH Business Place BUKRS
0 WB2_V_RBKP_RSEG2 BRNCH J_1BBRANCH Business Place BRANCH
0 WB2_V_RBKP_RSEG2 BRNCH J_1BBRANCH Business Place BUPLA_TYPE
1 WB2_V_RBKP_RSEG2 BUKRS T001 Company Codes BUKRS
0 WB2_V_RBKP_RSEG2 BUKRS_I T001 Company Codes BUKRS
1 WB2_V_RBKP_RSEG2 BUPLA PBUSINESSPLACE Generated Table for View BUKRS
1 WB2_V_RBKP_RSEG2 BUPLA PBUSINESSPLACE Generated Table for View BRANCH
0 WB2_V_RBKP_RSEG2 BWTAR_I T149D Global Valuation Types MANDT
0 WB2_V_RBKP_RSEG2 BWTAR_I T149D Global Valuation Types BWTAR
1 WB2_V_RBKP_RSEG2 EBELN_I EKKO Purchasing Document Header MANDT
1 WB2_V_RBKP_RSEG2 EBELN_I EKKO Purchasing Document Header EBELN
0 WB2_V_RBKP_RSEG2 EBELP_I EKPO Purchasing Document Item MANDT
0 WB2_V_RBKP_RSEG2 EBELP_I EKPO Purchasing Document Item EBELN
1 WB2_V_RBKP_RSEG2 ERFPR T169H Entry Profile MANDT
1 WB2_V_RBKP_RSEG2 ERFPR T169H Entry Profile ERFPR
0 WB2_V_RBKP_RSEG2 GITYP_I J_1ADTYP Distribution Types for Gross Income Tax MANDT
0 WB2_V_RBKP_RSEG2 GITYP_I J_1ADTYP Distribution Types for Gross Income Tax BUKRS
1 WB2_V_RBKP_RSEG2 GRICD_I J_1AGICD Activity codes for gross income tax declaration MANDT
1 WB2_V_RBKP_RSEG2 GRICD_I J_1AGICD Activity codes for gross income tax declaration LAND1
0 WB2_V_RBKP_RSEG2 GRIRG_I T005S Taxes: Region (Province) Key LAND1
1 WB2_V_RBKP_RSEG2 HBKID T012 House Banks BUKRS
0 WB2_V_RBKP_RSEG2 J_1BNFTYPE J_1BAA Nota Fiscal type NFTYPE
1 WB2_V_RBKP_RSEG2 KNTTP_I T163K Account Assignment Categories in Purchasing Document MANDT
1 WB2_V_RBKP_RSEG2 KNTTP_I T163K Account Assignment Categories in Purchasing Document KNTTP
0 WB2_V_RBKP_RSEG2 LANDL T005 Countries MANDT
0 WB2_V_RBKP_RSEG2 LANDL T005 Countries LAND1
1 WB2_V_RBKP_RSEG2 LIFNR LFA1 Supplier Master (General Section) MANDT
1 WB2_V_RBKP_RSEG2 LIFNR LFA1 Supplier Master (General Section) LIFNR
0 WB2_V_RBKP_RSEG2 LZBKZ T015L SCB Ratios LZBKZ
1 WB2_V_RBKP_RSEG2 MANDT T000 Clients MANDT
0 WB2_V_RBKP_RSEG2 MANDT_I T000 Clients MANDT
1 WB2_V_RBKP_RSEG2 MATNR_I MARA General Material Data MATNR
0 WB2_V_RBKP_RSEG2 MWSKZ1 TMRM007A Tax Codes: Invoice Verification/Invoice Entry (FI) KALSM
0 WB2_V_RBKP_RSEG2 MWSKZ1 TMRM007A Tax Codes: Invoice Verification/Invoice Entry (FI) MWSKZ
1 WB2_V_RBKP_RSEG2 MWSKZ2 T007A Tax Keys KALSM
1 WB2_V_RBKP_RSEG2 MWSKZ2 T007A Tax Keys MWSKZ
0 WB2_V_RBKP_RSEG2 MWSKZ_BNK T007A Tax Keys KALSM
0 WB2_V_RBKP_RSEG2 MWSKZ_BNK T007A Tax Keys MWSKZ
1 WB2_V_RBKP_RSEG2 MWSKZ_I T007A Tax Keys KALSM
1 WB2_V_RBKP_RSEG2 MWSKZ_I T007A Tax Keys MWSKZ
0 WB2_V_RBKP_RSEG2 PSTYP_I T163 Item Categories in Purchasing Document MANDT
0 WB2_V_RBKP_RSEG2 PSTYP_I T163 Item Categories in Purchasing Document PSTYP
1 WB2_V_RBKP_RSEG2 QSSKZ T059Q Withholding Tax MANDT
1 WB2_V_RBKP_RSEG2 QSSKZ T059Q Withholding Tax LAND1
1 WB2_V_RBKP_RSEG2 QSSKZ T059Q Withholding Tax QSSKZ
0 WB2_V_RBKP_RSEG2 SECCO SECCODE Section Code MANDT
0 WB2_V_RBKP_RSEG2 SECCO SECCODE Section Code BUKRS
0 WB2_V_RBKP_RSEG2 SECCO SECCODE Section Code SECCODE
1 WB2_V_RBKP_RSEG2 TCODE TSTC SAP Transaction Codes TCODE
0 WB2_V_RBKP_RSEG2 TXJCD_I TTXJ Check Table for Tax Jurisdiction MANDT
0 WB2_V_RBKP_RSEG2 TXJCD_I TTXJ Check Table for Tax Jurisdiction KALSM
1 WB2_V_RBKP_RSEG2 WAERS TCURC Currency Codes MANDT
1 WB2_V_RBKP_RSEG2 WAERS TCURC Currency Codes WAERS
0 WB2_V_RBKP_RSEG2 WERKS_I T001W Plants/Branches MANDT
0 WB2_V_RBKP_RSEG2 WERKS_I T001W Plants/Branches WERKS
1 WB2_V_RBKP_RSEG2 ZLSCH T042Z Payment Methods for Automatic Payment MANDT
1 WB2_V_RBKP_RSEG2 ZLSCH T042Z Payment Methods for Automatic Payment LAND1
1 WB2_V_RBKP_RSEG2 ZLSCH T042Z Payment Methods for Automatic Payment ZLSCH
0 WB2_V_RBKP_RSEG2 ZLSPR T008 Blocking Reasons for Automatic Payment Transcations MANDT
0 WB2_V_RBKP_RSEG2 ZLSPR T008 Blocking Reasons for Automatic Payment Transcations ZAHLS