SAP table BP1020_UPD (BP: Business partner - fiscal data)

SAP table BP1020_UPD 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 BU_PARTNER
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 * COUNC
CITYC City Code CHAR 4 0 * 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 * TXJCD
COUNTRY Country/Region Key CHAR 3 0 * LAND1
REGION Region (State, Province, County) CHAR 3 0 * REGIO
FISKN Account number of the master record with the fiscal address CHAR 10 0 * FISKN_D
KZ Type of Change CHAR 1 0 CDCHNGIND
D Delete
E Delete (single field documentation)
I Insert
J Insert (single field documentation)
U Change

BP1020_UPD foreign key relationships

Table Field Check Table Check Field
0 BP1020_UPD MANDT T000 Clients MANDT