I_Addressindependentphone

Core view for address independent phone details | view: IADDRINDPHONE | Extraction: Not supported | Component: SAP Business Partner
Tables used: ADR2
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
PhoneNumberType Indicator: Telephone is a Mobile Telephone Show values
IsDefaultPhoneNumber Standard Sender Address in this Communication Type Show values
IsHomePhoneNumber Recipient address in this communication type (mail sys.grp) Show values
Column Name Description Domain name
InternationalPhoneNumber Complete Number: Dialling Code+Number+Extension CHAR30
PhoneNumberExtension Telephone no.: Extension CHAR10
AddressPhoneNumber Telephone no.: dialling code+number CHAR30
Master Data Relations Join Conditions
Address number
  • Client
  • ?
  • ?
  • Address Number
  • I_ADDRESSINDEPENDENTPHONE.MANDT == ADRC.CLIENT
  • I_ADDRESSINDEPENDENTPHONE.[column in domain "AD_NATION"] == ADRC.NATION
  • I_ADDRESSINDEPENDENTPHONE.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • I_ADDRESSINDEPENDENTPHONE.ADDRESSID == ADRC.ADDRNUMBER
Person number
  • Client
  • ?
  • ?
  • Person Number
  • I_ADDRESSINDEPENDENTPHONE.MANDT == ADRP.CLIENT
  • I_ADDRESSINDEPENDENTPHONE.[column in domain "AD_NATION"] == ADRP.NATION
  • I_ADDRESSINDEPENDENTPHONE.[column in domain "AD_DATE_FR"] == ADRP.DATE_FROM
  • I_ADDRESSINDEPENDENTPHONE.PERSON == ADRP.PERSNUMBER
Country key
  • Client
  • Country/Region for Telephone/Fax Number
  • I_ADDRESSINDEPENDENTPHONE.MANDT == T005.MANDT
  • I_ADDRESSINDEPENDENTPHONE.PHONENUMBERCOUNTRY == T005.LAND1