I_Businesspartneraddressusage

Busineess Partner Address Usage Core View | view: IBPADDRESSUSAGE | Extraction: Not supported | Component: SAP Business Partner
Tables used: BUT000BUT021_FS
Column Name Description
BusinessPartner FK Business Partner Number
ValidityEndDate Validity End of a Business Partner Address Usage
AddressUsage FK Address Type
AddressNumber FK Address Number
Column Name Description
Column Name Description
Column Name Description
Column Name Description
StandardUsage Indicator: Standard Address Usage Show values
Column Name Description Domain name
ValidityStartDate Validity Start of a Business Partner Address Usage TZNTSTMPS
Master Data Relations Join Conditions
Address Number
  • Client
  • Address Number
  • Business Partner Number
  • I_BUSINESSPARTNERADDRESSUSAGE.MANDT == BUT020.CLIENT
  • I_BUSINESSPARTNERADDRESSUSAGE.ADDRESSNUMBER == BUT020.ADDRNUMBER
  • I_BUSINESSPARTNERADDRESSUSAGE.BUSINESSPARTNER == BUT020.PARTNER
Address Type
  • Client
  • Address Type
  • I_BUSINESSPARTNERADDRESSUSAGE.MANDT == TB009.CLIENT
  • I_BUSINESSPARTNERADDRESSUSAGE.ADDRESSUSAGE == TB009.ADR_KIND
Authorization Group
  • Client
  • ?
  • Authorization Group
  • I_BUSINESSPARTNERADDRESSUSAGE.MANDT == TB037.CLIENT
  • I_BUSINESSPARTNERADDRESSUSAGE.[column in domain "BU_AUOBJ"] == TB037.AUOBJ
  • I_BUSINESSPARTNERADDRESSUSAGE.AUTHORIZATIONGROUP == TB037.AUGRP
Business Partner Number
  • Client
  • Business Partner Number
  • I_BUSINESSPARTNERADDRESSUSAGE.MANDT == BUT000.CLIENT
  • I_BUSINESSPARTNERADDRESSUSAGE.BUSINESSPARTNER == BUT000.PARTNER