SAP Table TPZ3

BP: Business Partner - Role Category

TPZ3 (BP: Business Partner - Role 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 TPZ3 to other SAP tables.

TPZ3 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
ROLETYP Business Partner Role Category BP_ROLETYP_OLD CHAR 4 0
TYPE Partner category BP_TYPE_OLD CHAR 1 0
NULL Unknown
1 Organization
2 Natural Person
RLTYP BDT: Object part BU_RLTYP TBZ0 CHAR 6 0
PARTNERROLE BP Role BU_PARTNERROLE TB003 CHAR 6 0

TPZ3 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TPZ3 MANDT TPZ3 MANDT T000 Clients MANDT
TPZ3 PARTNERROLE TPZ3 PARTNERROLE TB003 BP Roles ROLE
TPZ3 PARTNERROLE TPZ3 MANDT TB003 BP Roles CLIENT
TPZ3 RLTYP TPZ3 MANDT TBZ0 BDT Object Parts CLIENT
TPZ3 RLTYP 'BUPA' TBZ0 BDT Object Parts OBJAP
TPZ3 RLTYP TPZ3 RLTYP TBZ0 BDT Object Parts RLTYP