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.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.