I_BusinessPartnerAddrUsageTP

Business Partner Address Usage BOPF View | view: IBPADDRUSAGETP | Extraction: Not supported | Component: Business Partners
Tables used: 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
ValidityEndDate Validity End of a Business Partner Address Usage TZNTSTMPS
ValidityStartDate Validity Start of a Business Partner Address Usage TZNTSTMPS
Master Data Relations Join Conditions
Address Number
  • Client
  • Business Partner Number
  • Business Partner Number
  • Address Number
  • Address Number
  • I_BUSINESSPARTNERADDRUSAGETP.MANDT == BUT020.CLIENT
  • I_BUSINESSPARTNERADDRUSAGETP.BUSINESSPARTNER == BUT020.PARTNER
  • I_BUSINESSPARTNERADDRUSAGETP.BUSINESSPARTNERFOREDIT == BUT020.PARTNER
  • I_BUSINESSPARTNERADDRUSAGETP.ADDRESSNUMBERFOREDIT == BUT020.ADDRNUMBER
  • I_BUSINESSPARTNERADDRUSAGETP.ADDRESSNUMBER == BUT020.ADDRNUMBER
Address Number
  • Client
  • Business Partner Number
  • Business Partner Number
  • Address Number
  • Address Number
  • I_BUSINESSPARTNERADDRUSAGETP.MANDT == BUT020.CLIENT
  • I_BUSINESSPARTNERADDRUSAGETP.BUSINESSPARTNER == BUT020.PARTNER
  • I_BUSINESSPARTNERADDRUSAGETP.BUSINESSPARTNERFOREDIT == BUT020.PARTNER
  • I_BUSINESSPARTNERADDRUSAGETP.ADDRESSNUMBERFOREDIT == BUT020.ADDRNUMBER
  • I_BUSINESSPARTNERADDRUSAGETP.ADDRESSNUMBER == BUT020.ADDRNUMBER
Address Type
  • Client
  • Address Type
  • Address Type
  • I_BUSINESSPARTNERADDRUSAGETP.MANDT == TB009.CLIENT
  • I_BUSINESSPARTNERADDRUSAGETP.ADDRESSUSAGE == TB009.ADR_KIND
  • I_BUSINESSPARTNERADDRUSAGETP.ADDRESSUSAGEFOREDIT == TB009.ADR_KIND
Address Type
  • Client
  • Address Type
  • Address Type
  • I_BUSINESSPARTNERADDRUSAGETP.MANDT == TB009.CLIENT
  • I_BUSINESSPARTNERADDRUSAGETP.ADDRESSUSAGE == TB009.ADR_KIND
  • I_BUSINESSPARTNERADDRUSAGETP.ADDRESSUSAGEFOREDIT == TB009.ADR_KIND
Business Partner Number
  • Client
  • Business Partner Number
  • Business Partner Number
  • I_BUSINESSPARTNERADDRUSAGETP.MANDT == BUT000.CLIENT
  • I_BUSINESSPARTNERADDRUSAGETP.BUSINESSPARTNER == BUT000.PARTNER
  • I_BUSINESSPARTNERADDRUSAGETP.BUSINESSPARTNERFOREDIT == BUT000.PARTNER
Business Partner Number
  • Client
  • Business Partner Number
  • Business Partner Number
  • I_BUSINESSPARTNERADDRUSAGETP.MANDT == BUT000.CLIENT
  • I_BUSINESSPARTNERADDRUSAGETP.BUSINESSPARTNER == BUT000.PARTNER
  • I_BUSINESSPARTNERADDRUSAGETP.BUSINESSPARTNERFOREDIT == BUT000.PARTNER