SAP table MHNK (Dunning data (account entries))

SAP table MHNK has 12 primary key fields being MANDT,LAUFD,LAUFI,KOART,BUKRS,KUNNR,LIFNR,CPDKY,SKNRZE,SMABER,SMAHSK,BUSAB.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
LAUFD Date on Which the Program Is to Be Run DATS 8 0 LAUFD
LAUFI Additional Identification CHAR 6 0 LAUFI
KOART Account type CHAR 1 0 KOART
A Assets
D Customers
K Vendors
M Material
S G/L accounts
BUKRS Company Code CHAR 4 0 T001 BUKRS
KUNNR Customer Number CHAR 10 0 KNA1 KUNNR
LIFNR Account Number of Supplier CHAR 10 0 LFA1 LIFNR
CPDKY Sort Field for One-Time Accounts CHAR 16 0 CPDKY
SKNRZE Head Office Account Number (in branch accounts) CHAR 10 0 KNA1 KNRZE
SMABER Dunning Area CHAR 2 0 T047M MABER
SMAHSK Dunning Level NUMC 1 0 MAHNS_D
BUSAB Dunning Clerk CHAR 2 0 T001S BUSAB_MA
AUSDT Dunning Date DATS 8 0 AUSDT_F150
GRDAT Posting Date up to Which Documents Are Included DATS 8 0 GRDAT_F150
KNRMA Account Number of the Dunning Recipient CHAR 10 0 KNA1 KNRMA
GMVDT Date of the Legal Dunning Proceedings DATS 8 0 GMVDT
MAHNA Dunning Procedure CHAR 4 0 T047A MAHNA
MAHNS Dunning Level NUMC 1 0 MAHNS_D
VZSKZ Interest Indicator CHAR 2 0 T056 VZSKZ
WAERS Currency Key CUKY 5 0 TCURC WAERS
SALDO Balance in Dunning Area in Dunning Currency CURR 23 2 SALFW_MHNK
SALHW Balance in Dunning Area Local Currency CURR 23 2 SALHW_MHNK
GSFBT Total of Blocked and Due Items CURR 23 2 GSFBT_MHNK
GSNBT Total Balance of Blocked Items Not Due CURR 23 2 GSNBT_MHNK
FAEBT Total of Line Items Due CURR 23 2 FAEBT_MHNK
FAEHW Total of Due Items in Local Currency CURR 23 2 FAEHW_MHNK
XMFLG Indicator: Is a Dunning Notice Sent? CHAR 1 0 XMFLG_MHNK
MANSP Dunning Block CHAR 1 0 T040S MANSP
MAHSK Highest Dunning Level for Account in Dunning Area NUMC 1 0 MAHNS_MHNK
ZINBT Interest Total for Dunning Notice in Dunning Currency CURR 23 2 DZINBT_MHN
ZINHW Interest Total for Dunning Notice in Company Code Currency CURR 23 2 DZINHW_MHN
XZINS Indicator: Do Not Display Interest in the Dunning Notice CHAR 1 0 XZINS_MHNK
MGRUP Key for Dunning Notice Grouping CHAR 2 0 T047R MGRUP
VERTN Contract Number CHAR 13 0 RANL
VERTT Contract Type CHAR 1 0 RANTYP
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
B Bank Accounts
E Exposures
T Trade Finance
V Contract Management - Consumer Products
X External Accounts
Y Reserved for Customer Enhancements
Z Reserved for Customer Enhancements
IMKEY Internal Key for Real Estate Object CHAR 8 0 IMKEY
FAMSM Total due itemsin dunning currency from dunning level CURR 23 2 FAMSM_MHNK
FAMSH Total due items in local currency from dunning level CURR 23 2 FAMSH_MHNK
PSTLZ Postal Code CHAR 10 0 PSTLZ
ORT01 City CHAR 35 0 ORT01_GP
STRAS Street and House Number CHAR 35 0 STRAS_GP
PFACH PO Box CHAR 10 0 PFACH
LAND1 Country/Region Key CHAR 3 0 T005 LAND1
AVSID Payment Advice Number CHAR 16 0 AVSID
APPLK Application Indicator CHAR 6 0 APPLK_BF
CPDKY_GRP Sort Field for One-Time Accounts CHAR 16 0 CPDKY
CPDKY_CPD Sort Field for One-Time Accounts CHAR 16 0 CPDKY
MHNGH Dunning Charge in Local Currency CURR 23 2 MHNGH_F150
MHNGF Dunning Charge in Foreign Currency CURR 23 2 MHNGF_F150
PRNFORM Form Types CHAR 1 0 FORM_TYPES
PRNNACHA Transmission Medium for Correspondence CHAR 1 0 FI_NACHA
1 Printout
2 Fax
I E-Mail
PRNDT Dunning Notice: Date of Printing DATS 8 0 PRNDT
PRNDT_BEFORE Print Date of Last Dunning Notice DATS 8 0 PRNDT_BEFORE
SDUNNDOCLO Type of Dunning Letter CHAR 1 0 SDUNNDOC
No dunning letter
C Copy of dunning letter
O Original dunning letter
SRANLPOSTLO Contract Number CHAR 13 0 RANL
DBUDATLO Posting Date in the Document DATS 8 0 BUDAT
SWENR Business Entity Number CHAR 8 0 SWENR
SMENR Number of Rental Unit CHAR 8 0 SMENR
PSOMD Dunning Notice Already Printed CHAR 1 0 PSOMD

MHNK foreign key relationships

Table Field Check Table Check Field
0 MHNK BUKRS T001 Company Codes BUKRS
1 MHNK BUSAB T001S Accounting Clerks MANDT
1 MHNK BUSAB T001S Accounting Clerks BUKRS
1 MHNK BUSAB T001S Accounting Clerks BUSAB
0 MHNK KNRMA KNA1 General Data in Customer Master MANDT
0 MHNK KNRMA KNA1 General Data in Customer Master KUNNR
1 MHNK KUNNR KNA1 General Data in Customer Master MANDT
1 MHNK KUNNR KNA1 General Data in Customer Master KUNNR
0 MHNK LAND1 T005 Countries MANDT
0 MHNK LAND1 T005 Countries LAND1
1 MHNK LIFNR LFA1 Supplier Master (General Section) MANDT
1 MHNK LIFNR LFA1 Supplier Master (General Section) LIFNR
0 MHNK MAHNA T047A Account Level Dunning Control MANDT
1 MHNK MANDT T000 Clients MANDT
0 MHNK MGRUP T047R Grouping rules for dunning notices MANDT
0 MHNK MGRUP T047R Grouping rules for dunning notices MGRUP
1 MHNK SKNRZE KNA1 General Data in Customer Master MANDT
1 MHNK SKNRZE KNA1 General Data in Customer Master KUNNR
0 MHNK SMABER T047M Dunning areas MANDT
0 MHNK SMABER T047M Dunning areas BUKRS
1 MHNK VZSKZ T056 Interest Indicator MANDT
1 MHNK VZSKZ T056 Interest Indicator VZSKZ
0 MHNK WAERS TCURC Currency Codes MANDT
0 MHNK WAERS TCURC Currency Codes WAERS