SAP table ADRVP (Person Where-Used List (Business Address Services))
SAP table ADRVP has 3 primary key fields being CLIENT,PERSNUMBER,CONSNUMBER.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| CLIENT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| PERSNUMBER | Person Number | CHAR | 10 | 0 | ADRP | AD_PERSNUM | |
| 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 personal reference logical field name | CHAR | 10 | 0 | AD_APPLFDP | ||
| APPL_KEY | Application table key (incl. client) | CHAR | 120 | 0 | AD_APPLKEY | ||
| PERS_ADDR | Flag: Personal address used for person | CHAR | 1 | 0 | AD_REFPERS | ||
| PERS_GROUP | Person Group (Key) (Business Address Services) | CHAR | 4 | 0 | TSAD8 | AD_GROUP_P | |
| ADDRNUMBER | Address number to which the person reference relates | CHAR | 10 | 0 | ADRC | AD_ADDRREF | |
| 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 |
ADRVP foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 ADRVP | ADDRNUMBER | ADRC | Addresses (Business Address Services) | DATE_FROM |
| 0 ADRVP | ADDRNUMBER | ADRC | Addresses (Business Address Services) | NATION |
| 1 ADRVP | CLIENT | T000 | Clients | MANDT |
| 0 ADRVP | PERSNUMBER | ADRP | Persons (Business Address Services) | PERSNUMBER |
| 0 ADRVP | PERSNUMBER | ADRP | Persons (Business Address Services) | DATE_FROM |
| 0 ADRVP | PERSNUMBER | ADRP | Persons (Business Address Services) | NATION |
| 1 ADRVP | PERS_GROUP | TSAD8 | Groups of Persons (Business Address Services) | PERS_GROUP |