The CDBD_ADRT table in SAP ERP or S/4HANA stores Communication data text (central address administration) data. There are total 16 fields in CDBD_ADRT table. The Communication data text (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_ADRT 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_ADRT Table Fields
Following is the list of fields that are available in SAP CDBD_ADRT table. The primary key fields of Communication data text (central address administration) table in SAP are CLIENT (Client), ADRT_GUID (Guid for ADRt(Address table)).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| CLIENT | Client | MANDT | T000 | CLNT (3) |
| ADRT_GUID | Guid for ADRt(Address table) | CDBT_ADRT_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) |
| COMM_TYPE | Communication Method (Key) (Business Address Services) | AD_COMM | TSAC | CHAR (3) |
| DATE_FROM | Valid-from date – in current Release only 00010101 possible | AD_DATE_FR | DATS (8) | |
| CONSNUMBER | Sequence Number | AD_CONSNUM | NUMC (3) | |
| LANGU | Language Key | SPRAS | T002 | LANG (1) |
| REMARK | Communication link notes | AD_REMARK2 | CHAR (50) | |
| 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) |
