MHND - Dunning Data

Dunning Data information is stored in SAP table MHND.
It is part of development package FBAS in software component FI. This development package consists of objects that can be grouped under "Financial Accounting "Basis"".

Fields for table MHND

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
MANDTClientXMANDTCLNT6T000
LAUFDDate on Which the Program Is to Be RunXLAUFDDATS16
LAUFIAdditional IdentificationXLAUFICHAR12
KOARTAccount typeXKOARTCHAR2
BUKRSCompany CodeXBUKRSCHAR8T001
KUNNRCustomer NumberXKUNNRCHAR20KNA1
LIFNRAccount Number of SupplierXLIFNRCHAR20LFA1
CPDKYSort Field for One-Time AccountsXCPDKYCHAR32
SKNRZEHead Office Account Number (in branch accounts)XKNRZECHAR20KNA1
SMABERDunning AreaXMABERCHAR4T047M
SMAHSKDunning LevelXMAHNS_DNUMC2
BBUKRSDocument Company CodeXBBUKRSCHAR8
BELNRDocument Number of an Accounting DocumentXBELNR_DCHAR20
GJAHRFiscal YearXGJAHRNUMC8
BUZEINumber of Line Item Within Accounting DocumentXBUZEINUMC6
GSBERBusiness AreaGSBERCHAR8TGSB
XBLNRReference Document NumberXBLNR1CHAR32
BUDATPosting Date in the DocumentBUDATDATS16
BLDATDocument Date in DocumentBLDATDATS16
CPUDTDay On Which Accounting Document Was EnteredCPUDTDATS16
FAEDTNet Due DateNETDTDATS16
BLARTDocument TypeBLARTCHAR4T003
BSCHLPosting KeyBSCHLCHAR4TBSL
MSCHLDunning KeyMSCHLCHAR2T040
SMSCHLDunning Key If Separate Printout Is Active; Otherwise BlankMSCHL_MHNDCHAR2T040
MANSPDunning BlockMANSPCHAR2T040S
MABERDunning AreaMABERCHAR4T047M
MADATDate of Last Dunning NoticeMADATDATS16
MAHNSOld Dunning LevelMAHNS_ALTNUMC2
MAHNNDunning LevelMAHNS_DNUMC2
XZALBIndicator: Items Payable (Not to Be Dunned) ?XZALB_MHNDCHAR2
XFAELIndicator: Line Items Overdue ?XFAELCHAR2
VERZNDays in Arrears by Net Due DateVERZNDEC3
UMSKSSpecial G/L Transaction TypeUMSKSCHAR2
UMSKZSpecial G/L IndicatorUMSKZCHAR2T074U
SHKZGDebit/Credit IndicatorSHKZGCHAR2
WAERSCurrency KeyWAERSCUKY10TCURC
DMSHBAmount in Local Currency with +/- SignsDMSHBCURR12
WRSHBForeign Currency Amount with Signs (+/-)WRSHBCURR12
WZSBTInterest Amount in Foreign CurrencyWZSBTCURR12
FILKDAccount Number of the BranchFILKDCHAR20
VKORGSales OrganizationVKORGCHAR8TVKO
VTWEGDistribution ChannelVTWEGCHAR4TVTW
SPARTDivisionSPARTCHAR4TSPA
XZINSIndicator: Do Not Display Interest in the ItemXZINS_MHNDCHAR2
REBZGDocument No. of the Invoice to Which the Transaction BelongsREBZGCHAR20
REBZJFiscal Year of the Relevant Invoice (for Credit Memo)REBZJNUMC8
REBZZLine Item in the Relevant InvoiceREBZZNUMC6
VERTNContract NumberRANLCHAR26
VERTTContract TypeRANTYPCHAR2
BKOARTDocument Account Type (K=BSIK, D=BSID)BKOARTCHAR2
.INCLUDEMHND_JV0
VNAMEJoint ventureJV_NAMECHAR12
EGRUPEquity groupJV_EGROUPCHAR6
BTYPEBilling IndicatorJV_BILINDCHAR4
XREF1Business Partner Reference KeyXREF1CHAR24
XREF2Business Partner Reference KeyXREF2CHAR24
XREF3Reference key for line itemXREF3CHAR40
Privacy Policy