/BOFU/CV_Q_BPRelationship

Root Query on Relationship | view: /BOFU/CV_QBPR | Extraction: Not supported | Component: Reusable Components of Business Suite Foundation
Tables used: BUT000BUT050TBZ9BUT000BUT100BUT000
Column Name Description
partner FK Business Partner Number
role FK BP Role
Relshp_partner FK Business Partner Number
Relshp_role FK BP Role
Column Name Description
Column Name Description
Column Name Description
valid_date Field of type DATS
validfromdate Validity Date (Valid From)
validuntildate Validity Date (Valid To)
Column Name Description
type Business Partner Category Show values
IsBusinessPurposeCompleted Business Purpose Completed Flag Show values
Column Name Description Domain name
partner_guid Business Partner GUID SYSUUID
mc_name1 Search Help Field 1 (Name 1/Last Name) CHAR35
mc_name2 Search Help Field 2 (Name 2/First Name) CHAR35
bu_sort1 Search Term 1 for Business Partner BU_SORT1
bu_sort2 Search Term 2 for Business Partner BU_SORT1
Reltyp_dir Relationship Type With Direction
Relshp_mc_name1 Search Help Field 1 (Name 1/Last Name) CHAR35
Relshp_mc_name2 Search Help Field 2 (Name 2/First Name) CHAR35
Master Data Relations Join Conditions
Authorization Group
  • Authorization Group
  • Client
  • ?
  • /BOFU/CV_Q_BPRELATIONSHIP.AUGRP == TB037.AUGRP
  • /BOFU/CV_Q_BPRELATIONSHIP.MANDT == TB037.CLIENT
  • /BOFU/CV_Q_BPRELATIONSHIP.[column in domain "BU_AUOBJ"] == TB037.AUOBJ
Business Partner Number
  • Business Partner Number
  • Client
  • /BOFU/CV_Q_BPRELATIONSHIP.PARTNER == BUT000.PARTNER
  • /BOFU/CV_Q_BPRELATIONSHIP.MANDT == BUT000.CLIENT
Business Partner Number
  • Client
  • Business Partner Number
  • /BOFU/CV_Q_BPRELATIONSHIP.MANDT == BUT000.CLIENT
  • /BOFU/CV_Q_BPRELATIONSHIP.RELSHP_PARTNER == BUT000.PARTNER
BP Role
  • Client
  • BP Role
  • BP Role
  • /BOFU/CV_Q_BPRELATIONSHIP.MANDT == TB003.CLIENT
  • /BOFU/CV_Q_BPRELATIONSHIP.RELSHP_ROLE == TB003.ROLE
  • /BOFU/CV_Q_BPRELATIONSHIP.ROLE == TB003.ROLE
BP Role
  • Client
  • BP Role
  • BP Role
  • /BOFU/CV_Q_BPRELATIONSHIP.MANDT == TB003.CLIENT
  • /BOFU/CV_Q_BPRELATIONSHIP.RELSHP_ROLE == TB003.ROLE
  • /BOFU/CV_Q_BPRELATIONSHIP.ROLE == TB003.ROLE