MHNK

Dunning data (account entries) | #transactional | Component: Dunning/Interest
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
BUSAB FK Dunning Clerk
Column Name Description
💲 Currency Key (WAERS):
SALDO Balance in Dunning Area in Dunning Currency
SALHW Balance in Dunning Area Local Currency
GSFBT Total of Blocked and Due Items
GSNBT Total Balance of Blocked Items Not Due
FAEBT Total of Line Items Due
FAEHW Total of Due Items in Local Currency
ZINBT Interest Total for Dunning Notice in Dunning Currency
ZINHW Interest Total for Dunning Notice in Company Code Currency
FAMSM Total due itemsin dunning currency from dunning level
FAMSH Total due items in local currency from dunning level
MHNGH Dunning Charge in Local Currency
MHNGF Dunning Charge in Foreign Currency
Column Name Description
Column Name Description
LAUFD Date on Which the Program Is to Be Run
AUSDT Dunning Date
GRDAT Posting Date up to Which Documents Are Included
GMVDT Date of the Legal Dunning Proceedings
PRNDT Dunning Notice: Date of Printing
PRNDT_BEFORE Print Date of Last Dunning Notice
DBUDATLO Posting Date in the Document
Column Name Description
KOART Account type Show values
XMFLG Indicator: Is a Dunning Notice Sent? Show values
XZINS Indicator: Do Not Display Interest in the Dunning Notice Show values
VERTT Contract Type Show values
PRNFORM Form Types Show values
PRNNACHA Transmission Medium for Correspondence Show values
SDUNNDOCLO Type of Dunning Letter Show values
PSOMD Dunning Notice Already Printed Show values
Column Name Description Domain name
MAHNS Dunning Level MAHNS
MAHSK Highest Dunning Level for Account in Dunning Area MAHNS
VERTN Contract Number RANL
IMKEY Internal Key for Real Estate Object IMKEY
PSTLZ Postal Code PSTLZ
ORT01 City TEXT35
STRAS Street and House Number TEXT35
PFACH PO Box PFACH
AVSID Payment Advice Number AVSID
APPLK Application Indicator APPLK_BF
CPDKY_GRP Sort Field for One-Time Accounts TEXT16
CPDKY_CPD Sort Field for One-Time Accounts TEXT16
SRANLPOSTLO Contract Number RANL
SWENR Business Entity Number SWENR
SMENR Number of Rental Unit SMENR
Master Data Relations Join Conditions
Company Code
  • MHNK.MANDT == T001.MANDT
  • MHNK.BUKRS == T001.BUKRS
Dunning Clerk
  • Company Code
  • Client
  • Dunning Clerk
  • MHNK.BUKRS == T001S.BUKRS
  • MHNK.MANDT == T001S.MANDT
  • MHNK.BUSAB == T001S.BUSAB
Account Number of the Dunning Recipient
  • MHNK.MANDT == KNA1.MANDT
  • MHNK.KNRMA == KNA1.KUNNR
Customer Number
  • MHNK.MANDT == KNA1.MANDT
  • MHNK.KUNNR == KNA1.KUNNR
Country/Region Key
  • Country/Region Key
  • Client
  • MHNK.LAND1 == T005.LAND1
  • MHNK.MANDT == T005.MANDT
Account Number of Supplier
  • MHNK.MANDT == LFA1.MANDT
  • MHNK.LIFNR == LFA1.LIFNR
Dunning Procedure
  • MHNK.MANDT == T047A.MANDT
  • MHNK.MAHNA == T047A.MAHNA
Client MHNK.MANDT == T000.MANDT
Dunning Block
  • MHNK.MANDT == T040S.MANDT
  • MHNK.MANSP == T040S.MANSP
Key for Dunning Notice Grouping
  • MHNK.MANDT == T047R.MANDT
  • MHNK.MGRUP == T047R.MGRUP
Head Office Account Number (in branch accounts)
  • MHNK.MANDT == KNA1.MANDT
  • MHNK.SKNRZE == KNA1.KUNNR
Dunning Area
  • Dunning Area
  • Company Code
  • MHNK.MANDT == T047M.MANDT
  • MHNK.SMABER == T047M.MABER
  • MHNK.BUKRS == T047M.BUKRS
Interest Indicator
  • Interest Indicator
  • Client
  • MHNK.VZSKZ == T056.VZSKZ
  • MHNK.MANDT == T056.MANDT
Currency Key
  • MHNK.MANDT == TCURC.MANDT
  • MHNK.WAERS == TCURC.WAERS