I_BusPartAddress

Business Partner Address | view: IBUPAADDRESS | Extraction: Not supported | Component: Business Partners
Tables used: BUT000BUT020
Column Name Description
BusinessPartner FK Business Partner Number
AddressID FK Address Number
Column Name Description
Column Name Description
Column Name Description
Column Name Description
IsBusinessPurposeCompleted Business Purpose Completed Flag Show values
Column Name Description Domain name
AddressUUID GUID of a Business Partner Address SYSUUID
ValidityStartDate Validity Start of a Business Partner Address TZNTSTMPS
ValidityEndDate Validity End of a Business Partner Address TZNTSTMPS
AddressIDByExternalSystem Address number in external system BU_ADEXT
Master Data Relations Join Conditions
Address Number
  • Address Number
  • Client
  • ?
  • ?
  • I_BUSPARTADDRESS.ADDRESSID == ADRC.ADDRNUMBER
  • I_BUSPARTADDRESS.MANDT == ADRC.CLIENT
  • I_BUSPARTADDRESS.[column in domain "AD_NATION"] == ADRC.NATION
  • I_BUSPARTADDRESS.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
Authorization Group
  • ?
  • Client
  • Authorization Group
  • I_BUSPARTADDRESS.[column in domain "BU_AUOBJ"] == TB037.AUOBJ
  • I_BUSPARTADDRESS.MANDT == TB037.CLIENT
  • I_BUSPARTADDRESS.AUTHORIZATIONGROUP == TB037.AUGRP
Business Partner Number
  • Client
  • Business Partner Number
  • I_BUSPARTADDRESS.MANDT == BUT000.CLIENT
  • I_BUSPARTADDRESS.BUSINESSPARTNER == BUT000.PARTNER