SAP Table ADRVP
Person Where-Used List (Business Address Services)
ADRVP (Person 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 ADRVP to other SAP tables.
ADRVP table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CLIENT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||
| PERSNUMBER | Person number | AD_PERSNUM | ADRP | 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 personal reference logical field name | AD_APPLFDP | CHAR | 10 | 0 | |||||||
| APPL_KEY | Application table key (incl. client) | AD_APPLKEY | CHAR | 120 | 0 | |||||||
| PERS_ADDR | Flag: Personal address used for person | AD_REFPERS | CHAR | 1 | 0 |
Possible values
|
||||||
| PERS_GROUP | Person Group (Key) (Business Address Services) | AD_GROUP_P | TSAD8 | CHAR | 4 | 0 | ||||||
| ADDRNUMBER | Address number to which the person reference relates | AD_ADDRREF | ADRC | CHAR | 10 | 0 | ||||||
| OWNER | Flag: Adress owner object reference | AD_OWNER | CHAR | 1 | 0 |
Possible values
|
||||||
ADRVP foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| ADRVP | ADDRNUMBER | ADRVP | CLIENT | ADRC | Addresses (Business Address Services) | CLIENT |
| ADRVP | ADDRNUMBER | ADRVP | ADDRNUMBER | ADRC | Addresses (Business Address Services) | ADDRNUMBER |
| ADRVP | ADDRNUMBER | * | ADRC | Addresses (Business Address Services) | DATE_FROM | |
| ADRVP | ADDRNUMBER | * | ADRC | Addresses (Business Address Services) | NATION | |
| ADRVP | CLIENT | ADRVP | CLIENT | T000 | Clients | MANDT |
| ADRVP | PERSNUMBER | ADRVP | CLIENT | ADRP | Persons (Business Address Services) | CLIENT |
| ADRVP | PERSNUMBER | ADRVP | PERSNUMBER | ADRP | Persons (Business Address Services) | PERSNUMBER |
| ADRVP | PERSNUMBER | * | ADRP | Persons (Business Address Services) | DATE_FROM | |
| ADRVP | PERSNUMBER | * | ADRP | Persons (Business Address Services) | NATION | |
| ADRVP | PERS_GROUP | ADRVP | PERS_GROUP | TSAD8 | Groups of Persons (Business Address Services) | PERS_GROUP |
