fndei_adr2_filter

Filter View for table ADR2 | view: FNDEIFADR2 | TRAN | Extraction: Not supported | Component: View Provisioning: Orchestration
Tables used: ADCPADR2ADR2ADRC
Column Name Description
addrnumber FK Address Number
persnumber FK Person Number
date_from Valid-from date - in current Release only 00010101 possible
consnumber Sequence Number
Column Name Description
Column Name Description
Column Name Description
date_from Valid-from date - in current Release only 00010101 possible
_dataaging Data Filter Value for Data Aging
Column Name Description
flgdefault Standard Sender Address in this Communication Type Show values
flg_nouse Flag: This Communication Number is Not Used Show values
home_flag Recipient address in this communication type (mail sys.grp) Show values
dft_receiv Indicator: Telephone is SMS-Enabled Show values
r3_user Indicator: Telephone is a Mobile Telephone Show values
Column Name Description Domain name
tel_number Telephone no.: dialling code+number CHAR30
tel_extens Telephone no.: Extension CHAR10
telnr_long Complete Number: Dialling Code+Number+Extension CHAR30
telnr_call Telephone number for determining caller CHAR30
valid_from Communication Data: Valid From (YYYYMMDDHHMMSS) TIMESTMP
valid_to Communication Data: Valid To (YYYYMMDDHHMMSS) TIMESTAMP
Master Data Relations Join Conditions
Address number
  • Address Number
  • Client
  • ?
  • ?
  • FNDEI_ADR2_FILTER.ADDRNUMBER == ADRC.ADDRNUMBER
  • FNDEI_ADR2_FILTER.MANDT == ADRC.CLIENT
  • FNDEI_ADR2_FILTER.[column in domain "AD_NATION"] == ADRC.NATION
  • FNDEI_ADR2_FILTER.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
Country key
  • Country/Region for Telephone/Fax Number
  • Client
  • FNDEI_ADR2_FILTER.COUNTRY == T005.LAND1
  • FNDEI_ADR2_FILTER.MANDT == T005.MANDT
Person number
  • Person Number
  • Client
  • ?
  • ?
  • FNDEI_ADR2_FILTER.PERSNUMBER == ADRP.PERSNUMBER
  • FNDEI_ADR2_FILTER.MANDT == ADRP.CLIENT
  • FNDEI_ADR2_FILTER.[column in domain "AD_NATION"] == ADRP.NATION
  • FNDEI_ADR2_FILTER.[column in domain "AD_DATE_FR"] == ADRP.DATE_FROM