SAP table TPZ7 (BP: Business Partner - Relationship Category)

SAP table TPZ7 has 2 primary key fields being MANDT,REL_TYP.

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
REL_TYP Business Partner Relationship Category CHAR 4 0 BP_REL_TYP_OLD
KARDINAL Cardinality of BP Relationship Category CHAR 2 0 BP_KARDIN
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 CHAR 1 0 BP_TYPE_P1
TYPE_P2 Category of Business Partner 2 CHAR 1 0 BP_TYPE_P2
COMPNYC Company Code Relevance Indicator CHAR 1 0 BP_COMPNYC
RELTYP Business Partner Relationship Category CHAR 6 0 TBZ9 BU_RELTYP
ORDER_CHANGE Change Sequence CHAR 1 0 BU_ORDER
Ignore sequence
X Change sequence
REL_MAIN Business Partner: Leading Relationship Category CHAR 1 0 BU_REL_MAIN
REL_GRP Business Partner: Convert to Group CHAR 1 0 BU_REL_GRP

TPZ7 foreign key relationships

Table Field Check Table Check Field
0 TPZ7 RELTYP TBZ9 BP relationship categories RELTYP
0 TPZ7 RELTYP TBZ9 BP relationship categories XRF