C_BPCustSlsAddrDepdntTaxInfo

Cview for I_BPCustSlsAddrDepdntTaxInfoTP | view: CCUSTTAXDADDR | Extraction: Not supported | Component: Business Partners

Tables used: BUT000, KNA1, KNVV, CVI_CUST_LINK, KNVI, T001W, TVKWZ, TVTA, KNVI_ADDR

🔑 Keys (7)
💰 Amounts
∑ Quantities
📅 Dates
☰ Categorical
Other (2)
🔗 Relations (10)

Column Name	Description
BusinessPartner	Business Partner Number
SalesOrganization FK	Sales Organization
DistributionChannel FK	Reference distrib.channel for cust.and material masters
Division FK	Division
DepartureCountry FK	Departure Country/Region (from which the goods are sent)
CustomerTaxCategory FK	Tax category (sales tax, federal sales tax,...)
AddressID FK	Business Partner Address Number (from BUT020)

Column Name	Description

Column Name	Description

Column Name	Description

Column Name	Description

Column Name	Description	Domain name
FormattedAddress	null
Customer	Customer Number	KUNNR

Master Data Relations	Join Conditions
Business Partner Address Number (from BUT020) ? Business Partner Address Number (from BUT020) Business Partner Address Number (from BUT020) Client	`C_BPCUSTSLSADDRDEPDNTTAXINFO.[column in domain "BU_PARTNER"] == BUT020.PARTNER` `C_BPCUSTSLSADDRDEPDNTTAXINFO.ADDRESSID == BUT020.ADDRNUMBER` `C_BPCUSTSLSADDRDEPDNTTAXINFO.ADDRESSIDFOREDIT == BUT020.ADDRNUMBER` `C_BPCUSTSLSADDRDEPDNTTAXINFO.MANDT == BUT020.CLIENT`
Business Partner Address Number (from BUT020) ? Business Partner Address Number (from BUT020) Business Partner Address Number (from BUT020) Client	`C_BPCUSTSLSADDRDEPDNTTAXINFO.[column in domain "BU_PARTNER"] == BUT020.PARTNER` `C_BPCUSTSLSADDRDEPDNTTAXINFO.ADDRESSID == BUT020.ADDRNUMBER` `C_BPCUSTSLSADDRDEPDNTTAXINFO.ADDRESSIDFOREDIT == BUT020.ADDRNUMBER` `C_BPCUSTSLSADDRDEPDNTTAXINFO.MANDT == BUT020.CLIENT`
Tax category (sales tax, federal sales tax,...) ? ? Client Tax category (sales tax, federal sales tax,...) Tax category (sales tax, federal sales tax,...)	`C_BPCUSTSLSADDRDEPDNTTAXINFO.[column in domain "KAPPL"] == T685.KAPPL` `C_BPCUSTSLSADDRDEPDNTTAXINFO.[column in domain "KVEWE"] == T685.KVEWE` `C_BPCUSTSLSADDRDEPDNTTAXINFO.MANDT == T685.MANDT` `C_BPCUSTSLSADDRDEPDNTTAXINFO.CUSTOMERTAXCATEGORYFOREDIT == T685.KSCHL` `C_BPCUSTSLSADDRDEPDNTTAXINFO.CUSTOMERTAXCATEGORY == T685.KSCHL`
Tax category (sales tax, federal sales tax,...) ? ? Client Tax category (sales tax, federal sales tax,...) Tax category (sales tax, federal sales tax,...)	`C_BPCUSTSLSADDRDEPDNTTAXINFO.[column in domain "KAPPL"] == T685.KAPPL` `C_BPCUSTSLSADDRDEPDNTTAXINFO.[column in domain "KVEWE"] == T685.KVEWE` `C_BPCUSTSLSADDRDEPDNTTAXINFO.MANDT == T685.MANDT` `C_BPCUSTSLSADDRDEPDNTTAXINFO.CUSTOMERTAXCATEGORYFOREDIT == T685.KSCHL` `C_BPCUSTSLSADDRDEPDNTTAXINFO.CUSTOMERTAXCATEGORY == T685.KSCHL`
Tax classification for customer Client Tax category (sales tax, federal sales tax,...) Tax category (sales tax, federal sales tax,...) Tax classification for customer	`C_BPCUSTSLSADDRDEPDNTTAXINFO.MANDT == TSKD.MANDT` `C_BPCUSTSLSADDRDEPDNTTAXINFO.CUSTOMERTAXCATEGORYFOREDIT == TSKD.TATYP` `C_BPCUSTSLSADDRDEPDNTTAXINFO.CUSTOMERTAXCATEGORY == TSKD.TATYP` `C_BPCUSTSLSADDRDEPDNTTAXINFO.CUSTOMERTAXCLASSIFICATION == TSKD.TAXKD`
Departure Country/Region (from which the goods are sent) Departure Country/Region (from which the goods are sent) Departure Country/Region (from which the goods are sent) Client	`C_BPCUSTSLSADDRDEPDNTTAXINFO.DEPARTURECOUNTRYFOREDIT == T005.LAND1` `C_BPCUSTSLSADDRDEPDNTTAXINFO.DEPARTURECOUNTRY == T005.LAND1` `C_BPCUSTSLSADDRDEPDNTTAXINFO.MANDT == T005.MANDT`
Departure Country/Region (from which the goods are sent) Departure Country/Region (from which the goods are sent) Departure Country/Region (from which the goods are sent) Client	`C_BPCUSTSLSADDRDEPDNTTAXINFO.DEPARTURECOUNTRYFOREDIT == T005.LAND1` `C_BPCUSTSLSADDRDEPDNTTAXINFO.DEPARTURECOUNTRY == T005.LAND1` `C_BPCUSTSLSADDRDEPDNTTAXINFO.MANDT == T005.MANDT`
Reference distrib.channel for cust.and material masters Client Sales Organization Reference distrib.channel for cust.and material masters	`C_BPCUSTSLSADDRDEPDNTTAXINFO.MANDT == TVKOV.MANDT` `C_BPCUSTSLSADDRDEPDNTTAXINFO.SALESORGANIZATION == TVKOV.VKORG` `C_BPCUSTSLSADDRDEPDNTTAXINFO.DISTRIBUTIONCHANNEL == TVKOV.VTWEG`
Division Client Sales Organization Division	`C_BPCUSTSLSADDRDEPDNTTAXINFO.MANDT == TVKOS.MANDT` `C_BPCUSTSLSADDRDEPDNTTAXINFO.SALESORGANIZATION == TVKOS.VKORG` `C_BPCUSTSLSADDRDEPDNTTAXINFO.DIVISION == TVKOS.SPART`
Sales Organization Client Sales Organization	`C_BPCUSTSLSADDRDEPDNTTAXINFO.MANDT == TVKO.MANDT` `C_BPCUSTSLSADDRDEPDNTTAXINFO.SALESORGANIZATION == TVKO.VKORG`