C_CustomerBPAddressVH

Business Partner Addresses of Customers | view: CCSTADDRESSVH | Extraction: Not supported | Component: Customer Material Information
Tables used: ADCPADRCADR6ADR3ADR12ADR2BUT020BUT000CVI_CUST_LINKKNA1
Column Name Description
AddressID FK Address Number
Customer Customer Number
Column Name Description
Column Name Description
Column Name Description
ValidityStartDate null
ValidityEndDate null
Column Name Description
IsBusinessPurposeCompleted Business Purpose Completed Flag Show values
Column Name Description Domain name
FormattedPostalAddressDesc One-line short form of formatted address
BusinessPartner Business Partner Number BU_PARTNER
AuthorizationGroup Authorization Group BRGRU
Master Data Relations Join Conditions
Address Number
  • Address Number
  • ?
  • Client
  • ?
  • C_CUSTOMERBPADDRESSVH.ADDRESSID == ADRC.ADDRNUMBER
  • C_CUSTOMERBPADDRESSVH.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • C_CUSTOMERBPADDRESSVH.MANDT == ADRC.CLIENT
  • C_CUSTOMERBPADDRESSVH.[column in domain "AD_NATION"] == ADRC.NATION
Customer Account Group
  • Client
  • Customer Account Group
  • C_CUSTOMERBPADDRESSVH.MANDT == T077D.MANDT
  • C_CUSTOMERBPADDRESSVH.CUSTOMERACCOUNTGROUP == T077D.KTOKD