SAP ABAP Table VDCORR_ALOI (Loans: Search Index for Correspondence (Document Finder))

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FS-CML (Application Component) Loans Management
     ⤷ FVVD_CORR_PRINT (Package) Loans: Central Modules for Correspondence Tool

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	VDCORR_ALOI	Table Relationship Diagram
Short Description	Loans: Search Index for Correspondence (Document Finder)

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	BUKRS	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	*
3	RANL	☑	RANL	RANL	CHAR	13	0	Contract Number
4	CREATE_DATE	☑	DATS	DATS	DATS	8	0	Field of type DATS
5	RECEIVER_ID	☑	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
6	CORR_TYPE	☑	COTYP_KK	COTYP_KK	CHAR	4	0	Correspondence Type	*
7	ARCHIV_ID	☑	SAEARCHIVI	SADC2_AR	CHAR	2	0	Content Repository Identification	TOAAR
8	ARC_DOC_ID	☑	SAEARDOID	SADC40	CHAR	40	0	SAP ArchiveLink: Document ID
9	SAP_OBJECT	☐	SAEANWDID	OJ_NAME	CHAR	10	0	SAP ArchiveLink: Object type of business object	TOJTB
10	OBJECT_ID	☐	SAEOBJID	SADC50	CHAR	50	0	SAP ArchiveLink: Object ID (object identifier)
11	AR_OBJECT	☐	SAEOBJART	SADC10_DV	CHAR	10	0	Document type	TOADV
12	DOC_CLASS	☐	SAEDOCETYP	SADC20	CHAR	20	0	SAP ArchiveLink: Technical document class
13	REFDATE	☐	TB_CORR_REFERENCE_DATE	DATUM	DATS	8	0	Reference Date for Creating Correspondence
14	BANKS	☐	BANKS	LAND1	CHAR	3	0	Bank country key	T005
15	BANKL	☐	BANKK	BANKK	CHAR	15	0	Bank Keys
16	CURRENCY	☐	SWHR	WAERS	CUKY	5	0	Currency	TCURC
17	STMTNREKA	☐	STMTNREKA	NUMC07	NUMC	7	0	Number of last account statement
18	BEGRU	☐	BEGRU	BEGRU	CHAR	4	0	Authorization Group
19	BEARB	☐	VVRSBEAR	KUNNR_VV	CHAR	10	0	Loan Officer	TZB21
20	.INCLU--AP	☐				0	0	Append for Index VDCORR_ALOI (Consumer Loans)
21	.INCLUDE	☐				0	0	Include for Correspondence ALOI (Consumer Loans)
22	ORGUNIT	☐	TB_MD_ORGUNIT_CNMGT	T_MD_ORGUNIT_CNMGT	CHAR	12	0	Organizational Unit	TD19
23	DISTRIB_CHANNEL	☐	TB_MD_DISTRIBUTION_CHANNEL	T_MD_DISTRIBUTION_CHANNEL	CHAR	10	0	Sales Channel	TD30

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VDCORR_ALOI	ARCHIV_ID	TOAAR	ARCHIV_ID
2	VDCORR_ALOI	AR_OBJECT	TOADV	AR_OBJECT
3	VDCORR_ALOI	BANKS	T005	LAND1
4	VDCORR_ALOI	BEARB	TZB21	BEARB
5	VDCORR_ALOI	CURRENCY	TCURC	WAERS
6	VDCORR_ALOI	DISTRIB_CHANNEL	TD30	DISTRIB_CHANNEL
7	VDCORR_ALOI	ORGUNIT	TD19	ORGUNIT
8	VDCORR_ALOI	SAP_OBJECT	TOJTB	NAME

History

Last changed by/on	SAP	20110901
SAP Release Created in	200