TBZ9 table in SAP ERP or S/4HANA stores BP relationship categories data. There are total 24 fields in TBZ9 table. The BP relationship categories table is available in all major of SAP S/4HANA versions and is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of TBZ9 table. It is in SAP Business Partner: Basic Components (S_BUPA_GENERAL) ABAP package and is part of the Business Partner Foundation (BC-SRV-BP) module.
SAP TBZ9 Table Fields
Following is the list of fields that are available in SAP TBZ9 table. The primary key fields of BP relationship categories table in SAP are CLIENT (Client), RELTYP (Business Partner Relationship Category), XRF (Business partner role definition instead of BP relationship).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| CLIENT | Client | MANDT | T000 | CLNT(3) |
| RELTYP | Business Partner Relationship Category | BU_RELTYP | CHAR(6) | |
| XRF | Business partner role definition instead of BP relationship | BU_XRF | CHAR(1) | |
| RLTP1 | BP Role Category | BU_PARTNERROLECAT | TB003A | CHAR(6) |
| RLTP2 | BP Role Category | BU_PARTNERROLECAT | TB003A | CHAR(6) |
| DFTYP | Differentiation Type | BU_DFTYP | TBZ0D | CHAR(2) |
| APPLI_TAB | Data management application | BU_APPLTAB | TBZ0A | CHAR(4) |
| VARNR | BDT: Screen sequence | BU_VARNR | TBZ3N | CHAR(6) |
| RLTCATGRP1 | BP Role Category Group | BU_PARTROLECATGRP | TB003P | CHAR(6) |
| RLTCATGRP2 | BP Role Category Group | BU_PARTROLECATGRP | TB003P | CHAR(6) |
| XDIRECTION | One-Way Business Partner Relationship Category | BU_XDIRECT | CHAR(1) | |
| TIMDP | Time Constraint | BU_TIMDEP | CHAR(1) | |
| CARDI | Number of relationships/role definitions in each set | BU_CARDIN | NUMC(3) | |
| CARDI_P1 | Cardinality from view of business partner 1 | BU_CARDIN_P1 | NUMC(3) | |
| CARDI_P2 | Cardinality from view of business partner 2 | BU_CARDIN_P2 | NUMC(3) | |
| XORGA_P1 | ‘Organization’ partner cat. relev. for relationship/role def | BU_XORGA_R | CHAR(1) | |
| XPERS_P1 | ‘Person’ partner category rel. for relationship/role def. | BU_XPERS_R | CHAR(1) | |
| XGROU_P1 | ‘Group’ partner category relevant for relationship/role def. | BU_XGROU_R | CHAR(1) | |
| XORGA_P2 | ‘Organization’ partner cat. relev. for relationship/role def | BU_XORGA_R | CHAR(1) | |
| XPERS_P2 | ‘Person’ partner category rel. for relationship/role def. | BU_XPERS_R | CHAR(1) | |
| XGROU_P2 | ‘Group’ partner category relevant for relationship/role def. | BU_XGROU_R | CHAR(1) | |
| XDFREL | Standard Relationship Indicator Maintenance | BU_DFREL | CHAR(1) | |
| XDFREL2 | Standard Relationship Indicator Maintenance | BU_DFREL | CHAR(1) | |
| PROTECT | BP: ‘Protect Data’ Indicator | BU_PROTECT | CHAR(1) |
