A_AddressPhoneNumber

Phone Number | view: AADDRPHONENUMBER | Extraction: Not supported | Component: Business Partners
Tables used: ADRTADR2BUT000BUT020
Column Name Description
AddressID FK Address Number
Person FK Person Number
OrdinalNumber Sequence Number
Column Name Description
Column Name Description
Column Name Description
Column Name Description
IsDefaultPhoneNumber Standard Sender Address in this Communication Type Show values
PhoneNumberType Indicator: Telephone is a Mobile Telephone Show values
IsBusinessPurposeCompleted Business Purpose Completed Flag Show values
Column Name Description Domain name
PhoneNumber Telephone no.: dialling code+number CHAR30
PhoneNumberExtension Telephone no.: Extension CHAR10
InternationalPhoneNumber Complete Number: Dialling Code+Number+Extension CHAR30
AddressCommunicationRemarkText Communication link notes TEXT50
Master Data Relations Join Conditions
Address number
  • Address Number
  • Client
  • ?
  • ?
  • A_ADDRESSPHONENUMBER.ADDRESSID == ADRC.ADDRNUMBER
  • A_ADDRESSPHONENUMBER.MANDT == ADRC.CLIENT
  • A_ADDRESSPHONENUMBER.[column in domain "AD_NATION"] == ADRC.NATION
  • A_ADDRESSPHONENUMBER.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
Authorization Group
  • Authorization Group
  • Client
  • ?
  • A_ADDRESSPHONENUMBER.AUTHORIZATIONGROUP == TB037.AUGRP
  • A_ADDRESSPHONENUMBER.MANDT == TB037.CLIENT
  • A_ADDRESSPHONENUMBER.[column in domain "BU_AUOBJ"] == TB037.AUOBJ
Business Partner Number
  • Client
  • Business Partner Number
  • A_ADDRESSPHONENUMBER.MANDT == BUT000.CLIENT
  • A_ADDRESSPHONENUMBER.BUSINESSPARTNER == BUT000.PARTNER
Country key
  • Client
  • Country/Region for Telephone/Fax Number
  • A_ADDRESSPHONENUMBER.MANDT == T005.MANDT
  • A_ADDRESSPHONENUMBER.DESTINATIONLOCATIONCOUNTRY == T005.LAND1
Person number
  • Client
  • ?
  • ?
  • Person Number
  • A_ADDRESSPHONENUMBER.MANDT == ADRP.CLIENT
  • A_ADDRESSPHONENUMBER.[column in domain "AD_NATION"] == ADRP.NATION
  • A_ADDRESSPHONENUMBER.[column in domain "AD_DATE_FR"] == ADRP.DATE_FROM
  • A_ADDRESSPHONENUMBER.PERSON == ADRP.PERSNUMBER