SAP Table ADCPS - Shadow Table: Assignment Person/Addr. (Bus. Addr. Services)

Field Key Data Element Type Offset Leng Decimals Check Table Text
CLIENT X MANDT CLNT 0 3 0 T000 Client
TRKORR X TRKORR CHAR 3 20 0 Request/Task
ADDRNUMBER X AD_ADDRNUM CHAR 23 10 0 Address number
PERSNUMBER X AD_PERSNUM CHAR 33 10 0 ADRP Person number
DATE_FROM X AD_DATE_FR DATS 43 8 0 Valid-from date - in current Release only 00010101 possible
NATION X AD_NATION CHAR 51 1 0 TSADV International address version ID
DATE_TO AD_DATE_TO DATS 52 8 0 Valid-to date in current Release only 99991231 possible
COMP_PERS AD_CMP_PRS CHAR 60 1 0 Flag: Person in company (C) or private (P) address
SO_KEY AD_SO_KEY CHAR 61 10 0 SAP-Office key
DEPARTMENT AD_DPRTMNT CHAR 71 40 0 Department
FUNCTION AD_FNCTN CHAR 111 40 0 Function
BUILDING AD_BLDNG_P CHAR 151 10 0 Building (number or code)
FLOOR AD_FLOOR CHAR 161 10 0 Floor in building
ROOMNUMBER AD_ROOMNUM CHAR 171 10 0 Room or Appartment Number
ID_CODE AD_ID_CODE CHAR 181 10 0 Short name for correspondence
IH_MAIL AD_IH_MAIL CHAR 191 10 0 Int. mail postal code
SORT1 AD_SORTOLD CHAR 201 20 0 (Not Supported) Search Term
SORT2 AD_SORTOLD CHAR 221 20 0 (Not Supported) Search Term
SORT_PHN AD_SRTPHN CHAR 241 20 0 (Not Supported) Phonetic Search Sort Field
ALT_COMPNY AD_ALTCMPY CHAR 261 10 0 Business address number, if different (not used)
DEFLT_COMM AD_COMM CHAR 271 3 0 Communication Method (Key) (Business Address Services)
TEL_NUMBER AD_TLNMBR1 CHAR 274 30 0 First telephone no.: dialling code+number
TEL_EXTENS AD_TLXTNS1 CHAR 304 10 0 First Telephone No.: Extension
FAX_NUMBER AD_FXNMBR1 CHAR 314 30 0 First fax no.: dialling code+number
FAX_EXTENS AD_FXXTNS1 CHAR 344 10 0 First fax no.: extension
FLAGCOMM2 AD_FLGCM02 CHAR 354 1 0 Flag: Telephone number(s) maintained
FLAGCOMM3 AD_FLGCM03 CHAR 355 1 0 Flag: Fax number(s) maintained
FLAGCOMM4 AD_FLGCM04 CHAR 356 1 0 Flag: Teletex number(s) maintained
FLAGCOMM5 AD_FLGCM05 CHAR 357 1 0 Flag: Telex number(s) maintained
FLAGCOMM6 AD_FLGCM06 CHAR 358 1 0 Indicator: E-Mail Address(es) Maintained
FLAGCOMM7 AD_FLGCM07 CHAR 359 1 0 Flag: RML (remote mail) addresse(s) maintained
FLAGCOMM8 AD_FLGCM08 CHAR 360 1 0 Flag: X.400 addresse(s) maintained
FLAGCOMM9 AD_FLGCM09 CHAR 361 1 0 Flag: RFC destination(s) maintained
FLAGCOMM10 AD_FLGCM10 CHAR 362 1 0 Flag: Printer maintained
FLAGCOMM11 AD_FLGCM11 CHAR 363 1 0 Flag: SSF maintained
FLAGCOMM12 AD_FLGCM12 CHAR 364 1 0 Flag: URI/FTP address maintained
FLAGCOMM13 AD_FLGCM13 CHAR 365 1 0 Flag: Pager address maintained