C_CustomerSalesAreaOP

Consumption Factsheet - Sales view Facet | view: CUSTSALESAREAOP | Extraction: Not supported | Component: Business Partners
Tables used: KNVV
Column Name Description
Customer FK Customer Number
SalesOrganization FK Sales Organization
DistributionChannel FK Distribution Channel
Division FK Division
Column Name Description
Column Name Description
Column Name Description
Column Name Description
IsBusinessPurposeCompleted Business Purpose Completed Flag Show values
Column Name Description Domain name
CustomerABCClassification Customer classification (ABC analysis) KLABC
AuthorizationGroup Authorization Group BEGRU
Master Data Relations Join Conditions
Billing block for customer (sales and distribution)
  • Billing block for customer (sales and distribution)
  • Client
  • C_CUSTOMERSALESAREAOP.BILLINGISBLOCKEDFORCUSTOMER == TVFS.FAKSP
  • C_CUSTOMERSALESAREAOP.MANDT == TVFS.MANDT
Customer Number
  • Client
  • Customer Number
  • C_CUSTOMERSALESAREAOP.MANDT == KNA1.MANDT
  • C_CUSTOMERSALESAREAOP.CUSTOMER == KNA1.KUNNR
Customer Group
  • Client
  • Customer Group
  • C_CUSTOMERSALESAREAOP.MANDT == T151.MANDT
  • C_CUSTOMERSALESAREAOP.CUSTOMERGROUP == T151.KDGRP
Customer delivery block (sales area)
  • Client
  • Customer delivery block (sales area)
  • C_CUSTOMERSALESAREAOP.MANDT == TVLS.MANDT
  • C_CUSTOMERSALESAREAOP.DELIVERYISBLOCKEDFORCUSTOMER == TVLS.LIFSP
Distribution Channel
  • Client
  • Distribution Channel
  • C_CUSTOMERSALESAREAOP.MANDT == TVTW.MANDT
  • C_CUSTOMERSALESAREAOP.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Client
  • Division
  • C_CUSTOMERSALESAREAOP.MANDT == TSPA.MANDT
  • C_CUSTOMERSALESAREAOP.DIVISION == TSPA.SPART
Customer order block (sales area)
  • Client
  • ?
  • Customer order block (sales area)
  • C_CUSTOMERSALESAREAOP.MANDT == TVAST.MANDT
  • C_CUSTOMERSALESAREAOP.[column in domain "SPRAS"] == TVAST.SPRAS
  • C_CUSTOMERSALESAREAOP.ORDERISBLOCKEDFORCUSTOMER == TVAST.AUFSP
Sales group
  • Client
  • Sales group
  • Sales office
  • C_CUSTOMERSALESAREAOP.MANDT == TVBVK.MANDT
  • C_CUSTOMERSALESAREAOP.SALESGROUP == TVBVK.VKGRP
  • C_CUSTOMERSALESAREAOP.SALESOFFICE == TVBVK.VKBUR
Sales office
  • Client
  • Sales office
  • C_CUSTOMERSALESAREAOP.MANDT == TVBUR.MANDT
  • C_CUSTOMERSALESAREAOP.SALESOFFICE == TVBUR.VKBUR
Sales Organization
  • Client
  • Sales Organization
  • C_CUSTOMERSALESAREAOP.MANDT == TVKO.MANDT
  • C_CUSTOMERSALESAREAOP.SALESORGANIZATION == TVKO.VKORG