BUT020

BP: Addresses | #masterdata | Component: Business Partner Foundation
Column Name Description
CLIENT FK Client
PARTNER FK Business Partner Number
ADDRNUMBER FK Address Number
Column Name Description
Column Name Description
Column Name Description
DATE_FROM Date Obsolete
Column Name Description
XDFADR Indicator: Address is standard address Show values
Column Name Description Domain name
ADEXT Address number in external system BU_ADEXT
GUID UUID in character form SYSUUID_C
MOVE_ADDR Number of Move Target Address for Address Moves AD_ADDRNUM
ADDRESS_GUID GUID of a Business Partner Address SYSUUID
ADDR_VALID_FROM Validity Start of a Business Partner Address TZNTSTMPS
ADDR_VALID_TO Validity End of a Business Partner Address TZNTSTMPS
ADDR_MOVE_DATE Date of Move for Address Moves TZNTSTMPS
Master Data Relations Join Conditions
Address Number
  • Address Number
  • Date Obsolete
  • Version ID for International Addresses
  • BUT020.CLIENT == ADRC.CLIENT
  • BUT020.ADDRNUMBER == ADRC.ADDRNUMBER
  • BUT020.DATE_FROM == ADRC.DATE_FROM
  • BUT020.NATION == ADRC.NATION
Client BUT020.CLIENT == T000.MANDT
Version ID for International Addresses BUT020.NATION == TSADV.NATION
Business Partner Number
  • Business Partner Number
  • Client
  • BUT020.PARTNER == BUT000.PARTNER
  • BUT020.CLIENT == BUT000.CLIENT