SAP Table VDCBR_RES_PART - Partner Data Reported to Credit Bureau (Pro Loan)

Field Key Data Element Type Offset Leng Decimals Check Table Text
MANDT X MANDT CLNT 0 3 0 T000 Client
BUKRS X BUKRS CHAR 3 4 0 T001 Company Code
RANL X RANL CHAR 7 13 0 Contract Number
CREATION_DATE X TB_CBR_CREATION_DATE DATS 20 8 0 Created On
CREATION_TIME X TIMESTAMP DEC 28 15 0 UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
PARTNER X BP_PARTNR_NEW CHAR 36 10 0 Business Partner Number
ROLE BP_ROLETYP_OLD CHAR 46 4 0 TPZ3 Business Partner Role Category
HIST_PROF TB_CBR_PAYMENT_HIST_PROF CHAR 50 24 0 Payment History (Metro2 -Format)
SEGM_ID TB_CBR_SEGM_IDENT CHAR 74 2 0 Indicator for Segment
CON_TR_TYPE TB_CBR_CONSUMER_TRANS_TYPE CHAR 76 1 0 Changes to Borrower
SURNAME TB_CBR_SURNAME CHAR 77 25 0 Last Name (Metro2 Format)
FIRST_NAME TB_CBR_FIRST_NAME CHAR 102 20 0 First Name (Metro2 Format)
MIDDLE_NAME TB_CBR_MIDDLE_NAME CHAR 122 20 0 Middle Name (Metro2 Format)
GEN_CODE TB_CBR_GENERATION_CODE CHAR 142 1 0 Generation Code (Metro2 Format)
SOC_SEC_NUM TB_CBR_SOZ_SECURITY_NUM CHAR 143 9 0 Social Security Number (Metro2 Format)
BIRTH_DATE TB_CBR_BIRTH_DATE DATS 152 8 0 Date of Birth (Metro2 Format)
TEL_NUMBER TB_CBR_TEL_NUM NUMC 160 10 0 Telephone Number (Metro2 Format)
ECOA_CODE TB_CBR_ECOA_CODE CHAR 170 1 0 Business Partner Role for Loan (Metro2 Format)
CONS_INFO_IND TB_CBR_CONS_INFO_INDICATOR CHAR 171 2 0 Bankruptcy Phase of Business Partner (Metro2 Format)
COUNTRY_CODE TB_CBR_COUNTRY_CODE CHAR 173 2 0 Country Key (Metro2 Format)
FADR_LINE TB_CBR_FIRST_ADR_LINE CHAR 175 32 0 Address Line (Metro2 Format)
SADR_LINE TB_CBR_FIRST_ADR_LINE CHAR 207 32 0 Address Line (Metro2 Format)
CITY TB_CBR_CITY CHAR 239 20 0 City (Metro2 Format)
STATE TB_CBR_STATE CHAR 259 2 0 State Identification (Metro 2 Format)
POST_CODE TB_CBR_POSTAL_CODE CHAR 261 9 0 Postal Code (Metro2 Format)
ADR_INDICATOR TB_CBR_ADR_INDICATOR CHAR 270 1 0 Indicator Field for Address (Metro2 Format)
RESID_CODE TB_CBR_RESIDENCE_CODE CHAR 271 1 0 Residence Code for Metro2 Format
RESERVE2 TB_CBR_RESERVE_2 CHAR 272 2 0 Placeholder for 2 Bytes