BUT051S

Shadow Table BP Relationship: Contact Person Relationship | #masterdata | Component: Business Partner Foundation
Column Name Description
CLIENT FK Client
TRKORR Request/Task
RELNR FK BP Relationship Number
PARTNER1 Business Partner Number
PARTNER2 Business Partner Number
DATE_TO Validity Date (Valid To)
Column Name Description
💲 Currency Key (REL_CUR):
REL_AMO Obsolete: Amount of Capital Interest
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
FNCTN Function name of partner TEXT40
DPRTMNT Department at business partner TEXT40
PAREM Notes for Partner TEXT40
TEL_NUMBER Telephone no.: dialling code+number CHAR30
TEL_EXTENS Telephone no.: Extension CHAR10
FAX_NUMBER Fax number: dialling code+number CHAR30
FAX_EXTENS Fax no.: Extension CHAR10
SMTP_ADDRESS E-Mail Address AD_SMTPADR
REL_PER Obsolete: Percentage of Capital Interest DEC3_7
CALL_RULEID Identification Rule for Periodic Appointments: Calling Hours BU_SC_RULEID
VISIT_RULEID Identification Rule for Periodic Appointments:Visiting Hours BU_SC_RULEID
CALL_GUID SAP BP: Calendar Schema GUID, Calling Hours SYSUUID
VISIT_GUID SAP BP: Calendar Schema GUID, Visiting Hours SYSUUID
BP_EEW_BUT051 Dummy function in length 1 DUMMY
Master Data Relations Join Conditions
Department
  • Department
  • Client
  • BUT051S.ABTNR == TB910.ABTNR
  • BUT051S.CLIENT == TB910.CLIENT
Client BUT051S.CLIENT == T000.MANDT
Partner's Authority
  • BUT051S.CLIENT == TB914.CLIENT
  • BUT051S.PAAUTH == TB914.PAAUTH
Function of partner
  • Function of partner
  • Client
  • BUT051S.PAFKT == TB912.PAFKT
  • BUT051S.CLIENT == TB912.CLIENT
VIP Partner
  • BUT051S.CLIENT == TB916.CLIENT
  • BUT051S.PAVIP == TB916.PAVIP
BP Relationship Number
  • Validity Date (Valid To)
  • BP Relationship Number
  • Business Partner Number
  • Client
  • Business Partner Number
  • BUT051S.DATE_TO == BUT050.DATE_TO
  • BUT051S.RELNR == BUT050.RELNR
  • BUT051S.PARTNER2 == BUT050.PARTNER2
  • BUT051S.CLIENT == BUT050.CLIENT
  • BUT051S.PARTNER1 == BUT050.PARTNER1
Business Partner Relationship Category
  • Business Partner Relationship Category
  • Business partner role definition instead of BP relationship
  • BUT051S.CLIENT == TBZ9.CLIENT
  • BUT051S.RELTYP == TBZ9.RELTYP
  • BUT051S.XRF == TBZ9.XRF