1. Home
  2. Resources
  3. SAP Tables
  4. MHNK - Dunning data (account entries)

SAP Table MHNK

Dunning data (account entries)

MHNK (Dunning data (account entries)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link MHNK to other SAP tables.

MHNK table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
LAUFD Date on Which the Program Is to Be Run LAUFD DATS 8 0
LAUFI Additional Identification LAUFI CHAR 6 0
KOART Account Type KOART CHAR 1 0
A Assets
D Customers
K Vendors
M Material
S G/L accounts
BUKRS Company Code BUKRS T001 CHAR 4 0
KUNNR Customer Number KUNNR KNA1 CHAR 10 0
LIFNR Account Number of Vendor or Creditor LIFNR LFA1 CHAR 10 0
CPDKY Sort field for one-time accounts CPDKY CHAR 16 0
SKNRZE Head office account number (in branch accounts) KNRZE KNA1 CHAR 10 0
SMABER Dunning Area MABER T047M CHAR 2 0
SMAHSK Dunning level MAHNS_D NUMC 1 0
BUSAB Dunning clerk BUSAB_MA T001S CHAR 2 0
AUSDT Dunning date AUSDT_F150 DATS 8 0
GRDAT Posting date up to which documents are included GRDAT_F150 DATS 8 0
KNRMA Account number of the dunning recipient KNRMA KNA1 CHAR 10 0
GMVDT Date of the legal dunning proceedings GMVDT DATS 8 0
MAHNA Dunning Procedure MAHNA T047A CHAR 4 0
MAHNS Dunning level MAHNS_D NUMC 1 0
VZSKZ Interest calculation indicator VZSKZ T056 CHAR 2 0
WAERS Currency Key WAERS TCURC CUKY 5 0
SALDO Balance in dunning area in dunning currency SALFW_MHNK CURR 15 2
SALHW Balance in dunning area local currency SALHW_MHNK CURR 15 2
GSFBT Total of blocked and due items GSFBT_MHNK CURR 15 2
GSNBT Total balance of blocked items not due GSNBT_MHNK CURR 15 2
FAEBT Total of line items due FAEBT_MHNK CURR 15 2
FAEHW Total of due items in local currency FAEHW_MHNK CURR 15 2
XMFLG Indicator: Is a dunning notice sent? XMFLG_MHNK CHAR 1 0
X Yes
NULL No
MANSP Dunning block MANSP T040S CHAR 1 0
MAHSK Highest dunning level for account in dunning area MAHNS_MHNK NUMC 1 0
ZINBT Interest total for dunning notice in dunning currency DZINBT_MHN CURR 15 2
ZINHW Interest total for dunning notice in company code currency DZINHW_MHN CURR 15 2
XZINS Indicator: Do not display interest in the dunning notice XZINS_MHNK CHAR 1 0
X Yes
NULL No
MGRUP Key for dunning notice grouping MGRUP T047R CHAR 2 0
VERTN Contract Number RANL CHAR 13 0
VERTT Contract Type RANTYP CHAR 1 0
1 Loans
2 Securities
3 Lease-Out - Real Estate
4 Foreign Exchange
5 Money Market
6 Derivatives
7 Open Item Transactions
8 Administration Contract - Real Estate
9 General Contract - Real Estate
A Internal use only
Y Reserved for Customer Enhancements
Z Reserved for Customer Enhancements
V Contract Management - Consumer Products
X External Accounts
E Exposure Position
IMKEY Internal Key for Real Estate Object IMKEY CHAR 8 0
FAMSM Total due itemsin dunning currency from dunning level FAMSM_MHNK CURR 15 2
FAMSH Total due items in local currency from dunning level FAMSH_MHNK CURR 15 2
PSTLZ Postal Code PSTLZ CHAR 10 0
ORT01 City ORT01_GP CHAR 35 0
STRAS House number and street STRAS_GP CHAR 35 0
PFACH PO Box PFACH CHAR 10 0
LAND1 Country Key LAND1 T005 CHAR 3 0
AVSID Payment Advice Number AVSID CHAR 16 0
APPLK Application Indicator APPLK_BF CHAR 6 0
CPDKY_GRP Sort field for one-time accounts CPDKY CHAR 16 0
CPDKY_CPD Sort field for one-time accounts CPDKY CHAR 16 0
MHNGH Dunning charge in local currency MHNGH_F150 CURR 15 2
MHNGF Dunning charge in foreign currency MHNGF_F150 CURR 15 2
PRNDT Dunning notice: Date of printing PRNDT DATS 8 0
PRNDT_BEFORE Print Date of Last Dunning Notice PRNDT_BEFORE DATS 8 0
SDUNNDOCLO Type of Dunning Letter SDUNNDOC CHAR 1 0
NULL No dunning letter
O Original dunning letter
C Copy of dunning letter
SRANLPOSTLO Contract Number RANL CHAR 13 0
DBUDATLO Posting Date in the Document BUDAT DATS 8 0
SWENR Site Number SWENR CHAR 8 0
SMENR Number of Rental Unit SMENR CHAR 8 0
PSOMD Dunning Notice Already Printed PSOMD CHAR 1 0
X Yes
NULL No

MHNK foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
MHNK BUKRS MHNK MANDT T001 Company Codes MANDT
MHNK BUKRS MHNK BUKRS T001 Company Codes BUKRS
MHNK BUSAB MHNK BUKRS T001S Accounting Clerks BUKRS
MHNK BUSAB MHNK BUSAB T001S Accounting Clerks BUSAB
MHNK BUSAB MHNK MANDT T001S Accounting Clerks MANDT
MHNK KNRMA MHNK MANDT KNA1 General Data in Customer Master MANDT
MHNK KNRMA MHNK KNRMA KNA1 General Data in Customer Master KUNNR
MHNK KUNNR MHNK MANDT KNA1 General Data in Customer Master MANDT
MHNK KUNNR MHNK KUNNR KNA1 General Data in Customer Master KUNNR
MHNK LAND1 MHNK MANDT T005 Countries MANDT
MHNK LAND1 MHNK LAND1 T005 Countries LAND1
MHNK LIFNR MHNK LIFNR LFA1 Vendor Master (General Section) LIFNR
MHNK LIFNR MHNK MANDT LFA1 Vendor Master (General Section) MANDT
MHNK MAHNA MHNK MANDT T047A Account Level Dunning Control MANDT
MHNK MAHNA MHNK MAHNA T047A Account Level Dunning Control MAHNA
MHNK MANDT MHNK MANDT T000 Clients MANDT
MHNK MANSP MHNK MANDT T040S Blocking reasons for dunning notices MANDT
MHNK MANSP MHNK MANSP T040S Blocking reasons for dunning notices MANSP
MHNK MGRUP MHNK MANDT T047R Grouping rules for dunning notices MANDT
MHNK MGRUP MHNK MGRUP T047R Grouping rules for dunning notices MGRUP
MHNK SKNRZE MHNK MANDT KNA1 General Data in Customer Master MANDT
MHNK SKNRZE MHNK SKNRZE KNA1 General Data in Customer Master KUNNR
MHNK SMABER MHNK MANDT T047M Dunning areas MANDT
MHNK SMABER MHNK BUKRS T047M Dunning areas BUKRS
MHNK SMABER MHNK SMABER T047M Dunning areas MABER
MHNK VZSKZ MHNK MANDT T056 Interest settlement MANDT
MHNK VZSKZ MHNK VZSKZ T056 Interest settlement VZSKZ
MHNK WAERS MHNK WAERS TCURC Currency Codes WAERS
MHNK WAERS MHNK MANDT TCURC Currency Codes MANDT