SAP VDCBR_RES_DATA Table of Data Reported to Credit Bureau (Per Loan) Table data and field list

VDCBR_RES_DATA is a standard SAP Table which is used to store Table of Data Reported to Credit Bureau (Per Loan) data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The VDCBR_RES_DATA table consists of various fields, each holding specific information or linking keys about Table of Data Reported to Credit Bureau (Per Loan) data available in SAP. These include BUKRS (Company Code), RANL (Contract Number), DATE_CREA (Created On), TIME_CREA (UTC Time Stamp in Short Form (YYYYMMDDhhmmss))... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

VDCBR_RES_DATA table Technical Details:

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced


SAP VDCBR_RES_DATA table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the VDCBR_RES_DATA table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3Assigned to domainMANDT
BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
RANLContract Number RANLCHAR13ALPHARANLRAN
DATE_CREACreated On TB_CBR_CREATION_DATEDATS8DATS
TIME_CREAUTC Time Stamp in Short Form (YYYYMMDDhhmmss) TIMESTAMPDEC15TZNTSTMPS
BDWBlock Length Field for Output in File TB_CBR_BLOCK_DESC_WORDNUMC4NUMC4
RDWRecord Length Field TB_CBR_REC_DESC_WORDNUMC4NUMC4
PROCESS_INDIndicator for Forwarding Data in Metro2 Format TB_CBR_INDICATORNUMC1NUMC1
TIMESTAMPUTC Time Stamp (Metro2 Format) TB_CBR_TIMESTAMPCHAR15CHAR15
CORRECTION_INDIndicator for Forwarding Data in Metro2 Format TB_CBR_INDICATORNUMC1NUMC1
IDENT_NONuber of Data Provider TB_CBR_IDENT_NUMBERCHAR20CHAR20
CYCLE_IDENTCycle for Reporting to Credit Bureau TB_CBR_CYCLE_NUMBERCHAR2CHAR02
CONSUMER_ACC_NOLoan Number (30 Characters) (Metro2 Format) TB_CBR_ACCOUNT_NO_30CHAR30CHAR30
PORTFOLIO_TYPELoan Type TB_CBR_PORTFOLIO_TYPECHAR1T_CBR_PORTFOLIO_TYPE
ACCOUNT_TYPELoan Type (Metro2 Format) TB_CBR_ACCOUNT_TYPECHAR2T_CBR_ACCOUNT_TYPE
DATE_OPENEDFirst Entered on DERFDATS8DATUM
CREDIT_LIMITCredit Limit in (Metro2 Format) TB_CBR_CREDIT_LIMITNUMC9T_CBR_AMOUNT_METRO2
O_LOAN_AMOUNTLoan Amount (Metro2 Format) TB_CBR_ORG_LOAN_AMOUNTNUMC9T_CBR_AMOUNT_METRO2
TERMS_DURATIONLoan Term (Metro2 Format) TB_CBR_TERMS_DURATIONCHAR3CHAR03
TERMS_FREQUENCYFrequency of Payment Due Date (Metro2 Format) TB_CBR_TERMS_FREQUENCYCHAR1CHAR01
MON_PAYM_AMOUNTPlanned Monthly Payment Amount TB_CBR_MON_PAYM_AMOUNTNUMC9T_CBR_AMOUNT_METRO2
ACT_PAYM_AMOUNTAmount Paid to Current Date (Metro2 Format) TB_CBR_ACT_PAYM_AMOUNTNUMC9T_CBR_AMOUNT_METRO2
ACCOUNT_STATUSLoan Status (Metro2-Format) TB_CBR_ACCOUNT_STATUSCHAR2CHAR02
PAYMENT_RATINGPayment Rating TB_CBR_PAYMENT_RATINGCHAR1CHAR01
PAYM_HIST_PROFILPayment History (Metro2 -Format) TB_CBR_PAYMENT_HIST_PROFCHAR24CHAR24
SPECIAL_COMMENTComment Key (Metro2 Format) TB_CBR_SPECIAL_COMMENTCHAR2CHAR02
COMPL_COND_CODEComment Key (Metro2 Format) TB_CBR_SPECIAL_COMMENTCHAR2CHAR02
CURRENT_BALANCEBalance on Current Date (Metro2 - Format) TB_CBR_CURRENT_BALANCENUMC9T_CBR_AMOUNT_METRO2
AMOUNT_PAST_DUEPayments Past Due (Metro2 Format) TB_CBR_AMOUNT_PAST_DUENUMC9T_CBR_AMOUNT_METRO2
CHARGE_OFF_AMCharge-Off Amount (Metro2 Format) TB_CBR_CHARGE_OFF_AMOUNTNUMC9T_CBR_AMOUNT_METRO2
BILLING_DATEBill Creation Date TB_BILL_DATEDATS8DATS
FCRA_DATEDate of First Delinquency (Metro2 - Format) TB_CBR_FCRA_DATEDATS8DATS
DATE_CLOSEDContract End Date TB_CBR_DATE_CLOSEDDATS8DATS
LAST_PAYM_DATEDate of Last Incoming Payment TB_CBR_DATE_LAST_PAYMENTDATS8DATS
RESERVEReserve Bytes (Length 17) TB_CBR_RESERVE_17CHAR17CHAR17
CONS_TRANS_TYPEChanges to Borrower TB_CBR_CONSUMER_TRANS_TYPECHAR1CHAR01
SURNAMELast Name (Metro2 Format) TB_CBR_SURNAMECHAR25CHAR25
FIRST_NAMEFirst Name (Metro2 Format) TB_CBR_FIRST_NAMECHAR20CHAR20
MIDDLE_NAMEMiddle Name (Metro2 Format) TB_CBR_MIDDLE_NAMECHAR20CHAR20
GENERATION_CODEGeneration Code (Metro2 Format) TB_CBR_GENERATION_CODECHAR1CHAR01
SOCIAL_SEC_NOSocial Security Number (Metro2 Format) TB_CBR_SOZ_SECURITY_NUMCHAR9CHAR9
DATE_OF_BIRTHDate of Birth (Metro2 Format) TB_CBR_BIRTH_DATEDATS8DATS
TEL_NUMBERTelephone Number (Metro2 Format) TB_CBR_TEL_NUMNUMC10NUMC10
ECOA_CODEBusiness Partner Role for Loan (Metro2 Format) TB_CBR_ECOA_CODECHAR1CHAR01
CONS_INFO_INDBankruptcy Phase of Business Partner (Metro2 Format) TB_CBR_CONS_INFO_INDICATORCHAR2CHAR02
COUNTRY_CODECountry Key (Metro2 Format) TB_CBR_COUNTRY_CODECHAR2CHAR02
FIRST_ADR_LINEAddress Line (Metro2 Format) TB_CBR_FIRST_ADR_LINECHAR32CHAR32
SECOND_ADR_LINEAddress Line (Metro2 Format) TB_CBR_FIRST_ADR_LINECHAR32CHAR32
CITYCity (Metro2 Format) TB_CBR_CITYCHAR20CHAR20
STATEState Identification (Metro 2 Format) TB_CBR_STATECHAR2CHAR02
POSTAL_CODEPostal Code (Metro2 Format) TB_CBR_POSTAL_CODECHAR9CHAR9
ADR_INDICATORIndicator Field for Address (Metro2 Format) TB_CBR_ADR_INDICATORCHAR1CHAR01
RESID_CODEResidence Code for Metro2 Format TB_CBR_RESIDENCE_CODECHAR1CHAR01
SEGMENT_IDENT7Indicator for Segment TB_CBR_SEGM_IDENTCHAR2CHAR02
EMPLOYER_NAMEName of Employer TB_CBR_EMPL_NAMECHAR30CHAR30
EMP_FI_ADR_LINEAddress Line (Metro2 Format) TB_CBR_FIRST_ADR_LINECHAR32CHAR32
EMP_CITYCity (Metro2 Format) TB_CBR_CITYCHAR20CHAR20
EMP_STATEState Identification (Metro 2 Format) TB_CBR_STATECHAR2CHAR02
EMP_POST_CODEPostal Code (Metro2 Format) TB_CBR_POSTAL_CODECHAR9CHAR9
OCCUPATIONName of Occupation (Metro2 Format) TB_CBR_OCCUPATIONCHAR18CHAR18
RESERVE7Place Holder for 1 Byte TB_CBR_RESERVE_1CHAR1CHAR01
SEGMENT_IDENT6Indicator for Segment TB_CBR_SEGM_IDENTCHAR2CHAR02
SPEC_PAYM_INDPayment Arrangements (MEtro2 Format) TB_CBR_PAYMENT_INDICATORCHAR2T_CBR_PAYMENT_INDICATOR
DEF_PAYM_STARTStart Date of Derffered Repayments (Metro2 Format) TB_CBR_DEFER_PAYM_START_DATEDATS8DATS
PAYM_DUE_DATEDue Date of Final Installment (Metro2 - Format) TB_CBR_PAYM_DUE_DATEDATS8DATS
PAYM_AMOUNTFinal Installment Amount (Ballon) (Metro2 Format) TB_CBR_PAYM_AMOUNTNUMC9T_CBR_AMOUNT_METRO2
RESERVE6Place Holder for 1 Byte TB_CBR_RESERVE_1CHAR1CHAR01

Key field Non-key field



How do I retrieve data from SAP table VDCBR_RES_DATA using ABAP code

The following ABAP code Example will allow you to do a basic selection on VDCBR_RES_DATA to SELECT all data from the table
DATA: WA_VDCBR_RES_DATA TYPE VDCBR_RES_DATA.

SELECT SINGLE *
FROM VDCBR_RES_DATA
INTO CORRESPONDING FIELDS OF WA_VDCBR_RES_DATA
WHERE...

How to access SAP table VDCBR_RES_DATA

Within an ECC or HANA version of SAP you can also view further information about VDCBR_RES_DATA and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).