VDCBR_RES_DATA SAP table for – Table of Data Reported to Credit Bureau (Per Loan)

Here we would like to draw your attention to VDCBR_RES_DATA table in SAP. As we know it is being mainly used with the SAP FS-CML (Loans Management in FS) component which is coming under FS module (Financial Services). VDCBR_RES_DATA is a SAP standard transp table used for storing Table of Data Reported to Credit Bureau (Per Loan) related data in SAP. It comes under the package FVVD_CREDIT_BUREAU.

SAP VDCBR_RES_DATA table

Table VDCBR_RES_DATA technical data

TableVDCBR_RES_DATA
Data storingTable of Data Reported to Credit Bureau (Per Loan)
ModuleFS
Sub ModuleFS-CML
SAP PackageFVVD_CREDIT_BUREAU
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FINSERV
Table CategoryTRANSP

SAP VDCBR_RES_DATA Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in VDCBR_RES_DATA table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • BUKRS : Company Code
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • RANL : Contract Number
    Its a key field. Its data type is CHAR (Character String) with field length 13
  • DATE_CREA : Created On
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • TIME_CREA : UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
    Its a key field. Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • .INCLUDE : Basis Segment of Output File for Credit Bur. (Metro2 Format)
  • BDW : Block Length Field for Output in File
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • RDW : Record Length Field
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • PROCESS_IND : Indicator for Forwarding Data in Metro2 Format
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • TIMESTAMP : UTC Time Stamp (Metro2 Format)
    Its data type is CHAR (Character String) with field length 15
  • CORRECTION_IND : Indicator for Forwarding Data in Metro2 Format
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • IDENT_NO : Nuber of Data Provider
    Its data type is CHAR (Character String) with field length 20
  • CYCLE_IDENT : Cycle for Reporting to Credit Bureau
    Its data type is CHAR (Character String) with field length 2
  • CONSUMER_ACC_NO : Loan Number (30 Characters) (Metro2 Format)
    Its data type is CHAR (Character String) with field length 30
  • PORTFOLIO_TYPE : Loan Type
    Its data type is CHAR (Character String) with field length 1
  • ACCOUNT_TYPE : Loan Type (Metro2 Format)
    Its data type is CHAR (Character String) with field length 2
  • DATE_OPENED : First Entered on
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CREDIT_LIMIT : Credit Limit in (Metro2 Format)
    Its data type is NUMC (Character String with Digits Only) with field length 9
  • O_LOAN_AMOUNT : Loan Amount (Metro2 Format)
    Its data type is NUMC (Character String with Digits Only) with field length 9
  • TERMS_DURATION : Loan Term (Metro2 Format)
    Its data type is CHAR (Character String) with field length 3
  • TERMS_FREQUENCY : Frequency of Payment Due Date (Metro2 Format)
    Its data type is CHAR (Character String) with field length 1
  • MON_PAYM_AMOUNT : Planned Monthly Payment Amount
    Its data type is NUMC (Character String with Digits Only) with field length 9
  • ACT_PAYM_AMOUNT : Amount Paid to Current Date (Metro2 Format)
    Its data type is NUMC (Character String with Digits Only) with field length 9
  • ACCOUNT_STATUS : Loan Status (Metro2-Format)
    Its data type is CHAR (Character String) with field length 2
  • PAYMENT_RATING : Payment Rating
    Its data type is CHAR (Character String) with field length 1
  • PAYM_HIST_PROFIL : Payment History (Metro2 -Format)
    Its data type is CHAR (Character String) with field length 24
  • SPECIAL_COMMENT : Comment Key (Metro2 Format)
    Its data type is CHAR (Character String) with field length 2
  • COMPL_COND_CODE : Comment Key (Metro2 Format)
    Its data type is CHAR (Character String) with field length 2
  • CURRENT_BALANCE : Balance on Current Date (Metro2 – Format)
    Its data type is NUMC (Character String with Digits Only) with field length 9
  • AMOUNT_PAST_DUE : Payments Past Due (Metro2 Format)
    Its data type is NUMC (Character String with Digits Only) with field length 9
  • CHARGE_OFF_AM : Charge-Off Amount (Metro2 Format)
    Its data type is NUMC (Character String with Digits Only) with field length 9
  • BILLING_DATE : Bill Creation Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • FCRA_DATE : Date of First Delinquency (Metro2 – Format)
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DATE_CLOSED : Contract End Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • LAST_PAYM_DATE : Date of Last Incoming Payment
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • RESERVE : Reserve Bytes (Length 17)
    Its data type is CHAR (Character String) with field length 17
  • CONS_TRANS_TYPE : Changes to Borrower
    Its data type is CHAR (Character String) with field length 1
  • SURNAME : Last Name (Metro2 Format)
    Its data type is CHAR (Character String) with field length 25
  • FIRST_NAME : First Name (Metro2 Format)
    Its data type is CHAR (Character String) with field length 20
  • MIDDLE_NAME : Middle Name (Metro2 Format)
    Its data type is CHAR (Character String) with field length 20
  • GENERATION_CODE : Generation Code (Metro2 Format)
    Its data type is CHAR (Character String) with field length 1
  • SOCIAL_SEC_NO : Social Security Number (Metro2 Format)
    Its data type is CHAR (Character String) with field length 9
  • DATE_OF_BIRTH : Date of Birth (Metro2 Format)
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • TEL_NUMBER : Telephone Number (Metro2 Format)
    Its data type is NUMC (Character String with Digits Only) with field length 10
  • ECOA_CODE : Business Partner Role for Loan (Metro2 Format)
    Its data type is CHAR (Character String) with field length 1
  • CONS_INFO_IND : Bankruptcy Phase of Business Partner (Metro2 Format)
    Its data type is CHAR (Character String) with field length 2
  • COUNTRY_CODE : Country Key (Metro2 Format)
    Its data type is CHAR (Character String) with field length 2
  • FIRST_ADR_LINE : Address Line (Metro2 Format)
    Its data type is CHAR (Character String) with field length 32
  • SECOND_ADR_LINE : Address Line (Metro2 Format)
    Its data type is CHAR (Character String) with field length 32
  • CITY : City (Metro2 Format)
    Its data type is CHAR (Character String) with field length 20
  • STATE : State Identification (Metro 2 Format)
    Its data type is CHAR (Character String) with field length 2
  • POSTAL_CODE : Postal Code (Metro2 Format)
    Its data type is CHAR (Character String) with field length 9
  • ADR_INDICATOR : Indicator Field for Address (Metro2 Format)
    Its data type is CHAR (Character String) with field length 1
  • RESID_CODE : Residence Code for Metro2 Format
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : N1 Segment of Output File for Credit Bur. (Metro2 – Format)
  • SEGMENT_IDENT7 : Indicator for Segment
    Its data type is CHAR (Character String) with field length 2
  • EMPLOYER_NAME : Name of Employer
    Its data type is CHAR (Character String) with field length 30
  • EMP_FI_ADR_LINE : Address Line (Metro2 Format)
    Its data type is CHAR (Character String) with field length 32
  • EMP_CITY : City (Metro2 Format)
    Its data type is CHAR (Character String) with field length 20
  • EMP_STATE : State Identification (Metro 2 Format)
    Its data type is CHAR (Character String) with field length 2
  • EMP_POST_CODE : Postal Code (Metro2 Format)
    Its data type is CHAR (Character String) with field length 9
  • OCCUPATION : Name of Occupation (Metro2 Format)
    Its data type is CHAR (Character String) with field length 18
  • RESERVE7 : Place Holder for 1 Byte
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : K4 Segment of Output File for Credit Bur. (Metro2 – Format)
  • SEGMENT_IDENT6 : Indicator for Segment
    Its data type is CHAR (Character String) with field length 2
  • SPEC_PAYM_IND : Payment Arrangements (MEtro2 Format)
    Its data type is CHAR (Character String) with field length 2
  • DEF_PAYM_START : Start Date of Derffered Repayments (Metro2 Format)
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • PAYM_DUE_DATE : Due Date of Final Installment (Metro2 – Format)
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • PAYM_AMOUNT : Final Installment Amount (Ballon) (Metro2 Format)
    Its data type is NUMC (Character String with Digits Only) with field length 9
  • RESERVE6 : Place Holder for 1 Byte
    Its data type is CHAR (Character String) with field length 1