MZDAT SAP table for – Dunning and interest data for batch input

Here we would like to draw your attention to MZDAT 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). MZDAT is a SAP standard transp table used for storing Dunning and interest data for batch input related data in SAP. It comes under the package FVVD.

SAP MZDAT table

Table MZDAT technical data

TableMZDAT
Data storingDunning and interest data for batch input
ModuleFS
Sub ModuleFS-CML
SAP PackageFVVD
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FINSERV
Table CategoryTRANSP

SAP MZDAT 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 MZDAT table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • LAUFD : Date on Which the Program Is to Be Run
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • LAUFI : Additional Identification
    Its a key field. Its data type is CHAR (Character String) with field length 6
  • IDENT : Version Number Component
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • BUKRS : Company Code
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • VERTN : Contract Number
    Its a key field. Its data type is CHAR (Character String) with field length 13
  • VERTT : Contract Type
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • KUNNR : Customer Number
    Its data type is CHAR (Character String) with field length 10
  • WAERS : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • ZSBTR : Interest amount in local currency
    Its data type is CURR (Currency Field) with field length 13
  • WZSBT : Interest amount in foreign currency
    Its data type is CURR (Currency Field) with field length 13
  • MAHNN : Dunning Level
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • MADAT : Date of Last Dunning Notice
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ERLDT : Date of Printing
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ZINKZ : Exempted from Interest Calculation
    Its data type is CHAR (Character String) with field length 2
  • DBERBIS : End of Calculation Period
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8