SAP VDSEPA_MND_USG Overview of mandates used in Loans Management Table
Overview
VDSEPA_MND_USG is a standard SAP S/4HANA table that stores Overview of mandates used in Loans Management data. There are total 21 fields in the VDSEPA_MND_USG table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VDSEPA_MND_USG 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 VDSEPA_MND_USG to other SAP tables and standard CDS views available based on VDSEPA_MND_USG table in S/4HANA 2020.
Techincal Settings of VDSEPA_MND_USG
Below are technical details of the table VDSEPA_MND_USG
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VDSEPA_MND_USG Fields
The following table gives you an overview of the fields available in VDSEPA_MND_USG
| 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 | |
| SOBJEKT | Internal key for object for business partner table | VVSOBJGPO | CHAR | 13 | |
| PARTNR | Business Partner Number | BP_PARTNR_NEW | * | CHAR | 10 |
| ROLETYP | BP Role | BU_PARTNERROLE | * | CHAR | 6 |
| DTRANS | Flow data key: System date | VVDTRANS | DATS | 8 | |
| DGUEL_KK | Date Condition Effective from | DGUEL | DATS | 8 | |
| NLFD_ANG | Offer consecutive number | NLFD_ANG | NUMC | 3 | |
| SKOART | Condition Type (Smallest Subdivision of Condition Records) | SKOART | * | NUMC | 4 |
| DGUEL_KP | Condition Item Valid From | DGUEL_KP | DATS | 8 | |
| NSTUFE | Level number of condition item for recurring payments | NSTUFE | NUMC | 2 | |
| SSIGN | Direction of Flow | TB_SSIGN | CHAR | 1 | |
| WAERS | Currency Key | WAERS | * | CUKY | 5 |
| DZVERB | Payment Details Effective From | TB_DZVERB | DATS | 8 | |
| SBEWART | Flow Type | SBEWART | * | CHAR | 4 |
| MNDID | Unique Reference to Mandate for each Payee | SEPA_MNDID | CHAR | 35 | |
| KUNNR | Customer Number | KUNNR | * | CHAR | 10 |
| FLG_VZZKOPO | Checkbox | XFELD | CHAR | 1 | |
| FLG_VDGPO | Checkbox | XFELD | CHAR | 1 | |
| FLG_VDZV | Checkbox | XFELD | CHAR | 1 |
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 VDSEPA_MND_USG