SAP table TBZ9 (BP relationship categories)
SAP table TBZ9 has 3 primary key fields being CLIENT,RELTYP,XRF.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CLIENT | Client | CLNT | 3 | 0 | T000 | MANDT | |||||||||||
| RELTYP | Business Partner Relationship Category | CHAR | 6 | 0 | BU_RELTYP | ||||||||||||
| XRF | Business partner role definition instead of BP relationship | CHAR | 1 | 0 | BU_XRF | ||||||||||||
| RLTP1 | BP Role Category | CHAR | 6 | 0 | TB003A | BU_PARTNERROLECAT | |||||||||||
| RLTP2 | BP Role Category | CHAR | 6 | 0 | TB003A | BU_PARTNERROLECAT | |||||||||||
| DFTYP | Differentiation Type | CHAR | 2 | 0 | TBZ0D | BU_DFTYP | |||||||||||
| APPLI_TAB | Data management application | CHAR | 4 | 0 | TBZ0A | BU_APPLTAB | |||||||||||
| VARNR | BDT: Screen sequence | CHAR | 6 | 0 | TBZ3N | BU_VARNR | |||||||||||
| RLTCATGRP1 | BP Role Category Group | CHAR | 6 | 0 | TB003P | BU_PARTROLECATGRP | |||||||||||
| RLTCATGRP2 | BP Role Category Group | CHAR | 6 | 0 | TB003P | BU_PARTROLECATGRP | |||||||||||
| XDIRECTION | One-Way Business Partner Relationship Category | CHAR | 1 | 0 | BU_XDIRECT | ||||||||||||
| TIMDP | Time Constraint | CHAR | 1 | 0 | BU_TIMDEP |
|
|||||||||||
| CARDI | Number of relationships/role definitions in each set | NUMC | 3 | 0 | BU_CARDIN | ||||||||||||
| CARDI_P1 | Cardinality from view of business partner 1 | NUMC | 3 | 0 | BU_CARDIN_P1 | ||||||||||||
| CARDI_P2 | Cardinality from view of business partner 2 | NUMC | 3 | 0 | BU_CARDIN_P2 | ||||||||||||
| XORGA_P1 | 'Organization' partner cat. relev. for relationship/role def | CHAR | 1 | 0 | BU_XORGA_R | ||||||||||||
| XPERS_P1 | 'Person' partner category rel. for relationship/role def. | CHAR | 1 | 0 | BU_XPERS_R | ||||||||||||
| XGROU_P1 | 'Group' partner category relevant for relationship/role def. | CHAR | 1 | 0 | BU_XGROU_R | ||||||||||||
| XORGA_P2 | 'Organization' partner cat. relev. for relationship/role def | CHAR | 1 | 0 | BU_XORGA_R | ||||||||||||
| XPERS_P2 | 'Person' partner category rel. for relationship/role def. | CHAR | 1 | 0 | BU_XPERS_R | ||||||||||||
| XGROU_P2 | 'Group' partner category relevant for relationship/role def. | CHAR | 1 | 0 | BU_XGROU_R | ||||||||||||
| XDFREL | Standard Relationship Indicator Maintenance | CHAR | 1 | 0 | BU_DFREL |
|
|||||||||||
| XDFREL2 | Standard Relationship Indicator Maintenance | CHAR | 1 | 0 | BU_DFREL |
|
|||||||||||
| PROTECT | BP: 'Protect Data' Indicator | CHAR | 1 | 0 | BU_PROTECT | ||||||||||||
| OWNER_BO | ESF: Name of a Business Object | CHAR | 30 | 0 | BU_SESF_BUSINESS_OBJECT |
TBZ9 foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 TBZ9 | APPLI_TAB | TBZ0A | BDT Applications | CLIENT |
| 0 TBZ9 | APPLI_TAB | TBZ0A | BDT Applications | OBJAP |
| 0 TBZ9 | APPLI_TAB | TBZ0A | BDT Applications | APPLI |
| 1 TBZ9 | CLIENT | T000 | Clients | MANDT |
| 0 TBZ9 | RLTCATGRP1 | TB003P | BP role category group | ROLECATEGORYGRP |
| 1 TBZ9 | RLTCATGRP2 | TB003P | BP role category group | ROLECATEGORYGRP |
| 0 TBZ9 | VARNR | TBZ3N | BDT-Screen Sequence Category -> BDT-Screen Seq. Assignment | CLIENT |
| 0 TBZ9 | VARNR | TBZ3N | BDT-Screen Sequence Category -> BDT-Screen Seq. Assignment | OBJAP |
| 0 TBZ9 | VARNR | TBZ3N | BDT-Screen Sequence Category -> BDT-Screen Seq. Assignment | VARTP |
| 0 TBZ9 | VARNR | TBZ3N | BDT-Screen Sequence Category -> BDT-Screen Seq. Assignment | VARNR |