SAP ABAP Table VDCBR_RES_DATA (Table of Data Reported to Credit Bureau (Per Loan))

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FS-CML (Application Component) Loans Management
     ⤷ FVVD_CREDIT_BUREAU (Package) Data for Credit Bureau Reporting

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	VDCBR_RES_DATA	Table Relationship Diagram
Short Description	Table of Data Reported to Credit Bureau (Per Loan)

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	BUKRS	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	*
3	RANL	☑	RANL	RANL	CHAR	13	0	Contract Number
4	DATE_CREA	☑	TB_CBR_CREATION_DATE	DATS	DATS	8	0	Created On
5	TIME_CREA	☑	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
6	.INCLUDE	☐				0	0	Basis Segment of Output File for Credit Bur. (Metro2 Format)
7	BDW	☐	TB_CBR_BLOCK_DESC_WORD	NUMC4	NUMC	4	0	Block Length Field for Output in File
8	RDW	☐	TB_CBR_REC_DESC_WORD	NUMC4	NUMC	4	0	Record Length Field
9	PROCESS_IND	☐	TB_CBR_INDICATOR	NUMC1	NUMC	1	0	Indicator for Forwarding Data in Metro2 Format
10	TIMESTAMP	☐	TB_CBR_TIMESTAMP	CHAR15	CHAR	15	0	UTC Time Stamp (Metro2 Format)
11	CORRECTION_IND	☐	TB_CBR_INDICATOR	NUMC1	NUMC	1	0	Indicator for Forwarding Data in Metro2 Format
12	IDENT_NO	☐	TB_CBR_IDENT_NUMBER	CHAR20	CHAR	20	0	Nuber of Data Provider
13	CYCLE_IDENT	☐	TB_CBR_CYCLE_NUMBER	CHAR02	CHAR	2	0	Cycle for Reporting to Credit Bureau
14	CONSUMER_ACC_NO	☐	TB_CBR_ACCOUNT_NO_30	CHAR30	CHAR	30	0	Loan Number (30 Characters) (Metro2 Format)
15	PORTFOLIO_TYPE	☐	TB_CBR_PORTFOLIO_TYPE	T_CBR_PORTFOLIO_TYPE	CHAR	1	0	Loan Type
16	ACCOUNT_TYPE	☐	TB_CBR_ACCOUNT_TYPE	T_CBR_ACCOUNT_TYPE	CHAR	2	0	Loan Type (Metro2 Format)
17	DATE_OPENED	☐	DERF	DATUM	DATS	8	0	First Entered on
18	CREDIT_LIMIT	☐	TB_CBR_CREDIT_LIMIT	T_CBR_AMOUNT_METRO2	NUMC	9	0	Credit Limit in (Metro2 Format)
19	O_LOAN_AMOUNT	☐	TB_CBR_ORG_LOAN_AMOUNT	T_CBR_AMOUNT_METRO2	NUMC	9	0	Loan Amount (Metro2 Format)
20	TERMS_DURATION	☐	TB_CBR_TERMS_DURATION	CHAR03	CHAR	3	0	Loan Term (Metro2 Format)
21	TERMS_FREQUENCY	☐	TB_CBR_TERMS_FREQUENCY	CHAR01	CHAR	1	0	Frequency of Payment Due Date (Metro2 Format)
22	MON_PAYM_AMOUNT	☐	TB_CBR_MON_PAYM_AMOUNT	T_CBR_AMOUNT_METRO2	NUMC	9	0	Planned Monthly Payment Amount
23	ACT_PAYM_AMOUNT	☐	TB_CBR_ACT_PAYM_AMOUNT	T_CBR_AMOUNT_METRO2	NUMC	9	0	Amount Paid to Current Date (Metro2 Format)
24	ACCOUNT_STATUS	☐	TB_CBR_ACCOUNT_STATUS	CHAR02	CHAR	2	0	Loan Status (Metro2-Format)
25	PAYMENT_RATING	☐	TB_CBR_PAYMENT_RATING	CHAR01	CHAR	1	0	Payment Rating
26	PAYM_HIST_PROFIL	☐	TB_CBR_PAYMENT_HIST_PROF	CHAR24	CHAR	24	0	Payment History (Metro2 -Format)
27	SPECIAL_COMMENT	☐	TB_CBR_SPECIAL_COMMENT	CHAR02	CHAR	2	0	Comment Key (Metro2 Format)
28	COMPL_COND_CODE	☐	TB_CBR_SPECIAL_COMMENT	CHAR02	CHAR	2	0	Comment Key (Metro2 Format)
29	CURRENT_BALANCE	☐	TB_CBR_CURRENT_BALANCE	T_CBR_AMOUNT_METRO2	NUMC	9	0	Balance on Current Date (Metro2 - Format)
30	AMOUNT_PAST_DUE	☐	TB_CBR_AMOUNT_PAST_DUE	T_CBR_AMOUNT_METRO2	NUMC	9	0	Payments Past Due (Metro2 Format)
31	CHARGE_OFF_AM	☐	TB_CBR_CHARGE_OFF_AMOUNT	T_CBR_AMOUNT_METRO2	NUMC	9	0	Charge-Off Amount (Metro2 Format)
32	BILLING_DATE	☐	TB_BILL_DATE	DATS	DATS	8	0	Bill Creation Date
33	FCRA_DATE	☐	TB_CBR_FCRA_DATE	DATS	DATS	8	0	Date of First Delinquency (Metro2 - Format)
34	DATE_CLOSED	☐	TB_CBR_DATE_CLOSED	DATS	DATS	8	0	Contract End Date
35	LAST_PAYM_DATE	☐	TB_CBR_DATE_LAST_PAYMENT	DATS	DATS	8	0	Date of Last Incoming Payment
36	RESERVE	☐	TB_CBR_RESERVE_17	CHAR17	CHAR	17	0	Reserve Bytes (Length 17)
37	CONS_TRANS_TYPE	☐	TB_CBR_CONSUMER_TRANS_TYPE	CHAR01	CHAR	1	0	Changes to Borrower
38	SURNAME	☐	TB_CBR_SURNAME	CHAR25	CHAR	25	0	Last Name (Metro2 Format)
39	FIRST_NAME	☐	TB_CBR_FIRST_NAME	CHAR20	CHAR	20	0	First Name (Metro2 Format)
40	MIDDLE_NAME	☐	TB_CBR_MIDDLE_NAME	CHAR20	CHAR	20	0	Middle Name (Metro2 Format)
41	GENERATION_CODE	☐	TB_CBR_GENERATION_CODE	CHAR01	CHAR	1	0	Generation Code (Metro2 Format)
42	SOCIAL_SEC_NO	☐	TB_CBR_SOZ_SECURITY_NUM	CHAR9	CHAR	9	0	Social Security Number (Metro2 Format)
43	DATE_OF_BIRTH	☐	TB_CBR_BIRTH_DATE	DATS	DATS	8	0	Date of Birth (Metro2 Format)
44	TEL_NUMBER	☐	TB_CBR_TEL_NUM	NUMC10	NUMC	10	0	Telephone Number (Metro2 Format)
45	ECOA_CODE	☐	TB_CBR_ECOA_CODE	CHAR01	CHAR	1	0	Business Partner Role for Loan (Metro2 Format)
46	CONS_INFO_IND	☐	TB_CBR_CONS_INFO_INDICATOR	CHAR02	CHAR	2	0	Bankruptcy Phase of Business Partner (Metro2 Format)
47	COUNTRY_CODE	☐	TB_CBR_COUNTRY_CODE	CHAR02	CHAR	2	0	Country Key (Metro2 Format)
48	FIRST_ADR_LINE	☐	TB_CBR_FIRST_ADR_LINE	CHAR32	CHAR	32	0	Address Line (Metro2 Format)
49	SECOND_ADR_LINE	☐	TB_CBR_FIRST_ADR_LINE	CHAR32	CHAR	32	0	Address Line (Metro2 Format)
50	CITY	☐	TB_CBR_CITY	CHAR20	CHAR	20	0	City (Metro2 Format)
51	STATE	☐	TB_CBR_STATE	CHAR02	CHAR	2	0	State Identification (Metro 2 Format)
52	POSTAL_CODE	☐	TB_CBR_POSTAL_CODE	CHAR9	CHAR	9	0	Postal Code (Metro2 Format)
53	ADR_INDICATOR	☐	TB_CBR_ADR_INDICATOR	CHAR01	CHAR	1	0	Indicator Field for Address (Metro2 Format)
54	RESID_CODE	☐	TB_CBR_RESIDENCE_CODE	CHAR01	CHAR	1	0	Residence Code for Metro2 Format
55	.INCLUDE	☐				0	0	N1 Segment of Output File for Credit Bur. (Metro2 - Format)
56	SEGMENT_IDENT7	☐	TB_CBR_SEGM_IDENT	CHAR02	CHAR	2	0	Indicator for Segment
57	EMPLOYER_NAME	☐	TB_CBR_EMPL_NAME	CHAR30	CHAR	30	0	Name of Employer
58	EMP_FI_ADR_LINE	☐	TB_CBR_FIRST_ADR_LINE	CHAR32	CHAR	32	0	Address Line (Metro2 Format)
59	EMP_CITY	☐	TB_CBR_CITY	CHAR20	CHAR	20	0	City (Metro2 Format)
60	EMP_STATE	☐	TB_CBR_STATE	CHAR02	CHAR	2	0	State Identification (Metro 2 Format)
61	EMP_POST_CODE	☐	TB_CBR_POSTAL_CODE	CHAR9	CHAR	9	0	Postal Code (Metro2 Format)
62	OCCUPATION	☐	TB_CBR_OCCUPATION	CHAR18	CHAR	18	0	Name of Occupation (Metro2 Format)
63	RESERVE7	☐	TB_CBR_RESERVE_1	CHAR01	CHAR	1	0	Place Holder for 1 Byte
64	.INCLUDE	☐				0	0	K4 Segment of Output File for Credit Bur. (Metro2 - Format)
65	SEGMENT_IDENT6	☐	TB_CBR_SEGM_IDENT	CHAR02	CHAR	2	0	Indicator for Segment
66	SPEC_PAYM_IND	☐	TB_CBR_PAYMENT_INDICATOR	T_CBR_PAYMENT_INDICATOR	CHAR	2	0	Payment Arrangements (MEtro2 Format)
67	DEF_PAYM_START	☐	TB_CBR_DEFER_PAYM_START_DATE	DATS	DATS	8	0	Start Date of Derffered Repayments (Metro2 Format)
68	PAYM_DUE_DATE	☐	TB_CBR_PAYM_DUE_DATE	DATS	DATS	8	0	Due Date of Final Installment (Metro2 - Format)
69	PAYM_AMOUNT	☐	TB_CBR_PAYM_AMOUNT	T_CBR_AMOUNT_METRO2	NUMC	9	0	Final Installment Amount (Ballon) (Metro2 Format)
70	RESERVE6	☐	TB_CBR_RESERVE_1	CHAR01	CHAR	1	0	Place Holder for 1 Byte

History

Last changed by/on	SAP	20130529
SAP Release Created in	600