VDCORR_ALOI SAP table for – Loans: Search Index for Correspondence (Document Finder)

Here we would like to draw your attention to VDCORR_ALOI 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). VDCORR_ALOI is a SAP standard transp table used for storing Loans: Search Index for Correspondence (Document Finder) related data in SAP. It comes under the package FVVD_CORR_PRINT.

SAP VDCORR_ALOI table

Table VDCORR_ALOI technical data

TableVDCORR_ALOI
Data storingLoans: Search Index for Correspondence (Document Finder)
ModuleFS
Sub ModuleFS-CML
SAP PackageFVVD_CORR_PRINT
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FINSERV
Table CategoryTRANSP

SAP VDCORR_ALOI 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 VDCORR_ALOI 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
  • CREATE_DATE : Field of type DATS
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • RECEIVER_ID : Business Partner Number
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • CORR_TYPE : Correspondence Type
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • ARCHIV_ID : Content Repository Identification
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • ARC_DOC_ID : SAP ArchiveLink: Document ID
    Its a key field. Its data type is CHAR (Character String) with field length 40
  • SAP_OBJECT : SAP ArchiveLink: Object type of business object
    Its data type is CHAR (Character String) with field length 10
  • OBJECT_ID : SAP ArchiveLink: Object ID (object identifier)
    Its data type is CHAR (Character String) with field length 50
  • AR_OBJECT : Document type
    Its data type is CHAR (Character String) with field length 10
  • DOC_CLASS : SAP ArchiveLink: Technical document class
    Its data type is CHAR (Character String) with field length 20
  • REFDATE : Reference Date for Creating Correspondence
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BANKS : Bank country key
    Its data type is CHAR (Character String) with field length 3
  • BANKL : Bank Keys
    Its data type is CHAR (Character String) with field length 15
  • CURRENCY : Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • STMTNREKA : Number of last account statement
    Its data type is NUMC (Character String with Digits Only) with field length 7
  • BEGRU : Authorization Group
    Its data type is CHAR (Character String) with field length 4
  • BEARB : Loan Officer
    Its data type is CHAR (Character String) with field length 10
  • .INCLU–AP : Append for Index VDCORR_ALOI (Consumer Loans)
  • .INCLUDE : Include for Correspondence ALOI (Consumer Loans)
  • ORGUNIT : Organizational Unit
    Its data type is CHAR (Character String) with field length 12
  • DISTRIB_CHANNEL : Sales Channel
    Its data type is CHAR (Character String) with field length 10