1. Home
  2. Resources
  3. SAP Tables
  4. TPZ7 - BP: Business Partner - Relationship Category

SAP Table TPZ7

BP: Business Partner - Relationship Category

TPZ7 (BP: Business Partner - Relationship Category) 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 TPZ7 to other SAP tables.

TPZ7 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
REL_TYP Business Partner Relationship Category BP_REL_TYP_OLD CHAR 4 0
KARDINAL Cardinality of BP Relationship Category BP_KARDIN CHAR 2 0
NULL Unlimited number of relationships allowed
01 1 relationship allowed
02 2 relationships allowed
03 3 relationships allowed
04 4 relationships allowed
05 5 relationships allowed
06 6 relationships allowed
07 7 relationships allowed
08 8 relationships allowed
09 9 relationships allowed
10 10 relationships allowed
11 11 relationships allowed
12 12 relationships allowed
13 13 relationships allowed
14 14 relationships allowed
15 15 relationships allowed
16 16 relationships allowed
17 17 relationships allowed
18 18 relationships allowed
19 19 relationships allowed
20 20 relationships allowed
21 21 relationships allowed
22 22 relationships allowed
23 23 relationships allowed
24 24 relationships allowed
25 25 relationships allowed
26 26 relationships allowed
27 27 relationships allowed
28 28 relationships allowed
29 29 relationships allowed
30 30 relationships allowed
31 31 relationships allowed
32 32 relationships allowed
33 33 relationships allowed
34 34 relationships allowed
35 35 relationships allowed
36 36 relationships allowed
37 37 relationships allowed
38 38 relationships allowed
39 39 relationships allowed
40 40 relationships allowed
41 41 relationships allowed
42 42 relationships allowed
43 43 relationships allowed
44 44 relationships allowed
45 45 relationships allowed
46 46 relationships allowed
47 47 relationships allowed
48 48 relationships allowed
49 49 relationships allowed
50 50 relationships allowed
51 51 relationships allowed
52 52 relationships allowed
53 53 relationships allowed
54 54 relationships allowed
55 55 relationships allowed
56 56 relationships allowed
57 57 relationships allowed
58 58 relationships allowed
59 59 relationships allowed
60 60 relationships allowed
61 61 relationships allowed
62 62 relationships allowed
63 63 relationships allowed
64 64 relationships allowed
65 65 relationships allowed
66 66 relationships allowed
67 67 relationships allowed
68 68 relationships allowed
69 69 relationships allowed
70 70 relationships allowed
71 71 relationships allowed
72 72 relationships allowed
73 73 relationships allowed
74 74 relationships allowed
75 75 relationships allowed
76 76 relationships allowed
77 77 relationships allowed
78 78 relationships allowed
79 79 relationships allowed
80 80 relationships allowed
81 81 relationships allowed
82 82 relationships allowed
83 83 relationships allowed
84 84 relationships allowed
85 85 relationships allowed
86 86 relationships allowed
87 87 relationships allowed
88 88 relationships allowed
89 89 relationships allowed
90 90 relationships allowed
91 91 relationships allowed
92 92 relationships allowed
93 93 relationships allowed
94 94 relationships allowed
95 95 relationships allowed
96 96 relationships allowed
97 97 relationships allowed
98 98 relationships allowed
99 99 relationships allowed
TYPE_P1 Category of Business Partner 1 BP_TYPE_P1 CHAR 1 0
NULL Unknown
1 Organization
2 Natural Person
TYPE_P2 Category of Business Partner 2 BP_TYPE_P2 CHAR 1 0
NULL Unknown
1 Organization
2 Natural Person
COMPNYC Company Code Relevance Indicator BP_COMPNYC CHAR 1 0
X Yes
NULL No
RELTYP Business Partner Relationship Category BU_RELTYP TBZ9 CHAR 6 0
ORDER_CHANGE Change Sequence BU_ORDER CHAR 1 0
X Change sequence
NULL Ignore sequence
REL_MAIN Business Partner: Leading Relationship Category BU_REL_MAIN CHAR 1 0
X Yes
NULL No
REL_GRP Business Partner: Convert to Group BU_REL_GRP CHAR 1 0
X Yes
NULL No

TPZ7 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TPZ7 MANDT TPZ7 MANDT T000 Clients MANDT
TPZ7 RELTYP TPZ7 RELTYP TBZ9 BP relationship categories RELTYP
TPZ7 RELTYP ' ' TBZ9 BP relationship categories XRF
TPZ7 RELTYP TPZ7 MANDT TBZ9 BP relationship categories CLIENT