Transparent database tablesthat store the data records for the
infotype
nnnn
.
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 .
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 |
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
.
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.