I_DunningEntryItem

Dunning Entry Item | view: IDUNNINGENTRITM | Extraction: Not supported | Component: Dunning/Interest
Tables used: MHND
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 Dunning Level
ReferenceDocumentCompanyCode Company Code
JournalEntry Journal Entry
FiscalYear Fiscal Year
JournalEntryItem Journal Entry Posting View Item
Column Name Description
💲 Transaction Currency (TransactionCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
AmountInTransactionCurrency Amount in Transaction Currency
Column Name Description
Column Name Description
DunningRunDate Dunning Run Date
PostingDate Posting Date
DocumentDate Journal Entry Date
AccountingDocumentCreationDate Accounting Document Entry Date
DueCalculationBaseDate Baseline Date for Due Date Calculation
NetDueDate Due Date for Net Payment
LastDunningDate Date of Last Dunning Notice
Column Name Description
FinancialAccountType Account Type Show values
DunningItemIsPayable Items Not to be Dunned Show values
DebitCreditCode Debit/Credit Code Show values
TreasuryContractType Contract Type Show values
Column Name Description Domain name
DocumentReferenceID Reference Document Number XBLNR1
OldDunningLevel Old Dunning Level MAHNS
DunningLevel Dunning Level MAHNS
NetDueArrearsDays Days in Arrears by Net Due Date WRTV3
SpecialGLTransactionType Special G/L Transaction Type UMSKS
BranchAccount Account Number of the Branch MAXKK
InvoiceReference Invoice Reference BELNR
InvoiceReferenceFiscalYear Invoice Reference Fiscal Year GJAHR
InvoiceItemReference Invoice Item Reference BUZEI
TreasuryContract Contract Number RANL
SupplierPaymentMethod Payment Method ZLSCH
Master Data Relations Join Conditions
Journal Entry Type
  • Journal Entry Type
  • Client
  • I_DUNNINGENTRYITEM.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • I_DUNNINGENTRYITEM.MANDT == T003.MANDT
Business Area
  • Business Area
  • Client
  • I_DUNNINGENTRYITEM.BUSINESSAREA == TGSB.GSBER
  • I_DUNNINGENTRYITEM.MANDT == TGSB.MANDT
Company Code
  • Company Code
  • Client
  • I_DUNNINGENTRYITEM.COMPANYCODE == T001.BUKRS
  • I_DUNNINGENTRYITEM.MANDT == T001.MANDT
Customer Number
  • Customer Number
  • Client
  • I_DUNNINGENTRYITEM.CUSTOMER == KNA1.KUNNR
  • I_DUNNINGENTRYITEM.MANDT == KNA1.MANDT
Head Office Account Number (in branch accounts)
  • Head Office Account Number (in branch accounts)
  • Client
  • I_DUNNINGENTRYITEM.CUSTOMERHEADOFFICE == KNA1.KUNNR
  • I_DUNNINGENTRYITEM.MANDT == KNA1.MANDT
Distribution Channel
  • Distribution Channel
  • Client
  • I_DUNNINGENTRYITEM.DISTRIBUTIONCHANNEL == TVTW.VTWEG
  • I_DUNNINGENTRYITEM.MANDT == TVTW.MANDT
Division
  • Client
  • Division
  • I_DUNNINGENTRYITEM.MANDT == TSPA.MANDT
  • I_DUNNINGENTRYITEM.DIVISION == TSPA.SPART
Dunning Area
  • Company Code
  • Dunning Area
  • Client
  • I_DUNNINGENTRYITEM.COMPANYCODE == T047M.BUKRS
  • I_DUNNINGENTRYITEM.DUNNINGAREA == T047M.MABER
  • I_DUNNINGENTRYITEM.MANDT == T047M.MANDT
Dunning Block
  • Dunning Block
  • Client
  • I_DUNNINGENTRYITEM.DUNNINGBLOCKINGREASON == T040S.MANSP
  • I_DUNNINGENTRYITEM.MANDT == T040S.MANDT
Dunning Key
  • Client
  • Dunning Key
  • I_DUNNINGENTRYITEM.MANDT == T040.MANDT
  • I_DUNNINGENTRYITEM.DUNNINGKEY == T040.MSCHL
Dunning Area
  • Company Code
  • Client
  • Dunning Area
  • I_DUNNINGENTRYITEM.COMPANYCODE == T047M.BUKRS
  • I_DUNNINGENTRYITEM.MANDT == T047M.MANDT
  • I_DUNNINGENTRYITEM.GROUPINGDUNNINGAREA == T047M.MABER
Payment Block on Item
  • Payment Block on Item
  • Client
  • I_DUNNINGENTRYITEM.PAYMENTBLOCKINGREASON == T008.ZAHLS
  • I_DUNNINGENTRYITEM.MANDT == T008.MANDT
Posting Key
  • Posting Key
  • Client
  • I_DUNNINGENTRYITEM.POSTINGKEY == TBSL.BSCHL
  • I_DUNNINGENTRYITEM.MANDT == TBSL.MANDT
Sales Organization
  • Client
  • Sales Organization
  • I_DUNNINGENTRYITEM.MANDT == TVKO.MANDT
  • I_DUNNINGENTRYITEM.SALESORGANIZATION == TVKO.VKORG
Special G/L Indicator
  • Account Type
  • Special G/L Indicator
  • Client
  • I_DUNNINGENTRYITEM.FINANCIALACCOUNTTYPE == T074U.KOART
  • I_DUNNINGENTRYITEM.SPECIALGLCODE == T074U.UMSKZ
  • I_DUNNINGENTRYITEM.MANDT == T074U.MANDT
Supplier
  • Supplier
  • Client
  • I_DUNNINGENTRYITEM.SUPPLIER == LFA1.LIFNR
  • I_DUNNINGENTRYITEM.MANDT == LFA1.MANDT
Transaction Currency
  • Client
  • Transaction Currency
  • I_DUNNINGENTRYITEM.MANDT == TCURC.MANDT
  • I_DUNNINGENTRYITEM.TRANSACTIONCURRENCY == TCURC.WAERS