SAP Table ADRV
Address Where-Used List (Business Address Services)
ADRV (Address Where-Used List (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 ADRV to other SAP tables.
ADRV 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 | ||||||
| CONSNUMBER | Where-used list serial number | AD_REFNUM | NUMC | 10 | 0 | |||||||
| APPL_TABLE | Application table logical name (address management) | AD_APPLTAB | CHAR | 10 | 0 | |||||||
| APPL_FIELD | Application table address where-used list logical field name | AD_APPLFLD | CHAR | 10 | 0 | |||||||
| APPL_KEY | Application table key (incl. client) | AD_APPLKEY | CHAR | 120 | 0 | |||||||
| ADDR_GROUP | Address Group (Key) (Business Address Services) | AD_GROUP | TSAD7 | CHAR | 4 | 0 | ||||||
| OWNER | Flag: Adress owner object reference | AD_OWNER | CHAR | 1 | 0 |
Possible values
|
||||||
ADRV foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| ADRV | ADDRNUMBER | ADRV | CLIENT | ADRC | Addresses (Business Address Services) | CLIENT |
| ADRV | ADDRNUMBER | ADRV | ADDRNUMBER | ADRC | Addresses (Business Address Services) | ADDRNUMBER |
| ADRV | ADDRNUMBER | * | ADRC | Addresses (Business Address Services) | DATE_FROM | |
| ADRV | ADDRNUMBER | * | ADRC | Addresses (Business Address Services) | NATION | |
| ADRV | ADDR_GROUP | ADRV | ADDR_GROUP | TSAD7 | Address Groups (Business Address Services) | ADDR_GROUP |
| ADRV | CLIENT | ADRV | CLIENT | T000 | Clients | MANDT |
