I_AddressFaxNumber_2

Fax Number | view: IADDRFAXNUMBER2 | Extraction: Not supported | Component: Address Management/Business Address
Tables used: ADR3
Column Name Description
AddressID FK Address Number
AddressPersonID FK Person Number
CommMediumSequenceNumber Sequence Number
Column Name Description
Column Name Description
Column Name Description
ValidityStartDate null
ValidityEndDate null
Column Name Description
FaxNumberIsCurrentDefault Standard Sender Address in this Communication Type Show values
Column Name Description Domain name
FaxAreaCodeSubscriberNumber Fax number: dialling code+number CHAR30
FaxExtensionNumber Fax no.: Extension CHAR10
InternationalFaxNumber Complete number: dialling code+number+extension CHAR30
Master Data Relations Join Conditions
Address number
  • Address Number
  • ?
  • ?
  • Client
  • I_ADDRESSFAXNUMBER_2.ADDRESSID == ADRC.ADDRNUMBER
  • I_ADDRESSFAXNUMBER_2.[column in domain "AD_NATION"] == ADRC.NATION
  • I_ADDRESSFAXNUMBER_2.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • I_ADDRESSFAXNUMBER_2.MANDT == ADRC.CLIENT
Person number
  • Person Number
  • ?
  • ?
  • Client
  • I_ADDRESSFAXNUMBER_2.ADDRESSPERSONID == ADRP.PERSNUMBER
  • I_ADDRESSFAXNUMBER_2.[column in domain "AD_NATION"] == ADRP.NATION
  • I_ADDRESSFAXNUMBER_2.[column in domain "AD_DATE_FR"] == ADRP.DATE_FROM
  • I_ADDRESSFAXNUMBER_2.MANDT == ADRP.CLIENT
Country key
  • Client
  • Country/Region for Telephone/Fax Number
  • I_ADDRESSFAXNUMBER_2.MANDT == T005.MANDT
  • I_ADDRESSFAXNUMBER_2.FAXNUMBERCOUNTRY == T005.LAND1