BUT150

BP relationship: Attribute table (test different.type TBUKR) | #masterdata | Component: Business Partner Foundation
Column Name Description
CLIENT FK Client
RELNR FK BP Relationship Number
PARTNER1 Business Partner Number
PARTNER2 Business Partner Number
DATE_TO Validity Date (Valid To)
Column Name Description
Column Name Description
Column Name Description
DATE_TO Validity Date (Valid To)
Column Name Description
XRF Business partner role definition instead of BP relationship Show values
Column Name Description Domain name
Master Data Relations Join Conditions
Differentiation type element like company code
  • Differentiation type element like company code
  • Client
  • BUT150.BUKRS == TB990.TBUKRS
  • BUT150.CLIENT == TB990.CLIENT
Client BUT150.CLIENT == T000.MANDT
BP Relationship Number
  • Validity Date (Valid To)
  • BP Relationship Number
  • Business Partner Number
  • Client
  • Business Partner Number
  • BUT150.DATE_TO == BUT050.DATE_TO
  • BUT150.RELNR == BUT050.RELNR
  • BUT150.PARTNER2 == BUT050.PARTNER2
  • BUT150.CLIENT == BUT050.CLIENT
  • BUT150.PARTNER1 == BUT050.PARTNER1
Business Partner Relationship Category
  • Business Partner Relationship Category
  • Business partner role definition instead of BP relationship
  • BUT150.CLIENT == TBZ9.CLIENT
  • BUT150.RELTYP == TBZ9.RELTYP
  • BUT150.XRF == TBZ9.XRF