SAP VDCBR_RES_DATA Table of Data Reported to Credit Bureau (Per Loan) Table
Overview
VDCBR_RES_DATA is a standard SAP S/4HANA table that stores Table of Data Reported to Credit Bureau (Per Loan) data. There are total 67 fields in the VDCBR_RES_DATA table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VDCBR_RES_DATA belongs to Loans Management (FS-CML) module and is located in the package Data for Credit Bureau Reporting (FVVD_CREDIT_BUREAU).
In addition, following links provide an overview of foreign key relationships, if any, that link VDCBR_RES_DATA to other SAP tables and standard CDS views available based on VDCBR_RES_DATA table in S/4HANA 2020.
Techincal Settings of VDCBR_RES_DATA
Below are technical details of the table VDCBR_RES_DATA
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VDCBR_RES_DATA Fields
The following table gives you an overview of the fields available in VDCBR_RES_DATA
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT | 3 |
| BUKRS | Company Code | BUKRS | * | CHAR | 4 |
| RANL | Contract Number | RANL | CHAR | 13 | |
| DATE_CREA | Created On | TB_CBR_CREATION_DATE | DATS | 8 | |
| TIME_CREA | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC | 15 | |
| BDW | Block Length Field for Output in File | TB_CBR_BLOCK_DESC_WORD | NUMC | 4 | |
| RDW | Record Length Field | TB_CBR_REC_DESC_WORD | NUMC | 4 | |
| PROCESS_IND | Indicator for Forwarding Data in Metro2 Format | TB_CBR_INDICATOR | NUMC | 1 | |
| TIMESTAMP | UTC Time Stamp (Metro2 Format) | TB_CBR_TIMESTAMP | CHAR | 15 | |
| CORRECTION_IND | Indicator for Forwarding Data in Metro2 Format | TB_CBR_INDICATOR | NUMC | 1 | |
| IDENT_NO | Nuber of Data Provider | TB_CBR_IDENT_NUMBER | CHAR | 20 | |
| CYCLE_IDENT | Cycle for Reporting to Credit Bureau | TB_CBR_CYCLE_NUMBER | CHAR | 2 | |
| CONSUMER_ACC_NO | Loan Number (30 Characters) (Metro2 Format) | TB_CBR_ACCOUNT_NO_30 | CHAR | 30 | |
| PORTFOLIO_TYPE | Loan Type | TB_CBR_PORTFOLIO_TYPE | CHAR | 1 | |
| ACCOUNT_TYPE | Loan Type (Metro2 Format) | TB_CBR_ACCOUNT_TYPE | CHAR | 2 | |
| DATE_OPENED | First Entered On | DERF | DATS | 8 | |
| CREDIT_LIMIT | Credit Limit in (Metro2 Format) | TB_CBR_CREDIT_LIMIT | NUMC | 9 | |
| O_LOAN_AMOUNT | Loan Amount (Metro2 Format) | TB_CBR_ORG_LOAN_AMOUNT | NUMC | 9 | |
| TERMS_DURATION | Loan Term (Metro2 Format) | TB_CBR_TERMS_DURATION | CHAR | 3 | |
| TERMS_FREQUENCY | Frequency of Payment Due Date (Metro2 Format) | TB_CBR_TERMS_FREQUENCY | CHAR | 1 | |
| MON_PAYM_AMOUNT | Planned Monthly Payment Amount | TB_CBR_MON_PAYM_AMOUNT | NUMC | 9 | |
| ACT_PAYM_AMOUNT | Amount Paid to Current Date (Metro2 Format) | TB_CBR_ACT_PAYM_AMOUNT | NUMC | 9 | |
| ACCOUNT_STATUS | Loan Status (Metro2-Format) | TB_CBR_ACCOUNT_STATUS | CHAR | 2 | |
| PAYMENT_RATING | Payment Rating | TB_CBR_PAYMENT_RATING | CHAR | 1 | |
| PAYM_HIST_PROFIL | Payment History (Metro2 -Format) | TB_CBR_PAYMENT_HIST_PROF | CHAR | 24 | |
| SPECIAL_COMMENT | Comment Key (Metro2 Format) | TB_CBR_SPECIAL_COMMENT | CHAR | 2 | |
| COMPL_COND_CODE | Comment Key (Metro2 Format) | TB_CBR_SPECIAL_COMMENT | CHAR | 2 | |
| CURRENT_BALANCE | Balance on Current Date (Metro2 - Format) | TB_CBR_CURRENT_BALANCE | NUMC | 9 | |
| AMOUNT_PAST_DUE | Payments Past Due (Metro2 Format) | TB_CBR_AMOUNT_PAST_DUE | NUMC | 9 | |
| CHARGE_OFF_AM | Charge-Off Amount (Metro2 Format) | TB_CBR_CHARGE_OFF_AMOUNT | NUMC | 9 | |
| BILLING_DATE | Bill Creation Date | TB_BILL_DATE | DATS | 8 | |
| FCRA_DATE | Date of First Delinquency (Metro2 - Format) | TB_CBR_FCRA_DATE | DATS | 8 | |
| DATE_CLOSED | Contract End Date | TB_CBR_DATE_CLOSED | DATS | 8 | |
| LAST_PAYM_DATE | Date of Last Incoming Payment | TB_CBR_DATE_LAST_PAYMENT | DATS | 8 | |
| RESERVE | Reserve Bytes (Length 17) | TB_CBR_RESERVE_17 | CHAR | 17 | |
| CONS_TRANS_TYPE | Changes to Borrower | TB_CBR_CONSUMER_TRANS_TYPE | CHAR | 1 | |
| SURNAME | Last Name (Metro2 Format) | TB_CBR_SURNAME | CHAR | 25 | |
| FIRST_NAME | First Name (Metro2 Format) | TB_CBR_FIRST_NAME | CHAR | 20 | |
| MIDDLE_NAME | Middle Name (Metro2 Format) | TB_CBR_MIDDLE_NAME | CHAR | 20 | |
| GENERATION_CODE | Generation Code (Metro2 Format) | TB_CBR_GENERATION_CODE | CHAR | 1 | |
| SOCIAL_SEC_NO | Social Security Number (Metro2 Format) | TB_CBR_SOZ_SECURITY_NUM | CHAR | 9 | |
| DATE_OF_BIRTH | Date of Birth (Metro2 Format) | TB_CBR_BIRTH_DATE | DATS | 8 | |
| TEL_NUMBER | Telephone Number (Metro2 Format) | TB_CBR_TEL_NUM | NUMC | 10 | |
| ECOA_CODE | Business Partner Role for Loan (Metro2 Format) | TB_CBR_ECOA_CODE | CHAR | 1 | |
| CONS_INFO_IND | Bankruptcy Phase of Business Partner (Metro2 Format) | TB_CBR_CONS_INFO_INDICATOR | CHAR | 2 | |
| COUNTRY_CODE | Country Key (Metro2 Format) | TB_CBR_COUNTRY_CODE | CHAR | 2 | |
| FIRST_ADR_LINE | Address Line (Metro2 Format) | TB_CBR_FIRST_ADR_LINE | CHAR | 32 | |
| SECOND_ADR_LINE | Address Line (Metro2 Format) | TB_CBR_FIRST_ADR_LINE | CHAR | 32 | |
| CITY | City (Metro2 Format) | TB_CBR_CITY | CHAR | 20 | |
| STATE | State Identification (Metro 2 Format) | TB_CBR_STATE | CHAR | 2 | |
| POSTAL_CODE | Postal Code (Metro2 Format) | TB_CBR_POSTAL_CODE | CHAR | 9 | |
| ADR_INDICATOR | Indicator Field for Address (Metro2 Format) | TB_CBR_ADR_INDICATOR | CHAR | 1 | |
| RESID_CODE | Residence Code for Metro2 Format | TB_CBR_RESIDENCE_CODE | CHAR | 1 | |
| SEGMENT_IDENT7 | Indicator for Segment | TB_CBR_SEGM_IDENT | CHAR | 2 | |
| EMPLOYER_NAME | Name of Employer | TB_CBR_EMPL_NAME | CHAR | 30 | |
| EMP_FI_ADR_LINE | Address Line (Metro2 Format) | TB_CBR_FIRST_ADR_LINE | CHAR | 32 | |
| EMP_CITY | City (Metro2 Format) | TB_CBR_CITY | CHAR | 20 | |
| EMP_STATE | State Identification (Metro 2 Format) | TB_CBR_STATE | CHAR | 2 | |
| EMP_POST_CODE | Postal Code (Metro2 Format) | TB_CBR_POSTAL_CODE | CHAR | 9 | |
| OCCUPATION | Name of Occupation (Metro2 Format) | TB_CBR_OCCUPATION | CHAR | 18 | |
| RESERVE7 | Place Holder for 1 Byte | TB_CBR_RESERVE_1 | CHAR | 1 | |
| SEGMENT_IDENT6 | Indicator for Segment | TB_CBR_SEGM_IDENT | CHAR | 2 | |
| SPEC_PAYM_IND | Payment Arrangements (MEtro2 Format) | TB_CBR_PAYMENT_INDICATOR | CHAR | 2 | |
| DEF_PAYM_START | Start Date of Derffered Repayments (Metro2 Format) | TB_CBR_DEFER_PAYM_START_DATE | DATS | 8 | |
| PAYM_DUE_DATE | Due Date of Final Installment (Metro2 - Format) | TB_CBR_PAYM_DUE_DATE | DATS | 8 | |
| PAYM_AMOUNT | Final Installment Amount (Ballon) (Metro2 Format) | TB_CBR_PAYM_AMOUNT | NUMC | 9 | |
| RESERVE6 | Place Holder for 1 Byte | TB_CBR_RESERVE_1 | CHAR | 1 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for VDCBR_RES_DATA