The ADRT table in SAP ERP or S/4HANA stores Communication Data Text (Business Address Services) data. There are total 9 fields in ADRT table. The Communication Data Text (Business Address Services) 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 ADRT table. It is in SAP Technology – Business Services: Address Management (SZAD) ABAP package and is part of the Address Management/Business Address (BC-SRV-ADR) module.
SAP ADRT Table Fields
Following is the list of fields that are available in SAP ADRT table. The primary key fields of the table are CLIENT (Client), ADDRNUMBER (Address Number), PERSNUMBER (Person Number), COMM_TYPE (Communication Method (Key) (Business Address Services)), DATE_FROM (Valid-from date – in current Release only 00010101 possible), CONSNUMBER (Sequence Number), LANGU (Language Key).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| CLIENT | Client | MANDT | T000 | CLNT (3) |
| 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) | |
| _DATAAGING | Data Filter Value for Data Aging | DATA_TEMPERATURE | DATS (8) |
