VDCBR_RES_PART SAP (Partner Data Reported to Credit Bureau (Pro Loan)) Table details
Dictionary Type: Table
Description: Partner Data Reported to Credit Bureau (Pro Loan)
Description: Partner Data Reported to Credit Bureau (Pro Loan)
ABAP Code to SELECT data from VDCBR_RES_PART
Related tables to VDCBR_RES_PART
Access table VDCBR_RES_PART
Related tables to VDCBR_RES_PART
Access table VDCBR_RES_PART
Table field list including key, data, relationships and ABAP select examples
VDCBR_RES_PART is a standard SAP Table which is used to store Partner Data Reported to Credit Bureau (Pro Loan) data and is available within R/3 SAP systems depending on the version and release level.
The VDCBR_RES_PART table consists of various fields, each holding specific information or linking keys about Partner Data Reported to Credit Bureau (Pro Loan) data available in SAP. These include BUKRS (Company Code), RANL (Contract Number), CREATION_DATE (Created On), CREATION_TIME (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_PART 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 | ||
| CREATION_DATE | Created On | TB_CBR_CREATION_DATE | DATS | 8 | DATS | ||||
| CREATION_TIME | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC | 15 | TZNTSTMPS | ||||
| PARTNER | Business Partner Number | BP_PARTNR_NEW | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
| ROLE | Business Partner Role Category | BP_ROLETYP_OLD | CHAR | 4 | Assigned to domain | BP_ROLETYP | BPR | ||
| HIST_PROF | Payment History (Metro2 -Format) | TB_CBR_PAYMENT_HIST_PROF | CHAR | 24 | CHAR24 | ||||
| SEGM_ID | Indicator for Segment | TB_CBR_SEGM_IDENT | CHAR | 2 | CHAR02 | ||||
| CON_TR_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 | ||||
| GEN_CODE | Generation Code (Metro2 Format) | TB_CBR_GENERATION_CODE | CHAR | 1 | CHAR01 | ||||
| SOC_SEC_NUM | Social Security Number (Metro2 Format) | TB_CBR_SOZ_SECURITY_NUM | CHAR | 9 | CHAR9 | ||||
| BIRTH_DATE | 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 | ||||
| FADR_LINE | Address Line (Metro2 Format) | TB_CBR_FIRST_ADR_LINE | CHAR | 32 | CHAR32 | ||||
| SADR_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 | ||||
| POST_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 | ||||
| RESERVE2 | Placeholder for 2 Bytes | TB_CBR_RESERVE_2 | CHAR | 2 | CHAR02 |
| Key field | Non-key field |
How do I retrieve data from SAP table VDCBR_RES_PART using ABAP code
The following ABAP code Example will allow you to do a basic selection on VDCBR_RES_PART to SELECT all data from the tableDATA: WA_VDCBR_RES_PART TYPE VDCBR_RES_PART.
SELECT SINGLE *
FROM VDCBR_RES_PART
INTO CORRESPONDING FIELDS OF WA_VDCBR_RES_PART
WHERE...
How to access SAP table VDCBR_RES_PART
Within an ECC or HANA version of SAP you can also view further information about VDCBR_RES_PART 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