C_DunningLevelDistribution

Dunning Level Distribution Smart Business App | view: CFIDUNLVLDISTR | Extraction: Not supported | Component: Information System
Tables used: BSEGT001SADCPADRCT004T001TKA02T005T005TKNA1T077DT077XTKUKLTKUKTKNB1KNB5SKA1T005ST005UT014SKAT
Column Name Description
CompanyCode FK Company Code
Customer FK Customer
DunningLevel Dunning Level
Column Name Description
💲 Display Currency (DisplayCurrency):
DunningLevel1AmtInDspCrcy Dunning Amount Level 1 in Display Currency
DunningLevel2AmtInDspCrcy Dunning Amount Level 2 in Display Currency
DunningLevel3AmtInDspCrcy Dunning Amount Level 3 in Display Currency
DunningLevel4AmtInDspCrcy Dunning Amount Level 4 in Display Currency
DunningLevel5AmtInDspCrcy Dunning Amount Level 5 in Display Currency
DunningLevel6AmtInDspCrcy Dunning Amount Level 6 in Display Currency
DunningLevel7AmtInDspCrcy Dunning Amount Level 7 in Display Currency
DunningLevel8AmtInDspCrcy Dunning Amount Level 8 in Display Currency
DunningLevel9AmtInDspCrcy Dunning Amount Level 9 in Display Currency
DunningLevelRngeAmtInDspCrcy Dunning Level Range Amount in Display Currency
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
ExchangeRateType Exchange Rate Type KURST
CustomerCountry Country / Region Key LAND1
CustomerRegion Region (State, Province, County) REGIO
CompanyCodeName Name of Company Code or Company TEXT25
CustomerName Name of Customer TEXT80
CustomerCountryName Country/Region Name TEXT50
CustomerRegionName Description TEXT20
AccountingClerkName Name of Accounting Clerk TEXT30
ReconciliationAccountLongName G/L Account Long Text TEXT50
CustomerAccountGroupName Account Group Name TEXT30
CustomerClassificationDesc Customer Classification Description TEXT20
Master Data Relations Join Conditions
Accounting Clerk
  • Company Code
  • Accounting Clerk
  • Client
  • C_DUNNINGLEVELDISTRIBUTION.COMPANYCODE == T001S.BUKRS
  • C_DUNNINGLEVELDISTRIBUTION.ACCOUNTINGCLERK == T001S.BUSAB
  • C_DUNNINGLEVELDISTRIBUTION.MANDT == T001S.MANDT
Company Code
  • Company Code
  • Client
  • C_DUNNINGLEVELDISTRIBUTION.COMPANYCODE == T001.BUKRS
  • C_DUNNINGLEVELDISTRIBUTION.MANDT == T001.MANDT
Customer
  • Customer
  • Client
  • C_DUNNINGLEVELDISTRIBUTION.CUSTOMER == KNA1.KUNNR
  • C_DUNNINGLEVELDISTRIBUTION.MANDT == KNA1.MANDT
Customer Account Group
  • Client
  • Customer Account Group
  • C_DUNNINGLEVELDISTRIBUTION.MANDT == T077D.MANDT
  • C_DUNNINGLEVELDISTRIBUTION.CUSTOMERACCOUNTGROUP == T077D.KTOKD
Customer Classification
  • Client
  • Customer Classification
  • C_DUNNINGLEVELDISTRIBUTION.MANDT == TKUKL.MANDT
  • C_DUNNINGLEVELDISTRIBUTION.CUSTOMERCLASSIFICATION == TKUKL.KUKLA
Reconciliation Account in General Ledger
  • Company Code
  • Client
  • Reconciliation Account in General Ledger
  • C_DUNNINGLEVELDISTRIBUTION.COMPANYCODE == SKB1.BUKRS
  • C_DUNNINGLEVELDISTRIBUTION.MANDT == SKB1.MANDT
  • C_DUNNINGLEVELDISTRIBUTION.RECONCILIATIONACCOUNT == SKB1.SAKNR