SAP Table BP1020_UPD

BP: Business partner - fiscal data

BP1020_UPD (BP: Business partner - fiscal data) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link BP1020_UPD to other SAP tables.

BP1020_UPD table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
PARTNR Business Partner Number BU_PARTNER BUT000 CHAR 10 0
STCD1 Tax Number 1 STCD1 CHAR 16 0
STCD2 Tax Number 2 STCD2 CHAR 11 0
TAX_RES Tax Non-Resident Indicator BP_TAX_RES CHAR 1 0
X Yes
NULL No
COUNC County Code COUNC CHAR 3 0
CITYC City Code CITYC CHAR 4 0
STKZA Indicator: Business Partner Subject to Equalization Tax? STKZA CHAR 1 0
NULL Not subject to equalization tax
X Subject to equalization tax
STKZU Liable for VAT STKZU CHAR 1 0
X Yes
NULL No
STCEG VAT Registration Number STCEG CHAR 20 0
TXJCD Tax Jurisdiction TXJCD CHAR 15 0
COUNTRY Country Key LAND1 CHAR 3 0
REGION Region (State, Province, County) REGIO CHAR 3 0
FISKN Account number of the master record with the fiscal address FISKN_D CHAR 10 0
KZ Change Type (U, I, S, D) CDCHNGIND CHAR 1 0
U Update
I Insert
E Delete (Single Field Documentation)
D Delete
J Insert (Single Field Documentation)

BP1020_UPD foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
BP1020_UPD MANDT BP1020_UPD MANDT T000 Clients MANDT
BP1020_UPD PARTNR BP1020_UPD MANDT BUT000 BP: General data I CLIENT
BP1020_UPD PARTNR BP1020_UPD PARTNR BUT000 BP: General data I PARTNER