Tuesday, August 7, 2012

PA Transperant tables



 Each PAnnnn infotype table and the client (MANDT field) is defined in the ABAP Dictionary using the following three include structures:
Ÿ PAKEY:
Contains the infotype table key fields
Ÿ PSHD1:
Contains administrative information on the infotype record (amongst other things, the date the last change was made and the name of the user who made the change)
Ÿ PSnnnn:
Contains the infotype-specific fields that hold the infotype's actual information and data


n The PAKEY structure contains an infotype's primary key. It is the same for all Personnel Administration infotypes and is made up of the following key fields:
    PERNR: In a client, the personnel number is the only unique key that identifies an employee. It can be used to display and maintain master data and working time data (infotypes) for an employee.
SUBTY: Subtypes are subdivisions of infotypes. The subtypes of an infotype may have different time constraints and create their own history.
OBJPS: The object identification indicator is used to differentiate records with the same infotype, subtype, lock indicator, valid from date, and valid to date. For example: Child number in infotype 0021 Family Member/Dependents. SPRPS: The lock indicator for HR master data can be used to lock and unlock data records. It can be used to guarantee double control, that is, at least two users are involved in writing an active data record to the database. One of the users creates a locked infotype record. Another user unlocks this record by activating it.
ENDDA: Valid to date
BEGDA: Valid from date
SEQNR: The sequential number differentiates infotype records with the same key and the time constraint '3'. Unlike the personnel object identification, it is automatically assigned by the system.
n Each Personnel Administration infotype contains an include CI_Pnnnn in the data structure PSnnnn. Customer-specific fields can be added to this include as enhancements to an infotype. In the standard SAP system, the include CI_Pnnnn is empty.

No comments:

Post a Comment

About Me

ABAP HR Consultants with 5 years of vast experience