SAP Table ADCP - Person/Address Assignment (Business Address Services)

Field Key Data Element Type Offset Leng Decimals Check Table Text
CLIENT X MANDT CLNT 0 3 0 T000 Client
ADDRNUMBER X AD_ADDRNUM CHAR 3 10 0 Address number
PERSNUMBER X AD_PERSNUM CHAR 13 10 0 ADRP Person number
DATE_FROM X AD_DATE_FR DATS 23 8 0 Valid-from date - in current Release only 00010101 possible
NATION X AD_NATION CHAR 31 1 0 TSADV International address version ID
DATE_TO AD_DATE_TO DATS 32 8 0 Valid-to date in current Release only 99991231 possible
COMP_PERS AD_CMP_PRS CHAR 40 1 0 Flag: Person in company (C) or private (P) address
SO_KEY AD_SO_KEY CHAR 41 10 0 SAP-Office key
DEPARTMENT AD_DPRTMNT CHAR 51 40 0 Department
FUNCTION AD_FNCTN CHAR 91 40 0 Function
BUILDING AD_BLDNG_P CHAR 131 10 0 Building (number or code)
FLOOR AD_FLOOR CHAR 141 10 0 Floor in building
ROOMNUMBER AD_ROOMNUM CHAR 151 10 0 Room or Appartment Number
ID_CODE AD_ID_CODE CHAR 161 10 0 Short name for correspondence
IH_MAIL AD_IH_MAIL CHAR 171 10 0 Int. mail postal code
SORT1 AD_SORTOLD CHAR 181 20 0 (Not Supported) Search Term
SORT2 AD_SORTOLD CHAR 201 20 0 (Not Supported) Search Term
SORT_PHN AD_SRTPHN CHAR 221 20 0 (Not Supported) Phonetic Search Sort Field
ALT_COMPNY AD_ALTCMPY CHAR 241 10 0 Business address number, if different (not used)
DEFLT_COMM AD_COMM CHAR 251 3 0 Communication Method (Key) (Business Address Services)
TEL_NUMBER AD_TLNMBR1 CHAR 254 30 0 First telephone no.: dialling code+number
TEL_EXTENS AD_TLXTNS1 CHAR 284 10 0 First Telephone No.: Extension
FAX_NUMBER AD_FXNMBR1 CHAR 294 30 0 First fax no.: dialling code+number
FAX_EXTENS AD_FXXTNS1 CHAR 324 10 0 First fax no.: extension
FLAGCOMM2 AD_FLGCM02 CHAR 334 1 0 Flag: Telephone number(s) maintained
FLAGCOMM3 AD_FLGCM03 CHAR 335 1 0 Flag: Fax number(s) maintained
FLAGCOMM4 AD_FLGCM04 CHAR 336 1 0 Flag: Teletex number(s) maintained
FLAGCOMM5 AD_FLGCM05 CHAR 337 1 0 Flag: Telex number(s) maintained
FLAGCOMM6 AD_FLGCM06 CHAR 338 1 0 Indicator: E-Mail Address(es) Maintained
FLAGCOMM7 AD_FLGCM07 CHAR 339 1 0 Flag: RML (remote mail) addresse(s) maintained
FLAGCOMM8 AD_FLGCM08 CHAR 340 1 0 Flag: X.400 addresse(s) maintained
FLAGCOMM9 AD_FLGCM09 CHAR 341 1 0 Flag: RFC destination(s) maintained
FLAGCOMM10 AD_FLGCM10 CHAR 342 1 0 Flag: Printer maintained
FLAGCOMM11 AD_FLGCM11 CHAR 343 1 0 Flag: SSF maintained
FLAGCOMM12 AD_FLGCM12 CHAR 344 1 0 Flag: URI/FTP address maintained
FLAGCOMM13 AD_FLGCM13 CHAR 345 1 0 Flag: Pager address maintained

893900Report for inconsistencies b/w BUT000 & relationships
856819AM-891 when you delete a contact person relationship
1003051TDMS 3.0 corrections - Composite SAP Note
836353Correction Report for inconsistencies in BUT052/ADCP tables
842768Partner cannot be deleted due to relationship address
918871Problems in R/3 inbox due to "Mobile only" contact fields
536414CRM 3.0/3.1 SAP Composite Note: Middleware reorganization
847705AM-885 Relationship address cannot be assigned -2-
846390AM-885 Relationship address cannot be assigned
384462Master data and addresses
525673 Indexes on address tables
450322Indexes in the tables of the Business Address Services
166833IS-U/CCS: Notes on inst. & prod. system operation