SAP VDCORR_ALOI Loans: Search Index for Correspondence (Document Finder) Table
Overview
VDCORR_ALOI is a standard SAP S/4HANA table that stores Loans: Search Index for Correspondence (Document Finder) data. There are total 21 fields in the VDCORR_ALOI table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VDCORR_ALOI belongs to Loans Management (FS-CML) module and is located in the package Loans: Central Modules for Correspondence Tool (FVVD_CORR_PRINT).
In addition, following links provide an overview of foreign key relationships, if any, that link VDCORR_ALOI to other SAP tables and standard CDS views available based on VDCORR_ALOI table in S/4HANA 2020.
Techincal Settings of VDCORR_ALOI
Below are technical details of the table VDCORR_ALOI
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VDCORR_ALOI Fields
The following table gives you an overview of the fields available in VDCORR_ALOI
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT | 3 |
| BUKRS | Company Code | BUKRS | * | CHAR | 4 |
| RANL | Contract Number | RANL | CHAR | 13 | |
| CREATE_DATE | Field of type DATS | DATS | DATS | 8 | |
| RECEIVER_ID | Business Partner Number | BU_PARTNER | * | CHAR | 10 |
| CORR_TYPE | Correspondence Type | COTYP_KK | * | CHAR | 4 |
| ARCHIV_ID | Content Repository Identification | SAEARCHIVI | TOAAR | CHAR | 2 |
| ARC_DOC_ID | SAP ArchiveLink: Document ID | SAEARDOID | CHAR | 40 | |
| SAP_OBJECT | SAP ArchiveLink: Object type of business object | SAEANWDID | TOJTB | CHAR | 10 |
| OBJECT_ID | SAP ArchiveLink: Object ID (object identifier) | SAEOBJID | CHAR | 50 | |
| AR_OBJECT | Document type | SAEOBJART | TOADV | CHAR | 10 |
| DOC_CLASS | SAP ArchiveLink: Technical document class | SAEDOCETYP | CHAR | 20 | |
| REFDATE | Reference Date for Creating Correspondence | TB_CORR_REFERENCE_DATE | DATS | 8 | |
| BANKS | Bank country key | BANKS | T005 | CHAR | 3 |
| BANKL | Bank Keys | BANKK | CHAR | 15 | |
| CURRENCY | Currency | SWHR | TCURC | CUKY | 5 |
| STMTNREKA | Number of last account statement | STMTNREKA | NUMC | 7 | |
| BEGRU | Authorization Group | BEGRU | CHAR | 4 | |
| BEARB | Loan Officer | VVRSBEAR | TZB21 | CHAR | 10 |
| ORGUNIT | Organizational Unit | TB_MD_ORGUNIT_CNMGT | TD19 | CHAR | 12 |
| DISTRIB_CHANNEL | Sales Channel | TB_MD_DISTRIBUTION_CHANNEL | TD30 | CHAR | 10 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for VDCORR_ALOI
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VDCORR_ALOI | ARCHIV_ID | : | TOAAR |
| VDCORR_ALOI | AR_OBJECT | : | TOADV |
| VDCORR_ALOI | BANKS | : | T005 |
| VDCORR_ALOI | BEARB | : | TZB21 |
| VDCORR_ALOI | CURRENCY | : | TCURC |
| VDCORR_ALOI | DISTRIB_CHANNEL | : | TD30 |
| VDCORR_ALOI | ORGUNIT | : | TD19 |
| VDCORR_ALOI | SAP_OBJECT | : | TOJTB |