TBZ9 is a standard SAP HANA table in SAP ERP (or) S/4HANA system which stores BP relationship categories data. There are total 24 fields in the table. The TBZ9 table can be found in the SAP Business Partner: Basic Components (S_BUPA_GENERAL) package and is part of the Business Partner Foundation (BC-SRV-BP) module.
| SAP HANA Table Type | Column Store |
|---|---|
| Buffering Permission | Buffering switched on |
| Buffering Type | Full table is passed to buffer |
TBZ9 Table Fields
The following is the list of fields that are available in SAP TBZ9 table. The key fields of the table are highlighted in color.
| Field | Description | Data Element | Domain | Check Table | Data Type | Length |
|---|---|---|---|---|---|---|
| CLIENT | Client | MANDT | MANDT | T000 | CLNT | 3 |
| RELTYP | Business Partner Relationship Category | BU_RELTYP | BU_RELTYP | CHAR | 6 | |
| XRF | Business partner role definition instead of BP relationship | BU_XRF | XFELD | CHAR | 1 | |
| RLTP1 | BP Role Category | BU_PARTNERROLECAT | BU_ROLECAT | TB003A | CHAR | 6 |
| RLTP2 | BP Role Category | BU_PARTNERROLECAT | BU_ROLECAT | TB003A | CHAR | 6 |
| DFTYP | Differentiation Type | BU_DFTYP | BU_DFTYP | TBZ0D | CHAR | 2 |
| APPLI_TAB | Data management application | BU_APPLTAB | BU_APPLI | TBZ0A | CHAR | 4 |
| VARNR | BDT: Screen sequence | BU_VARNR | BU_VARNR | TBZ3N | CHAR | 6 |
| RLTCATGRP1 | BP Role Category Group | BU_PARTROLECATGRP | BU_ROLECATGRP | TB003P | CHAR | 6 |
| RLTCATGRP2 | BP Role Category Group | BU_PARTROLECATGRP | BU_ROLECATGRP | TB003P | CHAR | 6 |
| XDIRECTION | One-Way Business Partner Relationship Category | BU_XDIRECT | XFELD | CHAR | 1 | |
| TIMDP | Time Constraint | BU_TIMDEP | BU_TIMDEP | CHAR | 1 | |
| CARDI | Number of relationships/role definitions in each set | BU_CARDIN | BU_CARDIN | NUMC | 3 | |
| CARDI_P1 | Cardinality from view of business partner 1 | BU_CARDIN_P1 | BU_CARDIN | NUMC | 3 | |
| CARDI_P2 | Cardinality from view of business partner 2 | BU_CARDIN_P2 | BU_CARDIN | NUMC | 3 | |
| XORGA_P1 | ‘Organization’ partner cat. relev. for relationship/role def | BU_XORGA_R | XFELD | CHAR | 1 | |
| XPERS_P1 | ‘Person’ partner category rel. for relationship/role def. | BU_XPERS_R | XFELD | CHAR | 1 | |
| XGROU_P1 | ‘Group’ partner category relevant for relationship/role def. | BU_XGROU_R | XFELD | CHAR | 1 | |
| XORGA_P2 | ‘Organization’ partner cat. relev. for relationship/role def | BU_XORGA_R | XFELD | CHAR | 1 | |
| XPERS_P2 | ‘Person’ partner category rel. for relationship/role def. | BU_XPERS_R | XFELD | CHAR | 1 | |
| XGROU_P2 | ‘Group’ partner category relevant for relationship/role def. | BU_XGROU_R | XFELD | CHAR | 1 | |
| XDFREL | Standard Relationship Indicator Maintenance | BU_DFREL | BU_DFREL | CHAR | 1 | |
| XDFREL2 | Standard Relationship Indicator Maintenance | BU_DFREL | BU_DFREL | CHAR | 1 | |
| PROTECT | BP: ‘Protect Data’ Indicator | BU_PROTECT | XFELD | CHAR | 1 |
Availability
The SAP HANA table TBZ9 is available within SAP S/4HANA On-premise and SAP S/4HANA Cloud systems depending on the version and release level.
| SAP S/4HANA Version | Released |
|---|---|
| 1909 | Yes |
| 2020 | Yes |
| 2021 | Yes |
| 2022 | Yes |
| 2023 | Yes |
CDS Views for TBZ9 table
We’re updating the content all the time, so check back regularly.
