I_BPCustomerMultiAddrVH

Customers by Multiple Addresses | view: IMULTIADDRCUSTVH | Extraction: Not supported | Component: Business Partners
Column Name Description
AddressID FK Address Number
BusinessPartner Business Partner Number
Customer Customer Number
Column Name Description
Column Name Description
Column Name Description
AddressValidityStartDate null
AddressValidityEndDate null
Column Name Description
BusPartAddrLayoutStdIsHidden Truth Value: True/False Show values
Column Name Description Domain name
CityName City
StreetName Street
PostalCode City postal code
CustomerName Name of Customer
AuthorizationGroup Authorization Group BRGRU
IsBusinessPurposeCompleted Business Purpose Completed Flag
StandardUsage Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')
OrganizationBPName1 Name 1
OrganizationBPName2 Name 2
Master Data Relations Join Conditions
Address Number
  • Address Number
  • ?
  • Client
  • ?
  • I_BPCUSTOMERMULTIADDRVH.ADDRESSID == ADRC.ADDRNUMBER
  • I_BPCUSTOMERMULTIADDRVH.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • I_BPCUSTOMERMULTIADDRVH.MANDT == ADRC.CLIENT
  • I_BPCUSTOMERMULTIADDRVH.[column in domain "AD_NATION"] == ADRC.NATION
Address Type
  • Address Type
  • Client
  • I_BPCUSTOMERMULTIADDRVH.ADDRESSUSAGE == TB009.ADR_KIND
  • I_BPCUSTOMERMULTIADDRVH.MANDT == TB009.CLIENT
Business Partner Type
  • Business Partner Type
  • Client
  • I_BPCUSTOMERMULTIADDRVH.BUSINESSPARTNERTYPE == TB004.BPKIND
  • I_BPCUSTOMERMULTIADDRVH.MANDT == TB004.CLIENT
Country key
  • Client
  • Country/Region Key
  • I_BPCUSTOMERMULTIADDRVH.MANDT == T005.MANDT
  • I_BPCUSTOMERMULTIADDRVH.COUNTRY == T005.LAND1
Customer Account Group
  • Customer Account Group
  • Client
  • I_BPCUSTOMERMULTIADDRVH.CUSTOMERACCOUNTGROUP == T077D.KTOKD
  • I_BPCUSTOMERMULTIADDRVH.MANDT == T077D.MANDT