SAP table ADRV (Address Where-Used List (Business Address Services))
SAP table ADRV has 3 primary key fields being CLIENT,ADDRNUMBER,CONSNUMBER.
| 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 | |
| CONSNUMBER | Where-used list serial number | NUMC | 10 | 0 | AD_REFNUM | ||
| APPL_TABLE | Application table logical name (address management) | CHAR | 10 | 0 | AD_APPLTAB | ||
| APPL_FIELD | Application table address where-used list logical field name | CHAR | 10 | 0 | AD_APPLFLD | ||
| APPL_KEY | Application table key (incl. client) | CHAR | 120 | 0 | AD_APPLKEY | ||
| ADDR_GROUP | Address Group (Key) (Business Address Services) | CHAR | 4 | 0 | TSAD7 | AD_GROUP | |
| OWNER | Flag: Reference of Owner Object of Address | CHAR | 1 | 0 | AD_OWNER | ||
| _DATAAGING | Data Filter Value for Data Aging | DATS | 8 | 0 | DATA_TEMPERATURE |
ADRV foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 ADRV | ADDRNUMBER | ADRC | Addresses (Business Address Services) | DATE_FROM |
| 0 ADRV | ADDRNUMBER | ADRC | Addresses (Business Address Services) | NATION |
| 1 ADRV | ADDR_GROUP | TSAD7 | Address Groups (Business Address Services) | ADDR_GROUP |
| 0 ADRV | CLIENT | T000 | Clients | MANDT |