SAP Table ADCP
Person/Address Assignment (Business Address Services)
ADCP (Person/Address Assignment (Business Address Services)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link ADCP to other SAP tables.
ADCP table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CLIENT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||
| ADDRNUMBER | Address number | AD_ADDRNUM | ADRC | CHAR | 10 | 0 | ||||||||
| PERSNUMBER | Person number | AD_PERSNUM | ADRP | CHAR | 10 | 0 | ||||||||
| DATE_FROM | Valid-from date - in current Release only 00010101 possible | AD_DATE_FR | DATS | 8 | 0 | |||||||||
| NATION | Version ID for International Addresses | AD_NATION | TSADV | CHAR | 1 | 0 | ||||||||
| DATE_TO | Valid-to date in current Release only 99991231 possible | AD_DATE_TO | DATS | 8 | 0 | |||||||||
| COMP_PERS | Flag: Person in company (C) or private (P) address | AD_CMP_PRS | CHAR | 1 | 0 |
Possible values
|
||||||||
| SO_KEY | SAP-Office key | AD_SO_KEY | CHAR | 10 | 0 | |||||||||
| DEPARTMENT | Department | AD_DPRTMNT | CHAR | 40 | 0 | |||||||||
| FUNCTION | Function | AD_FNCTN | CHAR | 40 | 0 | |||||||||
| BUILDING | Building (number or code) | AD_BLDNG_P | CHAR | 10 | 0 | |||||||||
| FLOOR | Floor in building | AD_FLOOR | CHAR | 10 | 0 | |||||||||
| ROOMNUMBER | Room or Appartment Number | AD_ROOMNUM | CHAR | 10 | 0 | |||||||||
| ID_CODE | Short name for correspondence | AD_ID_CODE | CHAR | 10 | 0 | |||||||||
| IH_MAIL | Int. mail postal code | AD_IH_MAIL | CHAR | 10 | 0 | |||||||||
| SORT1 | (Not Supported) Search Term | AD_SORTOLD | CHAR | 20 | 0 | |||||||||
| SORT2 | (Not Supported) Search Term | AD_SORTOLD | CHAR | 20 | 0 | |||||||||
| SORT_PHN | (Not Supported) Phonetic Search Sort Field | AD_SRTPHN | CHAR | 20 | 0 | |||||||||
| ALT_COMPNY | Business address number, if different (not used) | AD_ALTCMPY | ADRC | CHAR | 10 | 0 | ||||||||
| DEFLT_COMM | Communication Method (Key) (Business Address Services) | AD_COMM | TSAC | CHAR | 3 | 0 | ||||||||
| TEL_NUMBER | First telephone no.: dialling code+number | AD_TLNMBR1 | CHAR | 30 | 0 | |||||||||
| TEL_EXTENS | First Telephone No.: Extension | AD_TLXTNS1 | CHAR | 10 | 0 | |||||||||
| FAX_NUMBER | First fax no.: dialling code+number | AD_FXNMBR1 | CHAR | 30 | 0 | |||||||||
| FAX_EXTENS | First fax no.: extension | AD_FXXTNS1 | CHAR | 10 | 0 | |||||||||
| FLAGCOMM2 | Flag: Telephone number(s) maintained | AD_FLGCM02 | CHAR | 1 | 0 |
Possible values
|
||||||||
| FLAGCOMM3 | Flag: Fax number(s) maintained | AD_FLGCM03 | CHAR | 1 | 0 |
Possible values
|
||||||||
| FLAGCOMM4 | Flag: Teletex number(s) maintained | AD_FLGCM04 | CHAR | 1 | 0 |
Possible values
|
||||||||
| FLAGCOMM5 | Flag: Telex number(s) maintained | AD_FLGCM05 | CHAR | 1 | 0 |
Possible values
|
||||||||
| FLAGCOMM6 | Indicator: E-Mail Address(es) Maintained | AD_FLGCM06 | CHAR | 1 | 0 |
Possible values
|
||||||||
| FLAGCOMM7 | Flag: RML (remote mail) addresse(s) maintained | AD_FLGCM07 | CHAR | 1 | 0 |
Possible values
|
||||||||
| FLAGCOMM8 | Flag: X.400 addresse(s) maintained | AD_FLGCM08 | CHAR | 1 | 0 |
Possible values
|
||||||||
| FLAGCOMM9 | Flag: RFC destination(s) maintained | AD_FLGCM09 | CHAR | 1 | 0 |
Possible values
|
||||||||
| FLAGCOMM10 | Flag: Printer maintained | AD_FLGCM10 | CHAR | 1 | 0 |
Possible values
|
||||||||
| FLAGCOMM11 | Flag: SSF maintained | AD_FLGCM11 | CHAR | 1 | 0 |
Possible values
|
||||||||
| FLAGCOMM12 | Flag: URI/FTP address maintained | AD_FLGCM12 | CHAR | 1 | 0 |
Possible values
|
||||||||
| FLAGCOMM13 | Flag: Pager address maintained | AD_FLGCM13 | CHAR | 1 | 0 |
Possible values
|
||||||||
| ADCP_UUID | UUID Used in the Address | AD_UUID | RAW | 16 | 0 | |||||||||
| UUID_BELATED | Indicator: UUID was generated later | AD_UUID_BELATED | CHAR | 1 | 0 |
Possible values
|
||||||||
| ID_CATEGORY | Category of an Address ID | AD_ID_CATEGORY | CHAR | 1 | 0 |
Possible values
|
||||||||
| ADCP_ERR_STATUS | Error Status of Address | AD_ERR_STATUS | CHAR | 1 | 0 |
Possible values
|
||||||||
ADCP foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| ADCP | ADDRNUMBER | ADCP | NATION | ADRC | Addresses (Business Address Services) | NATION |
| ADCP | ADDRNUMBER | ADCP | CLIENT | ADRC | Addresses (Business Address Services) | CLIENT |
| ADCP | ADDRNUMBER | ADCP | ADDRNUMBER | ADRC | Addresses (Business Address Services) | ADDRNUMBER |
| ADCP | ADDRNUMBER | * | ADRC | Addresses (Business Address Services) | DATE_FROM | |
| ADCP | ALT_COMPNY | ADCP | CLIENT | ADRC | Addresses (Business Address Services) | CLIENT |
| ADCP | ALT_COMPNY | ADCP | ALT_COMPNY | ADRC | Addresses (Business Address Services) | ADDRNUMBER |
| ADCP | ALT_COMPNY | * | ADRC | Addresses (Business Address Services) | DATE_FROM | |
| ADCP | ALT_COMPNY | * | ADRC | Addresses (Business Address Services) | NATION | |
| ADCP | CLIENT | ADCP | CLIENT | T000 | Clients | MANDT |
| ADCP | DEFLT_COMM | ADCP | DEFLT_COMM | TSAC | Communication Methods (Business Address Services) | COMM_TYPE |
| ADCP | NATION | ADCP | NATION | TSADV | International versions of addresses | NATION |
| ADCP | PERSNUMBER | ADCP | CLIENT | ADRP | Persons (Business Address Services) | CLIENT |
| ADCP | PERSNUMBER | ADCP | PERSNUMBER | ADRP | Persons (Business Address Services) | PERSNUMBER |
| ADCP | PERSNUMBER | * | ADRP | Persons (Business Address Services) | DATE_FROM | |
| ADCP | PERSNUMBER | ADCP | NATION | ADRP | Persons (Business Address Services) | NATION |
