C_Productsalescountry

Product master - Sales Country/Region | view: CPRDSALESCNTRY | Extraction: Not supported | Component: Material Master
Tables used: MLAN, TSTL, T001, T001W, TSTL, TVKO, TVKWZ, TVTW
Column Name Description
Product FK Product Number
ProductSalesOrg Sales Organization
ProductDistributionChnl Distribution Channel
Country FK Departure Country/Region (from which the goods are sent)
TaxCategory FK Tax category (sales tax, federal sales tax,...)
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
TaxClassification null
Master Data Relations Join Conditions
Country key
  • Departure Country/Region (from which the goods are sent)
  • Departure Country/Region (from which the goods are sent)
  • Client
  • C_PRODUCTSALESCOUNTRY.SOURCELOCATIONCOUNTRY == T005.LAND1
  • C_PRODUCTSALESCOUNTRY.COUNTRY == T005.LAND1
  • C_PRODUCTSALESCOUNTRY.MANDT == T005.MANDT
Material No.
  • Client
  • Product Number
  • C_PRODUCTSALESCOUNTRY.MANDT == MARA.MANDT
  • C_PRODUCTSALESCOUNTRY.PRODUCT == MARA.MATNR
Country key
  • Departure Country/Region (from which the goods are sent)
  • Departure Country/Region (from which the goods are sent)
  • Client
  • C_PRODUCTSALESCOUNTRY.SOURCELOCATIONCOUNTRY == T005.LAND1
  • C_PRODUCTSALESCOUNTRY.COUNTRY == T005.LAND1
  • C_PRODUCTSALESCOUNTRY.MANDT == T005.MANDT
Tax category (sales tax, federal sales tax,...)
  • ?
  • Tax category (sales tax, federal sales tax,...)
  • Tax category (sales tax, federal sales tax,...)
  • Client
  • C_PRODUCTSALESCOUNTRY.[column in domain "KAPPL"] == T685A.KAPPL
  • C_PRODUCTSALESCOUNTRY.TAXCATEGORY == T685A.KSCHL
  • C_PRODUCTSALESCOUNTRY.TAXCLASSIFICATIONCATEGORY == T685A.KSCHL
  • C_PRODUCTSALESCOUNTRY.MANDT == T685A.MANDT
Tax category (sales tax, federal sales tax,...)
  • ?
  • Tax category (sales tax, federal sales tax,...)
  • Tax category (sales tax, federal sales tax,...)
  • Client
  • C_PRODUCTSALESCOUNTRY.[column in domain "KAPPL"] == T685A.KAPPL
  • C_PRODUCTSALESCOUNTRY.TAXCATEGORY == T685A.KSCHL
  • C_PRODUCTSALESCOUNTRY.TAXCLASSIFICATIONCATEGORY == T685A.KSCHL
  • C_PRODUCTSALESCOUNTRY.MANDT == T685A.MANDT