C_BPContactWbsteURL

C view fir BP contact Website URL | view: CBPCPWBSTEURL | Extraction: Not supported | Component: Business Partners
Tables used: ADRT, ADR3, ADR12, ADR2, ADCP, BUT000, BUT052
Column Name Description
BusinessPartner1 Business Partner Number
BusinessPartner2 Business Partner Number
RelationshipNumber FK BP Relationship Number
ValidityEndDate Validity Date (Valid To)
AddressID FK Address Number
OrdinalNumber Sequence Number
Column Name Description
Column Name Description
Column Name Description
ValidityEndDate Validity Date (Valid To)
ValidityEndDateForEdit 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
BusinessPartner1ForEdit Business Partner Number BU_PARTNER
BusinessPartner2ForEdit Business Partner Number BU_PARTNER
OrdinalNumberForEdit Sequence Number NUMC3
AddressCommunicationRemarkText Communication link notes TEXT50
URLFieldLength null
CorporateWebsiteURL Universal Resource Identifier (URI) AD_URI
Master Data Relations Join Conditions
Address Number
  • Address Number
  • Address Number
  • ?
  • Client
  • ?
  • C_BPCONTACTWBSTEURL.ADDRESSID == ADRC.ADDRNUMBER
  • C_BPCONTACTWBSTEURL.ADDRESSIDFOREDIT == ADRC.ADDRNUMBER
  • C_BPCONTACTWBSTEURL.[column in domain "AD_NATION"] == ADRC.NATION
  • C_BPCONTACTWBSTEURL.MANDT == ADRC.CLIENT
  • C_BPCONTACTWBSTEURL.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
Address Number
  • Address Number
  • Address Number
  • ?
  • Client
  • ?
  • C_BPCONTACTWBSTEURL.ADDRESSID == ADRC.ADDRNUMBER
  • C_BPCONTACTWBSTEURL.ADDRESSIDFOREDIT == ADRC.ADDRNUMBER
  • C_BPCONTACTWBSTEURL.[column in domain "AD_NATION"] == ADRC.NATION
  • C_BPCONTACTWBSTEURL.MANDT == ADRC.CLIENT
  • C_BPCONTACTWBSTEURL.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
BP Relationship Number
  • Client
  • Business Partner Number
  • Business Partner Number
  • Business Partner Number
  • Business Partner Number
  • Validity Date (Valid To)
  • Validity Date (Valid To)
  • BP Relationship Number
  • BP Relationship Number
  • C_BPCONTACTWBSTEURL.MANDT == BUT050.CLIENT
  • C_BPCONTACTWBSTEURL.BUSINESSPARTNER1 == BUT050.PARTNER1
  • C_BPCONTACTWBSTEURL.BUSINESSPARTNER1FOREDIT == BUT050.PARTNER1
  • C_BPCONTACTWBSTEURL.BUSINESSPARTNER2 == BUT050.PARTNER2
  • C_BPCONTACTWBSTEURL.BUSINESSPARTNER2FOREDIT == BUT050.PARTNER2
  • C_BPCONTACTWBSTEURL.VALIDITYENDDATEFOREDIT == BUT050.DATE_TO
  • C_BPCONTACTWBSTEURL.VALIDITYENDDATE == BUT050.DATE_TO
  • C_BPCONTACTWBSTEURL.RELATIONSHIPNUMBER == BUT050.RELNR
  • C_BPCONTACTWBSTEURL.RELATIONSHIPNUMBERFOREDIT == BUT050.RELNR
BP Relationship Number
  • Client
  • Business Partner Number
  • Business Partner Number
  • Business Partner Number
  • Business Partner Number
  • Validity Date (Valid To)
  • Validity Date (Valid To)
  • BP Relationship Number
  • BP Relationship Number
  • C_BPCONTACTWBSTEURL.MANDT == BUT050.CLIENT
  • C_BPCONTACTWBSTEURL.BUSINESSPARTNER1 == BUT050.PARTNER1
  • C_BPCONTACTWBSTEURL.BUSINESSPARTNER1FOREDIT == BUT050.PARTNER1
  • C_BPCONTACTWBSTEURL.BUSINESSPARTNER2 == BUT050.PARTNER2
  • C_BPCONTACTWBSTEURL.BUSINESSPARTNER2FOREDIT == BUT050.PARTNER2
  • C_BPCONTACTWBSTEURL.VALIDITYENDDATEFOREDIT == BUT050.DATE_TO
  • C_BPCONTACTWBSTEURL.VALIDITYENDDATE == BUT050.DATE_TO
  • C_BPCONTACTWBSTEURL.RELATIONSHIPNUMBER == BUT050.RELNR
  • C_BPCONTACTWBSTEURL.RELATIONSHIPNUMBERFOREDIT == BUT050.RELNR