SAP Table ADRT
Communication Data Text (Business Address Services)
ADRT (Communication Data Text (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 ADRT to other SAP tables.
ADRT 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 | ||
| COMM_TYPE | Communication Method (Key) (Business Address Services) | AD_COMM | TSAC | CHAR | 3 | 0 | ||
| DATE_FROM | Valid-from date - in current Release only 00010101 possible | AD_DATE_FR | DATS | 8 | 0 | |||
| CONSNUMBER | Sequence Number | AD_CONSNUM | NUMC | 3 | 0 | |||
| LANGU | Language Key | SPRAS | T002 | LANG | 1 | 0 | ||
| REMARK | Communication link notes | AD_REMARK2 | CHAR | 50 | 0 | |||
ADRT foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| ADRT | ADDRNUMBER | * | ADRC | Addresses (Business Address Services) | DATE_FROM | |
| ADRT | ADDRNUMBER | * | ADRC | Addresses (Business Address Services) | NATION | |
| ADRT | ADDRNUMBER | ADRT | CLIENT | ADRC | Addresses (Business Address Services) | CLIENT |
| ADRT | ADDRNUMBER | ADRT | ADDRNUMBER | ADRC | Addresses (Business Address Services) | ADDRNUMBER |
| ADRT | CLIENT | ADRT | CLIENT | T000 | Clients | MANDT |
| ADRT | COMM_TYPE | ADRT | COMM_TYPE | TSAC | Communication Methods (Business Address Services) | COMM_TYPE |
| ADRT | LANGU | ADRT | LANGU | T002 | Language Keys (Component BC-I18) | SPRAS |
| ADRT | PERSNUMBER | * | ADRP | Persons (Business Address Services) | NATION | |
| ADRT | PERSNUMBER | ADRT | CLIENT | ADRP | Persons (Business Address Services) | CLIENT |
| ADRT | PERSNUMBER | ADRT | PERSNUMBER | ADRP | Persons (Business Address Services) | PERSNUMBER |
| ADRT | PERSNUMBER | * | ADRP | Persons (Business Address Services) | DATE_FROM | |
