BUT020S

Shadow Table BP: Addresses | #masterdata | Component: Business Partner Foundation
Column Name Description
CLIENT FK Client
TRKORR Request/Task
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
  • BUT020S.CLIENT == ADRC.CLIENT
  • BUT020S.ADDRNUMBER == ADRC.ADDRNUMBER
  • BUT020S.DATE_FROM == ADRC.DATE_FROM
  • BUT020S.NATION == ADRC.NATION
Client BUT020S.CLIENT == T000.MANDT
Version ID for International Addresses BUT020S.NATION == TSADV.NATION
Business Partner Number
  • Business Partner Number
  • Client
  • BUT020S.PARTNER == BUT000.PARTNER
  • BUT020S.CLIENT == BUT000.CLIENT