I_BPRelationship

Interface view for BUT050 | view: IBUPAREL | Extraction: Not supported | Component: SAP Business Partner
Tables used: BUT050
Column Name Description
RelationshipNumber BP Relationship Number
BusinessPartnerCompany FK Business Partner Number
BusinessPartnerPerson FK Business Partner Number
ValidityEndDate Validity Date (Valid To)
Column Name Description
Column Name Description
Column Name Description
ValidityEndDate Validity Date (Valid To)
ValidityStartDate Validity Date (Valid From)
CreationDate Date on which the object was created
CreationTime Time at which the object was created
LastChangeDate Date when object was last changed
LastChangeTime Time at which object was last changed
Column Name Description
IsStandardRelationship Standard Relationship Show values
BusPartRelshpIsRoleDefinition Business partner role definition instead of BP relationship Show values
Column Name Description Domain name
CreatedByUser User who created the object USNAM
LastChangedByUser Last user to change object USNAM
Master Data Relations Join Conditions
Business Partner Number
  • Business Partner Number
  • Business Partner Number
  • Client
  • I_BPRELATIONSHIP.BUSINESSPARTNER1 == BUT000.PARTNER
  • I_BPRELATIONSHIP.BUSINESSPARTNERCOMPANY == BUT000.PARTNER
  • I_BPRELATIONSHIP.MANDT == BUT000.CLIENT
Business Partner Number
  • Client
  • Business Partner Number
  • Business Partner Number
  • I_BPRELATIONSHIP.MANDT == BUT000.CLIENT
  • I_BPRELATIONSHIP.BUSINESSPARTNER2 == BUT000.PARTNER
  • I_BPRELATIONSHIP.BUSINESSPARTNERPERSON == BUT000.PARTNER
Business Partner Number
  • Business Partner Number
  • Business Partner Number
  • Client
  • I_BPRELATIONSHIP.BUSINESSPARTNER1 == BUT000.PARTNER
  • I_BPRELATIONSHIP.BUSINESSPARTNERCOMPANY == BUT000.PARTNER
  • I_BPRELATIONSHIP.MANDT == BUT000.CLIENT
Business Partner Number
  • Client
  • Business Partner Number
  • Business Partner Number
  • I_BPRELATIONSHIP.MANDT == BUT000.CLIENT
  • I_BPRELATIONSHIP.BUSINESSPARTNER2 == BUT000.PARTNER
  • I_BPRELATIONSHIP.BUSINESSPARTNERPERSON == BUT000.PARTNER