SAP table ADRT (Communication Data Text (Business Address Services))
SAP table ADRT has 7 primary key fields being CLIENT,ADDRNUMBER,PERSNUMBER,COMM_TYPE,DATE_FROM,CONSNUMBER,LANGU.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| CLIENT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| ADDRNUMBER | Address Number | CHAR | 10 | 0 | ADRC | AD_ADDRNUM | |
| PERSNUMBER | Person Number | CHAR | 10 | 0 | ADRP | AD_PERSNUM | |
| COMM_TYPE | Communication Method (Key) (Business Address Services) | CHAR | 3 | 0 | TSAC | AD_COMM | |
| DATE_FROM | Valid-from date - in current Release only 00010101 possible | DATS | 8 | 0 | AD_DATE_FR | ||
| CONSNUMBER | Sequence Number | NUMC | 3 | 0 | AD_CONSNUM | ||
| LANGU | Language Key | LANG | 1 | 0 | T002 | SPRAS | |
| REMARK | Communication link notes | CHAR | 50 | 0 | AD_REMARK2 | ||
| _DATAAGING | Data Filter Value for Data Aging | DATS | 8 | 0 | DATA_TEMPERATURE |
ADRT foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 ADRT | ADDRNUMBER | ADRC | Addresses (Business Address Services) | DATE_FROM |
| 0 ADRT | ADDRNUMBER | ADRC | Addresses (Business Address Services) | NATION |
| 1 ADRT | CLIENT | T000 | Clients | MANDT |
| 0 ADRT | COMM_TYPE | TSAC | Communication Methods (Business Address Services) | COMM_TYPE |
| 1 ADRT | PERSNUMBER | ADRP | Persons (Business Address Services) | PERSNUMBER |
| 1 ADRT | PERSNUMBER | ADRP | Persons (Business Address Services) | DATE_FROM |
| 1 ADRT | PERSNUMBER | ADRP | Persons (Business Address Services) | NATION |