C_BPContactAddress

C View for BP Contact Address | view: CBPCPADDR | Extraction: Not supported | Component: Business Partners
Tables used: ADCP, ADRC, ADR6, ADR3, ADR12, ADR2, ADCP, BUT000, BUT052, BUT000, BUT020
Column Name Description
BusinessPartner1 Business Partner Number
BusinessPartner2 Business Partner Number
RelationshipNumber FK BP Relationship Number
ValidityEndDate Validity Date (Valid To)
AddressID FK Address Number
Column Name Description
Column Name Description
Column Name Description
ValidityEndDate Validity Date (Valid To)
ValidityEndDateForEdit Validity Date (Valid To)
Column Name Description
IsDefaultAddress Indicator: Address is standard address Show values
Column Name Description Domain name
BusinessPartner1ForEdit Business Partner Number BU_PARTNER
BusinessPartner2ForEdit Business Partner Number BU_PARTNER
ContactRelationshipFunction Function TEXT40
ContactRelationshipDepartment Department TEXT40
Floor Floor in building TEXT10
Building Building (number or code) TEXT10
RoomNumber Room or Apartment Number TEXT10
CorrespondenceShortName Short name for correspondence TEXT10
InhouseMail Internal Mail Postal Code TEXT10
FormattedAddress null
FullName Full name of a party (Bus. Partner, Org. Unit, Doc. address) TEXT80
HouseNumber House Number TEXT10
StreetName Street TEXT60
CityName City TEXT40
PostalCode City postal code CHAR10
Master Data Relations Join Conditions
Address Number
  • Client
  • ?
  • Address Number
  • Address Number
  • ?
  • C_BPCONTACTADDRESS.MANDT == ADRC.CLIENT
  • C_BPCONTACTADDRESS.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • C_BPCONTACTADDRESS.ADDRESSID == ADRC.ADDRNUMBER
  • C_BPCONTACTADDRESS.ADDRESSIDFOREDIT == ADRC.ADDRNUMBER
  • C_BPCONTACTADDRESS.[column in domain "AD_NATION"] == ADRC.NATION
Address Number
  • Client
  • ?
  • Address Number
  • Address Number
  • ?
  • C_BPCONTACTADDRESS.MANDT == ADRC.CLIENT
  • C_BPCONTACTADDRESS.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • C_BPCONTACTADDRESS.ADDRESSID == ADRC.ADDRNUMBER
  • C_BPCONTACTADDRESS.ADDRESSIDFOREDIT == ADRC.ADDRNUMBER
  • C_BPCONTACTADDRESS.[column in domain "AD_NATION"] == ADRC.NATION
Address time zone
  • Client
  • Address time zone
  • C_BPCONTACTADDRESS.MANDT == TTZZ.CLIENT
  • C_BPCONTACTADDRESS.ADDRESSTIMEZONE == TTZZ.TZONE
Country key
  • Client
  • Country/Region Key
  • C_BPCONTACTADDRESS.MANDT == T005.MANDT
  • C_BPCONTACTADDRESS.COUNTRY == T005.LAND1
Form-of-Address Key
  • Client
  • Form-of-Address Key
  • C_BPCONTACTADDRESS.MANDT == TSAD3.CLIENT
  • C_BPCONTACTADDRESS.FORMOFADDRESS == TSAD3.TITLE
Standard communication type C_BPCONTACTADDRESS.PRFRDCOMMMEDIUMTYPE == TSAC.COMM_TYPE
Region code
  • Client
  • Country/Region Key
  • Region (State, Province, County)
  • C_BPCONTACTADDRESS.MANDT == T005S.MANDT
  • C_BPCONTACTADDRESS.COUNTRY == T005S.LAND1
  • C_BPCONTACTADDRESS.REGION == T005S.BLAND
BP Relationship Number
  • Client
  • Business Partner Number
  • Business Partner Number
  • Business Partner Number
  • Business Partner Number
  • BP Relationship Number
  • BP Relationship Number
  • Validity Date (Valid To)
  • Validity Date (Valid To)
  • C_BPCONTACTADDRESS.MANDT == BUT050.CLIENT
  • C_BPCONTACTADDRESS.BUSINESSPARTNER1 == BUT050.PARTNER1
  • C_BPCONTACTADDRESS.BUSINESSPARTNER1FOREDIT == BUT050.PARTNER1
  • C_BPCONTACTADDRESS.BUSINESSPARTNER2 == BUT050.PARTNER2
  • C_BPCONTACTADDRESS.BUSINESSPARTNER2FOREDIT == BUT050.PARTNER2
  • C_BPCONTACTADDRESS.RELATIONSHIPNUMBER == BUT050.RELNR
  • C_BPCONTACTADDRESS.RELATIONSHIPNUMBERFOREDIT == BUT050.RELNR
  • C_BPCONTACTADDRESS.VALIDITYENDDATE == BUT050.DATE_TO
  • C_BPCONTACTADDRESS.VALIDITYENDDATEFOREDIT == BUT050.DATE_TO
BP Relationship Number
  • Client
  • Business Partner Number
  • Business Partner Number
  • Business Partner Number
  • Business Partner Number
  • BP Relationship Number
  • BP Relationship Number
  • Validity Date (Valid To)
  • Validity Date (Valid To)
  • C_BPCONTACTADDRESS.MANDT == BUT050.CLIENT
  • C_BPCONTACTADDRESS.BUSINESSPARTNER1 == BUT050.PARTNER1
  • C_BPCONTACTADDRESS.BUSINESSPARTNER1FOREDIT == BUT050.PARTNER1
  • C_BPCONTACTADDRESS.BUSINESSPARTNER2 == BUT050.PARTNER2
  • C_BPCONTACTADDRESS.BUSINESSPARTNER2FOREDIT == BUT050.PARTNER2
  • C_BPCONTACTADDRESS.RELATIONSHIPNUMBER == BUT050.RELNR
  • C_BPCONTACTADDRESS.RELATIONSHIPNUMBERFOREDIT == BUT050.RELNR
  • C_BPCONTACTADDRESS.VALIDITYENDDATE == BUT050.DATE_TO
  • C_BPCONTACTADDRESS.VALIDITYENDDATEFOREDIT == BUT050.DATE_TO