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

Here we would like to draw your attention to VDCBR_RES_HT 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_HT is a SAP standard transp table used for storing Header and Totals Records for Data Reported to Credit Bur. related data in SAP. It comes under the package FVVD_CREDIT_BUREAU.

SAP VDCBR_RES_HT table

Table VDCBR_RES_HT technical data

TableVDCBR_RES_HT
Data storingHeader and Totals Records for Data Reported to Credit Bur.
ModuleFS
Sub ModuleFS-CML
SAP PackageFVVD_CREDIT_BUREAU
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FINSERV
Table CategoryTRANSP

SAP VDCBR_RES_HT 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_HT table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • 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 : Header Record 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
  • RECORD_ID : Key for Header Record of Reporting File
    Its data type is CHAR (Character String) with field length 6
  • CYCLE_NUM : Cycle for Reporting to Credit Bureau
    Its data type is CHAR (Character String) with field length 2
  • INNOVIS_PGM_ID : Identification Key for Credit Bureau Innovis
    Its data type is CHAR (Character String) with field length 10
  • EQUIFAX_PGM_ID : Identification Key for Credit Bureau Equifax
    Its data type is CHAR (Character String) with field length 10
  • EXPERIAN_PGM_ID : Identification Key for Credit Bureau Experian
    Its data type is CHAR (Character String) with field length 5
  • TRANSUN_PGM_ID : Identification Key for Credit Bureau Transunion
    Its data type is CHAR (Character String) with field length 10
  • ACTIVITY_DATE : Date of Last Change
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CREATION_DATE : Created On
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • PGM_DATE : Date of Development Release
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • PGM_REV_DATE : Date of Support Package
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • REPORTER_NAME : Name of Data Provider
    Its data type is CHAR (Character String) with field length 40
  • REPORTER_ADR : Address of Data Provider
    Its data type is CHAR (Character String) with field length 96
  • REPORTER_PHONE : Telephone Number of Data Provider
    Its data type is CHAR (Character String) with field length 10
  • SW_VENDOR_NAME : Name of Software Producer
    Its data type is CHAR (Character String) with field length 40
  • SW_VERS_NO : Software Release Number (Metro2 Format)
    Its data type is CHAR (Character String) with field length 5
  • .INCLUDE : Trailer Record of Output File for Credit Bur.(Metro2 Format)
  • RDW1 : Record Length Field
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • RECORD_IDENT : Record Description Length 7 (Metro2 Format)
    Its data type is CHAR (Character String) with field length 7
  • SUM_BASE_REC : Total (Metro2 Format)
    Its data type is NUMC (Character String with Digits Only) with field length 9
  • RESERVE01 : Placeholder for 9 Bytes
    Its data type is CHAR (Character String) with field length 9
  • RESERVE02 : Placeholder for 9 Bytes
    Its data type is CHAR (Character String) with field length 9
  • TOTAL_J1_SEGM : Total (Metro2 Format)
    Its data type is NUMC (Character String with Digits Only) with field length 9
  • TOTAL_J2_SEGM : Total (Metro2 Format)
    Its data type is NUMC (Character String with Digits Only) with field length 9
  • BLOCK_COUNT : Total (Metro2 Format)
    Its data type is NUMC (Character String with Digits Only) with field length 9
  • SUM_ST_CODE_DA : Total (Metro2 Format)
    Its data type is NUMC (Character String with Digits Only) with field length 9
  • SUM_ST_CODE_05 : Total (Metro2 Format)
    Its data type is NUMC (Character String with Digits Only) with field length 9
  • SUM_ST_CODE_11 : Total (Metro2 Format)
    Its data type is NUMC (Character String with Digits Only) with field length 9
  • SUM_ST_CODE_13 : Total (Metro2 Format)
    Its data type is NUMC (Character String with Digits Only) with field length 9
  • SUM_ST_CODE_61 : Total (Metro2 Format)
    Its data type is NUMC (Character String with Digits Only) with field length 9
  • SUM_ST_CODE_62 : Total (Metro2 Format)
    Its data type is NUMC (Character String with Digits Only) with field length 9
  • SUM_ST_CODE_63 : Total (Metro2 Format)
    Its data type is NUMC (Character String with Digits Only) with field length 9
  • SUM_ST_CODE_64 : Total (Metro2 Format)
    Its data type is NUMC (Character String with Digits Only) with field length 9
  • SUM_ST_CODE_65 : Total (Metro2 Format)
    Its data type is NUMC (Character String with Digits Only) with field length 9
  • SUM_ST_CODE_71 : Total (Metro2 Format)
    Its data type is NUMC (Character String with Digits Only) with field length 9
  • SUM_ST_CODE_78 : Total (Metro2 Format)
    Its data type is NUMC (Character String with Digits Only) with field length 9
  • SUM_ST_CODE_80 : Total (Metro2 Format)
    Its data type is NUMC (Character String with Digits Only) with field length 9
  • SUM_ST_CODE_82 : Total (Metro2 Format)
    Its data type is NUMC (Character String with Digits Only) with field length 9
  • SUM_ST_CODE_83 : Total (Metro2 Format)
    Its data type is NUMC (Character String with Digits Only) with field length 9
  • SUM_ST_CODE_84 : Total (Metro2 Format)
    Its data type is NUMC (Character String with Digits Only) with field length 9
  • SUM_ST_CODE_88 : Total (Metro2 Format)
    Its data type is NUMC (Character String with Digits Only) with field length 9
  • SUM_ST_CODE_89 : Total (Metro2 Format)
    Its data type is NUMC (Character String with Digits Only) with field length 9
  • SUM_ST_CODE_93 : Total (Metro2 Format)
    Its data type is NUMC (Character String with Digits Only) with field length 9
  • SUM_ST_CODE_94 : Total (Metro2 Format)
    Its data type is NUMC (Character String with Digits Only) with field length 9
  • SUM_ST_CODE_95 : Total (Metro2 Format)
    Its data type is NUMC (Character String with Digits Only) with field length 9
  • SUM_ST_CODE_96 : Total (Metro2 Format)
    Its data type is NUMC (Character String with Digits Only) with field length 9
  • SUM_ST_CODE_97 : Total (Metro2 Format)
    Its data type is NUMC (Character String with Digits Only) with field length 9
  • SUM_ECOA_CODE_Z : Total (Metro2 Format)
    Its data type is NUMC (Character String with Digits Only) with field length 9
  • SUM_EMP_SEGM : Total (Metro2 Format)
    Its data type is NUMC (Character String with Digits Only) with field length 9
  • SUM_ORG_CRED : Total (Metro2 Format)
    Its data type is NUMC (Character String with Digits Only) with field length 9
  • SUM_PUR_SOLD : Total (Metro2 Format)
    Its data type is NUMC (Character String with Digits Only) with field length 9
  • SUM_MOR_INF_SEGM : Total (Metro2 Format)
    Its data type is NUMC (Character String with Digits Only) with field length 9
  • SUM_SPECIAL_PAYM : Total (Metro2 Format)
    Its data type is NUMC (Character String with Digits Only) with field length 9
  • SUM_CHANGE_SEGM : Total (Metro2 Format)
    Its data type is NUMC (Character String with Digits Only) with field length 9
  • SUM_SOCIAL_ALL : Total (Metro2 Format)
    Its data type is NUMC (Character String with Digits Only) with field length 9
  • SUM_SOCIAL_BAS : Total (Metro2 Format)
    Its data type is NUMC (Character String with Digits Only) with field length 9
  • SUM_SOCIAL_J1 : Total (Metro2 Format)
    Its data type is NUMC (Character String with Digits Only) with field length 9
  • SUM_SOCIAL_J2 : Total (Metro2 Format)
    Its data type is NUMC (Character String with Digits Only) with field length 9
  • SUM_BIRTH_ALL : Total (Metro2 Format)
    Its data type is NUMC (Character String with Digits Only) with field length 9
  • SUM_BIRTH_BAS : Total (Metro2 Format)
    Its data type is NUMC (Character String with Digits Only) with field length 9
  • SUM_BIRTH_J1 : Total (Metro2 Format)
    Its data type is NUMC (Character String with Digits Only) with field length 9
  • SUM_BIRTH_2 : Total (Metro2 Format)
    Its data type is NUMC (Character String with Digits Only) with field length 9
  • SUM_TEL_NO_ALL : Total (Metro2 Format)
    Its data type is NUMC (Character String with Digits Only) with field length 9
  • RESERVED3 : Place Holder for 19 Bytes (Metro2 Format)
    Its data type is CHAR (Character String) with field length 19