SAP Table RBCT_DATA

Flow Data Extraction for Loans

RBCT_DATA (Flow Data Extraction for Loans) 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 RBCT_DATA to other SAP tables.

RBCT_DATA table fields

Field Data element Checktable Datatype Length Decimals
UPDMOD BW Delta Process: Record Mode RODMUPDMOD CHAR 1 0
NULL After-Image
X Before-Image
A Add
D Delete (Key Only)
N New Image
R Reverse-Image
Y Update Image (Value from Update)
LOGSYS Logical system LOGSYS CHAR 10 0
BUKRS Company Code BUKRS CHAR 4 0
RANL Contract Number RANL CHAR 13 0
RBELKPFD Document Number of Document Header (Loan) RBELKPFD CHAR 10 0
RPOSNR Activity number NVORGANG CHAR 3 0
DTRANS Flow data key: System date VVDTRANS DATS 8 0
TTRANS Transaction data key: system time VVTTRANS TIMS 6 0
NTRANS Transaction data key: Consecutive number VVNTRANS NUMC 4 0
GSART Product Type VVSART CHAR 3 0
BUCHST_DL Posting status of flow for loans BUCHST_DL CHAR 1 0
2 Posted Flow
4 Reversed Flow
5 Planned Flow
6 Archived Flow
RKLAMMER Classification Number for Finance Projects RKLAMMER CHAR 13 0
RREFKONT Account Assignment Reference in Financial Assets Management RREFKONT CHAR 8 0
HKONT General Ledger Account HKONT CHAR 10 0
GSBER Business Area GSBER CHAR 4 0
RSTBLG Reverse Document Number STBLG CHAR 10 0
RZEBEL Doc.no. of debit pos. doc.header (only for inc.pmnt records) RZEBEL CHAR 10 0
RUZBEL Accounting Document Number BELNR_D CHAR 10 0
SBEWART Flow Type SBEWART CHAR 4 0
SBEWZITI Flow category SBEWZITI CHAR 4 0
SREFZITI Refer.flow category in accrual/deferral flow records VVSREFZITI CHAR 4 0
DDISPO Payment Date DDISPO DATS 8 0
DFAELL Due date DFAELL DATS 8 0
DBUDAT Posting Date in the Document BUDAT DATS 8 0
DVALUT Value date VALUT DATS 8 0
SSOLHAB Debit/credit indicator VVSSOLHAB CHAR 1 0
S Debit Posting
H Credit Posting
RSOLL Account for debit posting RSOLL CHAR 10 0
RHABEN Account for credit posting RHABEN CHAR 10 0
HDN_KUNNR Main Borrower Customer Number HDN_KUNNR CHAR 10 0
SSIGN Direction of flow TB_SSIGN CHAR 1 0
+ Inflow
- Outflow
KTOPL Chart of Accounts KTOPL CHAR 4 0
SSTORNO Reversal indicator SSTORNO CHAR 1 0
1 Reversal record
2 Reversed record
3 IP transferred
VDBILL_NUMBER Bill Number TB_BILL_NUMBER CHAR 15 0
BILL_DUE_DATE Due Date for Bill TB_BILL_DUE_DATE DATS 8 0
RPNNR Daybook no. VVRPNNR CHAR 10 0
SSTATI Status of data record SSTATI NUMC 2 0
SREFBEW Reference flow type SREFBEW CHAR 4 0
SVORGKZ Activity indicator for debit/credit control VVSVORGKZ NUMC 2 0
01 Receivable
02 Outgoing payment
03 Payable
04 Incoming payment
05 Expense
06 Revenue
07 Internal debit posting
08 Internal credit posting
09 Cost center debit to internal general contract
10 Cost center credit to internal general contract
11 General contract debit
12 General contract credit
SWOHER Source of flow record SWOHER CHAR 1 0
BNWHR Nominal amount BNWHR CURR 13 2
SNWHR Currency of nominal amount SNWHR CUKY 5 0
BBWHR Amount in position currency BBWHR CURR 13 2
BHWHR Amount in local currency BHWHR CURR 13 2
SANTWHR Position Currency (Currency of Position Amount) SBWHR CUKY 5 0
WAERS Local currency SHWHR CUKY 5 0
SPLWHR Profit/loss currency SPLWHR CUKY 5 0
WZBETR Payment Currency TB_WZBETR CUKY 5 0
BZKWR Current Commitment Capital in Position Currency VVBZKWR CURR 15 2
BAVWR Disbursement Obligation in Position Currency VVBAVWR CURR 15 2
BVAWR Value-Dated Capital in Position Currency VVBVAWR CURR 15 2
BVAHW Value-Dated Capital in Local Currency VVBVAHW CURR 15 2
BRPWR Rem. Capital Acc. to Debit Position in Position Currency VVBRPWR CURR 15 2
BRPHW Remaining Capital Acc. to Debit Position in Local Currency VVBRPHW CURR 15 2
BRPNWR Nominal Rem.Capital Acc. to Debit Position in Position Curr. VVBRPNWR CURR 15 2
BRINWR Nominal Effective Capital in Position Currency VVBRINWR CURR 15 2
BRIWR Effective Capital in Position Currency VVBRIWR CURR 15 2
BRIHW Effective Capital in Local Currency VVBRIHW CURR 15 2
BATWR Unsched. Repayment: Debit Position in Position Currency VVBATSWR CURR 15 2
BATHW Unscheduled Repayment: Debit Position in Local Currency VVBATSHW CURR 15 2
BATNWR Nominal Unscheduled Repayment in Position Currency VVBATNWR CURR 15 2
BATZWR Unsched. Repayment: Incoming Payments in Position Currency VVBATZWR CURR 15 2
BATZHW Unscheduled Repayment: Incoming Payments in Local Currency VVBATZHW CURR 15 2
BPTWR Scheduled Repayment: Debit Position in Position Currency VVBPTSWR CURR 15 2
BPTHW Scheduled Repayment: Debit Position in Local Currency VVBPTSHW CURR 15 2
BPTZWR Scheduled Repayment: Incoming Payment in Position Currency VVBPTZWR CURR 15 2
BPTZHW Scheduled Repayment: Incoming Payment in Local Currency VVBPTZHW CURR 15 2
BKGVHW Exchange Rate Gains and Losses in Local Currency VVBKGVHW CURR 15 2
BVKWR Contract Capital in Position Currency VVBVKWR CURR 15 2
BVZWR Current Contract Capital in Position Currency VVBVZWR CURR 15 2
BKKWR Commitment Capital Acc. to Condition Header in Pos. Currency VVBKKWR CURR 15 2
BMIWR Capital Reduction in Position Currency VVBMIWR CURR 15 2
BKAUFWR Acquisition value in position currency BKAUFWR CURR 15 2
BKAUFHW Acquisition value in local currency BKAUFHW CURR 15 2
BBUCHWR Book value in position currency BBUCHWR CURR 15 2
BBUCHHW Book value in local currency BBUCHHW CURR 15 2
BAMT3WR Premium/discount (position currency) FPM_AMT3_WR CURR 15 2
BAMT3HW Premium/discount (local currency) FPM_AMT3_HW CURR 15 2
EEBETR Profit/loss amount in profit/loss currency EEBETR CURR 13 2
EHBETR Profit/loss amount in local currency EHBETR CURR 13 2
ZINS Interest Payments in Arrears (Asset) TB_BZINS_A CURR 15 2
TILGUNG Repayments in Arrears (Assets) TB_BTILGUNG_A CURR 15 2
VERSCH Total Remaining Postings Outstanding VVVERSCH CURR 15 2
UEBERZ Total overpayments for contract VVUEBERZ CURR 15 2
BZBETR Payment Amount in Payment Currency TB_BZWR_A CURR 15 2
BHWBETR Payment amount in local currency TB_BZHW_A CURR 15 2
DBERVON Start of Calculation Period DBERVON DATS 8 0
SEXCLVON Exclusive Indicator for the Start of a Calculation Period VVSEXCLVON NUMC 1 0
0 Inclusive
1 Exclusive
DBERBIS End of Calculation Period DBERBIS DATS 8 0
SINCLBIS Inclusive Indicator for the End of a Calculation Period VVSINCLBIS NUMC 1 0
0 Exclusive
1 Inclusive
SINCL Inclusive indicator for beginning and end of a period VVSINCL NUMC 1 0
0 Start date inclusive/end date exclusive
1 Start date exclusive/end date inclusive
DVERRECH Settlement date VVDVERRECH DATS 8 0
SINCLVERR Inclusive Indicator for Clearing Date VVSINCLVER NUMC 1 0
0 Exclusive
1 Inclusive
PKOND Percentage rate for condition items PKOND DEC 10 7