fndei_adcp_filter

Filter View for table ADCP | view: FNDEIFADCP | TRAN | Extraction: Not supported | Component: View Provisioning: Orchestration
Tables used: ADCP
Column Name Description
ADDRNUMBER FK Address Number
PERSNUMBER FK Person Number
DATE_FROM Valid-from date - in current Release only 00010101 possible
NATION FK Version ID for International Addresses
Column Name Description
Column Name Description
Column Name Description
DATE_FROM Valid-from date - in current Release only 00010101 possible
DATE_TO Valid-to date in current Release only 99991231 possible
_DATAAGING Data Filter Value for Data Aging
Column Name Description
COMP_PERS Flag: Person in company (C) or private (P) address Show values
FLAGCOMM2 Flag: Telephone number(s) defined Show values
FLAGCOMM3 Flag: Fax number(s) defined Show values
FLAGCOMM4 Flag: Teletex number(s) defined Show values
FLAGCOMM5 Flag: Telex number(s) defined Show values
FLAGCOMM6 Flag: E-mail address(es) defined Show values
FLAGCOMM7 Flag: RML (remote mail) addresse(s) defined Show values
FLAGCOMM8 Flag: X.400 addresse(s) defined Show values
FLAGCOMM9 Flag: RFC destination(s) defined Show values
FLAGCOMM10 Flag: Printer defined Show values
FLAGCOMM11 Flag: SSF defined Show values
FLAGCOMM12 Flag: URI/FTP address defined Show values
FLAGCOMM13 Flag: Pager address defined Show values
UUID_BELATED Indicator: UUID created later Show values
ID_CATEGORY Category of an Address ID Show values
ADCP_ERR_STATUS Error Status of Address Show values
XPCPT Business Purpose Completed Flag Show values
Column Name Description Domain name
SO_KEY SAP-Office key AD_SO_KEY
DEPARTMENT Department TEXT40
FUNCTION Function TEXT40
BUILDING Building (number or code) TEXT10
FLOOR Floor in building TEXT10
ROOMNUMBER Room or Apartment Number TEXT10
ID_CODE Short name for correspondence TEXT10
IH_MAIL Internal Mail Postal Code TEXT10
SORT1 (Not Supported) Search Term CHAR20
SORT2 (Not Supported) Search Term CHAR20
SORT_PHN (Not Supported) Phonetic Search Sort Field CHAR20
TEL_NUMBER First telephone no.: dialling code+number CHAR30
TEL_EXTENS First Telephone No.: Extension CHAR10
FAX_NUMBER First Fax No.: Area Code + Number CHAR30
FAX_EXTENS First fax no.: extension CHAR10
ADCP_UUID UUID Used in the Address SYSUUID
Master Data Relations Join Conditions
Address key
  • Address Number
  • ?
  • Client
  • Version ID for International Addresses
  • FNDEI_ADCP_FILTER.ADDRNUMBER == ADRC.ADDRNUMBER
  • FNDEI_ADCP_FILTER.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • FNDEI_ADCP_FILTER.MANDT == ADRC.CLIENT
  • FNDEI_ADCP_FILTER.NATION == ADRC.NATION
Number of different business address
  • ?
  • ?
  • Business address number, if different (not used)
  • Client
  • FNDEI_ADCP_FILTER.[column in domain "AD_NATION"] == ADRC.NATION
  • FNDEI_ADCP_FILTER.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • FNDEI_ADCP_FILTER.ALT_COMPNY == ADRC.ADDRNUMBER
  • FNDEI_ADCP_FILTER.MANDT == ADRC.CLIENT
Standard communication type FNDEI_ADCP_FILTER.DEFLT_COMM == TSAC.COMM_TYPE
Version ID for International Addresses FNDEI_ADCP_FILTER.NATION == TSADV.NATION
Key of person
  • Person Number
  • ?
  • Client
  • Version ID for International Addresses
  • FNDEI_ADCP_FILTER.PERSNUMBER == ADRP.PERSNUMBER
  • FNDEI_ADCP_FILTER.[column in domain "AD_DATE_FR"] == ADRP.DATE_FROM
  • FNDEI_ADCP_FILTER.MANDT == ADRP.CLIENT
  • FNDEI_ADCP_FILTER.NATION == ADRP.NATION