C_Businesspartneraddrusage

Business Partner Address Usage Consumption View | view: CBPADDRUSAGE | Extraction: Not supported | Component: Business Partners
Tables used: TB010, BUT000, BUT021_FS
Column Name Description
BusinessPartner FK Business Partner Number
BPAddressUsageValidityEndDate null
AddressUsage FK Address Type
AddressNumber FK Address Number
Column Name Description
Column Name Description
Column Name Description
AddressUsageValidityStartDate null
AddressUsageValidityEndDate null
Column Name Description
StandardUsage Indicator: Standard Address Usage Show values
Column Name Description Domain name
AddressUsageName Name of Address Type TEXT40
Master Data Relations Join Conditions
Address Number
  • Business Partner Number
  • Business Partner Number
  • Address Number
  • Address Number
  • Client
  • C_BUSINESSPARTNERADDRUSAGE.BUSINESSPARTNER == BUT020.PARTNER
  • C_BUSINESSPARTNERADDRUSAGE.BUSINESSPARTNERFOREDIT == BUT020.PARTNER
  • C_BUSINESSPARTNERADDRUSAGE.ADDRESSNUMBER == BUT020.ADDRNUMBER
  • C_BUSINESSPARTNERADDRUSAGE.ADDRESSNUMBERFOREDIT == BUT020.ADDRNUMBER
  • C_BUSINESSPARTNERADDRUSAGE.MANDT == BUT020.CLIENT
Address Number
  • Business Partner Number
  • Business Partner Number
  • Address Number
  • Address Number
  • Client
  • C_BUSINESSPARTNERADDRUSAGE.BUSINESSPARTNER == BUT020.PARTNER
  • C_BUSINESSPARTNERADDRUSAGE.BUSINESSPARTNERFOREDIT == BUT020.PARTNER
  • C_BUSINESSPARTNERADDRUSAGE.ADDRESSNUMBER == BUT020.ADDRNUMBER
  • C_BUSINESSPARTNERADDRUSAGE.ADDRESSNUMBERFOREDIT == BUT020.ADDRNUMBER
  • C_BUSINESSPARTNERADDRUSAGE.MANDT == BUT020.CLIENT
Address Type
  • Address Type
  • Address Type
  • Client
  • C_BUSINESSPARTNERADDRUSAGE.ADDRESSUSAGE == TB009.ADR_KIND
  • C_BUSINESSPARTNERADDRUSAGE.ADDRESSUSAGEFOREDIT == TB009.ADR_KIND
  • C_BUSINESSPARTNERADDRUSAGE.MANDT == TB009.CLIENT
Address Type
  • Address Type
  • Address Type
  • Client
  • C_BUSINESSPARTNERADDRUSAGE.ADDRESSUSAGE == TB009.ADR_KIND
  • C_BUSINESSPARTNERADDRUSAGE.ADDRESSUSAGEFOREDIT == TB009.ADR_KIND
  • C_BUSINESSPARTNERADDRUSAGE.MANDT == TB009.CLIENT
Business Partner Number
  • Business Partner Number
  • Business Partner Number
  • Client
  • C_BUSINESSPARTNERADDRUSAGE.BUSINESSPARTNER == BUT000.PARTNER
  • C_BUSINESSPARTNERADDRUSAGE.BUSINESSPARTNERFOREDIT == BUT000.PARTNER
  • C_BUSINESSPARTNERADDRUSAGE.MANDT == BUT000.CLIENT
Business Partner Number
  • Business Partner Number
  • Business Partner Number
  • Client
  • C_BUSINESSPARTNERADDRUSAGE.BUSINESSPARTNER == BUT000.PARTNER
  • C_BUSINESSPARTNERADDRUSAGE.BUSINESSPARTNERFOREDIT == BUT000.PARTNER
  • C_BUSINESSPARTNERADDRUSAGE.MANDT == BUT000.CLIENT