I_DunningEntryForOutpDetn

Determine Output Parameter for Dunning | view: IDUNNFOROUTPDETN | Extraction: Not supported | Component: Dunning/Interest
Tables used: MHNKT001SADCPADRCADR6ADR6BUT000BUT020BUT021_FST001TKA02KNA1KNB1KNB5CVI_CUST_LINKADCPADR2ADR3ADR6ADRPUSR21
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 Sort Field for One-Time Accounts
CustomerHeadOffice FK Head Office Account Number (in branch accounts)
GroupingDunningArea FK Dunning Area
GroupingDunningLevel Grouping Dunning Level
DunningClerk FK Dunning Clerk
Column Name Description
Column Name Description
Column Name Description
DunningRunDate Dunning Run Date
DunningPrintDate Dunning Print Date
DunningDate Dunning Date
LegDunningProcedureOn Date of the Legal Dunning Proceedings
Column Name Description
FinancialAccountType Account Type Show values
Column Name Description Domain name
UserID Business User ID XUBNAME
EmailAddress Contact Card E-Mail Address
AddressIndependentEmailAddress E-Mail Address AD_SMTPADR
DefaultEmailAddress E-Mail Address AD_SMTPADR
AccountingClerkInternetAddress Internet address of partner company clerk TXT130
DunningLevel Dunning Level MAHNS
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • I_DUNNINGENTRYFOROUTPDETN.MANDT == T001.MANDT
  • I_DUNNINGENTRYFOROUTPDETN.COMPANYCODE == T001.BUKRS
Country/Region Key
  • Client
  • Country/Region Key
  • Country/Region Key
  • I_DUNNINGENTRYFOROUTPDETN.MANDT == T005.MANDT
  • I_DUNNINGENTRYFOROUTPDETN.COUNTRY == T005.LAND1
  • I_DUNNINGENTRYFOROUTPDETN.COMPANYCODECOUNTRY == T005.LAND1
Country/Region Key
  • Client
  • Country/Region Key
  • Country/Region Key
  • I_DUNNINGENTRYFOROUTPDETN.MANDT == T005.MANDT
  • I_DUNNINGENTRYFOROUTPDETN.COUNTRY == T005.LAND1
  • I_DUNNINGENTRYFOROUTPDETN.COMPANYCODECOUNTRY == T005.LAND1
Customer Number
  • Client
  • Customer Number
  • I_DUNNINGENTRYFOROUTPDETN.MANDT == KNA1.MANDT
  • I_DUNNINGENTRYFOROUTPDETN.CUSTOMER == KNA1.KUNNR
Head Office Account Number (in branch accounts)
  • Head Office Account Number (in branch accounts)
  • Client
  • I_DUNNINGENTRYFOROUTPDETN.CUSTOMERHEADOFFICE == KNA1.KUNNR
  • I_DUNNINGENTRYFOROUTPDETN.MANDT == KNA1.MANDT
Dunning Block
  • Client
  • Dunning Block
  • I_DUNNINGENTRYFOROUTPDETN.MANDT == T040S.MANDT
  • I_DUNNINGENTRYFOROUTPDETN.DUNNINGBLOCKINGREASON == T040S.MANSP
Dunning Clerk
  • Client
  • Company Code
  • Dunning Clerk
  • I_DUNNINGENTRYFOROUTPDETN.MANDT == T001S.MANDT
  • I_DUNNINGENTRYFOROUTPDETN.COMPANYCODE == T001S.BUKRS
  • I_DUNNINGENTRYFOROUTPDETN.DUNNINGCLERK == T001S.BUSAB
Dunning Procedure
  • Dunning Procedure
  • Client
  • I_DUNNINGENTRYFOROUTPDETN.DUNNINGPROCEDURE == T047A.MAHNA
  • I_DUNNINGENTRYFOROUTPDETN.MANDT == T047A.MANDT
Dunning Area
  • Client
  • Dunning Area
  • Company Code
  • I_DUNNINGENTRYFOROUTPDETN.MANDT == T047M.MANDT
  • I_DUNNINGENTRYFOROUTPDETN.GROUPINGDUNNINGAREA == T047M.MABER
  • I_DUNNINGENTRYFOROUTPDETN.COMPANYCODE == T047M.BUKRS
Language Key I_DUNNINGENTRYFOROUTPDETN.LANGUAGE == T002.SPRAS
Supplier
  • Client
  • Supplier
  • I_DUNNINGENTRYFOROUTPDETN.MANDT == LFA1.MANDT
  • I_DUNNINGENTRYFOROUTPDETN.SUPPLIER == LFA1.LIFNR