BUT052S

Shadow Table BP Relationship: Addresses | #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)
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
  • BUT052S.CLIENT == ADRC.CLIENT
  • BUT052S.ADDRNUMBER == ADRC.ADDRNUMBER
  • BUT052S.DATE_FROM == ADRC.DATE_FROM
  • BUT052S.NATION == ADRC.NATION
Client BUT052S.CLIENT == T000.MANDT
BP Relationship Number
  • Validity Date (Valid To)
  • BP Relationship Number
  • Business Partner Number
  • Client
  • Business Partner Number
  • BUT052S.DATE_TO == BUT050.DATE_TO
  • BUT052S.RELNR == BUT050.RELNR
  • BUT052S.PARTNER2 == BUT050.PARTNER2
  • BUT052S.CLIENT == BUT050.CLIENT
  • BUT052S.PARTNER1 == BUT050.PARTNER1