C_BPAddressValueHelp

Value Help view for list of addresses of a BP | view: CBPADDRESSVH | Extraction: Not supported | Component: Business Partners
Tables used: ADCPADRCADR6ADR3ADR12ADR2BUT020
Column Name Description
AddressNumber FK Address Number
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
HouseNumber House Number TEXT10
StreetName Street TEXT60
CityName City TEXT40
PostalCode City postal code CHAR10
CompleteAddress null
Master Data Relations Join Conditions
Address Number
  • Address Number
  • Client
  • ?
  • ?
  • C_BPADDRESSVALUEHELP.ADDRESSNUMBER == ADRC.ADDRNUMBER
  • C_BPADDRESSVALUEHELP.MANDT == ADRC.CLIENT
  • C_BPADDRESSVALUEHELP.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • C_BPADDRESSVALUEHELP.[column in domain "AD_NATION"] == ADRC.NATION
Business Partner Number
  • Client
  • Business Partner Number
  • C_BPADDRESSVALUEHELP.MANDT == BUT000.CLIENT
  • C_BPADDRESSVALUEHELP.BUSINESSPARTNER == BUT000.PARTNER
Country key
  • Client
  • Country/Region Key
  • C_BPADDRESSVALUEHELP.MANDT == T005.MANDT
  • C_BPADDRESSVALUEHELP.COUNTRY == T005.LAND1