BP1020

BP: Business Partner - Fiscal Data | #masterdata | Component: Business Partner
Column Name Description
MANDT FK Client
PARTNR Business Partner Number
Column Name Description
Column Name Description
Column Name Description
Column Name Description
TAX_RES Tax Non-Resident Indicator Show values
STKZA Indicator: Business Partner Subject to Equalization Tax? Show values
STKZU Liable for VAT Show values
Column Name Description Domain name
STCD1 Tax Number 1 STCD1
STCD2 Tax Number 2 STCD2
STCEG VAT Registration Number STCEG
Master Data Relations Join Conditions
City Code
  • Region (State, Province, County)
  • City Code
  • Client
  • Country/Region Key
  • BP1020.REGION == T005G.REGIO
  • BP1020.CITYC == T005G.CITYC
  • BP1020.MANDT == T005G.MANDT
  • BP1020.COUNTRY == T005G.LAND1
County Code
  • County Code
  • Country/Region Key
  • Region (State, Province, County)
  • BP1020.MANDT == T005E.MANDT
  • BP1020.COUNC == T005E.COUNC
  • BP1020.COUNTRY == T005E.LAND1
  • BP1020.REGION == T005E.REGIO
Country/Region Key
  • Country/Region Key
  • Client
  • BP1020.COUNTRY == T005.LAND1
  • BP1020.MANDT == T005.MANDT
Account number of the master record with the fiscal address
  • BP1020.MANDT == KNA1.MANDT
  • BP1020.FISKN == KNA1.KUNNR
Foreign Key: Client BP1020.MANDT == T000.MANDT
Region (State, Province, County)
  • Country/Region Key
  • Region (State, Province, County)
  • BP1020.MANDT == T005S.MANDT
  • BP1020.COUNTRY == T005S.LAND1
  • BP1020.REGION == T005S.BLAND
Foreign Key: Tax Jurisdiction
  • ?
  • Tax Jurisdiction
  • BP1020.MANDT == TTXJ.MANDT
  • BP1020.[column in domain "TAX_KALSM"] == TTXJ.KALSM
  • BP1020.TXJCD == TTXJ.TXJCD