I_BPCustSlsAddrDepdntTaxInfo

BP and Cust Tax ind Addr Depdnt Info | view: ICUSTTAXINDADDR | Extraction: Not supported | Component: Business Partners

Tables used: BUT020, BUT021_FS, BUT000, BUT000, CVI_CUST_LINK, KNA1, BUT020, KNA1, KNVV, KNVI, T001W, TVKWZ, TVTA, KNVI_ADDR, BUT021_FS, TB008S, TB008U

🔑 Keys (2)
💰 Amounts
∑ Quantities
📅 Dates
☰ Categorical (9)
Other (11)
🔗 Relations (20)

Column Name	Description
BusinessPartner FK	Business Partner Number
AddressID FK	Address Number

Column Name	Description

Column Name	Description

Column Name	Description

Column Name	Description
PostingIsBlocked	Central posting block	Show values
DataMediumExchangeIndicator	Report key for data medium exchange	Show values
VATLiability	Liable for VAT	Show values
IsNaturalPerson	Natural Person	Show values
DeliveryDateTypeRule	Delivery Date Rule	Show values
IsCompetitor	Indicator: Competitor	Show values
IsSalesPartner	Indicator: Sales partner	Show values
IsDefaultSoldToParty	ID for default sold-to party	Show values
IsConsumer	Indicator: Consumer	Show values

Column Name	Description	Domain name
Customer	Customer Number	KUNNR
SalesOrganization	null
DistributionChannel	null
Division	null
DepartureCountry	null
CustomerTaxCategory	null
CustomerTaxClassification	null
AuthorizationGroup	Authorization Group	BRGRU
CustomerCorporateGroup	Group key	KONZS
CityLocationCoordinatesCode	City Coordinates	LOCCO
DataExchangeInstructionKey	Instruction Key for Data Medium Exchange	DTAWS

Master Data Relations	Join Conditions
Address Number ? Address Number ? Client	`I_BPCUSTSLSADDRDEPDNTTAXINFO.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM` `I_BPCUSTSLSADDRDEPDNTTAXINFO.ADDRESSID == ADRC.ADDRNUMBER` `I_BPCUSTSLSADDRDEPDNTTAXINFO.[column in domain "AD_NATION"] == ADRC.NATION` `I_BPCUSTSLSADDRDEPDNTTAXINFO.MANDT == ADRC.CLIENT`
Account Number of an Alternative Payer Account Number of an Alternative Payer Client	`I_BPCUSTSLSADDRDEPDNTTAXINFO.ALTERNATIVEPAYERACCOUNT == KNA1.KUNNR` `I_BPCUSTSLSADDRDEPDNTTAXINFO.MANDT == KNA1.MANDT`
Central billing block for customer Central billing block for customer Client	`I_BPCUSTSLSADDRDEPDNTTAXINFO.BILLINGISBLOCKEDFORCUSTOMER == TVFS.FAKSP` `I_BPCUSTSLSADDRDEPDNTTAXINFO.MANDT == TVFS.MANDT`
Business Partner Number Business Partner Number Client	`I_BPCUSTSLSADDRDEPDNTTAXINFO.BUSINESSPARTNER == BUT000.PARTNER` `I_BPCUSTSLSADDRDEPDNTTAXINFO.MANDT == BUT000.CLIENT`
Customer Account Group Customer Account Group Client	`I_BPCUSTSLSADDRDEPDNTTAXINFO.CUSTOMERACCOUNTGROUP == T077D.KTOKD` `I_BPCUSTSLSADDRDEPDNTTAXINFO.MANDT == T077D.MANDT`
Customer Classification Customer Classification Client	`I_BPCUSTSLSADDRDEPDNTTAXINFO.CUSTOMERCLASSIFICATION == TKUKL.KUKLA` `I_BPCUSTSLSADDRDEPDNTTAXINFO.MANDT == TKUKL.MANDT`
Customer Condition Group Customer condition group 1 Client	`I_BPCUSTSLSADDRDEPDNTTAXINFO.CUSTOMERCONDITIONGROUP1 == TVKGG.KDKGR` `I_BPCUSTSLSADDRDEPDNTTAXINFO.MANDT == TVKGG.MANDT`
Customer Condition Group Client Customer condition group 2	`I_BPCUSTSLSADDRDEPDNTTAXINFO.MANDT == TVKGG.MANDT` `I_BPCUSTSLSADDRDEPDNTTAXINFO.CUSTOMERCONDITIONGROUP2 == TVKGG.KDKGR`
Customer Condition Group Client Customer condition group 3	`I_BPCUSTSLSADDRDEPDNTTAXINFO.MANDT == TVKGG.MANDT` `I_BPCUSTSLSADDRDEPDNTTAXINFO.CUSTOMERCONDITIONGROUP3 == TVKGG.KDKGR`
Customer Condition Group Client Customer condition group 4	`I_BPCUSTSLSADDRDEPDNTTAXINFO.MANDT == TVKGG.MANDT` `I_BPCUSTSLSADDRDEPDNTTAXINFO.CUSTOMERCONDITIONGROUP4 == TVKGG.KDKGR`
Customer Condition Group Customer condition group 5 Client	`I_BPCUSTSLSADDRDEPDNTTAXINFO.CUSTOMERCONDITIONGROUP5 == TVKGG.KDKGR` `I_BPCUSTSLSADDRDEPDNTTAXINFO.MANDT == TVKGG.MANDT`
Central delivery block for the customer Client Central delivery block for the customer	`I_BPCUSTSLSADDRDEPDNTTAXINFO.MANDT == TVLS.MANDT` `I_BPCUSTSLSADDRDEPDNTTAXINFO.DELIVERYISBLOCKED == TVLS.LIFSP`
Account number of the master record with the fiscal address Account number of the master record with the fiscal address Client	`I_BPCUSTSLSADDRDEPDNTTAXINFO.FISCALADDRESS == KNA1.KUNNR` `I_BPCUSTSLSADDRDEPDNTTAXINFO.MANDT == KNA1.MANDT`
Attribute 3 Attribute 3 Client	`I_BPCUSTSLSADDRDEPDNTTAXINFO.FREEDEFINEDATTRIBUTE03 == TVK3.KATR3` `I_BPCUSTSLSADDRDEPDNTTAXINFO.MANDT == TVK3.MANDT`
Industry code 1 Industry code 1 Client	`I_BPCUSTSLSADDRDEPDNTTAXINFO.INDUSTRYCODE1 == TBRC.BRACO` `I_BPCUSTSLSADDRDEPDNTTAXINFO.MANDT == TBRC.MANDT`
Industry code 2 Client Industry code 2	`I_BPCUSTSLSADDRDEPDNTTAXINFO.MANDT == TBRC.MANDT` `I_BPCUSTSLSADDRDEPDNTTAXINFO.INDUSTRYCODE2 == TBRC.BRACO`
Industry code 3 Industry code 3 Client	`I_BPCUSTSLSADDRDEPDNTTAXINFO.INDUSTRYCODE3 == TBRC.BRACO` `I_BPCUSTSLSADDRDEPDNTTAXINFO.MANDT == TBRC.MANDT`
Central order block for customer Central order block for customer ? Client	`I_BPCUSTSLSADDRDEPDNTTAXINFO.ORDERISBLOCKEDFORCUSTOMER == TVAST.AUFSP` `I_BPCUSTSLSADDRDEPDNTTAXINFO.[column in domain "SPRAS"] == TVAST.SPRAS` `I_BPCUSTSLSADDRDEPDNTTAXINFO.MANDT == TVAST.MANDT`
Plant Client Plant	`I_BPCUSTSLSADDRDEPDNTTAXINFO.MANDT == T001W.MANDT` `I_BPCUSTSLSADDRDEPDNTTAXINFO.PLANT == T001W.WERKS`
Account Number of Supplier Client Account Number of Supplier	`I_BPCUSTSLSADDRDEPDNTTAXINFO.MANDT == LFA1.MANDT` `I_BPCUSTSLSADDRDEPDNTTAXINFO.SUPPLIER == LFA1.LIFNR`