SAP Table BP1040_UPD

Business partner: Reporting data in company code

BP1040_UPD (Business partner: Reporting data in company code) 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 BP1040_UPD to other SAP tables.

BP1040_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
BUKRS Company Code BUKRS T001 CHAR 4 0
ENT_REL Legal Entity Relationship BerVersV Sample 1 BP_ENTITY_RELATIONS NUMC 2 0
01 Corporation - Insurance company
02 Corporation - Other
04 Private limited company - Other
97 Business Partner According to �54a Subp. 4a No. 5, a SICL
98 Business Partner According to �54a Subp. 4a No. 5, b SICL
99 Business Partner According to �54a Subp. 4a No. 5, c SICL
KWG_ORG Loan to Manager According to Paragraph 15 German Banking Act BP_KWG_ORG NUMC 2 0
BAL_SH Balance Sheet Display BP_BAL_SH CHAR 1 0
0 Not consolidated
1 Consolidated
2 Not associated
3 Associated
COMP_RE Company Relationship in Company Code BP_CCOM_RE CHAR 1 0
1 Affiliated Company
2 Shareholding
3 Other
4 Holding
LIABIL_RISK Type of Liability Risk BP_LIABIL_RISC TP016 CHAR 2 0
LIABIL_RISK_AMNT Amount of Liability Risk BP_RISK_AMNT DEC 17 2
LIABIL_RISK_CURR Currency Unit for Amount of Liability Risk BP_RISK_CURR TCURC CUKY 5 0
LIABIL_RISK_FROM Valid from Date for Liability Risk BP_LRISK_FROM DATS 8 0
LIABIL_RISK_TO Valid to Date for Liability Risk BP_LRISK_TO DATS 8 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)

BP1040_UPD foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
BP1040_UPD BUKRS BP1040_UPD MANDT T001 Company Codes MANDT
BP1040_UPD BUKRS BP1040_UPD BUKRS T001 Company Codes BUKRS
BP1040_UPD LIABIL_RISK SYST MANDT TP016 Value for Liability Risks MANDT
BP1040_UPD LIABIL_RISK BP1040_UPD LIABIL_RISK TP016 Value for Liability Risks BP_LIABIL_RISC
BP1040_UPD LIABIL_RISK_CURR BP1040_UPD LIABIL_RISK_CURR TCURC Currency Codes WAERS
BP1040_UPD LIABIL_RISK_CURR SYST MANDT TCURC Currency Codes MANDT
BP1040_UPD MANDT BP1040_UPD MANDT T000 Clients MANDT
BP1040_UPD PARTNR BP1040_UPD MANDT BUT000 BP: General data I CLIENT
BP1040_UPD PARTNR BP1040_UPD PARTNR BUT000 BP: General data I PARTNER