SAP VDCBR_RES_PART Partner Data Reported to Credit Bureau (Pro Loan) Table
Overview
VDCBR_RES_PART is a standard SAP S/4HANA table that stores Partner Data Reported to Credit Bureau (Pro Loan) data. There are total 28 fields in the VDCBR_RES_PART table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VDCBR_RES_PART 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_PART to other SAP tables and standard CDS views available based on VDCBR_RES_PART table in S/4HANA 2020.
Techincal Settings of VDCBR_RES_PART
Below are technical details of the table VDCBR_RES_PART
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VDCBR_RES_PART Fields
The following table gives you an overview of the fields available in VDCBR_RES_PART
| 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 | |
| CREATION_DATE | Created On | TB_CBR_CREATION_DATE | DATS | 8 | |
| CREATION_TIME | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC | 15 | |
| PARTNER | Business Partner Number | BP_PARTNR_NEW | * | CHAR | 10 |
| ROLE | Business Partner Role Category | BP_ROLETYP_OLD | * | CHAR | 4 |
| HIST_PROF | Payment History (Metro2 -Format) | TB_CBR_PAYMENT_HIST_PROF | CHAR | 24 | |
| SEGM_ID | Indicator for Segment | TB_CBR_SEGM_IDENT | CHAR | 2 | |
| CON_TR_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 | |
| GEN_CODE | Generation Code (Metro2 Format) | TB_CBR_GENERATION_CODE | CHAR | 1 | |
| SOC_SEC_NUM | Social Security Number (Metro2 Format) | TB_CBR_SOZ_SECURITY_NUM | CHAR | 9 | |
| BIRTH_DATE | 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 | |
| FADR_LINE | Address Line (Metro2 Format) | TB_CBR_FIRST_ADR_LINE | CHAR | 32 | |
| SADR_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 | |
| POST_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 | |
| RESERVE2 | Placeholder for 2 Bytes | TB_CBR_RESERVE_2 | CHAR | 2 |
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_PART