C_MyDunnProposals

My Dunning Proposals | view: CMYDUNNPROPS | Extraction: Not supported | Component: Fiori FXU Accounts Receivable FI-FIO-AR
Tables used: MAHNSMHNKT001SBUT000T001TKA02T005T005TTCURCTCURXTCURTKNA1CVI_CUST_LINKT047MT047NT040ST040TT047AT047T
Column Name Description
DunningRunDate Dunning Run Date
DunningRun Dunning Run Identification
FinancialAccountType Account Type Show values
CompanyCode FK Company Code
Customer FK Customer Number
BusinessPartner Business Partner 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
DunAreaAcctBalanceDunCrcy Dunning Area Account Balance in Dunning Currency
💲 Currency Key (CompanyCodeCurrency):
DueLineItemsTotalInCCCrcy Total of Due Items in Company Code Currency
Column Name Description
Column Name Description
DunningRunDate Dunning Run Date
DunningPrintDate Dunning Print Date
DunningDate Dunning Date
LegDunningProcedureOn Date of the Legal Dunning Proceedings
DocIncldUpToPostgDate Posting Date up to Which Documents Are Included
LastDunningPrntDate Print Date of Last Dunning Notice
Column Name Description
FinancialAccountType Account Type Show values
DunningNoticeIsSent Indicator: Is a Dunning Notice Sent? Show values
Column Name Description Domain name
AccountingClerkName Name of Accounting Clerk TEXT30
UserID Business User ID XUBNAME
CompanyCodeName Name of Company Code or Company TEXT25
CustomerName Name of Customer TEXT80
GroupingDunningAreaName Dunning Area Description TEXT50
CityName City TEXT40
CountryName Country/Region Name TEXT50
POBox PO Box CHAR10
PostalCode City postal code CHAR10
StreetName Street and House Number TEXT35
DunningBlockingReasonDesc Reason For Dunning Block TEXT50
DunningProcedureDescription Dunning Type Text TEXT60
DunningCurrencyName Description TEXT40
CompanyCodeCurrencyName Description TEXT40
DunningLevel Dunning Level MAHNS
OrganizationBPName1 Name 1 NAME
OrganizationBPName2 Name 2 NAME
AddressID Address ADRNR
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • C_MYDUNNPROPOSALS.COMPANYCODE == T001.BUKRS
  • C_MYDUNNPROPOSALS.MANDT == T001.MANDT
Currency Key
  • Client
  • Dunning Currency
  • Currency Key
  • C_MYDUNNPROPOSALS.MANDT == TCURC.MANDT
  • C_MYDUNNPROPOSALS.DUNNINGCURRENCY == TCURC.WAERS
  • C_MYDUNNPROPOSALS.COMPANYCODECURRENCY == TCURC.WAERS
Country/Region Key
  • Client
  • Country/Region Key
  • C_MYDUNNPROPOSALS.MANDT == T005.MANDT
  • C_MYDUNNPROPOSALS.COUNTRY == T005.LAND1
Customer Number
  • Client
  • Customer Number
  • C_MYDUNNPROPOSALS.MANDT == KNA1.MANDT
  • C_MYDUNNPROPOSALS.CUSTOMER == KNA1.KUNNR
Head Office Account Number (in branch accounts)
  • Client
  • Head Office Account Number (in branch accounts)
  • C_MYDUNNPROPOSALS.MANDT == KNA1.MANDT
  • C_MYDUNNPROPOSALS.CUSTOMERHEADOFFICE == KNA1.KUNNR
Dunning Block
  • Client
  • Dunning Block
  • C_MYDUNNPROPOSALS.MANDT == T040S.MANDT
  • C_MYDUNNPROPOSALS.DUNNINGBLOCKINGREASON == T040S.MANSP
Dunning Clerk
  • Company Code
  • Client
  • Dunning Clerk
  • C_MYDUNNPROPOSALS.COMPANYCODE == T001S.BUKRS
  • C_MYDUNNPROPOSALS.MANDT == T001S.MANDT
  • C_MYDUNNPROPOSALS.DUNNINGCLERK == T001S.BUSAB
Dunning Currency
  • Client
  • Dunning Currency
  • Currency Key
  • C_MYDUNNPROPOSALS.MANDT == TCURC.MANDT
  • C_MYDUNNPROPOSALS.DUNNINGCURRENCY == TCURC.WAERS
  • C_MYDUNNPROPOSALS.COMPANYCODECURRENCY == TCURC.WAERS
Key for Dunning Notice Grouping
  • Client
  • Key for Dunning Notice Grouping
  • C_MYDUNNPROPOSALS.MANDT == T047R.MANDT
  • C_MYDUNNPROPOSALS.DUNNINGNOTICEGROUP == T047R.MGRUP
Dunning Procedure
  • Client
  • Dunning Procedure
  • C_MYDUNNPROPOSALS.MANDT == T047A.MANDT
  • C_MYDUNNPROPOSALS.DUNNINGPROCEDURE == T047A.MAHNA
Account Number of the Dunning Recipient
  • Account Number of the Dunning Recipient
  • Client
  • C_MYDUNNPROPOSALS.DUNNINGRECIPIENT == KNA1.KUNNR
  • C_MYDUNNPROPOSALS.MANDT == KNA1.MANDT
Dunning Area
  • Company Code
  • Client
  • Dunning Area
  • C_MYDUNNPROPOSALS.COMPANYCODE == T047M.BUKRS
  • C_MYDUNNPROPOSALS.MANDT == T047M.MANDT
  • C_MYDUNNPROPOSALS.GROUPINGDUNNINGAREA == T047M.MABER
Language Key C_MYDUNNPROPOSALS.LANGUAGE == T002.SPRAS
Supplier
  • Supplier
  • Client
  • C_MYDUNNPROPOSALS.SUPPLIER == LFA1.LIFNR
  • C_MYDUNNPROPOSALS.MANDT == LFA1.MANDT