I_BPCustSlsAddrDepdntTaxInfoTP

TP View AdrDep SlsArea Tax Clasfctn | view: ICUSTTAXDADDRTP | 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 (3)
🔗 Relations (13)

Column Name	Description
DepartureCountry FK	Departure Country/Region (from which the goods are sent)
CustomerTaxCategory FK	Tax category (sales tax, federal sales tax,...)
SalesOrganization FK	Sales Organization
DistributionChannel FK	Reference distrib.channel for cust.and material masters
Division FK	Division
BusinessPartner	Business Partner Number
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
Customer	Customer Number	KUNNR
BusinessPartnerForEdit	Business Partner Number	BU_PARTNER
FormattedAddress	null

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