MHNK SAP (Dunning data (account entries)) Table details

Dictionary Type: Table
Description: Dunning data (account entries)




ABAP Code to SELECT data from MHNK
Related tables to MHNK
Access table MHNK




Table field list including key, data, relationships and ABAP select examples

MHNK is a standard SAP Table which is used to store Dunning data (account entries) data and is available within R/3 SAP systems depending on the version and release level.

The MHNK table consists of various fields, each holding specific information or linking keys about Dunning data (account entries) data available in SAP. These include LAUFD (Date on Which the Program Is to Be Run), LAUFI (Additional Identification), KOART (Account Type), 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. .

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 MHNK table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
LAUFDDate on Which the Program Is to Be Run LAUFDDATS8DATUM
LAUFIAdditional Identification LAUFICHAR6LAUFI
KOARTAccount Type KOARTCHAR1KOART
BUKRSCompany Code BUKRSCHAR4T001BUKRSBUKC_T001
KUNNRCustomer Numbers KUNNRCHAR10KNA1ALPHAKUNNRKUNC_KUNNR
LIFNRAccount Number of Vendor or Creditor LIFNRCHAR10LFA1ALPHALIFNRLIFKRED_C
CPDKYSort field for one-time accounts CPDKYCHAR16TEXT16
SKNRZEHead office account number (in branch accounts) KNRZECHAR10KNA1ALPHAKUNNR
SMABERDunning Area MABERCHAR2T047MMABER
SMAHSKDunning level MAHNS_DNUMC1MAHNS
BUSABDunning clerk BUSAB_MACHAR2T001SBUSAB
AUSDTDunning date AUSDT_F150DATS8DATUM
GRDATPosting date up to which documents are included GRDAT_F150DATS8DATUM
KNRMAAccount number of the dunning recipient KNRMACHAR10KNA1ALPHAKUNNRKUN
GMVDTDate of the legal dunning proceedings GMVDTDATS8DATUM
MAHNADunning Procedure MAHNACHAR4T047AMAHNA
MAHNSDunning level MAHNS_DNUMC1MAHNS
VZSKZInterest calculation indicator VZSKZCHAR2T056VZSKZ
WAERSCurrency Key WAERSCUKY5TCURCWAERSFWS
SALDOBalance in dunning area in dunning currency SALFW_MHNKCURR15(2) WRTV8
SALHWBalance in dunning area local currency SALHW_MHNKCURR15(2) WRTV8
GSFBTTotal of blocked and due items GSFBT_MHNKCURR15(2) WRTV8
GSNBTTotal balance of blocked items not due GSNBT_MHNKCURR15(2) WRTV8
FAEBTTotal of line items due FAEBT_MHNKCURR15(2) WRTV8
FAEHWTotal of due items in local currency FAEHW_MHNKCURR15(2) WRTV8
XMFLGIndicator: Is a dunning notice sent? XMFLG_MHNKCHAR1XFELD
MANSPDunning block MANSPCHAR1T040SMANSP
MAHSKHighest dunning level for account in dunning area MAHNS_MHNKNUMC1MAHNS
ZINBTInterest total for dunning notice in dunning currency DZINBT_MHNCURR15(2) WRTV8
ZINHWInterest total for dunning notice in company code currency DZINHW_MHNCURR15(2) WRTV8
XZINSIndicator: Do not display interest in the dunning notice XZINS_MHNKCHAR1XFELD
MGRUPKey for dunning notice grouping MGRUPCHAR2T047RMGRUP
VERTNContract Number RANLCHAR13ALPHARANLRAN
VERTTContract Type RANTYPCHAR1RANTYP
IMKEYInternal Key for Real Estate Object IMKEYCHAR8IMKEY
FAMSMTotal due itemsin dunning currency from dunning level FAMSM_MHNKCURR15(2) WRTV8
FAMSHTotal due items in local currency from dunning level FAMSH_MHNKCURR15(2) WRTV8
PSTLZPostal Code PSTLZCHAR10PSTLZ
ORT01City ORT01_GPCHAR35TEXT35
STRASHouse number and street STRAS_GPCHAR35TEXT35
PFACHPO Box PFACHCHAR10PFACH
LAND1Country Key LAND1CHAR3T005LAND1LND
AVSIDPayment Advice Number AVSIDCHAR16AVSIDAVN
APPLKApplication Indicator APPLK_BFCHAR6Assigned to domainAPPLK_BF
CPDKY_GRPSort field for one-time accounts CPDKYCHAR16TEXT16
CPDKY_CPDSort field for one-time accounts CPDKYCHAR16TEXT16
MHNGHDunning charge in local currency MHNGH_F150CURR15(2) WRTV8
MHNGFDunning charge in foreign currency MHNGF_F150CURR15(2) WRTV8
PRNDTDunning notice: Date of printing PRNDTDATS8DATUM
PRNDT_BEFOREPrint Date of Last Dunning Notice PRNDT_BEFOREDATS8DATUM
.INCLU-LO 0
SDUNNDOCLOType of Dunning Letter SDUNNDOCCHAR1SDUNNDOC
SRANLPOSTLOContract Number RANLCHAR13ALPHARANLRAN
DBUDATLOPosting Date in the Document BUDATDATS8DATUM
SWENRSite Number SWENRCHAR8Assigned to domainSWENRSWENRWEHMCWE
SMENRNumber of Rental Unit SMENRCHAR8Assigned to domainSMENRSMENRMEHMCME
.INCLU--AP 0
PSOMDDunning Notice Already Printed PSOMDCHAR1XFELD

Key field Non-key field



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

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

SELECT SINGLE *
FROM MHNK
INTO CORRESPONDING FIELDS OF WA_MHNK
WHERE...

How to access SAP table MHNK

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

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


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!