A_BuPaAddressUsage

Address Usage | view: ABPADDRESSUSAGE | Extraction: Not supported | Component: Business Partners
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
AddressID 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
  • Business Partner Number
  • Address Number
  • A_BUPAADDRESSUSAGE.MANDT == BUT020.CLIENT
  • A_BUPAADDRESSUSAGE.BUSINESSPARTNER == BUT020.PARTNER
  • A_BUPAADDRESSUSAGE.ADDRESSID == BUT020.ADDRNUMBER
Address Type
  • Address Type
  • Client
  • A_BUPAADDRESSUSAGE.ADDRESSUSAGE == TB009.ADR_KIND
  • A_BUPAADDRESSUSAGE.MANDT == TB009.CLIENT
Authorization Group
  • Authorization Group
  • ?
  • Client
  • A_BUPAADDRESSUSAGE.AUTHORIZATIONGROUP == TB037.AUGRP
  • A_BUPAADDRESSUSAGE.[column in domain "BU_AUOBJ"] == TB037.AUOBJ
  • A_BUPAADDRESSUSAGE.MANDT == TB037.CLIENT
Business Partner Number
  • Client
  • Business Partner Number
  • A_BUPAADDRESSUSAGE.MANDT == BUT000.CLIENT
  • A_BUPAADDRESSUSAGE.BUSINESSPARTNER == BUT000.PARTNER