Structure of the Where-Used List

The where-used list for an address (structure ADDR_REF) or a person (structure PERS_REF) consists of the following fields:

Field name in structure ADDR_REF

Field name in structure PERS_REF

Description

APPL_TABLE

APPL_TABLE

Name of the application table

APPL_FIELD

APPL_FIELD

Name of the field in the application table that stores the address/person number

APPL_KEY

APPL_KEY

Key of the application table (including the client)

ADDR_GROUP

PERS_GROUP

Address/Person group

OWNER

OWNER

Indicates whether the application object specified with APPL_TABLE, APPL_FIELD and APPL_KEY is the owner object for this address or person (see: Designated Application Objects).

 

PERS_ADDR

Specifies if the person is used for a personal address (PERS_ADDR = 'X') or for a workplace address (PERS_ADDR = SPACE).

ADDRNUMBER

If PERS_ADDR = SPACE has been set, you must enter the address number of the company address (address type 1) in this field.

You can find more information on how to fill the where-used list in the documentation on parameter ADDRESS_REFERENCE (PERSON_REFERENCE for where-used lists for persons) of function module <object>_NUMBER_GET (see also the function module overview in Working with the BAS).

Integration

The BAS store the where-used list for addresses in table ADRV, and the where-used list for persons in table ADRVP. Depending on whether address data is stored in ADRC or ADRP (see BAS Tables), the following where-used lists must be created:

Where-used lists to be saved according to address type

Address type

Where-used list for person (ADRVP)

Where-used list for address (ADRV)

Company address (1)

 

X

Personal address (2)

X

X

Workplace address (3)

X

(X)*

(X)*: If you link a new workplace address to an existing company address, you do not need to create a where-used list for this address since the reference to the person makes it implicitly clear where the address is used. If the company address does not exist, you have to create it first, specifying a where-used list.