MHND

Dunning Data | #transactional | Component: Financial Accounting
Column Name Description
MANDT FK Client
LAUFD Date on Which the Program Is to Be Run
LAUFI Additional Identification
KOART Account type Show values
BUKRS FK Company Code
KUNNR FK Customer Number
LIFNR FK Account Number of Supplier
CPDKY Sort Field for One-Time Accounts
SKNRZE FK Head Office Account Number (in branch accounts)
SMABER FK Dunning Area
SMAHSK Dunning Level
BBUKRS Document Company Code
BELNR Document Number of an Accounting Document
GJAHR Fiscal Year
BUZEI Number of Line Item Within Accounting Document
Column Name Description
πŸ’² Currency Key (T001.WAERS):
DMSHB Amount in Local Currency with +/- Signs
WRSHB Foreign Currency Amount with Signs (+/-)
ZSBTR Interest Amount in Local Currency
WZSBT Interest Amount in Foreign Currency
Column Name Description
Column Name Description
LAUFD Date on Which the Program Is to Be Run
BUDAT Posting Date in the Document
BLDAT Document Date in Document
CPUDT Day On Which Accounting Document Was Entered
ZFBDT Baseline Date for Due Date Calculation
FAEDT Net Due Date
MADAT Date of Last Dunning Notice
Column Name Description
KOART Account type Show values
XZALB Indicator: Items Payable (Not to Be Dunned) ? Show values
XFAEL Indicator: Line Items Overdue ? Show values
SHKZG Debit/Credit Indicator Show values
XZINS Indicator: Do Not Display Interest in the Item Show values
VERTT Contract Type Show values
BKOART Document Account Type (K=BSIK, D=BSID) Show values
Column Name Description Domain name
XBLNR Reference Document Number XBLNR1
ZUONR Assignment number ZUONR
MAHNS Old Dunning Level MAHNS
MAHNN Dunning Level MAHNS
VERZN Days in Arrears by Net Due Date WRTV3
UMSKS Special G/L Transaction Type UMSKS
ZINST Number of Days for Which Interest Is Calculated WRTV3
ZINSS Interest rate PRZ43
FILKD Account Number of the Branch MAXKK
REBZG Document No. of the Invoice to Which the Transaction Belongs BELNR
REBZJ Fiscal Year of the Relevant Invoice (for Credit Memo) GJAHR
REBZZ Line Item in the Relevant Invoice BUZEI
VERTN Contract Number RANL
ZLSCH Payment Method ZLSCH
VNAME Joint venture JV_NAME
EGRUP Equity group JV_EGROUP
BTYPE Billing Indicator JV_BILIND
XREF1 Business Partner Reference Key CHAR12
XREF2 Business Partner Reference Key CHAR12
ZINKZ Public Sector Industry Solution: Exempt from Interest Calc.
XREF3 Reference key for line item CHAR20
Master Data Relations Join Conditions
Document Type
  • Document Type
  • Client
  • MHND.BLART == T003.BLART
  • MHND.MANDT == T003.MANDT
Posting Key
  • MHND.MANDT == TBSL.MANDT
  • MHND.BSCHL == TBSL.BSCHL
Company Code
  • MHND.MANDT == T001.MANDT
  • MHND.BUKRS == T001.BUKRS
Business Area
  • MHND.MANDT == TGSB.MANDT
  • MHND.GSBER == TGSB.GSBER
Customer Number
  • MHND.MANDT == KNA1.MANDT
  • MHND.KUNNR == KNA1.KUNNR
Account Number of Supplier
  • MHND.MANDT == LFA1.MANDT
  • MHND.LIFNR == LFA1.LIFNR
Dunning Area
  • Dunning Area
  • Company Code
  • MHND.MANDT == T047M.MANDT
  • MHND.MABER == T047M.MABER
  • MHND.BUKRS == T047M.BUKRS
Client MHND.MANDT == T000.MANDT
Dunning Block
  • MHND.MANDT == T040S.MANDT
  • MHND.MANSP == T040S.MANSP
Dunning Key
  • MHND.MANDT == T040.MANDT
  • MHND.MSCHL == T040.MSCHL
Head Office Account Number (in branch accounts)
  • MHND.MANDT == KNA1.MANDT
  • MHND.SKNRZE == KNA1.KUNNR
Dunning Area
  • Dunning Area
  • Company Code
  • MHND.MANDT == T047M.MANDT
  • MHND.SMABER == T047M.MABER
  • MHND.BUKRS == T047M.BUKRS
Dunning Key If Separate Printout Is Active; Otherwise Blank
  • MHND.MANDT == T040.MANDT
  • MHND.SMSCHL == T040.MSCHL
Division
  • MHND.MANDT == TSPA.MANDT
  • MHND.SPART == TSPA.SPART
Special G/L Indicator
  • Special G/L Indicator
  • Account type
  • MHND.MANDT == T074U.MANDT
  • MHND.UMSKZ == T074U.UMSKZ
  • MHND.KOART == T074U.KOART
Sales Organization
  • MHND.MANDT == TVKO.MANDT
  • MHND.VKORG == TVKO.VKORG
Distribution Channel
  • Distribution Channel
  • Client
  • MHND.VTWEG == TVTW.VTWEG
  • MHND.MANDT == TVTW.MANDT
Currency Key
  • MHND.MANDT == TCURC.MANDT
  • MHND.WAERS == TCURC.WAERS
Payment Block Key
  • Payment Block Key
  • Client
  • MHND.ZLSPR == T008.ZAHLS
  • MHND.MANDT == T008.MANDT