1. Home
  2. Resources
  3. SAP Tables
  4. RBCT_RANL_VDARL - VDARL- Fields for Extraction Structure for IO 0FS_CTR_NO

SAP Table RBCT_RANL_VDARL

VDARL- Fields for Extraction Structure for IO 0FS_CTR_NO

RBCT_RANL_VDARL (VDARL- Fields for Extraction Structure for IO 0FS_CTR_NO) 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_RANL_VDARL to other SAP tables.

RBCT_RANL_VDARL table fields

Field Data element Checktable Datatype Length Decimals
BUKRS Company Code BUKRS CHAR 4 0
RANL Contract Number RANL CHAR 13 0
DATETO Date in CHAR format DATE CHAR 8 0
DATEFROM Date in CHAR format DATE CHAR 8 0
SANLF Product Category SANLF TZAF NUMC 3 0
GSART Product Type VVSART TZPA CHAR 3 0
RREFKONT Account Assignment Reference in Financial Assets Management RREFKONT T037S CHAR 8 0
HBKID Short Key for a House Bank HBKID T012 CHAR 5 0
HKTID ID for account details HKTID T012K CHAR 5 0
STITEL Loan Type Indicator STITEL TD03A NUMC 3 0
SGLZB SCB asset group indicator SGLZB TW07 CHAR 4 0
SFIBG Asset Grouping Indicator SFIBG NUMC 4 0
SBILK Balance Sheet Indicator SBILK TW11 CHAR 2 0
XAKT File Number XAKT CHAR 32 0
RANLALT1 Alternative Identification RANLALT1 CHAR 13 0
RANLALT2 Alternative identification 2 RANLALT2 CHAR 13 0
SGR1 Group Key 1 (Freely Available) SGRP1 TDDG1 CHAR 6 0
SGR2 Group Key 2 (Freely Available) SGRP2 TDDG2 CHAR 6 0
RKLAMMER Classification Number for Finance Projects RKLAMMER CHAR 13 0
RANLKET Principle loan investment number RANLHPT CHAR 13 0
RANTRAG Application number RANTRAG CHAR 13 0
SSOLIST Plan/Actual principle VVSSOLIST CHAR 1 0
0 Planned Principle
1 Actual Principle - Retain Annuity Pmnt Installment
2 Actual Principle - Increase Annuity Pmnt Installment
4 Incoming Payment Principle
5 Payment Plan Principle
SFRIST Loan Term SFRIST NUMC 2 0
BANTRAG Capital applied for BANTRAG CURR 13 2
SANTWHR Currency SWHR CUKY 5 0
DANTRAG Entry Date of Loan Application DANTRAG DATS 8 0
DZUSAGE Loan - Date of Commitment by Lender DZUSAGE DATS 8 0
SSICHER Primary collateral SSICHER TD01 CHAR 4 0
SVZWECK Purpose of Loan SVZWECK TD07 CHAR 2 0
SSONDER Special treatment of loan SSONDER TD10 NUMC 2 0
SLAENDER Country ID SLAENDER T005 CHAR 3 0
SNICHTAB Reason for Non-Acceptance SNICHTAB TDA5 NUMC 2 0
JORIG Posting system indicator for borrower's note loans BUCHSYS NUMC 1 0
1 Gross
2 Net
SDTYP Loans Class VVSDTYP TD02 NUMC 3 0
DBEWI Approval date VVDBEWI DATS 8 0
SABT Assignee VVSABT CHAR 4 0
MABER Dunning Area MABER T047M CHAR 2 0
MAHNS Dunning level MAHNS_D NUMC 1 0
MADAT Last dunned on MADAT DATS 8 0
SONDST Special posting treatment VVSONDST TD14 CHAR 2 0
SGRP3 Group Key 3 (Freely Available) SGRP3 TDDG3 CHAR 6 0
SGRP4 Group Key 4 (Freely Available) SGRP4 TDDG4 CHAR 6 0
SZKEY Indicator for Control of Incoming Payment Distribution VVSZKEY TVZ01 NUMC 2 0
SVERFU Type of Restraint on Drawing VVSVERFU TZV05 NUMC 2 0
STITART Borrower's Note Loan Security Type VVSTITART TD16 NUMC 2 0
RPORTB Portfolio RPORTB TWPOB CHAR 10 0
SREGION Sales Region VVSREGION TD18 CHAR 4 0
SGESST Branch Office VVSGESST TD17 CHAR 4 0
SBEA Loan Processing Indicator VVSBEA NUMC 2 0
01 Disbursed
07 Paid back on schedule
10 Settled
SOBEZ Organizational District VVSOBEZ CHAR 2 0
SBEZIRK Agent District VVSBEZIRK CHAR 4 0
SMAHNM Loan Manual Dunning Level VVSMAHNM TDMAHNS_MAN CHAR 1 0
DRUECK Date when loan will probably be redeemed VVDRUECK DATS 8 0
SABGRENZ Loan Discount Accrual/Deferral Method VVSABGRD CHAR 1 0
0 Acc. to flow type
1 Linear
2 Proportional to interest
9 None or manual
SFEST Indicator for Control of Fixed Contract VVFESTKZ CHAR 1 0
0 Fixed contract possible
1 Only manual fixed contract
2 No fixed contract
SRATING Rating BP_RATING TP06 CHAR 3 0
SRATAGEN Rating agency SRATAGEN_NEW BUT000 CHAR 10 0
RDARNEHM Business Partner Number BP_PARTNR_NEW BUT000 CHAR 10 0
OBJNR Text string 22 characters CHAR22 CHAR 22 0
HDN_KUNNR Main Borrower Customer Number HDN_KUNNR KNA1 CHAR 10 0
RANLSTAMNR Master number part of loan number for finding contracts RANLSTAMNR CHAR 13 0
SDUNNCMP Summarization Level for Dunning Letter SDUNNCMP CHAR 2 0
NULL Loan contract
FP Finance project
BO Main borrower
XNODUNN Exclude Loan from Dunning Run XNODUNN CHAR 1 0
X Yes
NULL No
ZUOND Assignment TB_ZUOND CHAR 18 0
REFER Internal Reference TB_REFER CHAR 16 0
MERKM Characteristics TB_MERKM CHAR 25 0
SDUNCHARG Post Dunning Charges and Interest to this Contract SDUNCHARG CHAR 1 0
X Yes
NULL No
SAKTPAS Indicator: Asset/Liability Transaction VVSAKTPAS CHAR 1 0
0 Asset Transaction
1 Liabilities Transaction
RPZAHL Payer/payee TB_RPZAHL_NEW BUT000 CHAR 10 0
GSBER Business Area GSBER TGSB CHAR 4 0
JNOREPAY Payoff Lock TB_JNOREPAY CHAR 1 0
X Yes
NULL No
JNODOIP Blocked by Payoff: No Open Item Clearing for Loan TB_JNODOIP CHAR 1 0
X Yes
NULL No
COM_VAL_CLASS General Valuation Class TPM_COM_VAL_CLASS TRGC_COM_VALCL NUMC 4 0
SSTATI Status of data record SSTATI TZC37 NUMC 2 0
SSTATE_OF_EXEC Region Where Contract Concluded TB_SREGION CHAR 3 0
BACKOFFICE_ID Object ID HROBJID NUMC 8 0
PAYM_STATUS Payment Status TB_PAYM_STATUS CHAR 1 0
NULL Normal
1 Delinquent
2 Prepaid

RBCT_RANL_VDARL foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
RBCT_RANL_VDARL COM_VAL_CLASS SYST MANDT TRGC_COM_VALCL General valuation class MANDT
RBCT_RANL_VDARL COM_VAL_CLASS RBCT_RANL_VDARL COM_VAL_CLASS TRGC_COM_VALCL General valuation class COM_VAL_CLASS
RBCT_RANL_VDARL GSART SYST MANDT TZPA Financial Assets Management Product Types MANDT
RBCT_RANL_VDARL GSART RBCT_RANL_VDARL GSART TZPA Financial Assets Management Product Types GSART
RBCT_RANL_VDARL GSBER SYST MANDT TGSB Business Areas MANDT
RBCT_RANL_VDARL GSBER RBCT_RANL_VDARL GSBER TGSB Business Areas GSBER
RBCT_RANL_VDARL HBKID RBCT_RANL_VDARL HBKID T012 House Banks HBKID
RBCT_RANL_VDARL HBKID SYST MANDT T012 House Banks MANDT
RBCT_RANL_VDARL HBKID RBCT_RANL_VDARL BUKRS T012 House Banks BUKRS
RBCT_RANL_VDARL HDN_KUNNR SYST MANDT KNA1 General Data in Customer Master MANDT
RBCT_RANL_VDARL HDN_KUNNR RBCT_RANL_VDARL HDN_KUNNR KNA1 General Data in Customer Master KUNNR
RBCT_RANL_VDARL HKTID SYST MANDT T012K House Bank Accounts MANDT
RBCT_RANL_VDARL HKTID RBCT_RANL_VDARL BUKRS T012K House Bank Accounts BUKRS
RBCT_RANL_VDARL HKTID RBCT_RANL_VDARL HBKID T012K House Bank Accounts HBKID
RBCT_RANL_VDARL HKTID RBCT_RANL_VDARL HKTID T012K House Bank Accounts HKTID
RBCT_RANL_VDARL MABER RBCT_RANL_VDARL BUKRS T047M Dunning areas BUKRS
RBCT_RANL_VDARL MABER RBCT_RANL_VDARL MABER T047M Dunning areas MABER
RBCT_RANL_VDARL MABER SYST MANDT T047M Dunning areas MANDT
RBCT_RANL_VDARL RDARNEHM RBCT_RANL_VDARL RDARNEHM BUT000 BP: General data I PARTNER
RBCT_RANL_VDARL RDARNEHM SYST MANDT BUT000 BP: General data I CLIENT
RBCT_RANL_VDARL RPORTB SYST MANDT TWPOB Portfolio position MANDT
RBCT_RANL_VDARL RPORTB RBCT_RANL_VDARL BUKRS TWPOB Portfolio position BUKRS
RBCT_RANL_VDARL RPORTB RBCT_RANL_VDARL RPORTB TWPOB Portfolio position RPORTB
RBCT_RANL_VDARL RPZAHL SYST MANDT BUT000 BP: General data I CLIENT
RBCT_RANL_VDARL RPZAHL RBCT_RANL_VDARL RPZAHL BUT000 BP: General data I PARTNER
RBCT_RANL_VDARL RREFKONT SYST MANDT T037S Account Assignment References acc. to Transaction Type MANDT
RBCT_RANL_VDARL RREFKONT RBCT_RANL_VDARL BUKRS T037S Account Assignment References acc. to Transaction Type BUKRS
RBCT_RANL_VDARL RREFKONT * T037S Account Assignment References acc. to Transaction Type RANTYP
RBCT_RANL_VDARL RREFKONT RBCT_RANL_VDARL RREFKONT T037S Account Assignment References acc. to Transaction Type RREFKONT
RBCT_RANL_VDARL SANLF RBCT_RANL_VDARL SANLF TZAF Product categories SANLF
RBCT_RANL_VDARL SBILK SYST MANDT TW11 Balance sheet indicator MANDT
RBCT_RANL_VDARL SBILK RBCT_RANL_VDARL SBILK TW11 Balance sheet indicator SBILK
RBCT_RANL_VDARL SDTYP SYST MANDT TD02 Table of Loan Classes MANDT
RBCT_RANL_VDARL SDTYP RBCT_RANL_VDARL SDTYP TD02 Table of Loan Classes SDTYP
RBCT_RANL_VDARL SGESST SYST MANDT TD17 Branch office MANDT
RBCT_RANL_VDARL SGESST RBCT_RANL_VDARL SGESST TD17 Branch office SGESST
RBCT_RANL_VDARL SGLZB SYST MANDT TW07 SCB group MANDT
RBCT_RANL_VDARL SGLZB RBCT_RANL_VDARL SGLZB TW07 SCB group SGLZB
RBCT_RANL_VDARL SGR1 RBCT_RANL_VDARL SGR1 TDDG1 Value table 1 User-specific loans key SGRP1
RBCT_RANL_VDARL SGR1 SYST MANDT TDDG1 Value table 1 User-specific loans key MANDT
RBCT_RANL_VDARL SGR2 SYST MANDT TDDG2 Value table 2 User-specific loans key MANDT
RBCT_RANL_VDARL SGR2 RBCT_RANL_VDARL SGR2 TDDG2 Value table 2 User-specific loans key SGRP2
RBCT_RANL_VDARL SGRP3 SYST MANDT TDDG3 Value table 3 User-specific loans key MANDT
RBCT_RANL_VDARL SGRP3 RBCT_RANL_VDARL SGRP3 TDDG3 Value table 3 User-specific loans key SGRP3
RBCT_RANL_VDARL SGRP4 SYST MANDT TDDG4 Value table 4 User-specific loans key MANDT
RBCT_RANL_VDARL SGRP4 RBCT_RANL_VDARL SGRP4 TDDG4 Value table 4 User-specific loans key SGRP4
RBCT_RANL_VDARL SLAENDER SYST MANDT T005 Countries MANDT
RBCT_RANL_VDARL SLAENDER RBCT_RANL_VDARL SLAENDER T005 Countries LAND1
RBCT_RANL_VDARL SMAHNM SYST MANDT TDMAHNS_MAN Loans: Manual Dunning Level MANDT
RBCT_RANL_VDARL SMAHNM RBCT_RANL_VDARL SMAHNM TDMAHNS_MAN Loans: Manual Dunning Level SMAHNM
RBCT_RANL_VDARL SNICHTAB SYST MANDT TDA5 Non-Accept.Reason MANDT
RBCT_RANL_VDARL SNICHTAB RBCT_RANL_VDARL BUKRS TDA5 Non-Accept.Reason BUKRS
RBCT_RANL_VDARL SNICHTAB RBCT_RANL_VDARL GSART TDA5 Non-Accept.Reason GSART
RBCT_RANL_VDARL SNICHTAB RBCT_RANL_VDARL SNICHTAB TDA5 Non-Accept.Reason SNICHTAB
RBCT_RANL_VDARL SONDST SYST MANDT TD14 Value table for tax preferential treatment ID MANDT
RBCT_RANL_VDARL SONDST RBCT_RANL_VDARL BUKRS TD14 Value table for tax preferential treatment ID BUKRS
RBCT_RANL_VDARL SONDST RBCT_RANL_VDARL SONDST TD14 Value table for tax preferential treatment ID SONDST
RBCT_RANL_VDARL SRATAGEN SYST MANDT BUT000 BP: General data I CLIENT
RBCT_RANL_VDARL SRATAGEN RBCT_RANL_VDARL SRATAGEN BUT000 BP: General data I PARTNER
RBCT_RANL_VDARL SRATING SYST MANDT TP06 Business Partner: Rating MANDT
RBCT_RANL_VDARL SRATING RBCT_RANL_VDARL SRATING TP06 Business Partner: Rating RATING
RBCT_RANL_VDARL SREGION SYST MANDT TD18 Business regions MANDT
RBCT_RANL_VDARL SREGION RBCT_RANL_VDARL SREGION TD18 Business regions SREGION
RBCT_RANL_VDARL SSICHER SYST MANDT TD01 Table for collateral keys MANDT
RBCT_RANL_VDARL SSICHER RBCT_RANL_VDARL SSICHER TD01 Table for collateral keys SSICH
RBCT_RANL_VDARL SSONDER SYST MANDT TD10 Indicator for special treatment of loan MANDT
RBCT_RANL_VDARL SSONDER RBCT_RANL_VDARL SSONDER TD10 Indicator for special treatment of loan SSONDER
RBCT_RANL_VDARL SSTATI RBCT_RANL_VDARL GSART TZC37 Financial Assets Management status definition GSART
RBCT_RANL_VDARL SSTATI RBCT_RANL_VDARL SSTATI TZC37 Financial Assets Management status definition STATU
RBCT_RANL_VDARL SSTATI SYST MANDT TZC37 Financial Assets Management status definition MANDT
RBCT_RANL_VDARL SSTATI RBCT_RANL_VDARL BUKRS TZC37 Financial Assets Management status definition BUKRS
RBCT_RANL_VDARL STITART SYST MANDT TD16 Borrower's note security value table MANDT
RBCT_RANL_VDARL STITART RBCT_RANL_VDARL STITART TD16 Borrower's note security value table STITART
RBCT_RANL_VDARL STITEL SYST MANDT TD03A Define Loan Type MANDT
RBCT_RANL_VDARL STITEL RBCT_RANL_VDARL STITEL TD03A Define Loan Type STITEL
RBCT_RANL_VDARL SVERFU RBCT_RANL_VDARL SVERFU TZV05 Types of restraint on drawing SVERFU
RBCT_RANL_VDARL SVERFU SYST MANDT TZV05 Types of restraint on drawing MANDT
RBCT_RANL_VDARL SVZWECK SYST MANDT TD07 Purpose of loan MANDT
RBCT_RANL_VDARL SVZWECK RBCT_RANL_VDARL GSART TD07 Purpose of loan GSART
RBCT_RANL_VDARL SVZWECK RBCT_RANL_VDARL SVZWECK TD07 Purpose of loan SVZWECK
RBCT_RANL_VDARL SZKEY RBCT_RANL_VDARL SZKEY TVZ01 Control of incoming payments SZKEY
RBCT_RANL_VDARL SZKEY SYST MANDT TVZ01 Control of incoming payments MANDT