ADRU is a standard SAP table in SAP ECC (or) S/4HANA which stores Table for Communication Usages data. There are total 11 fields in ADRU table.This blog post provides key technical details of SAP table ADRU, including its availability across SAP S/4HANA versions and the list of CDS views for ADRU table in SAP.
| SAP HANA Table Type | Column Store |
|---|---|
| Buffering Permission | Buffering not allowed |
| Buffering Type | No buffering |
| Package | SAP Technology – Business Services: Address Management (SZAD) |
| Technical Component | Address Management/Business Address (BC-SRV-ADR) |
SAP ADRU Table Fields
The following is the list of fields that are available in SAP ADRU table. The key fields of the table are highlighted in color.
| Field | Description | Data Element | Domain | Check Table | Data Type |
|---|---|---|---|---|---|
| CLIENT | Client | MANDT | MANDT | CLNT (3) | |
| ADDRNUMBER | Address Number | AD_ADDRNUM | AD_ADDRNUM | CHAR (10) | |
| PERSNUMBER | Person Number | AD_PERSNUM | AD_PERSNUM | CHAR (10) | |
| COMM_TYPE | Communication Method (Key) (Business Address Services) | AD_COMM | AD_COMM | CHAR (3) | |
| CONSNUMBER | Sequence Number | AD_CONSNUM | NUMC3 | NUMC (3) | |
| COMM_USAGE | Communication Usage: Key Field | AD_CUSAGE | AD_CUSAGE | CHAR (10) | |
| VALID_TO | Communication Data: Valid To (YYYYMMDDHHMMSS) | AD_VALTO | TIMESTAMP | CHAR (14) | |
| VALID_FROM | Communication Data: Valid From (YYYYMMDDHHMMSS) | AD_VALFROM | TIMESTMP | CHAR (14) | |
| DEF_USAGE | Indicator: Default for this Usage | AD_CDEFUSE | XFELD | CHAR (1) | |
| ADRU_UUID | UUID Used in the Address | AD_UUID | SYSUUID | RAW (16) | |
| _DATAAGING | Data Filter Value for Data Aging | DATA_TEMPERATURE | DATA_TEMPERATURE | DATS (8) |
Availability
The SAP table ADRU is available within SAP S/4HANA On-premise and SAP S/4HANA Cloud systems depending on the version and release level.
| SAP S/4HANA Version | Available? |
|---|---|
| 1909 | Yes |
| 2020 | Yes |
| 2021 | Yes |
| 2022 | Yes |
| 2023 | Yes |
CDS Views for ADRU table
There are no CDS views available in the system. We’re updating the content all the time, so check back regularly.
