VDCBR_RES_DATA SAP (Table of Data Reported to Credit Bureau (Per Loan)) Table details
Dictionary Type: Table
Description: Table of Data Reported to Credit Bureau (Per Loan)
Description: Table of Data Reported to Credit Bureau (Per Loan)
ABAP Code to SELECT data from VDCBR_RES_DATA
Related tables to VDCBR_RES_DATA
Access table VDCBR_RES_DATA
Related tables to VDCBR_RES_DATA
Access table VDCBR_RES_DATA
Table field list including key, data, relationships and ABAP select examples
VDCBR_RES_DATA is a standard SAP Table which is used to store Table of Data Reported to Credit Bureau (Per Loan) data and is available within R/3 SAP systems 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. .
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
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
BUKRS | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
RANL | Contract Number | RANL | CHAR | 13 | ALPHA | RANL | RAN | ||
DATE_CREA | Created On | TB_CBR_CREATION_DATE | DATS | 8 | DATS | ||||
TIME_CREA | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC | 15 | TZNTSTMPS | ||||
BDW | Block Length Field for Output in File | TB_CBR_BLOCK_DESC_WORD | NUMC | 4 | NUMC4 | ||||
RDW | Record Length Field | TB_CBR_REC_DESC_WORD | NUMC | 4 | NUMC4 | ||||
PROCESS_IND | Indicator for Forwarding Data in Metro2 Format | TB_CBR_INDICATOR | NUMC | 1 | NUMC1 | ||||
TIMESTAMP | UTC Time Stamp (Metro2 Format) | TB_CBR_TIMESTAMP | CHAR | 15 | CHAR15 | ||||
CORRECTION_IND | Indicator for Forwarding Data in Metro2 Format | TB_CBR_INDICATOR | NUMC | 1 | NUMC1 | ||||
IDENT_NO | Nuber of Data Provider | TB_CBR_IDENT_NUMBER | CHAR | 20 | CHAR20 | ||||
CYCLE_IDENT | Cycle for Reporting to Credit Bureau | TB_CBR_CYCLE_NUMBER | CHAR | 2 | CHAR02 | ||||
CONSUMER_ACC_NO | Loan Number (30 Characters) (Metro2 Format) | TB_CBR_ACCOUNT_NO_30 | CHAR | 30 | CHAR30 | ||||
PORTFOLIO_TYPE | Loan Type | TB_CBR_PORTFOLIO_TYPE | CHAR | 1 | T_CBR_PORTFOLIO_TYPE | ||||
ACCOUNT_TYPE | Loan Type (Metro2 Format) | TB_CBR_ACCOUNT_TYPE | CHAR | 2 | T_CBR_ACCOUNT_TYPE | ||||
DATE_OPENED | First Entered on | DERF | DATS | 8 | DATUM | ||||
CREDIT_LIMIT | Credit Limit in (Metro2 Format) | TB_CBR_CREDIT_LIMIT | NUMC | 9 | T_CBR_AMOUNT_METRO2 | ||||
O_LOAN_AMOUNT | Loan Amount (Metro2 Format) | TB_CBR_ORG_LOAN_AMOUNT | NUMC | 9 | T_CBR_AMOUNT_METRO2 | ||||
TERMS_DURATION | Loan Term (Metro2 Format) | TB_CBR_TERMS_DURATION | CHAR | 3 | CHAR03 | ||||
TERMS_FREQUENCY | Frequency of Payment Due Date (Metro2 Format) | TB_CBR_TERMS_FREQUENCY | CHAR | 1 | CHAR01 | ||||
MON_PAYM_AMOUNT | Planned Monthly Payment Amount | TB_CBR_MON_PAYM_AMOUNT | NUMC | 9 | T_CBR_AMOUNT_METRO2 | ||||
ACT_PAYM_AMOUNT | Amount Paid to Current Date (Metro2 Format) | TB_CBR_ACT_PAYM_AMOUNT | NUMC | 9 | T_CBR_AMOUNT_METRO2 | ||||
ACCOUNT_STATUS | Loan Status (Metro2-Format) | TB_CBR_ACCOUNT_STATUS | CHAR | 2 | CHAR02 | ||||
PAYMENT_RATING | Payment Rating | TB_CBR_PAYMENT_RATING | CHAR | 1 | CHAR01 | ||||
PAYM_HIST_PROFIL | Payment History (Metro2 -Format) | TB_CBR_PAYMENT_HIST_PROF | CHAR | 24 | CHAR24 | ||||
SPECIAL_COMMENT | Comment Key (Metro2 Format) | TB_CBR_SPECIAL_COMMENT | CHAR | 2 | CHAR02 | ||||
COMPL_COND_CODE | Comment Key (Metro2 Format) | TB_CBR_SPECIAL_COMMENT | CHAR | 2 | CHAR02 | ||||
CURRENT_BALANCE | Balance on Current Date (Metro2 - Format) | TB_CBR_CURRENT_BALANCE | NUMC | 9 | T_CBR_AMOUNT_METRO2 | ||||
AMOUNT_PAST_DUE | Payments Past Due (Metro2 Format) | TB_CBR_AMOUNT_PAST_DUE | NUMC | 9 | T_CBR_AMOUNT_METRO2 | ||||
CHARGE_OFF_AM | Charge-Off Amount (Metro2 Format) | TB_CBR_CHARGE_OFF_AMOUNT | NUMC | 9 | T_CBR_AMOUNT_METRO2 | ||||
BILLING_DATE | Bill Creation Date | TB_BILL_DATE | DATS | 8 | DATS | ||||
FCRA_DATE | Date of First Delinquency (Metro2 - Format) | TB_CBR_FCRA_DATE | DATS | 8 | DATS | ||||
DATE_CLOSED | Contract End Date | TB_CBR_DATE_CLOSED | DATS | 8 | DATS | ||||
LAST_PAYM_DATE | Date of Last Incoming Payment | TB_CBR_DATE_LAST_PAYMENT | DATS | 8 | DATS | ||||
RESERVE | Reserve Bytes (Length 17) | TB_CBR_RESERVE_17 | CHAR | 17 | CHAR17 | ||||
CONS_TRANS_TYPE | Changes to Borrower | TB_CBR_CONSUMER_TRANS_TYPE | CHAR | 1 | CHAR01 | ||||
SURNAME | Last Name (Metro2 Format) | TB_CBR_SURNAME | CHAR | 25 | CHAR25 | ||||
FIRST_NAME | First Name (Metro2 Format) | TB_CBR_FIRST_NAME | CHAR | 20 | CHAR20 | ||||
MIDDLE_NAME | Middle Name (Metro2 Format) | TB_CBR_MIDDLE_NAME | CHAR | 20 | CHAR20 | ||||
GENERATION_CODE | Generation Code (Metro2 Format) | TB_CBR_GENERATION_CODE | CHAR | 1 | CHAR01 | ||||
SOCIAL_SEC_NO | Social Security Number (Metro2 Format) | TB_CBR_SOZ_SECURITY_NUM | CHAR | 9 | CHAR9 | ||||
DATE_OF_BIRTH | Date of Birth (Metro2 Format) | TB_CBR_BIRTH_DATE | DATS | 8 | DATS | ||||
TEL_NUMBER | Telephone Number (Metro2 Format) | TB_CBR_TEL_NUM | NUMC | 10 | NUMC10 | ||||
ECOA_CODE | Business Partner Role for Loan (Metro2 Format) | TB_CBR_ECOA_CODE | CHAR | 1 | CHAR01 | ||||
CONS_INFO_IND | Bankruptcy Phase of Business Partner (Metro2 Format) | TB_CBR_CONS_INFO_INDICATOR | CHAR | 2 | CHAR02 | ||||
COUNTRY_CODE | Country Key (Metro2 Format) | TB_CBR_COUNTRY_CODE | CHAR | 2 | CHAR02 | ||||
FIRST_ADR_LINE | Address Line (Metro2 Format) | TB_CBR_FIRST_ADR_LINE | CHAR | 32 | CHAR32 | ||||
SECOND_ADR_LINE | Address Line (Metro2 Format) | TB_CBR_FIRST_ADR_LINE | CHAR | 32 | CHAR32 | ||||
CITY | City (Metro2 Format) | TB_CBR_CITY | CHAR | 20 | CHAR20 | ||||
STATE | State Identification (Metro 2 Format) | TB_CBR_STATE | CHAR | 2 | CHAR02 | ||||
POSTAL_CODE | Postal Code (Metro2 Format) | TB_CBR_POSTAL_CODE | CHAR | 9 | CHAR9 | ||||
ADR_INDICATOR | Indicator Field for Address (Metro2 Format) | TB_CBR_ADR_INDICATOR | CHAR | 1 | CHAR01 | ||||
RESID_CODE | Residence Code for Metro2 Format | TB_CBR_RESIDENCE_CODE | CHAR | 1 | CHAR01 | ||||
SEGMENT_IDENT7 | Indicator for Segment | TB_CBR_SEGM_IDENT | CHAR | 2 | CHAR02 | ||||
EMPLOYER_NAME | Name of Employer | TB_CBR_EMPL_NAME | CHAR | 30 | CHAR30 | ||||
EMP_FI_ADR_LINE | Address Line (Metro2 Format) | TB_CBR_FIRST_ADR_LINE | CHAR | 32 | CHAR32 | ||||
EMP_CITY | City (Metro2 Format) | TB_CBR_CITY | CHAR | 20 | CHAR20 | ||||
EMP_STATE | State Identification (Metro 2 Format) | TB_CBR_STATE | CHAR | 2 | CHAR02 | ||||
EMP_POST_CODE | Postal Code (Metro2 Format) | TB_CBR_POSTAL_CODE | CHAR | 9 | CHAR9 | ||||
OCCUPATION | Name of Occupation (Metro2 Format) | TB_CBR_OCCUPATION | CHAR | 18 | CHAR18 | ||||
RESERVE7 | Place Holder for 1 Byte | TB_CBR_RESERVE_1 | CHAR | 1 | CHAR01 | ||||
SEGMENT_IDENT6 | Indicator for Segment | TB_CBR_SEGM_IDENT | CHAR | 2 | CHAR02 | ||||
SPEC_PAYM_IND | Payment Arrangements (MEtro2 Format) | TB_CBR_PAYMENT_INDICATOR | CHAR | 2 | T_CBR_PAYMENT_INDICATOR | ||||
DEF_PAYM_START | Start Date of Derffered Repayments (Metro2 Format) | TB_CBR_DEFER_PAYM_START_DATE | DATS | 8 | DATS | ||||
PAYM_DUE_DATE | Due Date of Final Installment (Metro2 - Format) | TB_CBR_PAYM_DUE_DATE | DATS | 8 | DATS | ||||
PAYM_AMOUNT | Final Installment Amount (Ballon) (Metro2 Format) | TB_CBR_PAYM_AMOUNT | NUMC | 9 | T_CBR_AMOUNT_METRO2 | ||||
RESERVE6 | Place Holder for 1 Byte | TB_CBR_RESERVE_1 | CHAR | 1 | CHAR01 |
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 tableDATA: 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 asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects