Follow us on LinkedIn for your next SAP project

← Back to Search

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

Possible values

MANDT

Client

MANDT

T000

CLNT

REL_TYP

Business Partner Relationship Category

BP_REL_TYP_OLD

CHAR

KARDINAL

Cardinality of BP Relationship Category

BP_KARDIN

CHAR

Value	Description
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

Value	Description
NULL	Unknown
1	Organization
2	Natural Person

TYPE_P2

Category of Business Partner 2

BP_TYPE_P2

CHAR

Value	Description
NULL	Unknown
1	Organization
2	Natural Person

COMPNYC

Company Code Relevance Indicator

BP_COMPNYC

CHAR

Value	Description
X	Yes
NULL	No

RELTYP

Business Partner Relationship Category

BU_RELTYP

TBZ9

CHAR

ORDER_CHANGE

Change Sequence

BU_ORDER

CHAR

Value	Description
X	Change sequence
NULL	Ignore sequence

REL_MAIN

Business Partner: Leading Relationship Category

BU_REL_MAIN

CHAR

Value	Description
X	Yes
NULL	No

REL_GRP

Business Partner: Convert to Group

BU_REL_GRP

CHAR

Value	Description
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	MANDT	TBZ9 BP relationship categories	CLIENT
TPZ7	RELTYP	TPZ7	RELTYP	TBZ9 BP relationship categories	RELTYP
TPZ7	RELTYP	' '		TBZ9 BP relationship categories	XRF