Structure and Task of Tables PAnnnn and PBnnnn 

The data records of infotype nnnn are stored in database tables PAnnnn and PBnnnn. The area in which the infotype is used determines which of the tables you require.

You must also specify the database tables you want to use in the infotype characteristics (table T777D).

The tables have the following 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

 

PS nnnn

       

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

 

PS nnnn

       

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 within the HR applications, irrespective of the Data Dictionary settings.

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