Structure and Task of Tables PAnnnn and PBnnnn

Definition

Transparent database tablesthat store the data records for the infotype nnnn .

Use

Which of the tables you require depends on which area you want to use the infotype in:

  • If you want to use your infotype in Personnel Administration , create table PAnnnn .

  • If you want to use your infotype in Recruitment , create table PBnnnn .

  • If you want to use your infotype in Personnel Administration and Recruitment , create both tables PAnnnn and PBnnnn .

You must also specify which of the database tables you want to use in the Infotypes: Dialog/Database Assignment table (T777D).

For more information, see Infotype Characteristics .

Structure

Table PAnnnn

Field Name

Key

Data Element

Type

Length

Check Table

Short Text

MANDT

X

MANDT

CLNT

3

T000

Client

.INCLUDE

X

PAKEY

.INCLUDE

PSHD1

.INCLUDE

PSnnnn

Table PBnnnn

Field Name

Key

Data Element

Type

Length

Check Table

Short Text

MANDT

X

MANDT

CLNT

3

T000

Client

.INCLUDE

X

PBKEY

.INCLUDE

PSHD1

.INCLUDE

PSnnnn

The definition of the primary key is the only difference between the structure of the two tables. The primary key is determined on the basis of the Client field and substructures PAKEY and PBKEY .

Technical Settings of Database Tables

Database tables are read using the primary index. It is rarely necessary to create secondary indices.

When determining the logical memory parameters, enter the value APPL0 in the Data class field. The value of the size category can vary, depending on how the infotype is used. For this reason, you must estimate the number of expected data records and then specify a suitable size category.

Tables PAnnnn and PBnnnn may not be buffered using the SAP database interface because the application programs must always work with current data. For this reason, you must select the Buffering not allowed checkbox in the Buffering frame.

Infotype data records are buffered in the Personnel Management applications, irrespective of the ABAP Dictionary settings.

You can enter changes to infotype records in the form of change documents using the infotype log creation function in Personnel Management . Report RPUAUD00 enables you to display these documents. It is rarely necessary to log data changes within the ABAP Dictionary.