VDSEPA_MND_USG SAP table for – Overview of mandates used in Loans Management

Here we would like to draw your attention to VDSEPA_MND_USG 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). VDSEPA_MND_USG is a SAP standard transp table used for storing Overview of mandates used in Loans Management related data in SAP. It comes under the package FVVD.

SAP VDSEPA_MND_USG table

Table VDSEPA_MND_USG technical data

TableVDSEPA_MND_USG
Data storingOverview of mandates used in Loans Management
ModuleFS
Sub ModuleFS-CML
SAP PackageFVVD
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FINSERV
Table CategoryTRANSP

SAP VDSEPA_MND_USG 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 VDSEPA_MND_USG 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
  • SOBJEKT : Internal key for object for business partner table
    Its a key field. Its data type is CHAR (Character String) with field length 13
  • PARTNR : Business Partner Number
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • ROLETYP : BP Role
    Its a key field. Its data type is CHAR (Character String) with field length 6
  • DTRANS : Flow data key: System date
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DGUEL_KK : Date Condition Effective from
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • NLFD_ANG : Offer consecutive number
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 3
  • SKOART : Condition Type (Smallest Subdivision of Condition Records)
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • DGUEL_KP : Condition Item Valid From
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • NSTUFE : Level number of condition item for recurring payments
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 2
  • SSIGN : Direction of flow
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • WAERS : Currency Key
    Its a key field. Its data type is CUKY (Currency key for a currency field) with field length 5
  • DZVERB : Payment details effective from
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SBEWART : Flow Type
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • MNDID : Unique Referene to Mandate per Payment Recipient
    Its data type is CHAR (Character String) with field length 35
  • KUNNR : Customer Number
    Its data type is CHAR (Character String) with field length 10
  • FLG_VZZKOPO : Checkbox
    Its data type is CHAR (Character String) with field length 1
  • FLG_VDGPO : Checkbox
    Its data type is CHAR (Character String) with field length 1
  • FLG_VDZV : Checkbox
    Its data type is CHAR (Character String) with field length 1