I_DunningEntry

Dunning Entry | view: IDUNNINGENTRY | Extraction: Not supported | Component: Dunning/Interest
Tables used: MHNK
Column Name Description
DunningRunDate Dunning Run Date
DunningRun Dunning Run Identification
FinancialAccountType Account Type Show values
CompanyCode FK Company Code
Customer FK Customer Number
Supplier FK Supplier
OneTimeAcctBankAccount Bank account number
CustomerHeadOffice FK Head Office Account Number (in branch accounts)
GroupingDunningArea FK Dunning Area
GroupingDunningLevel Grouping Dunning Level
DunningClerk FK Dunning Clerk
Column Name Description
💲 Dunning Currency (DunningCurrency):
DunAreaAcctBalanceDunCrcy Dunning Area Account Balance in Dunning Currency
DunAreaAcctBalanceCCCrcy Dunning Area Balance in Company Code Currency
DueItemsBlockedInDunCrcy Total of Blocked Items in Dunning Currency
NotDueItemsBlockedInDunCrcy Total of Blocked Items Not Due in Dunning Currency
DueLineItemsTotalInDunCrcy Total Line Items Due in Dunning Currency
DueLineItemsTotalInCCCrcy Total of Due Items in Company Code Currency
InterestAmountInDunCrcy Total Interest for Dunning Notice in Dunning Currency
InterestAmountInCCCrcy Total Interest for Dunning Notice in Company Code Currency
DueItemDunLevelTotalInDunCrcy Total of Due Items at Dunning Level in Dunning Currency
DueItemDunLevelTotalInCCCrcy Total due items in local currency from dunning level
DunningChargeInCCCrcy Dunning Charge in Company Code Currency
DunningChargeInDunCrcy Dunning Charge in Dunning Currency
Column Name Description
Column Name Description
DunningRunDate Dunning Run Date
DunningDate Dunning Date
DocIncldUpToPostgDate Posting Date up to Which Documents Are Included
LegDunningProcedureOn Date of the Legal Dunning Proceedings
DunningPrintDate Dunning Print Date
LastDunningPrntDate Print Date of Last Dunning Notice
Column Name Description
FinancialAccountType Account Type Show values
DunningNoticeIsSent Indicator: Is a Dunning Notice Sent? Show values
InterestIsNotDisplayed Indicator: Do Not Display Interest in the Dunning Notice Show values
TreasuryContractType Contract Type Show values
Column Name Description Domain name
DunningLevel Dunning Level MAHNS
MaximumDunningLevel Highest Dunning Level of a Dunning Type MAHNS
TreasuryContract Contract Number RANL
RealEstateObject Internal Key for Real Estate Object IMKEY
PostalCode City postal code CHAR10
CityName City TEXT40
StreetName Street and House Number TEXT35
POBox PO Box CHAR10
PaymentAdvice Payment Advice Number AVSID
BusTransEventApplication Application Indicator APPLK_BF
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • I_DUNNINGENTRY.COMPANYCODE == T001.BUKRS
  • I_DUNNINGENTRY.MANDT == T001.MANDT
Country/Region Key
  • Client
  • Country/Region Key
  • I_DUNNINGENTRY.MANDT == T005.MANDT
  • I_DUNNINGENTRY.COUNTRY == T005.LAND1
Customer Number
  • Client
  • Customer Number
  • I_DUNNINGENTRY.MANDT == KNA1.MANDT
  • I_DUNNINGENTRY.CUSTOMER == KNA1.KUNNR
Head Office Account Number (in branch accounts)
  • Client
  • Head Office Account Number (in branch accounts)
  • I_DUNNINGENTRY.MANDT == KNA1.MANDT
  • I_DUNNINGENTRY.CUSTOMERHEADOFFICE == KNA1.KUNNR
Dunning Block
  • Client
  • Dunning Block
  • I_DUNNINGENTRY.MANDT == T040S.MANDT
  • I_DUNNINGENTRY.DUNNINGBLOCKINGREASON == T040S.MANSP
Dunning Clerk
  • Dunning Clerk
  • Company Code
  • Client
  • I_DUNNINGENTRY.DUNNINGCLERK == T001S.BUSAB
  • I_DUNNINGENTRY.COMPANYCODE == T001S.BUKRS
  • I_DUNNINGENTRY.MANDT == T001S.MANDT
Dunning Currency
  • Client
  • Dunning Currency
  • I_DUNNINGENTRY.MANDT == TCURC.MANDT
  • I_DUNNINGENTRY.DUNNINGCURRENCY == TCURC.WAERS
Key for Dunning Notice Grouping
  • Key for Dunning Notice Grouping
  • Client
  • I_DUNNINGENTRY.DUNNINGNOTICEGROUP == T047R.MGRUP
  • I_DUNNINGENTRY.MANDT == T047R.MANDT
Dunning Procedure
  • Dunning Procedure
  • Client
  • I_DUNNINGENTRY.DUNNINGPROCEDURE == T047A.MAHNA
  • I_DUNNINGENTRY.MANDT == T047A.MANDT
Account Number of the Dunning Recipient
  • Client
  • Account Number of the Dunning Recipient
  • I_DUNNINGENTRY.MANDT == KNA1.MANDT
  • I_DUNNINGENTRY.DUNNINGRECIPIENT == KNA1.KUNNR
Dunning Area
  • Dunning Area
  • Company Code
  • Client
  • I_DUNNINGENTRY.GROUPINGDUNNINGAREA == T047M.MABER
  • I_DUNNINGENTRY.COMPANYCODE == T047M.BUKRS
  • I_DUNNINGENTRY.MANDT == T047M.MANDT
Interest Calculation Indicator
  • Client
  • Interest Calculation Indicator
  • I_DUNNINGENTRY.MANDT == T056.MANDT
  • I_DUNNINGENTRY.INTERESTCALCULATIONCODE == T056.VZSKZ
Supplier
  • Client
  • Supplier
  • I_DUNNINGENTRY.MANDT == LFA1.MANDT
  • I_DUNNINGENTRY.SUPPLIER == LFA1.LIFNR