ADCPS

Shadow Table: Assignment Person/Addr. (Bus. Addr. Services) | #masterdata | Component: Address Management/Business Address
Column Name Description
CLIENT FK Client
TRKORR Request/Task
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
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
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
  • ?
  • Version ID for International Addresses
  • ADCPS.CLIENT == ADRC.CLIENT
  • ADCPS.ADDRNUMBER == ADRC.ADDRNUMBER
  • ADCPS.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • ADCPS.NATION == ADRC.NATION
Number of different business address
  • Business address number, if different (not used)
  • ?
  • ?
  • ADCPS.CLIENT == ADRC.CLIENT
  • ADCPS.ALT_COMPNY == ADRC.ADDRNUMBER
  • ADCPS.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • ADCPS.[column in domain "AD_NATION"] == ADRC.NATION
Client in which the address/person resides ADCPS.CLIENT == T000.MANDT
Standard communication type ADCPS.DEFLT_COMM == TSAC.COMM_TYPE
Version ID for International Addresses ADCPS.NATION == TSADV.NATION
Key of person
  • ?
  • Version ID for International Addresses
  • Client
  • Person Number
  • ADCPS.[column in domain "AD_DATE_FR"] == ADRP.DATE_FROM
  • ADCPS.NATION == ADRP.NATION
  • ADCPS.CLIENT == ADRP.CLIENT
  • ADCPS.PERSNUMBER == ADRP.PERSNUMBER