SAP table BP1040_UPD (Business partner: Reporting data in company code)
SAP table BP1040_UPD has 3 primary key fields being MANDT,PARTNR,BUKRS.
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
Client
CLNT
3
0
T000
MANDT
Business Partner Number
CHAR
10
0
BUT000
BU_PARTNER
Company Code
CHAR
4
0
T001
BUKRS
ENT_REL
Legal Entity Relationship BerVersV Sample 1
NUMC
2
0
BP_ENTITY_RELATIONS
KWG_ORG
Loan to Manager According to Paragraph 15 German Banking Act
NUMC
2
0
*
BP_KWG_ORG
BAL_SH
Balance Sheet Display
CHAR
1
0
BP_BAL_SH
Possible values
0
Not consolidated
1
Consolidated
2
Not associated
3
Associated
COMP_RE
Company Relationship in Company Code
CHAR
1
0
BP_CCOM_RE
LIABIL_RISK
Type of Liability Risk
CHAR
2
0
TP016
BP_LIABIL_RISC
Possible values
1
Guarantee
2
Bank Comfort Letter
3
Loss-Sharing Agreement
4
Numeric
A
Letters
LIABIL_RISK_AMNT
Amount of Liability Risk
DEC
17
2
BP_RISK_AMNT
LIABIL_RISK_CURR
Currency Unit for Amount of Liability Risk
CUKY
5
0
TCURC
BP_RISK_CURR
LIABIL_RISK_FROM
Valid from Date for Liability Risk
DATS
8
0
BP_LRISK_FROM
LIABIL_RISK_TO
Valid to Date for Liability Risk
DATS
8
0
BP_LRISK_TO
KZ
Type of Change
CHAR
1
0
CDCHNGIND
Possible values
D
Delete
E
Delete (single field documentation)
I
Insert
J
Insert (single field documentation)
U
Change
BP1040_UPD foreign key relationships
Table
Field
Check Table
Check Field
0 BP1040_UPD
BUKRS
T001 Company Codes
BUKRS
1 BP1040_UPD
LIABIL_RISK
TP016 Value for Liability Risks
MANDT
1 BP1040_UPD
LIABIL_RISK
TP016 Value for Liability Risks
BP_LIABIL_RISC
0 BP1040_UPD
LIABIL_RISK_CURR
TCURC Currency Codes
WAERS
1 BP1040_UPD
MANDT
T000 Clients
MANDT