/BOFU/CV_Q_BPByAddress

Root Query on Address Data | view: /BOFU/CVQRTADDR | Extraction: Not supported | Component: Reusable Components of Business Suite Foundation
Tables used: ADCPADRCBUT000BUT100BUT020BUT000
Column Name Description
partner Business Partner Number
role FK BP Role
addrnumber FK Address Number
Column Name Description
Column Name Description
Column Name Description
valid_date Field of type DATS
Column Name Description
type Business Partner Category Show values
IsBusinessPurposeCompleted Business Purpose Completed Flag Show values
Column Name Description Domain name
partner_guid Business Partner GUID SYSUUID
bu_sort1 Search Term 1 for Business Partner BU_SORT1
bu_sort2 Search Term 2 for Business Partner BU_SORT1
mc_name1 Search Help Field 1 (Name 1/Last Name) CHAR35
mc_name2 Search Help Field 2 (Name 2/First Name) CHAR35
mc_city1 null
mc_street null
post_code1 City postal code CHAR10
house_num1 House Number TEXT10
Master Data Relations Join Conditions
Address Number
  • Address Number
  • ?
  • ?
  • Client
  • /BOFU/CV_Q_BPBYADDRESS.ADDRNUMBER == ADRC.ADDRNUMBER
  • /BOFU/CV_Q_BPBYADDRESS.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • /BOFU/CV_Q_BPBYADDRESS.[column in domain "AD_NATION"] == ADRC.NATION
  • /BOFU/CV_Q_BPBYADDRESS.MANDT == ADRC.CLIENT
Authorization Group
  • ?
  • Authorization Group
  • Client
  • /BOFU/CV_Q_BPBYADDRESS.[column in domain "BU_AUOBJ"] == TB037.AUOBJ
  • /BOFU/CV_Q_BPBYADDRESS.AUGRP == TB037.AUGRP
  • /BOFU/CV_Q_BPBYADDRESS.MANDT == TB037.CLIENT
Country key
  • Client
  • Country/Region Key
  • /BOFU/CV_Q_BPBYADDRESS.MANDT == T005.MANDT
  • /BOFU/CV_Q_BPBYADDRESS.COUNTRY == T005.LAND1
BP Role
  • BP Role
  • Client
  • /BOFU/CV_Q_BPBYADDRESS.ROLE == TB003.ROLE
  • /BOFU/CV_Q_BPBYADDRESS.MANDT == TB003.CLIENT