1. Home
  2. Resources
  3. SAP Tables
  4. TBZ9 - BP relationship categories

SAP Table TBZ9

BP relationship categories

TBZ9 (BP relationship categories) 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 TBZ9 to other SAP tables.

TBZ9 table fields

Field Data element Checktable Datatype Length Decimals
CLIENT Client MANDT T000 CLNT 3 0
RELTYP Business Partner Relationship Category BU_RELTYP CHAR 6 0
XRF Business partner role definition instead of BP relationship BU_XRF CHAR 1 0
X Yes
NULL No
RLTP1 BP Role Category BU_PARTNERROLECAT TB003A CHAR 6 0
RLTP2 BP Role Category BU_PARTNERROLECAT TB003A CHAR 6 0
DFTYP Differentiation Type BU_DFTYP TBZ0D CHAR 2 0
APPLI_TAB Data management application BU_APPLTAB TBZ0A CHAR 4 0
VARNR BDT: Screen sequence BU_VARNR TBZ3N CHAR 6 0
XDIRECTION One-Way Business Partner Relationship Category BU_XDIRECT CHAR 1 0
X Yes
NULL No
TIMDP Time Constraint BU_TIMDEP CHAR 1 0
NULL No time constraint
0 No time constraint
1 Record must have no gaps, no overlap
2 Record may have gaps but no overlap
4 Record exists at least once from minimum to maximum
CARDI Number of relationships/role definitions in each set BU_CARDIN NUMC 3 0
CARDI_P1 Cardinality from view of business partner 1 BU_CARDIN_P1 NUMC 3 0
CARDI_P2 Cardinality from view of business partner 2 BU_CARDIN_P2 NUMC 3 0
XORGA_P1 'Organization' partner cat. relev. for relationship/role def BU_XORGA_R CHAR 1 0
X Yes
NULL No
XPERS_P1 'Person' partner category rel. for relationship/role def. BU_XPERS_R CHAR 1 0
X Yes
NULL No
XGROU_P1 'Group' partner category relevant for relationship/role def. BU_XGROU_R CHAR 1 0
X Yes
NULL No
XORGA_P2 'Organization' partner cat. relev. for relationship/role def BU_XORGA_R CHAR 1 0
X Yes
NULL No
XPERS_P2 'Person' partner category rel. for relationship/role def. BU_XPERS_R CHAR 1 0
X Yes
NULL No
XGROU_P2 'Group' partner category relevant for relationship/role def. BU_XGROU_R CHAR 1 0
X Yes
NULL No
XDFREL Standard Relationship Indicator Maintenance BU_DFREL CHAR 1 0
NULL No Maintenance Permitted
X Maintenance Permitted
XDFREL2 Standard Relationship Indicator Maintenance BU_DFREL CHAR 1 0
NULL No Maintenance Permitted
X Maintenance Permitted
PROTECT BP: 'Protect Data' Indicator BU_PROTECT CHAR 1 0
X Yes
NULL No
OWNER_BO ESF: Name of a Business Object BU_SESF_BUSINESS_OBJECT CHAR 30 0

TBZ9 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TBZ9 APPLI_TAB SYST MANDT TBZ0A BDT Applications CLIENT
TBZ9 APPLI_TAB 'BUPR' TBZ0A BDT Applications OBJAP
TBZ9 APPLI_TAB TBZ9 APPLI_TAB TBZ0A BDT Applications APPLI
TBZ9 CLIENT TBZ9 CLIENT T000 Clients MANDT
TBZ9 DFTYP TBZ9 DFTYP TBZ0D BDT Differentiation Types DFTYP
TBZ9 RLTP1 TBZ9 CLIENT TB003A BP role categories CLIENT
TBZ9 RLTP1 TBZ9 RLTP1 TB003A BP role categories ROLECATEGORY
TBZ9 RLTP2 TBZ9 CLIENT TB003A BP role categories CLIENT
TBZ9 RLTP2 TBZ9 RLTP2 TB003A BP role categories ROLECATEGORY
TBZ9 VARNR SYST MANDT TBZ3N BDT-Screen Sequence Category -> BDT-Screen Seq. Assignment CLIENT
TBZ9 VARNR 'BUPR' TBZ3N BDT-Screen Sequence Category -> BDT-Screen Seq. Assignment OBJAP
TBZ9 VARNR ' ' TBZ3N BDT-Screen Sequence Category -> BDT-Screen Seq. Assignment VARTP
TBZ9 VARNR TBZ9 VARNR TBZ3N BDT-Screen Sequence Category -> BDT-Screen Seq. Assignment VARNR