BUT050

BP relationships/role definitions: General data | #masterdata | Component: Business Partner Foundation
Column Name Description
CLIENT FK Client
RELNR BP Relationship Number
PARTNER1 FK Business Partner Number
PARTNER2 FK Business Partner Number
DATE_TO Validity Date (Valid To)
Column Name Description
Column Name Description
Column Name Description
DATE_TO Validity Date (Valid To)
DATE_FROM Validity Date (Valid From)
CRDAT Date on which the object was created
CRTIM Time at which the object was created
CHDAT Date when object was last changed
CHTIM Time at which object was last changed
Column Name Description
XRF Business partner role definition instead of BP relationship Show values
XDFREL Standard Relationship Show values
XDFREL2 Standard Relationship Show values
Column Name Description Domain name
DFTVAL BP: Differentiation type characteristic (change doc.-rel.) CHAR20
CRUSR User who created the object USNAM
CHUSR Last user to change object USNAM
DB_KEY GP: UUID for Identifying the Data Record (SETGUID) SYSUUID
DB_KEY_TD GP: UUID for Identifying the Data Record (SETGUID) SYSUUID
Master Data Relations Join Conditions
Client BUT050.CLIENT == T000.MANDT
Business Partner Number
  • Business Partner Number
  • Client
  • BUT050.PARTNER1 == BUT000.PARTNER
  • BUT050.CLIENT == BUT000.CLIENT
Business Partner Number
  • Business Partner Number
  • Client
  • BUT050.PARTNER2 == BUT000.PARTNER
  • BUT050.CLIENT == BUT000.CLIENT