C_EmailDunningEntryData

Email Data For Dunning Entry | view: CEMAILDUNNDATA | Extraction: Not supported | Component: Fiori FXU Accounts Receivable FI-FIO-AR
Tables used: MHNKT001ST001TKA02KNA1ADCPADR2ADR3ADR6ADRPUSR21
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):
DueLineItemsTotalInDunCrcy Total Line Items Due in Dunning Currency
Column Name Description
Column Name Description
DunningRunDate Dunning Run Date
Column Name Description
FinancialAccountType Account Type Show values
PrintIsReal Indicator: Is a Dunning Notice Sent? Show values
Column Name Description Domain name
UserID Business User ID XUBNAME
CompanyCodeName Name of Company Code or Company TEXT25
FullName Full Name of Person TEXT80
CustomerName Name of Customer TEXT80
DunningLevel Dunning Level MAHNS
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • C_EMAILDUNNINGENTRYDATA.COMPANYCODE == T001.BUKRS
  • C_EMAILDUNNINGENTRYDATA.MANDT == T001.MANDT
Customer Number
  • Customer Number
  • Client
  • C_EMAILDUNNINGENTRYDATA.CUSTOMER == KNA1.KUNNR
  • C_EMAILDUNNINGENTRYDATA.MANDT == KNA1.MANDT
Head Office Account Number (in branch accounts)
  • Client
  • Head Office Account Number (in branch accounts)
  • C_EMAILDUNNINGENTRYDATA.MANDT == KNA1.MANDT
  • C_EMAILDUNNINGENTRYDATA.CUSTOMERHEADOFFICE == KNA1.KUNNR
Dunning Clerk
  • Company Code
  • Dunning Clerk
  • Client
  • C_EMAILDUNNINGENTRYDATA.COMPANYCODE == T001S.BUKRS
  • C_EMAILDUNNINGENTRYDATA.DUNNINGCLERK == T001S.BUSAB
  • C_EMAILDUNNINGENTRYDATA.MANDT == T001S.MANDT
Dunning Currency
  • Client
  • Dunning Currency
  • C_EMAILDUNNINGENTRYDATA.MANDT == TCURC.MANDT
  • C_EMAILDUNNINGENTRYDATA.DUNNINGCURRENCY == TCURC.WAERS
Dunning Procedure
  • Dunning Procedure
  • Client
  • C_EMAILDUNNINGENTRYDATA.DUNNINGPROCEDURE == T047A.MAHNA
  • C_EMAILDUNNINGENTRYDATA.MANDT == T047A.MANDT
Dunning Area
  • Company Code
  • Dunning Area
  • Client
  • C_EMAILDUNNINGENTRYDATA.COMPANYCODE == T047M.BUKRS
  • C_EMAILDUNNINGENTRYDATA.GROUPINGDUNNINGAREA == T047M.MABER
  • C_EMAILDUNNINGENTRYDATA.MANDT == T047M.MANDT
Supplier
  • Supplier
  • Client
  • C_EMAILDUNNINGENTRYDATA.SUPPLIER == LFA1.LIFNR
  • C_EMAILDUNNINGENTRYDATA.MANDT == LFA1.MANDT