SAP MZDAT Dunning and interest data for batch input Table data and field list

MZDAT is a standard SAP Table which is used to store Dunning and interest data for batch input data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The MZDAT table consists of various fields, each holding specific information or linking keys about Dunning and interest data for batch input data available in SAP. These include LAUFD (Date on Which the Program Is to Be Run), LAUFI (Additional Identification), IDENT (Version Number Component), BUKRS (Company Code)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

MZDAT table Technical Details:

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP MZDAT table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the MZDAT table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3Assigned to domainMANDT
LAUFDDate on Which the Program Is to Be Run LAUFDDATS8DATUM
LAUFIAdditional Identification LAUFICHAR6LAUFI
IDENTVersion Number Component CHAR2CHAR2CHAR2
BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
VERTNContract Number RANLCHAR13ALPHARANLRAN
VERTTContract Type RANTYPCHAR1RANTYP
KUNNRCustomer Numbers KUNNRCHAR10Assigned to domainALPHAKUNNRKUNC_KUNNR
WAERSCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
ZSBTRInterest amount in local currency DZSBTRCURR13(2) WRTV7
WZSBTInterest amount in foreign currency WZSBTCURR13(2) WRTV7
MAHNNDunning level MAHNS_DNUMC1MAHNS
MADATLast dunned on MADATDATS8DATUM
ERLDTDate of Printing ERLDT_BKORDATS8DATUM
ZINKZExempted from interest calculation DZINKZCHAR2ZINKZ
DBERBISEnd of Calculation Period DBERBISDATS8DATUM

Key field Non-key field



How do I retrieve data from SAP table MZDAT using ABAP code

The following ABAP code Example will allow you to do a basic selection on MZDAT to SELECT all data from the table
DATA: WA_MZDAT TYPE MZDAT.

SELECT SINGLE *
FROM MZDAT
INTO CORRESPONDING FIELDS OF WA_MZDAT
WHERE...

How to access SAP table MZDAT

Within an ECC or HANA version of SAP you can also view further information about MZDAT and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).