SAP table ADCP (Person/Address Assignment (Business Address Services))

SAP table ADCP has 5 primary key fields being CLIENT,ADDRNUMBER,PERSNUMBER,DATE_FROM,NATION.

Field Description Data Type Length Decimals Checktable Data Element
CLIENT Client CLNT 3 0 T000 MANDT
ADDRNUMBER Address Number CHAR 10 0 ADRC AD_ADDRNUM
PERSNUMBER Person Number CHAR 10 0 ADRP AD_PERSNUM
DATE_FROM Valid-from date - in current Release only 00010101 possible DATS 8 0 AD_DATE_FR
NATION Version ID for International Addresses CHAR 1 0 TSADV AD_NATION
DATE_TO Valid-to date in current Release only 99991231 possible DATS 8 0 AD_DATE_TO
COMP_PERS Flag: Person in company (C) or private (P) address CHAR 1 0 AD_CMP_PRS
C Person in company
P Private
SO_KEY SAP-Office key CHAR 10 0 AD_SO_KEY
DEPARTMENT Department CHAR 40 0 AD_DPRTMNT
FUNCTION Function CHAR 40 0 AD_FNCTN
BUILDING Building (number or code) CHAR 10 0 AD_BLDNG_P
FLOOR Floor in building CHAR 10 0 AD_FLOOR
ROOMNUMBER Room or Apartment Number CHAR 10 0 AD_ROOMNUM
ID_CODE Short name for correspondence CHAR 10 0 AD_ID_CODE
IH_MAIL Internal Mail Postal Code CHAR 10 0 AD_IH_MAIL
SORT1 (Not Supported) Search Term CHAR 20 0 AD_SORTOLD
SORT2 (Not Supported) Search Term CHAR 20 0 AD_SORTOLD
SORT_PHN (Not Supported) Phonetic Search Sort Field CHAR 20 0 AD_SRTPHN
ALT_COMPNY Business address number, if different (not used) CHAR 10 0 ADRC AD_ALTCMPY
DEFLT_COMM Communication Method (Key) (Business Address Services) CHAR 3 0 TSAC AD_COMM
TEL_NUMBER First telephone no.: dialling code+number CHAR 30 0 AD_TLNMBR1
TEL_EXTENS First Telephone No.: Extension CHAR 10 0 AD_TLXTNS1
FAX_NUMBER First Fax No.: Area Code + Number CHAR 30 0 AD_FXNMBR1
FAX_EXTENS First fax no.: extension CHAR 10 0 AD_FXXTNS1
FLAGCOMM2 Flag: Telephone number(s) defined CHAR 1 0 AD_FLGCM02
FLAGCOMM3 Flag: Fax number(s) defined CHAR 1 0 AD_FLGCM03
FLAGCOMM4 Flag: Teletex number(s) defined CHAR 1 0 AD_FLGCM04
FLAGCOMM5 Flag: Telex number(s) defined CHAR 1 0 AD_FLGCM05
FLAGCOMM6 Flag: E-mail address(es) defined CHAR 1 0 AD_FLGCM06
FLAGCOMM7 Flag: RML (remote mail) addresse(s) defined CHAR 1 0 AD_FLGCM07
FLAGCOMM8 Flag: X.400 addresse(s) defined CHAR 1 0 AD_FLGCM08
FLAGCOMM9 Flag: RFC destination(s) defined CHAR 1 0 AD_FLGCM09
FLAGCOMM10 Flag: Printer defined CHAR 1 0 AD_FLGCM10
FLAGCOMM11 Flag: SSF defined CHAR 1 0 AD_FLGCM11
FLAGCOMM12 Flag: URI/FTP address defined CHAR 1 0 AD_FLGCM12
FLAGCOMM13 Flag: Pager address defined CHAR 1 0 AD_FLGCM13
ADCP_UUID UUID Used in the Address RAW 16 0 AD_UUID
UUID_BELATED Indicator: UUID created later CHAR 1 0 AD_UUID_BELATED
UUID was created when the address was created
X UUID was created later
ID_CATEGORY Category of an Address ID CHAR 1 0 AD_ID_CATEGORY
Normal AddressID
I Internal AddressID of Instance Sharing Address
ADCP_ERR_STATUS Error Status of Address CHAR 1 0 AD_ERR_STATUS
Address is consistent
E Address contains data with errors
W Address contains data that produces warnings
XPCPT Business Purpose Completed Flag CHAR 1 0 AD_XPCPT
False
X True
_DATAAGING Data Filter Value for Data Aging DATS 8 0 DATA_TEMPERATURE

ADCP foreign key relationships

Table Field Check Table Check Field
0 ADCP ADDRNUMBER ADRC Addresses (Business Address Services) DATE_FROM
0 ADCP ADDRNUMBER ADRC Addresses (Business Address Services) NATION
1 ADCP ALT_COMPNY ADRC Addresses (Business Address Services) DATE_FROM
1 ADCP ALT_COMPNY ADRC Addresses (Business Address Services) NATION
0 ADCP CLIENT T000 Clients MANDT
1 ADCP DEFLT_COMM TSAC Communication Methods (Business Address Services) COMM_TYPE
0 ADCP PERSNUMBER ADRP Persons (Business Address Services) PERSNUMBER
0 ADCP PERSNUMBER ADRP Persons (Business Address Services) DATE_FROM
0 ADCP PERSNUMBER ADRP Persons (Business Address Services) NATION