C_DaysSalesOutstanding0

DSO for SMB Query old | view: CFIDAYSSLSOUTST0 | Extraction: Not supported | Component: Information System
Tables used: SCAL_TT_DATEBSEGT001SADCPADRCT004T001TKA02T005T005TKNA1T077DT077XTKUKLTKUKTKNB1KNB5SKA1T005ST005UT001T014SKATT004
Column Name Description
CompanyCode Company Code
Customer Customer
CalendarYear Calendar Year
CalendarMonth Calendar Month
Column Name Description
💲 Display Currency (DisplayCurrency):
DebitAmtInDisplayCrcy null
RevenueAmountInDisplayCrcy null
Column Name Description
Column Name Description
Column Name Description
FinancialAccountType Account Type Show values
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
DaysSalesOutstanding null
Master Data Relations Join Conditions
Accounting Clerk
  • ?
  • Accounting Clerk
  • Client
  • C_DAYSSALESOUTSTANDING0.[column in domain "BUKRS"] == T001S.BUKRS
  • C_DAYSSALESOUTSTANDING0.ACCOUNTINGCLERK == T001S.BUSAB
  • C_DAYSSALESOUTSTANDING0.MANDT == T001S.MANDT
Customer Account Group
  • Client
  • Customer Account Group
  • C_DAYSSALESOUTSTANDING0.MANDT == T077D.MANDT
  • C_DAYSSALESOUTSTANDING0.CUSTOMERACCOUNTGROUP == T077D.KTOKD
Customer Classification
  • Client
  • Customer Classification
  • C_DAYSSALESOUTSTANDING0.MANDT == TKUKL.MANDT
  • C_DAYSSALESOUTSTANDING0.CUSTOMERCLASSIFICATION == TKUKL.KUKLA
Reconciliation Account in General Ledger
  • Reconciliation Account in General Ledger
  • ?
  • Client
  • C_DAYSSALESOUTSTANDING0.RECONCILIATIONACCOUNT == SKB1.SAKNR
  • C_DAYSSALESOUTSTANDING0.[column in domain "BUKRS"] == SKB1.BUKRS
  • C_DAYSSALESOUTSTANDING0.MANDT == SKB1.MANDT