MHNK SAP Dunning data (account entries) Table and data
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.
Below is the standard documentation available and a few details of the fields which make up this Table. You can view further information about SAP MHNK Table and the data within it using relevant transactions such as SE11, SE80 or SE16. Also check out the Comments section below to view or add related contributions and example screen shots.
Delivery Class: A - Application table containing master and transaction data
Display/Maintenance via SM30: Yes but with Restrictions
Enhancement category i: Can be enhanced (character-type or numeric)
See here for more information about this and other SAP enhancement categories
==>View Table relationships
SAP MHNK Table fields within data Dictionary
| Field | Data Element | Data Type | length (Decimals) | Check table | Description | Conversion Routine |
| MANDT | MANDT | CLNT | 3 | T000 | Client | |
| LAUFD | LAUFD | DATS | 8 | Date on Which the Program Is to Be Run | ||
| LAUFI | LAUFI | CHAR | 6 | Additional Identification | ||
| KOART | KOART | CHAR | 1 | Account Type | ||
| BUKRS | BUKRS | CHAR | 4 | T001 | Company Code | |
| KUNNR | KUNNR | CHAR | 10 | KNA1 | Customer Number | ALPHA |
| LIFNR | LIFNR | CHAR | 10 | LFA1 | Account Number of Vendor or Creditor | ALPHA |
| CPDKY | CPDKY | CHAR | 16 | Sort field for one-time accounts | ||
| SKNRZE | KNRZE | CHAR | 10 | KNA1 | Head office account number (in branch accounts) | ALPHA |
| SMABER | MABER | CHAR | 2 | T047M | Dunning Area | |
| SMAHSK | MAHNS_D | NUMC | 1 | Dunning level | ||
| BUSAB | BUSAB_MA | CHAR | 2 | T001S | Dunning clerk | |
| AUSDT | AUSDT_F150 | DATS | 8 | Dunning date | ||
| GRDAT | GRDAT_F150 | DATS | 8 | Posting date up to which documents are included | ||
| KNRMA | KNRMA | CHAR | 10 | KNA1 | Account number of the dunning recipient | ALPHA |
| GMVDT | GMVDT | DATS | 8 | Date of the legal dunning proceedings | ||
| MAHNA | MAHNA | CHAR | 4 | T047A | Dunning Procedure | |
| MAHNS | MAHNS_D | NUMC | 1 | Dunning level | ||
| VZSKZ | VZSKZ | CHAR | 2 | T056 | Interest calculation indicator | |
| WAERS | WAERS | CUKY | 5 | TCURC | Currency Key | |
| SALDO | SALFW_MHNK | CURR | 15(2) | Balance in dunning area in dunning currency | ||
| SALHW | SALHW_MHNK | CURR | 15(2) | Balance in dunning area local currency | ||
| GSFBT | GSFBT_MHNK | CURR | 15(2) | Total of blocked and due items | ||
| GSNBT | GSNBT_MHNK | CURR | 15(2) | Total balance of blocked items not due | ||
| FAEBT | FAEBT_MHNK | CURR | 15(2) | Total of line items due | ||
| FAEHW | FAEHW_MHNK | CURR | 15(2) | Total of due items in local currency | ||
| XMFLG | XMFLG_MHNK | CHAR | 1 | Indicator: Is a dunning notice sent? | ||
| MANSP | MANSP | CHAR | 1 | T040S | Dunning block | |
| MAHSK | MAHNS_MHNK | NUMC | 1 | Highest dunning level for account in dunning area | ||
| ZINBT | DZINBT_MHN | CURR | 15(2) | Interest total for dunning notice in dunning currency | ||
| ZINHW | DZINHW_MHN | CURR | 15(2) | Interest total for dunning notice in company code currency | ||
| XZINS | XZINS_MHNK | CHAR | 1 | Indicator: Do not display interest in the dunning notice | ||
| MGRUP | MGRUP | CHAR | 2 | T047R | Key for dunning notice grouping | |
| VERTN | RANL | CHAR | 13 | Contract Number | ALPHA | |
| VERTT | RANTYP | CHAR | 1 | Contract Type | ||
| IMKEY | IMKEY | CHAR | 8 | Internal Key for Real Estate Object | IMKEY | |
| FAMSM | FAMSM_MHNK | CURR | 15(2) | Total due itemsin dunning currency from dunning level | ||
| FAMSH | FAMSH_MHNK | CURR | 15(2) | Total due items in local currency from dunning level | ||
| PSTLZ | PSTLZ | CHAR | 10 | Postal Code | ||
| ORT01 | ORT01_GP | CHAR | 35 | City | ||
| STRAS | STRAS_GP | CHAR | 35 | House number and street | ||
| PFACH | PFACH | CHAR | 10 | PO Box | ||
| LAND1 | LAND1 | CHAR | 3 | T005 | Country Key | |
| AVSID | AVSID | CHAR | 16 | Payment Advice Number | ||
| APPLK | APPLK_BF | CHAR | 6 |
* | Application Indicator | |
| CPDKY_GRP | CPDKY | CHAR | 16 | Sort field for one-time accounts | ||
| CPDKY_CPD | CPDKY | CHAR | 16 | Sort field for one-time accounts | ||
| MHNGH | MHNGH_F150 | CURR | 15(2) | Dunning charge in local currency | ||
| MHNGF | MHNGF_F150 | CURR | 15(2) | Dunning charge in foreign currency | ||
| PRNDT | PRNDT | DATS | 8 | Dunning notice: Date of printing | ||
| PRNDT_BEFORE | PRNDT_BEFORE | DATS | 8 | Print Date of Last Dunning Notice | ||
| .INCLUDE | SI_MHNK | Include for supplements MHNK for SAP applications | ||||
| .INCLU-LO | SI_TRLO | Loans: SI Include for MHNK | ||||
| SDUNNDOCLO | SDUNNDOC | CHAR | 1 | Type of Dunning Letter | ||
| SRANLPOSTLO | RANL | CHAR | 13 | Contract Number | ALPHA | |
| DBUDATLO | BUDAT | DATS | 8 | Posting Date in the Document | ||
| .INCLUDE | SI_RE | Real Estate | ||||
| SMENR | SMENR | CHAR | 8 |
* | Number of Rental Unit | SMENR |
| .APPEND | APSO_MHNK | Holder for Include PSO | ||||
| .INCLUDE | SI_PSO | ISPS: SI Include for MHNK | ||||
| PSOMD | PSOMD | CHAR | 1 | Dunning Notice Already Printed | ||
| Key field | |
| Non-key field |
