The CDBD_ADCP table in SAP ERP or S/4HANA stores Person/Address assignment (central address administration) data. There are total 44 fields in CDBD_ADCP table. The Person/Address assignment (central address administration) table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of CDBD_ADCP table. It is in CRM Order: CDB Objects for General Sales Order Processing (CDB_ORDER) ABAP package and is part of the Business Transactions (CRM-BTX) module.
SAP CDBD_ADCP Table Fields
Following is the list of fields that are available in SAP CDBD_ADCP table. The primary key fields of Person/Address assignment (central address administration) table in SAP are CLIENT (Client), ADCP_GUID (Guid for ADCP ( address table )).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| CLIENT | Client | MANDT | T000 | CLNT (3) |
| ADCP_GUID | Guid for ADCP ( address table ) | CDBT_ADCP_GUID | RAW (16) | |
| ADR_GUID | Guid for ADR(Address table) | CDBT_ADR_GUID | RAW (16) | |
| ADDRNUMBER | Address Number | AD_ADDRNUM | ADRC | CHAR (10) |
| PERSNUMBER | Person Number | AD_PERSNUM | ADRP | CHAR (10) |
| DATE_FROM | Valid-from date – in current Release only 00010101 possible | AD_DATE_FR | DATS (8) | |
| NATION | Version ID for International Addresses | AD_NATION | TSADV | CHAR (1) |
| DATE_TO | Valid-to date in current Release only 99991231 possible | AD_DATE_TO | DATS (8) | |
| COMP_PERS | Flag: Person in company (C) or private (P) address | AD_CMP_PRS | CHAR (1) | |
| SO_KEY | SAP-Office key | AD_SO_KEY | CHAR (10) | |
| DEPARTMENT | Department | AD_DPRTMNT | CHAR (40) | |
| FUNCTION | Function | AD_FNCTN | CHAR (40) | |
| BUILDING | Building (number or code) | AD_BLDNG_P | CHAR (10) | |
| FLOOR | Floor in building | AD_FLOOR | CHAR (10) | |
| ROOMNUMBER | Room or Apartment Number | AD_ROOMNUM | CHAR (10) | |
| ID_CODE | Short name for correspondence | AD_ID_CODE | CHAR (10) | |
| IH_MAIL | Internal Mail Postal Code | AD_IH_MAIL | CHAR (10) | |
| SORT1 | Search Term 1 | AD_SORT1 | CHAR (20) | |
| SORT2 | Search Term 2 | AD_SORT2 | CHAR (20) | |
| SORT_PHN | (Not Supported) Phonetic Search Sort Field | AD_SRTPHN | CHAR (20) | |
| ALT_COMPNY | Business address number, if different (not used) | AD_ALTCMPY | ADRC | CHAR (10) |
| DEFLT_COMM | Communication Method (Key) (Business Address Services) | AD_COMM | TSAC | CHAR (3) |
| TEL_NUMBER | First telephone no.: dialling code+number | AD_TLNMBR1 | CHAR (30) | |
| TEL_EXTENS | First Telephone No.: Extension | AD_TLXTNS1 | CHAR (10) | |
| FAX_NUMBER | First Fax No.: Area Code + Number | AD_FXNMBR1 | CHAR (30) | |
| FAX_EXTENS | First fax no.: extension | AD_FXXTNS1 | CHAR (10) | |
| FLAGCOMM2 | Flag: Telephone number(s) defined | AD_FLGCM02 | CHAR (1) | |
| FLAGCOMM3 | Flag: Fax number(s) defined | AD_FLGCM03 | CHAR (1) | |
| FLAGCOMM4 | Flag: Teletex number(s) defined | AD_FLGCM04 | CHAR (1) | |
| FLAGCOMM5 | Flag: Telex number(s) defined | AD_FLGCM05 | CHAR (1) | |
| FLAGCOMM6 | Flag: E-mail address(es) defined | AD_FLGCM06 | CHAR (1) | |
| FLAGCOMM7 | Flag: RML (remote mail) addresse(s) defined | AD_FLGCM07 | CHAR (1) | |
| FLAGCOMM8 | Flag: X.400 addresse(s) defined | AD_FLGCM08 | CHAR (1) | |
| FLAGCOMM9 | Flag: RFC destination(s) defined | AD_FLGCM09 | CHAR (1) | |
| FLAGCOMM10 | Flag: Printer defined | AD_FLGCM10 | CHAR (1) | |
| FLAGCOMM11 | Flag: SSF defined | AD_FLGCM11 | CHAR (1) | |
| FLAGCOMM12 | Flag: URI/FTP address defined | AD_FLGCM12 | CHAR (1) | |
| FLAGCOMM13 | Flag: Pager address defined | AD_FLGCM13 | CHAR (1) | |
| TR_USER | Character field, length 32 | CHAR32 | CHAR (32) | |
| TR_ID | Character field, length 32 | CHAR32 | CHAR (32) | |
| TR_STATUS | Undefined range (can be used for patch levels) | CHAR4 | CHAR (4) | |
| TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC (15) | |
| DELETED | Single-Character Flag | CHAR1 | CHAR (1) | |
| TR_ROOTID | Character field, length 32 | CHAR32 | CHAR (32) |
