A_BPContactWrkPlaceHomePageURL

BP Contact Work Place URL Address | view: ABPCONTACTURL | Extraction: Not supported | Component: Business Partners
Tables used: ADRTADR3ADR12ADR2ADCPBUT000BUT052BUT000
Column Name Description
BusinessPartnerCompany Business Partner Number
BusinessPartnerPerson Business Partner Number
RelationshipNumber FK BP Relationship Number
AddressID FK Address Number
ValidityEndDate Validity Date (Valid To)
OrdinalNumber Sequence Number
IsDefaultURLAddress Flag: this address is the default address Show values
Column Name Description
Column Name Description
Column Name Description
ValidityEndDate Validity Date (Valid To)
Column Name Description
IsDefaultURLAddress Flag: this address is the default address Show values
CommNumberIsNotUsed Flag: This Communication Number is Not Used Show values
UniformResourceIdentifierType URI type flag Show values
Column Name Description Domain name
SearchURLAddress URI address search field CHAR50
AddressCommunicationRemarkText Communication link notes TEXT50
URLFieldLength null
Master Data Relations Join Conditions
Address Number
  • ?
  • Address Number
  • ?
  • Client
  • A_BPCONTACTWRKPLACEHOMEPAGEURL.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • A_BPCONTACTWRKPLACEHOMEPAGEURL.ADDRESSID == ADRC.ADDRNUMBER
  • A_BPCONTACTWRKPLACEHOMEPAGEURL.[column in domain "AD_NATION"] == ADRC.NATION
  • A_BPCONTACTWRKPLACEHOMEPAGEURL.MANDT == ADRC.CLIENT
BP Relationship Number
  • BP Relationship Number
  • Validity Date (Valid To)
  • Client
  • Business Partner Number
  • Business Partner Number
  • A_BPCONTACTWRKPLACEHOMEPAGEURL.RELATIONSHIPNUMBER == BUT050.RELNR
  • A_BPCONTACTWRKPLACEHOMEPAGEURL.VALIDITYENDDATE == BUT050.DATE_TO
  • A_BPCONTACTWRKPLACEHOMEPAGEURL.MANDT == BUT050.CLIENT
  • A_BPCONTACTWRKPLACEHOMEPAGEURL.BUSINESSPARTNERCOMPANY == BUT050.PARTNER1
  • A_BPCONTACTWRKPLACEHOMEPAGEURL.BUSINESSPARTNERPERSON == BUT050.PARTNER2