I_BPWebsiteURLTP

Business Partner Website | view: IBPWEBSITEURLTP | Extraction: Not supported | Component: Business Partners
Tables used: ADRTADR12BUT020BUT000
Column Name Description
BusinessPartner FK Business Partner Number
AddressID FK Address Number
Person FK Person Number
OrdinalNumber Sequence Number
ValidityStartDate Valid-from date - in current Release only 00010101 possible
IsDefaultURLAddress Flag: this address is the default address Show values
Column Name Description
Column Name Description
Column Name Description
ValidityStartDate Valid-from date - in current Release only 00010101 possible
Column Name Description
IsDefaultURLAddress Flag: this address is the default address Show values
Column Name Description Domain name
SearchURLAddress URI address search field CHAR50
AddressCommunicationRemarkText Communication link notes TEXT50
URLFieldLength URI field length AD_URILNG
WebsiteURL Universal Resource Identifier (URI) AD_URI
Master Data Relations Join Conditions
Address number
  • ?
  • ?
  • Address Number
  • Client
  • I_BPWEBSITEURLTP.[column in domain "AD_NATION"] == ADRC.NATION
  • I_BPWEBSITEURLTP.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • I_BPWEBSITEURLTP.ADDRESSID == ADRC.ADDRNUMBER
  • I_BPWEBSITEURLTP.MANDT == ADRC.CLIENT
Business Partner Number
  • Business Partner Number
  • Client
  • I_BPWEBSITEURLTP.BUSINESSPARTNER == BUT000.PARTNER
  • I_BPWEBSITEURLTP.MANDT == BUT000.CLIENT
Person number
  • ?
  • ?
  • Client
  • Person Number
  • I_BPWEBSITEURLTP.[column in domain "AD_NATION"] == ADRP.NATION
  • I_BPWEBSITEURLTP.[column in domain "AD_DATE_FR"] == ADRP.DATE_FROM
  • I_BPWEBSITEURLTP.MANDT == ADRP.CLIENT
  • I_BPWEBSITEURLTP.PERSON == ADRP.PERSNUMBER