I_BpContactToAddressStdVH

Business Partner Contact To Address | view: IBCTA__VH | Extraction: Not supported | Component: Business Partners
Tables used: ADR3ADR2ADCPBUT000BUT052BUT000
Column Name Description
RelationshipNumber FK BP Relationship Number
BusinessPartnerCompany Business Partner Number
BusinessPartnerPerson Business Partner Number
ValidityEndDate Validity Date (Valid To)
AddressID FK Address Number
Column Name Description
Column Name Description
Column Name Description
ValidityEndDate Validity Date (Valid To)
Column Name Description
Column Name Description Domain name
PersonNumber Person Number AD_PERSNUM
Master Data Relations Join Conditions
Address Number
  • Client
  • ?
  • ?
  • Address Number
  • I_BPCONTACTTOADDRESSSTDVH.MANDT == ADRC.CLIENT
  • I_BPCONTACTTOADDRESSSTDVH.[column in domain "AD_NATION"] == ADRC.NATION
  • I_BPCONTACTTOADDRESSSTDVH.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • I_BPCONTACTTOADDRESSSTDVH.ADDRESSID == ADRC.ADDRNUMBER
BP Relationship Number
  • Client
  • Validity Date (Valid To)
  • BP Relationship Number
  • Business Partner Number
  • Business Partner Number
  • I_BPCONTACTTOADDRESSSTDVH.MANDT == BUT050.CLIENT
  • I_BPCONTACTTOADDRESSSTDVH.VALIDITYENDDATE == BUT050.DATE_TO
  • I_BPCONTACTTOADDRESSSTDVH.RELATIONSHIPNUMBER == BUT050.RELNR
  • I_BPCONTACTTOADDRESSSTDVH.BUSINESSPARTNERCOMPANY == BUT050.PARTNER1
  • I_BPCONTACTTOADDRESSSTDVH.BUSINESSPARTNERPERSON == BUT050.PARTNER2