SAP table BPDTAX (BP Structure for Tax Data)

SAP table BPDTAX has 2 primary key fields being MANDT,PARTNR.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
PARTNR Business Partner Number CHAR 10 0 BUT000 BP_PARTNR_NEW
STCD1 Tax Number 1 CHAR 16 0 STCD1
STCD2 Tax Number 2 CHAR 11 0 STCD2
TAX_RES Tax Non-Resident Indicator CHAR 1 0 BP_TAX_RES
COUNC County Code CHAR 3 0 T005E COUNC
CITYC City Code CHAR 4 0 T005G CITYC
STKZA Indicator: Business Partner Subject to Equalization Tax? CHAR 1 0 STKZA
Not subject to equalization tax
X Subject to equalization tax
STKZU Liable for VAT CHAR 1 0 STKZU
STCEG VAT Registration Number CHAR 20 0 STCEG
TXJCD Tax Jurisdiction CHAR 15 0 TTXJ TXJCD
COUNTRY Country/Region Key CHAR 3 0 T005 LAND1
REGION Region (State, Province, County) CHAR 3 0 T005S REGIO
FISKN Account number of the master record with the fiscal address CHAR 10 0 KNA1 FISKN_D

BPDTAX foreign key relationships

Table Field Check Table Check Field
0 BPDTAX CITYC T005G City MANDT
0 BPDTAX CITYC T005G City LAND1
0 BPDTAX CITYC T005G City REGIO
0 BPDTAX CITYC T005G City CITYC
1 BPDTAX COUNC T005E County MANDT
1 BPDTAX COUNC T005E County LAND1
1 BPDTAX COUNC T005E County REGIO
1 BPDTAX COUNC T005E County COUNC
0 BPDTAX COUNTRY T005 Countries MANDT
0 BPDTAX COUNTRY T005 Countries LAND1
1 BPDTAX FISKN KNA1 General Data in Customer Master MANDT
1 BPDTAX FISKN KNA1 General Data in Customer Master KUNNR
0 BPDTAX MANDT T000 Clients MANDT
1 BPDTAX REGION T005S Taxes: Region (Province) Key LAND1
0 BPDTAX TXJCD TTXJ Check Table for Tax Jurisdiction MANDT
0 BPDTAX TXJCD TTXJ Check Table for Tax Jurisdiction KALSM