SAP VDUNTR File documents for loan allocation Table
Overview
VDUNTR is a standard SAP S/4HANA table that stores File documents for loan allocation data. There are total 28 fields in the VDUNTR table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VDUNTR belongs to Loans Management (FS-CML) module and is located in the package Treasury Loans (FVVD).
In addition, following links provide an overview of foreign key relationships, if any, that link VDUNTR to other SAP tables and standard CDS views available based on VDUNTR table in S/4HANA 2020.
Techincal Settings of VDUNTR
Below are technical details of the table VDUNTR
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VDUNTR Fields
The following table gives you an overview of the fields available in VDUNTR
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| SNUNTR | Number of Document in a File | SNUNTR | NUMC | 3 | |
| SAKT | File number of file for loan application | SAKT | CHAR | 32 | |
| SUART | Document Type | SUART | TD06 | CHAR | 4 |
| DEIN | Letter date of document being entered | DEIN | DATS | 8 | |
| DABG | Letter date of document being removed | DABG | DATS | 8 | |
| XOORT | Storage location of original documents | XOORT | CHAR | 32 | |
| XABLKZ | Storage indicator of file original document | XABLKZ | TD12 | CHAR | 1 |
| XBEMUN1 | Notes on the Document | XBEMUN | CHAR | 50 | |
| XBEMUN2 | Notes on the Document | XBEMUN | CHAR | 50 | |
| XBEMUN3 | Notes on the Document | XBEMUN | CHAR | 50 | |
| XBEMUN4 | Notes on the Document | XBEMUN | CHAR | 50 | |
| DUNANF | Date of Document Request | DUNANF | DATS | 8 | |
| RERF | Entered By | RERF | CHAR | 12 | |
| DERF | First Entered On | DERF | DATS | 8 | |
| TERF | Time of Creation | TERF | TIMS | 6 | |
| REHER | Source of Initial Entry | REHER | CHAR | 10 | |
| RBEAR | Employee ID | RBEAR | CHAR | 12 | |
| DBEAR | Last Edited On | DBEAR | DATS | 8 | |
| TBEAR | Last Edited At | TBEAR | TIMS | 6 | |
| RBHER | Editing Source | RBHER | CHAR | 10 | |
| BURKAP | Document amount | VVBURKAP | CURR | 13 | |
| WAERS | Currency Key | WAERS | TCURC | CUKY | 5 |
| XIURK | Document number | VVXIURK | CHAR | 15 | |
| DURK | Document date/expert opinion date | DURK | DATS | 8 | |
| VVUSTATUS | Document Status | VVUSTATUS | CHAR | 2 | |
| XRANL | Loan Number | RANLD | CHAR | 13 | |
| OBJECT_ID | SAP ArchiveLink: Object ID (object identifier) | SAEOBJID | CHAR | 50 |
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 VDUNTR
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VDUNTR | MANDT | 1: 1 | T000 |
| VDUNTR | SUART | 1: 1 | TD06 |
| VDUNTR | WAERS | 1: CN | TCURC |
| VDUNTR | XABLKZ | 1: CN | TD12 |