BUT052

BP Relationship: Addresses | #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)
ADDRNUMBER FK Address Number
Column Name Description
Column Name Description
Column Name Description
DATE_TO Validity Date (Valid To)
DATE_FROM Valid-from date - in current Release only 00010101 possible
Column Name Description
XDFADR Indicator: Address is standard address Show values
Column Name Description Domain name
NATION Version ID for International Addresses AD_NATION
Master Data Relations Join Conditions
Address Number
  • Address Number
  • Valid-from date - in current Release only 00010101 possible
  • Version ID for International Addresses
  • BUT052.CLIENT == ADRC.CLIENT
  • BUT052.ADDRNUMBER == ADRC.ADDRNUMBER
  • BUT052.DATE_FROM == ADRC.DATE_FROM
  • BUT052.NATION == ADRC.NATION
Client BUT052.CLIENT == T000.MANDT
BP Relationship Number
  • Validity Date (Valid To)
  • BP Relationship Number
  • Business Partner Number
  • Client
  • Business Partner Number
  • BUT052.DATE_TO == BUT050.DATE_TO
  • BUT052.RELNR == BUT050.RELNR
  • BUT052.PARTNER2 == BUT050.PARTNER2
  • BUT052.CLIENT == BUT050.CLIENT
  • BUT052.PARTNER1 == BUT050.PARTNER1