1. Home
  2. Resources
  3. SAP Tables
  4. MHND - Dunning Data

SAP Table MHND

Dunning Data

MHND (Dunning Data) 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 MHND to other SAP tables.

MHND 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
BBUKRS Document company code BBUKRS CHAR 4 0
BELNR Accounting Document Number BELNR_D CHAR 10 0
GJAHR Fiscal Year GJAHR NUMC 4 0
BUZEI Number of Line Item Within Accounting Document BUZEI NUMC 3 0
GSBER Business Area GSBER TGSB CHAR 4 0
XBLNR Reference Document Number XBLNR1 CHAR 16 0
ZUONR Assignment Number DZUONR CHAR 18 0
BUDAT Posting Date in the Document BUDAT DATS 8 0
BLDAT Document Date in Document BLDAT DATS 8 0
CPUDT Day On Which Accounting Document Was Entered CPUDT DATS 8 0
ZFBDT Baseline Date for Due Date Calculation DZFBDT DATS 8 0
FAEDT Due Date for Net Payment NETDT DATS 8 0
BLART Document Type BLART T003 CHAR 2 0
BSCHL Posting Key BSCHL TBSL CHAR 2 0
MSCHL Dunning key MSCHL T040 CHAR 1 0
SMSCHL Dunning key if separate printout is active; otherwise blank MSCHL_MHND T040 CHAR 1 0
MANSP Dunning block MANSP T040S CHAR 1 0
MABER Dunning Area MABER T047M CHAR 2 0
MADAT Last dunned on MADAT DATS 8 0
MAHNS Old dunning level MAHNS_ALT NUMC 1 0
MAHNN Dunning level MAHNS_D NUMC 1 0
ZLSPR Payment Block Key DZLSPR T008 CHAR 1 0
XZALB Indicator: items payable (not to be dunned) ? XZALB_MHND CHAR 1 0
X Yes
NULL No
XFAEL Indicator: line items overdue ? XFAEL CHAR 1 0
X Yes
NULL No
VERZN Days in Arrears by Net Due Date VERZN DEC 5 0
UMSKS Special G/L Transaction Type UMSKS CHAR 1 0
UMSKZ Special G/L Indicator UMSKZ T074U CHAR 1 0
SHKZG Debit/Credit Indicator SHKZG CHAR 1 0
H Credit
S Debit
WAERS Currency Key WAERS TCURC CUKY 5 0
DMSHB Amount in Local Currency with +/- Signs DMSHB CURR 13 2
WRSHB Foreign Currency Amount with Signs (+/-) WRSHB CURR 13 2
ZINST Number of days for which interest is calculated DZINST DEC 5 0
ZINSS Interest rate DZINSS DEC 7 3
ZSBTR Interest amount in local currency DZSBTR CURR 13 2
WZSBT Interest amount in foreign currency WZSBT CURR 13 2
FILKD Account Number of the Branch FILKD CHAR 10 0
VKORG Sales Organization VKORG TVKO CHAR 4 0
VTWEG Distribution Channel VTWEG TVTW CHAR 2 0
SPART Division SPART TSPA CHAR 2 0
XZINS Indicator: Do not display interest in the item XZINS_MHND CHAR 1 0
X Yes
NULL No
REBZG Number of the Invoice the Transaction Belongs to REBZG CHAR 10 0
REBZJ Fiscal Year of the Relevant Invoice (for Credit Memo) REBZJ NUMC 4 0
REBZZ Line Item in the Relevant Invoice REBZZ NUMC 3 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
ZLSCH Payment Method DZLSCH CHAR 1 0
BKOART Document account type (K=BSIK, D=BSID) BKOART CHAR 1 0
A Assets
D Customers
K Vendors
M Material
S G/L accounts
VNAME Joint Venture JV_NAME CHAR 6 0
EGRUP Equity group JV_EGROUP CHAR 3 0
BTYPE Payroll Type JV_BILIND CHAR 2 0
XREF1 Business partner reference key XREF1 CHAR 12 0
XREF2 Business partner reference key XREF2 CHAR 12 0
ZINKZ Public Sector Industry Solution: Exempt from Interest Calc. MHND_ZINKZ CHAR 2 0

MHND foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
MHND BLART MHND MANDT T003 Document Types MANDT
MHND BLART MHND BLART T003 Document Types BLART
MHND BSCHL MHND MANDT TBSL Posting Key MANDT
MHND BSCHL MHND BSCHL TBSL Posting Key BSCHL
MHND BUKRS MHND MANDT T001 Company Codes MANDT
MHND BUKRS MHND BUKRS T001 Company Codes BUKRS
MHND GSBER MHND MANDT TGSB Business Areas MANDT
MHND GSBER MHND GSBER TGSB Business Areas GSBER
MHND KUNNR MHND MANDT KNA1 General Data in Customer Master MANDT
MHND KUNNR MHND KUNNR KNA1 General Data in Customer Master KUNNR
MHND LIFNR MHND MANDT LFA1 Vendor Master (General Section) MANDT
MHND LIFNR MHND LIFNR LFA1 Vendor Master (General Section) LIFNR
MHND MABER MHND MANDT T047M Dunning areas MANDT
MHND MABER MHND BUKRS T047M Dunning areas BUKRS
MHND MABER MHND MABER T047M Dunning areas MABER
MHND MANDT MHND MANDT T000 Clients MANDT
MHND MANSP MHND MANSP T040S Blocking reasons for dunning notices MANSP
MHND MANSP MHND MANDT T040S Blocking reasons for dunning notices MANDT
MHND MSCHL MHND MANDT T040 Dunning keys MANDT
MHND MSCHL MHND MSCHL T040 Dunning keys MSCHL
MHND SKNRZE MHND MANDT KNA1 General Data in Customer Master MANDT
MHND SKNRZE MHND SKNRZE KNA1 General Data in Customer Master KUNNR
MHND SMABER MHND BUKRS T047M Dunning areas BUKRS
MHND SMABER MHND SMABER T047M Dunning areas MABER
MHND SMABER MHND MANDT T047M Dunning areas MANDT
MHND SMSCHL MHND MANDT T040 Dunning keys MANDT
MHND SMSCHL MHND SMSCHL T040 Dunning keys MSCHL
MHND SPART MHND MANDT TSPA Organizational Unit: Sales Divisions MANDT
MHND SPART MHND SPART TSPA Organizational Unit: Sales Divisions SPART
MHND UMSKZ MHND MANDT T074U Special G/L Indicator Properties MANDT
MHND UMSKZ MHND KOART T074U Special G/L Indicator Properties KOART
MHND UMSKZ MHND UMSKZ T074U Special G/L Indicator Properties UMSKZ
MHND VKORG MHND MANDT TVKO Organizational Unit: Sales Organizations MANDT
MHND VKORG MHND VKORG TVKO Organizational Unit: Sales Organizations VKORG
MHND VTWEG MHND VTWEG TVTW Organizational Unit: Distribution Channels VTWEG
MHND VTWEG MHND MANDT TVTW Organizational Unit: Distribution Channels MANDT
MHND WAERS MHND MANDT TCURC Currency Codes MANDT
MHND WAERS MHND WAERS TCURC Currency Codes WAERS
MHND ZLSPR MHND ZLSPR T008 Blocking Reasons for Automatic Payment Transcations ZAHLS
MHND ZLSPR MHND MANDT T008 Blocking Reasons for Automatic Payment Transcations MANDT