SAP table MHND (Dunning Data)

SAP table MHND has 15 primary key fields being MANDT,LAUFD,LAUFI,KOART,BUKRS,KUNNR,LIFNR,CPDKY,SKNRZE,SMABER,SMAHSK,BBUKRS,BELNR,GJAHR,BUZEI.

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
BBUKRS Document Company Code CHAR 4 0 BBUKRS
BELNR Document Number of an Accounting Document CHAR 10 0 BELNR_D
GJAHR Fiscal Year NUMC 4 0 GJAHR
BUZEI Number of Line Item Within Accounting Document NUMC 3 0 BUZEI
GSBER Business Area CHAR 4 0 TGSB GSBER
XBLNR Reference Document Number CHAR 16 0 XBLNR1
ZUONR Assignment number CHAR 18 0 DZUONR
BUDAT Posting Date in the Document DATS 8 0 BUDAT
BLDAT Document Date in Document DATS 8 0 BLDAT
CPUDT Day On Which Accounting Document Was Entered DATS 8 0 CPUDT
ZFBDT Baseline Date for Due Date Calculation DATS 8 0 DZFBDT
FAEDT Net Due Date DATS 8 0 NETDT
BLART Document Type CHAR 2 0 T003 BLART
BSCHL Posting Key CHAR 2 0 TBSL BSCHL
MSCHL Dunning Key CHAR 1 0 T040 MSCHL
SMSCHL Dunning Key If Separate Printout Is Active; Otherwise Blank CHAR 1 0 T040 MSCHL_MHND
MANSP Dunning Block CHAR 1 0 T040S MANSP
MABER Dunning Area CHAR 2 0 T047M MABER
MADAT Date of Last Dunning Notice DATS 8 0 MADAT
MAHNS Old Dunning Level NUMC 1 0 MAHNS_ALT
MAHNN Dunning Level NUMC 1 0 MAHNS_D
ZLSPR Payment Block Key CHAR 1 0 T008 DZLSPR
XZALB Indicator: Items Payable (Not to Be Dunned) ? CHAR 1 0 XZALB_MHND
XFAEL Indicator: Line Items Overdue ? CHAR 1 0 XFAEL
VERZN Days in Arrears by Net Due Date DEC 5 0 VERZN
UMSKS Special G/L Transaction Type CHAR 1 0 UMSKS
UMSKZ Special G/L Indicator CHAR 1 0 T074U UMSKZ
SHKZG Debit/Credit Indicator CHAR 1 0 SHKZG
H Credit
S Debit
WAERS Currency Key CUKY 5 0 TCURC WAERS
DMSHB Amount in Local Currency with +/- Signs CURR 23 2 DMSHB
WRSHB Foreign Currency Amount with Signs (+/-) CURR 23 2 WRSHB
ZINST Number of Days for Which Interest Is Calculated DEC 5 0 DZINST
ZINSS Interest rate DEC 7 3 DZINSS
ZSBTR Interest Amount in Local Currency CURR 23 2 DZSBTR
WZSBT Interest Amount in Foreign Currency CURR 23 2 WZSBT
FILKD Account Number of the Branch CHAR 10 0 FILKD
VKORG Sales Organization CHAR 4 0 TVKO VKORG
VTWEG Distribution Channel CHAR 2 0 TVTW VTWEG
SPART Division CHAR 2 0 TSPA SPART
XZINS Indicator: Do Not Display Interest in the Item CHAR 1 0 XZINS_MHND
REBZG Document No. of the Invoice to Which the Transaction Belongs CHAR 10 0 REBZG
REBZJ Fiscal Year of the Relevant Invoice (for Credit Memo) NUMC 4 0 REBZJ
REBZZ Line Item in the Relevant Invoice NUMC 3 0 REBZZ
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
ZLSCH Payment Method CHAR 1 0 DZLSCH
BKOART Document Account Type (K=BSIK, D=BSID) CHAR 1 0 BKOART
VNAME Joint venture CHAR 6 0 * JV_NAME
EGRUP Equity group CHAR 3 0 * JV_EGROUP
BTYPE Billing Indicator CHAR 2 0 * JV_BILIND
XREF1 Business Partner Reference Key CHAR 12 0 XREF1
XREF2 Business Partner Reference Key CHAR 12 0 XREF2
ZINKZ Public Sector Industry Solution: Exempt from Interest Calc. CHAR 2 0 MHND_ZINKZ
XREF3 Reference key for line item CHAR 20 0 XREF3

MHND foreign key relationships

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