C_TotalAccountsReceivables

Total Accounts Receivables Smart Business App | view: CFITOTALACCTRBLS | Extraction: Not supported | Component: Information System
Tables used: SCAL_TT_DATEBSEGT001SADCPADRCT004T001TKA02T005T005TKNA1T077DT077XTKUKLTKUKTKNB1KNB5SKA1T005ST005UT074UT074TT014SKAT
Column Name Description
Column Name Description
💲 Display Currency (DisplayCurrency):
TotalAmountInDisplayCrcy Total Amount in Display Currency
TotalNotOvrdAmtInDspCrcy Total Not Due Amount in Display Currency
TotalOverdueAmtInDspCrcy Total Overdue Amount in Display Currency
NetDueIntvl1AmtInDspCrcy Amount in 1st Due Period (Display Currency)
NetDueIntvl2AmtInDspCrcy Amount in 2nd Due Period (Display Currency)
NetDueIntvl3AmtInDspCrcy Amount in 3rd Due Period (Display Currency)
NetDueIntvl4AmtInDspCrcy Amount in 4th Due Period (Display Currency)
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
CompanyCode Company Code BUKRS
Customer Customer KUNNR
NetDueIntervalText Net Due Date Interval CHAR50
ExchangeRateType Exchange Rate Type KURST
CustomerCountry Country / Region Key LAND1
CustomerRegion Region (State, Province, County) REGIO
SpecialGLCode Special G/L Indicator UMSKZ
GLAccount G/L Account SAKNR
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
SpecialGLCodeName Long Text for Special G/L Indicators TEXT30
ReconciliationAccountLongName G/L Account Long Text TEXT50
GLAccountLongName G/L Account Long Text TEXT50
CustomerAccountGroupName Account Group Name TEXT30
CustomerClassificationDesc Customer Classification Description TEXT20
Master Data Relations Join Conditions
Accounting Clerk
  • ?
  • Accounting Clerk
  • Client
  • C_TOTALACCOUNTSRECEIVABLES.[column in domain "BUKRS"] == T001S.BUKRS
  • C_TOTALACCOUNTSRECEIVABLES.ACCOUNTINGCLERK == T001S.BUSAB
  • C_TOTALACCOUNTSRECEIVABLES.MANDT == T001S.MANDT
Currency Key
  • Currency Key
  • Client
  • C_TOTALACCOUNTSRECEIVABLES.COMPANYCODECURRENCY == TCURC.WAERS
  • C_TOTALACCOUNTSRECEIVABLES.MANDT == TCURC.MANDT
Customer Account Group
  • Customer Account Group
  • Client
  • C_TOTALACCOUNTSRECEIVABLES.CUSTOMERACCOUNTGROUP == T077D.KTOKD
  • C_TOTALACCOUNTSRECEIVABLES.MANDT == T077D.MANDT
Customer Classification
  • Client
  • Customer Classification
  • C_TOTALACCOUNTSRECEIVABLES.MANDT == TKUKL.MANDT
  • C_TOTALACCOUNTSRECEIVABLES.CUSTOMERCLASSIFICATION == TKUKL.KUKLA
Reconciliation Account in General Ledger
  • ?
  • Client
  • Reconciliation Account in General Ledger
  • C_TOTALACCOUNTSRECEIVABLES.[column in domain "BUKRS"] == SKB1.BUKRS
  • C_TOTALACCOUNTSRECEIVABLES.MANDT == SKB1.MANDT
  • C_TOTALACCOUNTSRECEIVABLES.RECONCILIATIONACCOUNT == SKB1.SAKNR