SAP VDCBR_RES_HT Header and Totals Records for Data Reported to Credit Bur. Table
Overview
VDCBR_RES_HT is a standard SAP S/4HANA table that stores Header and Totals Records for Data Reported to Credit Bur. data. There are total 67 fields in the VDCBR_RES_HT table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VDCBR_RES_HT 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_HT to other SAP tables and standard CDS views available based on VDCBR_RES_HT table in S/4HANA 2020.
Techincal Settings of VDCBR_RES_HT
Below are technical details of the table VDCBR_RES_HT
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VDCBR_RES_HT Fields
The following table gives you an overview of the fields available in VDCBR_RES_HT
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT | 3 |
| 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 | |
| RECORD_ID | Key for Header Record of Reporting File | TB_CBR_HEAD_IDENTIFIER | CHAR | 6 | |
| CYCLE_NUM | Cycle for Reporting to Credit Bureau | TB_CBR_CYCLE_NUMBER | CHAR | 2 | |
| INNOVIS_PGM_ID | Identification Key for Credit Bureau Innovis | TB_CBR_INNOVIS_ID | CHAR | 10 | |
| EQUIFAX_PGM_ID | Identification Key for Credit Bureau Equifax | TB_CBR_EQUIFAX_ID | CHAR | 10 | |
| EXPERIAN_PGM_ID | Identification Key for Credit Bureau Experian | TB_CBR_EXPERIA_ID | CHAR | 5 | |
| TRANSUN_PGM_ID | Identification Key for Credit Bureau Transunion | TB_CBR_TRANSUN_ID | CHAR | 10 | |
| ACTIVITY_DATE | Date of Last Change | TB_CBR_ACTIVITY_DATE | DATS | 8 | |
| CREATION_DATE | Created On | TB_CBR_CREATION_DATE | DATS | 8 | |
| PGM_DATE | Date of Development Release | TB_CBR_PROGRAM_DATE | DATS | 8 | |
| PGM_REV_DATE | Date of Support Package | TB_CBR_SUPPORT_DATE | DATS | 8 | |
| REPORTER_NAME | Name of Data Provider | TB_CBR_REPORTER_NAME | CHAR | 40 | |
| REPORTER_ADR | Address of Data Provider | TB_CBR_REPORTER_ADR | CHAR | 96 | |
| REPORTER_PHONE | Telephone Number of Data Provider | TB_CBR_REPORTER_PHONE | CHAR | 10 | |
| SW_VENDOR_NAME | Name of Software Producer | TB_CBR_SOFTWARE_VENDOR_NAME | CHAR | 40 | |
| SW_VERS_NO | Software Release Number (Metro2 Format) | TB_CBR_SOFTWARE_RELEASE_NO | CHAR | 5 | |
| RDW1 | Record Length Field | TB_CBR_REC_DESC_WORD | NUMC | 4 | |
| RECORD_IDENT | Record Description Length 7 (Metro2 Format) | TB_CBR_REC_IDENT_7 | CHAR | 7 | |
| SUM_BASE_REC | Total (Metro2 Format) | TB_CBR_TOTAL | NUMC | 9 | |
| RESERVE01 | Placeholder for 9 Bytes | TB_CBR_RESERVE_9 | CHAR | 9 | |
| RESERVE02 | Placeholder for 9 Bytes | TB_CBR_RESERVE_9 | CHAR | 9 | |
| TOTAL_J1_SEGM | Total (Metro2 Format) | TB_CBR_TOTAL | NUMC | 9 | |
| TOTAL_J2_SEGM | Total (Metro2 Format) | TB_CBR_TOTAL | NUMC | 9 | |
| BLOCK_COUNT | Total (Metro2 Format) | TB_CBR_TOTAL | NUMC | 9 | |
| SUM_ST_CODE_DA | Total (Metro2 Format) | TB_CBR_TOTAL | NUMC | 9 | |
| SUM_ST_CODE_05 | Total (Metro2 Format) | TB_CBR_TOTAL | NUMC | 9 | |
| SUM_ST_CODE_11 | Total (Metro2 Format) | TB_CBR_TOTAL | NUMC | 9 | |
| SUM_ST_CODE_13 | Total (Metro2 Format) | TB_CBR_TOTAL | NUMC | 9 | |
| SUM_ST_CODE_61 | Total (Metro2 Format) | TB_CBR_TOTAL | NUMC | 9 | |
| SUM_ST_CODE_62 | Total (Metro2 Format) | TB_CBR_TOTAL | NUMC | 9 | |
| SUM_ST_CODE_63 | Total (Metro2 Format) | TB_CBR_TOTAL | NUMC | 9 | |
| SUM_ST_CODE_64 | Total (Metro2 Format) | TB_CBR_TOTAL | NUMC | 9 | |
| SUM_ST_CODE_65 | Total (Metro2 Format) | TB_CBR_TOTAL | NUMC | 9 | |
| SUM_ST_CODE_71 | Total (Metro2 Format) | TB_CBR_TOTAL | NUMC | 9 | |
| SUM_ST_CODE_78 | Total (Metro2 Format) | TB_CBR_TOTAL | NUMC | 9 | |
| SUM_ST_CODE_80 | Total (Metro2 Format) | TB_CBR_TOTAL | NUMC | 9 | |
| SUM_ST_CODE_82 | Total (Metro2 Format) | TB_CBR_TOTAL | NUMC | 9 | |
| SUM_ST_CODE_83 | Total (Metro2 Format) | TB_CBR_TOTAL | NUMC | 9 | |
| SUM_ST_CODE_84 | Total (Metro2 Format) | TB_CBR_TOTAL | NUMC | 9 | |
| SUM_ST_CODE_88 | Total (Metro2 Format) | TB_CBR_TOTAL | NUMC | 9 | |
| SUM_ST_CODE_89 | Total (Metro2 Format) | TB_CBR_TOTAL | NUMC | 9 | |
| SUM_ST_CODE_93 | Total (Metro2 Format) | TB_CBR_TOTAL | NUMC | 9 | |
| SUM_ST_CODE_94 | Total (Metro2 Format) | TB_CBR_TOTAL | NUMC | 9 | |
| SUM_ST_CODE_95 | Total (Metro2 Format) | TB_CBR_TOTAL | NUMC | 9 | |
| SUM_ST_CODE_96 | Total (Metro2 Format) | TB_CBR_TOTAL | NUMC | 9 | |
| SUM_ST_CODE_97 | Total (Metro2 Format) | TB_CBR_TOTAL | NUMC | 9 | |
| SUM_ECOA_CODE_Z | Total (Metro2 Format) | TB_CBR_TOTAL | NUMC | 9 | |
| SUM_EMP_SEGM | Total (Metro2 Format) | TB_CBR_TOTAL | NUMC | 9 | |
| SUM_ORG_CRED | Total (Metro2 Format) | TB_CBR_TOTAL | NUMC | 9 | |
| SUM_PUR_SOLD | Total (Metro2 Format) | TB_CBR_TOTAL | NUMC | 9 | |
| SUM_MOR_INF_SEGM | Total (Metro2 Format) | TB_CBR_TOTAL | NUMC | 9 | |
| SUM_SPECIAL_PAYM | Total (Metro2 Format) | TB_CBR_TOTAL | NUMC | 9 | |
| SUM_CHANGE_SEGM | Total (Metro2 Format) | TB_CBR_TOTAL | NUMC | 9 | |
| SUM_SOCIAL_ALL | Total (Metro2 Format) | TB_CBR_TOTAL | NUMC | 9 | |
| SUM_SOCIAL_BAS | Total (Metro2 Format) | TB_CBR_TOTAL | NUMC | 9 | |
| SUM_SOCIAL_J1 | Total (Metro2 Format) | TB_CBR_TOTAL | NUMC | 9 | |
| SUM_SOCIAL_J2 | Total (Metro2 Format) | TB_CBR_TOTAL | NUMC | 9 | |
| SUM_BIRTH_ALL | Total (Metro2 Format) | TB_CBR_TOTAL | NUMC | 9 | |
| SUM_BIRTH_BAS | Total (Metro2 Format) | TB_CBR_TOTAL | NUMC | 9 | |
| SUM_BIRTH_J1 | Total (Metro2 Format) | TB_CBR_TOTAL | NUMC | 9 | |
| SUM_BIRTH_2 | Total (Metro2 Format) | TB_CBR_TOTAL | NUMC | 9 | |
| SUM_TEL_NO_ALL | Total (Metro2 Format) | TB_CBR_TOTAL | NUMC | 9 | |
| RESERVED3 | Place Holder for 19 Bytes (Metro2 Format) | TB_CBR_RESERVE_19 | CHAR | 19 |
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_HT