C_SalesOrganizationDEX

Sales Organization Data Extraction | view: CSDSALESORGDX | ATTR | Extraction: Full only | Component: Sales Analytics
Tables used: T001, TKA02, TVKO
Column Name Description
SalesOrganization Sales Organization
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
Master Data Relations Join Conditions
Company code of the sales organization
  • Company code of the sales organization
  • Client
  • C_SALESORGANIZATIONDEX.COMPANYCODE == T001.BUKRS
  • C_SALESORGANIZATIONDEX.MANDT == T001.MANDT
Country/Region Key
  • Client
  • Country/Region Key
  • C_SALESORGANIZATIONDEX.MANDT == T005.MANDT
  • C_SALESORGANIZATIONDEX.COUNTRY == T005.LAND1
Currency Key
  • Currency Key
  • Statistics currency
  • Client
  • C_SALESORGANIZATIONDEX.CURRENCY == TCURC.WAERS
  • C_SALESORGANIZATIONDEX.SALESORGANIZATIONCURRENCY == TCURC.WAERS
  • C_SALESORGANIZATIONDEX.MANDT == TCURC.MANDT
Fiscal Year Variant
  • Client
  • Fiscal Year Variant
  • C_SALESORGANIZATIONDEX.MANDT == T009.MANDT
  • C_SALESORGANIZATIONDEX.FISCALYEARVARIANT == T009.PERIV
Customer number for intercompany billing
  • Customer number for intercompany billing
  • Client
  • C_SALESORGANIZATIONDEX.INTERCOMPANYBILLINGCUSTOMER == KNA1.KUNNR
  • C_SALESORGANIZATIONDEX.MANDT == KNA1.MANDT
Statistics currency
  • Currency Key
  • Statistics currency
  • Client
  • C_SALESORGANIZATIONDEX.CURRENCY == TCURC.WAERS
  • C_SALESORGANIZATIONDEX.SALESORGANIZATIONCURRENCY == TCURC.WAERS
  • C_SALESORGANIZATIONDEX.MANDT == TCURC.MANDT