VDCBR_RES_DATA - Table of Data Reported to Credit Bureau (Per Loan)
Table of Data Reported to Credit Bureau (Per Loan) information is stored in SAP table VDCBR_RES_DATA.
It is part of development package FVVD_CREDIT_BUREAU in software component FS-CML. This development package consists of objects that can be grouped under "Data for Credit Bureau Reporting".
It is part of development package FVVD_CREDIT_BUREAU in software component FS-CML. This development package consists of objects that can be grouped under "Data for Credit Bureau Reporting".
Fields for table VDCBR_RES_DATA
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | * |
| BUKRS | Company Code | X | BUKRS | CHAR | 8 | * |
| RANL | Contract Number | X | RANL | CHAR | 26 | |
| DATE_CREA | Created On | X | TB_CBR_CREATION_DATE | DATS | 16 | |
| TIME_CREA | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | X | TIMESTAMP | DEC | 8 | |
| .INCLUDE | RVD_CBR_BASE_SEGM | 0 | ||||
| BDW | Block Length Field for Output in File | TB_CBR_BLOCK_DESC_WORD | NUMC | 8 | ||
| RDW | Record Length Field | TB_CBR_REC_DESC_WORD | NUMC | 8 | ||
| PROCESS_IND | Indicator for Forwarding Data in Metro2 Format | TB_CBR_INDICATOR | NUMC | 2 | ||
| TIMESTAMP | UTC Time Stamp (Metro2 Format) | TB_CBR_TIMESTAMP | CHAR | 30 | ||
| CORRECTION_IND | Indicator for Forwarding Data in Metro2 Format | TB_CBR_INDICATOR | NUMC | 2 | ||
| IDENT_NO | Nuber of Data Provider | TB_CBR_IDENT_NUMBER | CHAR | 40 | ||
| CYCLE_IDENT | Cycle for Reporting to Credit Bureau | TB_CBR_CYCLE_NUMBER | CHAR | 4 | ||
| CONSUMER_ACC_NO | Loan Number (30 Characters) (Metro2 Format) | TB_CBR_ACCOUNT_NO_30 | CHAR | 60 | ||
| PORTFOLIO_TYPE | Loan Type | TB_CBR_PORTFOLIO_TYPE | CHAR | 2 | ||
| ACCOUNT_TYPE | Loan Type (Metro2 Format) | TB_CBR_ACCOUNT_TYPE | CHAR | 4 | ||
| DATE_OPENED | First Entered On | DERF | DATS | 16 | ||
| CREDIT_LIMIT | Credit Limit in (Metro2 Format) | TB_CBR_CREDIT_LIMIT | NUMC | 18 | ||
| O_LOAN_AMOUNT | Loan Amount (Metro2 Format) | TB_CBR_ORG_LOAN_AMOUNT | NUMC | 18 | ||
| TERMS_DURATION | Loan Term (Metro2 Format) | TB_CBR_TERMS_DURATION | CHAR | 6 | ||
| TERMS_FREQUENCY | Frequency of Payment Due Date (Metro2 Format) | TB_CBR_TERMS_FREQUENCY | CHAR | 2 | ||
| MON_PAYM_AMOUNT | Planned Monthly Payment Amount | TB_CBR_MON_PAYM_AMOUNT | NUMC | 18 | ||
| ACT_PAYM_AMOUNT | Amount Paid to Current Date (Metro2 Format) | TB_CBR_ACT_PAYM_AMOUNT | NUMC | 18 | ||
| ACCOUNT_STATUS | Loan Status (Metro2-Format) | TB_CBR_ACCOUNT_STATUS | CHAR | 4 | ||
| PAYMENT_RATING | Payment Rating | TB_CBR_PAYMENT_RATING | CHAR | 2 | ||
| PAYM_HIST_PROFIL | Payment History (Metro2 -Format) | TB_CBR_PAYMENT_HIST_PROF | CHAR | 48 | ||
| SPECIAL_COMMENT | Comment Key (Metro2 Format) | TB_CBR_SPECIAL_COMMENT | CHAR | 4 | ||
| COMPL_COND_CODE | Comment Key (Metro2 Format) | TB_CBR_SPECIAL_COMMENT | CHAR | 4 | ||
| CURRENT_BALANCE | Balance on Current Date (Metro2 - Format) | TB_CBR_CURRENT_BALANCE | NUMC | 18 | ||
| AMOUNT_PAST_DUE | Payments Past Due (Metro2 Format) | TB_CBR_AMOUNT_PAST_DUE | NUMC | 18 | ||
| CHARGE_OFF_AM | Charge-Off Amount (Metro2 Format) | TB_CBR_CHARGE_OFF_AMOUNT | NUMC | 18 | ||
| BILLING_DATE | Bill Creation Date | TB_BILL_DATE | DATS | 16 | ||
| FCRA_DATE | Date of First Delinquency (Metro2 - Format) | TB_CBR_FCRA_DATE | DATS | 16 | ||
| DATE_CLOSED | Contract End Date | TB_CBR_DATE_CLOSED | DATS | 16 | ||
| LAST_PAYM_DATE | Date of Last Incoming Payment | TB_CBR_DATE_LAST_PAYMENT | DATS | 16 | ||
| RESERVE | Reserve Bytes (Length 17) | TB_CBR_RESERVE_17 | CHAR | 34 | ||
| CONS_TRANS_TYPE | Changes to Borrower | TB_CBR_CONSUMER_TRANS_TYPE | CHAR | 2 | ||
| SURNAME | Last Name (Metro2 Format) | TB_CBR_SURNAME | CHAR | 50 | ||
| FIRST_NAME | First Name (Metro2 Format) | TB_CBR_FIRST_NAME | CHAR | 40 | ||
| MIDDLE_NAME | Middle Name (Metro2 Format) | TB_CBR_MIDDLE_NAME | CHAR | 40 | ||
| GENERATION_CODE | Generation Code (Metro2 Format) | TB_CBR_GENERATION_CODE | CHAR | 2 | ||
| SOCIAL_SEC_NO | Social Security Number (Metro2 Format) | TB_CBR_SOZ_SECURITY_NUM | CHAR | 18 | ||
| DATE_OF_BIRTH | Date of Birth (Metro2 Format) | TB_CBR_BIRTH_DATE | DATS | 16 | ||
| TEL_NUMBER | Telephone Number (Metro2 Format) | TB_CBR_TEL_NUM | NUMC | 20 | ||
| ECOA_CODE | Business Partner Role for Loan (Metro2 Format) | TB_CBR_ECOA_CODE | CHAR | 2 | ||
| CONS_INFO_IND | Bankruptcy Phase of Business Partner (Metro2 Format) | TB_CBR_CONS_INFO_INDICATOR | CHAR | 4 | ||
| COUNTRY_CODE | Country/Region Key (Metro2 Format) | TB_CBR_COUNTRY_CODE | CHAR | 4 | ||
| FIRST_ADR_LINE | Address Line (Metro2 Format) | TB_CBR_FIRST_ADR_LINE | CHAR | 64 | ||
| SECOND_ADR_LINE | Address Line (Metro2 Format) | TB_CBR_FIRST_ADR_LINE | CHAR | 64 | ||
| CITY | City (Metro2 Format) | TB_CBR_CITY | CHAR | 40 | ||
| STATE | State Identification (Metro 2 Format) | TB_CBR_STATE | CHAR | 4 | ||
| POSTAL_CODE | Postal Code (Metro2 Format) | TB_CBR_POSTAL_CODE | CHAR | 18 | ||
| ADR_INDICATOR | Indicator Field for Address (Metro2 Format) | TB_CBR_ADR_INDICATOR | CHAR | 2 | ||
| RESID_CODE | Residence Code for Metro2 Format | TB_CBR_RESIDENCE_CODE | CHAR | 2 | ||
| .INCLUDE | RVD_CBR_N1_SEGM | 0 | ||||
| SEGMENT_IDENT7 | Indicator for Segment | TB_CBR_SEGM_IDENT | CHAR | 4 | ||
| EMPLOYER_NAME | Name of Employer | TB_CBR_EMPL_NAME | CHAR | 60 | ||
| EMP_FI_ADR_LINE | Address Line (Metro2 Format) | TB_CBR_FIRST_ADR_LINE | CHAR | 64 | ||
| EMP_CITY | City (Metro2 Format) | TB_CBR_CITY | CHAR | 40 | ||
| EMP_STATE | State Identification (Metro 2 Format) | TB_CBR_STATE | CHAR | 4 | ||
| EMP_POST_CODE | Postal Code (Metro2 Format) | TB_CBR_POSTAL_CODE | CHAR | 18 | ||
| OCCUPATION | Name of Occupation (Metro2 Format) | TB_CBR_OCCUPATION | CHAR | 36 | ||
| RESERVE7 | Place Holder for 1 Byte | TB_CBR_RESERVE_1 | CHAR | 2 | ||
| .INCLUDE | RVD_CBR_K4_SEGM | 0 | ||||
| SEGMENT_IDENT6 | Indicator for Segment | TB_CBR_SEGM_IDENT | CHAR | 4 | ||
| SPEC_PAYM_IND | Payment Arrangements (MEtro2 Format) | TB_CBR_PAYMENT_INDICATOR | CHAR | 4 | ||
| DEF_PAYM_START | Start Date of Derffered Repayments (Metro2 Format) | TB_CBR_DEFER_PAYM_START_DATE | DATS | 16 | ||
| PAYM_DUE_DATE | Due Date of Final Installment (Metro2 - Format) | TB_CBR_PAYM_DUE_DATE | DATS | 16 | ||
| PAYM_AMOUNT | Final Installment Amount (Ballon) (Metro2 Format) | TB_CBR_PAYM_AMOUNT | NUMC | 18 | ||
| RESERVE6 | Place Holder for 1 Byte | TB_CBR_RESERVE_1 | CHAR | 2 |