1. SAP Tutorial
  2. Financial Services

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

    • VDCBR_RES_DATA related tables

    • TDCBR_PAR : Define Parameters for Credit Bureau
    • VDCBR_CONTROL : Data Selection for Credit Bureau
    • TDCBRSTSMA : Assignment of Status Profile to Credit Bureau Field
    • VDCBR_RES_DATA : Table of Data Reported to Credit Bureau (Per Loan)
    • VDCBR_RES_HT : Header and Totals Records for Data Reported to Credit Bur.
    • VDCBR_HIST : History of Data Supplied to Credit Bureau
    • VDCBR_RES_PART : Partner Data Reported to Credit Bureau (Pro Loan)
    • TDCBRSTATFLD : Assignment of Status Field No. to Credit Bureau Field Name

    VDCBR_RES_DATA related transaction codes under SAP package FVVD_CREDIT_BUREAU

    • FN_CBR_PROCESS : Create Files for Credit Bureau
    • FN_CBR_INFO : Display Files for Credit Bureau

    Related References

    Related Tutorials

    VDCBR_RES_PART SAP table for – Partner Data Reported to Credit Bureau (Pro Loan)

    VDCBR_RES_PART table in SAP FS (Loans Management in FS) module. This table is used for storing data of Partner Data...

    VDCBR_RES_HT SAP table for – Header and Totals Records for Data Reported to Credit Bur.

    VDCBR_RES_HT table in SAP FS (Loans Management in FS) module. This table is used for storing data of Header and...

    VDCBR_HIST SAP table for – History of Data Supplied to Credit Bureau

    VDCBR_HIST table in SAP FS (Loans Management in FS) module. This table is used for storing data of History of...

    VDCBR_CONTROL SAP table for – Data Selection for Credit Bureau

    VDCBR_CONTROL table in SAP FS (Loans Management in FS) module. This table is used for storing data of Data Selection...

    TDCBR_PAR SAP table for – Define Parameters for Credit Bureau

    TDCBR_PAR table in SAP FS (Loans Management in FS) module. This table is used for storing data of Define Parameters...

    TDCBRSTSMA SAP table for – Assignment of Status Profile to Credit Bureau Field

    TDCBRSTSMA table in SAP FS (Loans Management in FS) module. This table is used for storing data of Assignment of...

    TDCBRSTATFLD SAP table for – Assignment of Status Field No. to Credit Bureau Field Name

    TDCBRSTATFLD table in SAP FS (Loans Management in FS) module. This table is used for storing data of Assignment of...

    «
    »