fndei_adr6_filter

Filter View for table ADR6 | view: FNDEIFADR6 | TRAN | Extraction: Not supported | Component: View Provisioning: Orchestration
Tables used: ADCPADR6ADR6ADRC
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 Flag: this address is the default address 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 Flag: Recipient is standard recipient for this address Show values
r3_user Flag: Connected to an SAP System Show values
encode Required Data Encoding (E-Mail) Show values
tnef Flag: Receiver can receive TNEF encoding by SMTP Show values
Column Name Description Domain name
smtp_addr E-Mail Address AD_SMTPADR
smtp_srch E-Mail Address Search Field CHAR20
valid_from Communication Data: Valid From (YYYYMMDDHHMMSS) TIMESTMP
valid_to Communication Data: Valid To (YYYYMMDDHHMMSS) TIMESTAMP
Master Data Relations Join Conditions
Address number
  • Client
  • Address Number
  • ?
  • ?
  • FNDEI_ADR6_FILTER.MANDT == ADRC.CLIENT
  • FNDEI_ADR6_FILTER.ADDRNUMBER == ADRC.ADDRNUMBER
  • FNDEI_ADR6_FILTER.[column in domain "AD_NATION"] == ADRC.NATION
  • FNDEI_ADR6_FILTER.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
Person number
  • Client
  • Person Number
  • ?
  • ?
  • FNDEI_ADR6_FILTER.MANDT == ADRP.CLIENT
  • FNDEI_ADR6_FILTER.PERSNUMBER == ADRP.PERSNUMBER
  • FNDEI_ADR6_FILTER.[column in domain "AD_NATION"] == ADRP.NATION
  • FNDEI_ADR6_FILTER.[column in domain "AD_DATE_FR"] == ADRP.DATE_FROM