P0147 SAP (HR Master Record: Infotype 0147 (Pers. Appraisals JP)) Structure details

Dictionary Type: Structure
Description: HR Master Record: Infotype 0147 (Pers. Appraisals JP)




ABAP Code to SELECT data from P0147
Related tables to P0147
Access table P0147




Structure field list including key, data, relationships and ABAP select examples

P0147 is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "HR Master Record: Infotype 0147 (Pers. Appraisals JP)" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_P0147 TYPE P0147.

The P0147 table consists of various fields, each holding specific information or linking keys about HR Master Record: Infotype 0147 (Pers. Appraisals JP) data available in SAP. These include PERNR (Personnel Number), INFTY (Infotype), SUBTY (Subtype), OBJPS (Object Identification).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP P0147 structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
PERNRPersonnel Number PERNR_DNUMC8PERNRPER
INFTYInfotype INFTYCHAR4T582AINFOTYPITP
SUBTYSubtype SUBTYCHAR4SUBTYSUB
OBJPSObject Identification OBJPSCHAR2OBJPSOPS
SPRPSLock Indicator for HR Master Data Record SPRPSCHAR1SPRPS
ENDDAEnd Date ENDDADATS8DATUM
BEGDAStart Date BEGDADATS8DATUM
SEQNRNumber of Infotype Record with Same Key SEQNRNUMC3NUM03
AEDTMChanged On AEDATDATS8DATUM
UNAMEName of Person Who Changed Object AENAMCHAR12USNAM
HISTOHistorical Record Flag HISTOCHAR1CHAR1
ITXEXText Exists for Infotype ITXEXCHAR1XFELD
REFEXReference Fields Exist (Primary/Secondary Costs) PRFEXCHAR1XFELD
ORDEXConfirmation Fields Exist ORDEXCHAR1XFELD
ITBLDInfotype Screen Control ITBLDCHAR2CHAR2
PREASReason for Changing Master Data PREASCHAR2T530EPREAS
FLAG1Reserved Field/Unused Field NUSEDCHAR1NUSED
FLAG2Reserved Field/Unused Field NUSEDCHAR1NUSED
FLAG3Reserved Field/Unused Field NUSEDCHAR1NUSED
FLAG4Reserved Field/Unused Field NUSEDCHAR1NUSED
RESE1Reserved Field/Unused Field of Length 2 NUSED2CHAR2NUSED2
RESE2Reserved Field/Unused Field of Length 2 NUSED2CHAR2NUSED2
GRPVLGrouping Value for Personnel Assignments PCCE_GPVALCHAR4PCCE_GPVAL
APPTYPersonal appraisal type JP P22J_APPTYCHAR4Assigned to domainSUBTY_591A
APPIDIndicator for Personal Appraisal JP P22J_APPIDCHAR2CHAR2
EVNM1Name of 1st evaluator P22J_EVNM1CHAR25NACHN
EVDT1Date of 1st appraisal evaluation P22J_EVDT1DATS8DATUM
EVNM2Name of 2nd evaluator P22J_EVNM2CHAR25NACHN
EVDT2Date of 2nd appraisal evaluation P22J_EVDT2DATS8DATUM
EVNMFName of final evaluator P22J_EVNMFCHAR25NACHN
EVDTFDate of final appraisal evaluation P22J_EVDTFDATS8DATUM
PSREGIndicator for automatic payscale regrading P22J_PSREGCHAR1XFELD
DFGRPdifference of pay scale group P22J_DFGRPINT13INT1
PSCHGIndicator for payscale group change P22J_PSCHGCHAR1XFELD
DFLVLDifference of pay scale level P22J_DFLVLINT13INT1
APRT11st Appraisal Rank Criteria P22J_APRT1CHAR3T5J46P22J_APPRK
APPT11st Point value for appraisal criterion P22J_APPT1DEC5(2) DEC3_2
APRT22nd Appraisal Rank Criteria P22J_APRT2CHAR3T5J46P22J_APPRK
APPT22nd Point value for appraisal criterion P22J_APPT2DEC5(2) DEC3_2
APRTFFinal Appraisal Rank Criteria P22J_APRTFCHAR3T5J46P22J_APPRK
APPTFFinal Point value for appraisal criterion P22J_APPTFDEC5(2) DEC3_2
APF0AAppraisals main feature P22J_APPFTCHAR2Assigned to domainP22J_APPFT
APD0AAppraisal Detail Feature P22J_APPDTCHAR2Assigned to domainP22J_APPDT
APR0AAppraisal Rank Criteria P22J_APPRKCHAR3T5J46P22J_APPRK
APP0APoint value for appraisal criterion P22J_APPPTDEC5(2) DEC3_2
APF0BAppraisals main feature P22J_APPFTCHAR2Assigned to domainP22J_APPFT
APD0BAppraisal Detail Feature P22J_APPDTCHAR2Assigned to domainP22J_APPDT
APR0BAppraisal Rank Criteria P22J_APPRKCHAR3T5J46P22J_APPRK
APP0BPoint value for appraisal criterion P22J_APPPTDEC5(2) DEC3_2
APF0CAppraisals main feature P22J_APPFTCHAR2Assigned to domainP22J_APPFT
APD0CAppraisal Detail Feature P22J_APPDTCHAR2Assigned to domainP22J_APPDT
APR0CAppraisal Rank Criteria P22J_APPRKCHAR3T5J46P22J_APPRK
APP0CPoint value for appraisal criterion P22J_APPPTDEC5(2) DEC3_2
APF0DAppraisals main feature P22J_APPFTCHAR2Assigned to domainP22J_APPFT
APD0DAppraisal Detail Feature P22J_APPDTCHAR2Assigned to domainP22J_APPDT
APR0DAppraisal Rank Criteria P22J_APPRKCHAR3T5J46P22J_APPRK
APP0DPoint value for appraisal criterion P22J_APPPTDEC5(2) DEC3_2
APF0EAppraisals main feature P22J_APPFTCHAR2Assigned to domainP22J_APPFT
APD0EAppraisal Detail Feature P22J_APPDTCHAR2Assigned to domainP22J_APPDT
APR0EAppraisal Rank Criteria P22J_APPRKCHAR3T5J46P22J_APPRK
APP0EPoint value for appraisal criterion P22J_APPPTDEC5(2) DEC3_2
APF0FAppraisals main feature P22J_APPFTCHAR2Assigned to domainP22J_APPFT
APD0FAppraisal Detail Feature P22J_APPDTCHAR2Assigned to domainP22J_APPDT
APR0FAppraisal Rank Criteria P22J_APPRKCHAR3T5J46P22J_APPRK
APP0FPoint value for appraisal criterion P22J_APPPTDEC5(2) DEC3_2
APF01Appraisals main feature P22J_APPFTCHAR2Assigned to domainP22J_APPFT
APD01Appraisal Detail Feature P22J_APPDTCHAR2Assigned to domainP22J_APPDT
APR01Appraisal Rank Criteria P22J_APPRKCHAR3T5J46P22J_APPRK
APP01Point value for appraisal criterion P22J_APPPTDEC5(2) DEC3_2
APF02Appraisals main feature P22J_APPFTCHAR2Assigned to domainP22J_APPFT
APD02Appraisal Detail Feature P22J_APPDTCHAR2Assigned to domainP22J_APPDT
APR02Appraisal Rank Criteria P22J_APPRKCHAR3T5J46P22J_APPRK
APP02Point value for appraisal criterion P22J_APPPTDEC5(2) DEC3_2
APF03Appraisals main feature P22J_APPFTCHAR2Assigned to domainP22J_APPFT
APD03Appraisal Detail Feature P22J_APPDTCHAR2Assigned to domainP22J_APPDT
APR03Appraisal Rank Criteria P22J_APPRKCHAR3T5J46P22J_APPRK
APP03Point value for appraisal criterion P22J_APPPTDEC5(2) DEC3_2
APF04Appraisals main feature P22J_APPFTCHAR2Assigned to domainP22J_APPFT
APD04Appraisal Detail Feature P22J_APPDTCHAR2Assigned to domainP22J_APPDT
APR04Appraisal Rank Criteria P22J_APPRKCHAR3T5J46P22J_APPRK
APP04Point value for appraisal criterion P22J_APPPTDEC5(2) DEC3_2
APF05Appraisals main feature P22J_APPFTCHAR2Assigned to domainP22J_APPFT
APD05Appraisal Detail Feature P22J_APPDTCHAR2Assigned to domainP22J_APPDT
APR05Appraisal Rank Criteria P22J_APPRKCHAR3T5J46P22J_APPRK
APP05Point value for appraisal criterion P22J_APPPTDEC5(2) DEC3_2
APF06Appraisals main feature P22J_APPFTCHAR2Assigned to domainP22J_APPFT
APD06Appraisal Detail Feature P22J_APPDTCHAR2Assigned to domainP22J_APPDT
APR06Appraisal Rank Criteria P22J_APPRKCHAR3T5J46P22J_APPRK
APP06Point value for appraisal criterion P22J_APPPTDEC5(2) DEC3_2
APF07Appraisals main feature P22J_APPFTCHAR2Assigned to domainP22J_APPFT
APD07Appraisal Detail Feature P22J_APPDTCHAR2Assigned to domainP22J_APPDT
APR07Appraisal Rank Criteria P22J_APPRKCHAR3T5J46P22J_APPRK
APP07Point value for appraisal criterion P22J_APPPTDEC5(2) DEC3_2
APF08Appraisals main feature P22J_APPFTCHAR2Assigned to domainP22J_APPFT
APD08Appraisal Detail Feature P22J_APPDTCHAR2Assigned to domainP22J_APPDT
APR08Appraisal Rank Criteria P22J_APPRKCHAR3T5J46P22J_APPRK
APP08Point value for appraisal criterion P22J_APPPTDEC5(2) DEC3_2
APF09Appraisals main feature P22J_APPFTCHAR2Assigned to domainP22J_APPFT
APD09Appraisal Detail Feature P22J_APPDTCHAR2Assigned to domainP22J_APPDT
APR09Appraisal Rank Criteria P22J_APPRKCHAR3T5J46P22J_APPRK
APP09Point value for appraisal criterion P22J_APPPTDEC5(2) DEC3_2
APF10Appraisals main feature P22J_APPFTCHAR2Assigned to domainP22J_APPFT
APD10Appraisal Detail Feature P22J_APPDTCHAR2Assigned to domainP22J_APPDT
APR10Appraisal Rank Criteria P22J_APPRKCHAR3T5J46P22J_APPRK
APP10Point value for appraisal criterion P22J_APPPTDEC5(2) DEC3_2
APF11Appraisals main feature P22J_APPFTCHAR2Assigned to domainP22J_APPFT
APD11Appraisal Detail Feature P22J_APPDTCHAR2Assigned to domainP22J_APPDT
APR11Appraisal Rank Criteria P22J_APPRKCHAR3T5J46P22J_APPRK
APP11Point value for appraisal criterion P22J_APPPTDEC5(2) DEC3_2
APF12Appraisals main feature P22J_APPFTCHAR2Assigned to domainP22J_APPFT
APD12Appraisal Detail Feature P22J_APPDTCHAR2Assigned to domainP22J_APPDT
APR12Appraisal Rank Criteria P22J_APPRKCHAR3T5J46P22J_APPRK
APP12Point value for appraisal criterion P22J_APPPTDEC5(2) DEC3_2
APF13Appraisals main feature P22J_APPFTCHAR2Assigned to domainP22J_APPFT
APD13Appraisal Detail Feature P22J_APPDTCHAR2Assigned to domainP22J_APPDT
APR13Appraisal Rank Criteria P22J_APPRKCHAR3T5J46P22J_APPRK
APP13Point value for appraisal criterion P22J_APPPTDEC5(2) DEC3_2
APF14Appraisals main feature P22J_APPFTCHAR2Assigned to domainP22J_APPFT
APD14Appraisal Detail Feature P22J_APPDTCHAR2Assigned to domainP22J_APPDT
APR14Appraisal Rank Criteria P22J_APPRKCHAR3T5J46P22J_APPRK
APP14Point value for appraisal criterion P22J_APPPTDEC5(2) DEC3_2
APF15Appraisals main feature P22J_APPFTCHAR2Assigned to domainP22J_APPFT
APD15Appraisal Detail Feature P22J_APPDTCHAR2Assigned to domainP22J_APPDT
APR15Appraisal Rank Criteria P22J_APPRKCHAR3T5J46P22J_APPRK
APP15Point value for appraisal criterion P22J_APPPTDEC5(2) DEC3_2
APF16Appraisals main feature P22J_APPFTCHAR2Assigned to domainP22J_APPFT
APD16Appraisal Detail Feature P22J_APPDTCHAR2Assigned to domainP22J_APPDT
APR16Appraisal Rank Criteria P22J_APPRKCHAR3T5J46P22J_APPRK
APP16Point value for appraisal criterion P22J_APPPTDEC5(2) DEC3_2
APF17Appraisals main feature P22J_APPFTCHAR2Assigned to domainP22J_APPFT
APD17Appraisal Detail Feature P22J_APPDTCHAR2Assigned to domainP22J_APPDT
APR17Appraisal Rank Criteria P22J_APPRKCHAR3T5J46P22J_APPRK
APP17Point value for appraisal criterion P22J_APPPTDEC5(2) DEC3_2
APF18Appraisals main feature P22J_APPFTCHAR2Assigned to domainP22J_APPFT
APD18Appraisal Detail Feature P22J_APPDTCHAR2Assigned to domainP22J_APPDT
APR18Appraisal Rank Criteria P22J_APPRKCHAR3T5J46P22J_APPRK
APP18Point value for appraisal criterion P22J_APPPTDEC5(2) DEC3_2
APF19Appraisals main feature P22J_APPFTCHAR2Assigned to domainP22J_APPFT
APD19Appraisal Detail Feature P22J_APPDTCHAR2Assigned to domainP22J_APPDT
APR19Appraisal Rank Criteria P22J_APPRKCHAR3T5J46P22J_APPRK
APP19Point value for appraisal criterion P22J_APPPTDEC5(2) DEC3_2
APF20Appraisals main feature P22J_APPFTCHAR2Assigned to domainP22J_APPFT
APD20Appraisal Detail Feature P22J_APPDTCHAR2Assigned to domainP22J_APPDT
APR20Appraisal Rank Criteria P22J_APPRKCHAR3T5J46P22J_APPRK
APP20Point value for appraisal criterion P22J_APPPTDEC5(2) DEC3_2
APF21Appraisals main feature P22J_APPFTCHAR2Assigned to domainP22J_APPFT
APD21Appraisal Detail Feature P22J_APPDTCHAR2Assigned to domainP22J_APPDT
APR21Appraisal Rank Criteria P22J_APPRKCHAR3T5J46P22J_APPRK
APP21Point value for appraisal criterion P22J_APPPTDEC5(2) DEC3_2
APF22Appraisals main feature P22J_APPFTCHAR2Assigned to domainP22J_APPFT
APD22Appraisal Detail Feature P22J_APPDTCHAR2Assigned to domainP22J_APPDT
APR22Appraisal Rank Criteria P22J_APPRKCHAR3T5J46P22J_APPRK
APP22Point value for appraisal criterion P22J_APPPTDEC5(2) DEC3_2
APF23Appraisals main feature P22J_APPFTCHAR2Assigned to domainP22J_APPFT
APD23Appraisal Detail Feature P22J_APPDTCHAR2Assigned to domainP22J_APPDT
APR23Appraisal Rank Criteria P22J_APPRKCHAR3T5J46P22J_APPRK
APP23Point value for appraisal criterion P22J_APPPTDEC5(2) DEC3_2
APF24Appraisals main feature P22J_APPFTCHAR2Assigned to domainP22J_APPFT
APD24Appraisal Detail Feature P22J_APPDTCHAR2Assigned to domainP22J_APPDT
APR24Appraisal Rank Criteria P22J_APPRKCHAR3T5J46P22J_APPRK
APP24Point value for appraisal criterion P22J_APPPTDEC5(2) DEC3_2
APF25Appraisals main feature P22J_APPFTCHAR2Assigned to domainP22J_APPFT
APD25Appraisal Detail Feature P22J_APPDTCHAR2Assigned to domainP22J_APPDT
APR25Appraisal Rank Criteria P22J_APPRKCHAR3T5J46P22J_APPRK
APP25Point value for appraisal criterion P22J_APPPTDEC5(2) DEC3_2
APF26Appraisals main feature P22J_APPFTCHAR2Assigned to domainP22J_APPFT
APD26Appraisal Detail Feature P22J_APPDTCHAR2Assigned to domainP22J_APPDT
APR26Appraisal Rank Criteria P22J_APPRKCHAR3T5J46P22J_APPRK
APP26Point value for appraisal criterion P22J_APPPTDEC5(2) DEC3_2
APF27Appraisals main feature P22J_APPFTCHAR2Assigned to domainP22J_APPFT
APD27Appraisal Detail Feature P22J_APPDTCHAR2Assigned to domainP22J_APPDT
APR27Appraisal Rank Criteria P22J_APPRKCHAR3T5J46P22J_APPRK
APP27Point value for appraisal criterion P22J_APPPTDEC5(2) DEC3_2
APF28Appraisals main feature P22J_APPFTCHAR2Assigned to domainP22J_APPFT
APD28Appraisal Detail Feature P22J_APPDTCHAR2Assigned to domainP22J_APPDT
APR28Appraisal Rank Criteria P22J_APPRKCHAR3T5J46P22J_APPRK
APP28Point value for appraisal criterion P22J_APPPTDEC5(2) DEC3_2
APF29Appraisals main feature P22J_APPFTCHAR2Assigned to domainP22J_APPFT
APD29Appraisal Detail Feature P22J_APPDTCHAR2Assigned to domainP22J_APPDT
APR29Appraisal Rank Criteria P22J_APPRKCHAR3T5J46P22J_APPRK
APP29Point value for appraisal criterion P22J_APPPTDEC5(2) DEC3_2
APF30Appraisals main feature P22J_APPFTCHAR2Assigned to domainP22J_APPFT
APD30Appraisal Detail Feature P22J_APPDTCHAR2Assigned to domainP22J_APPDT
APR30Appraisal Rank Criteria P22J_APPRKCHAR3T5J46P22J_APPRK
APP30Point value for appraisal criterion P22J_APPPTDEC5(2) DEC3_2
APF31Appraisals main feature P22J_APPFTCHAR2Assigned to domainP22J_APPFT
APD31Appraisal Detail Feature P22J_APPDTCHAR2Assigned to domainP22J_APPDT
APR31Appraisal Rank Criteria P22J_APPRKCHAR3T5J46P22J_APPRK
APP31Point value for appraisal criterion P22J_APPPTDEC5(2) DEC3_2
APF32Appraisals main feature P22J_APPFTCHAR2Assigned to domainP22J_APPFT
APD32Appraisal Detail Feature P22J_APPDTCHAR2Assigned to domainP22J_APPDT
APR32Appraisal Rank Criteria P22J_APPRKCHAR3T5J46P22J_APPRK
APP32Point value for appraisal criterion P22J_APPPTDEC5(2) DEC3_2
APF33Appraisals main feature P22J_APPFTCHAR2Assigned to domainP22J_APPFT
APD33Appraisal Detail Feature P22J_APPDTCHAR2Assigned to domainP22J_APPDT
APR33Appraisal Rank Criteria P22J_APPRKCHAR3T5J46P22J_APPRK
APP33Point value for appraisal criterion P22J_APPPTDEC5(2) DEC3_2
APF34Appraisals main feature P22J_APPFTCHAR2Assigned to domainP22J_APPFT
APD34Appraisal Detail Feature P22J_APPDTCHAR2Assigned to domainP22J_APPDT
APR34Appraisal Rank Criteria P22J_APPRKCHAR3T5J46P22J_APPRK
APP34Point value for appraisal criterion P22J_APPPTDEC5(2) DEC3_2
APF35Appraisals main feature P22J_APPFTCHAR2Assigned to domainP22J_APPFT
APD35Appraisal Detail Feature P22J_APPDTCHAR2Assigned to domainP22J_APPDT
APR35Appraisal Rank Criteria P22J_APPRKCHAR3T5J46P22J_APPRK
APP35Point value for appraisal criterion P22J_APPPTDEC5(2) DEC3_2
APF36Appraisals main feature P22J_APPFTCHAR2Assigned to domainP22J_APPFT
APD36Appraisal Detail Feature P22J_APPDTCHAR2Assigned to domainP22J_APPDT
APR36Appraisal Rank Criteria P22J_APPRKCHAR3T5J46P22J_APPRK
APP36Point value for appraisal criterion P22J_APPPTDEC5(2) DEC3_2
APF37Appraisals main feature P22J_APPFTCHAR2Assigned to domainP22J_APPFT
APD37Appraisal Detail Feature P22J_APPDTCHAR2Assigned to domainP22J_APPDT
APR37Appraisal Rank Criteria P22J_APPRKCHAR3T5J46P22J_APPRK
APP37Point value for appraisal criterion P22J_APPPTDEC5(2) DEC3_2
APF38Appraisals main feature P22J_APPFTCHAR2Assigned to domainP22J_APPFT
APD38Appraisal Detail Feature P22J_APPDTCHAR2Assigned to domainP22J_APPDT
APR38Appraisal Rank Criteria P22J_APPRKCHAR3T5J46P22J_APPRK
APP38Point value for appraisal criterion P22J_APPPTDEC5(2) DEC3_2
APF39Appraisals main feature P22J_APPFTCHAR2Assigned to domainP22J_APPFT
APD39Appraisal Detail Feature P22J_APPDTCHAR2Assigned to domainP22J_APPDT
APR39Appraisal Rank Criteria P22J_APPRKCHAR3T5J46P22J_APPRK
APP39Point value for appraisal criterion P22J_APPPTDEC5(2) DEC3_2
APF40Appraisals main feature P22J_APPFTCHAR2Assigned to domainP22J_APPFT
APD40Appraisal Detail Feature P22J_APPDTCHAR2Assigned to domainP22J_APPDT
APR40Appraisal Rank Criteria P22J_APPRKCHAR3T5J46P22J_APPRK
APP40Point value for appraisal criterion P22J_APPPTDEC5(2) DEC3_2
KTRATReduction rate from attendance P22J_KTRATDEC5(3) DEC2_3

Key field Non-key field



How do I retrieve data from SAP structure P0147 using ABAP code?

As P0147 is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on P0147 as there is no data to select.

How to access SAP table P0147

Within an ECC or HANA version of SAP you can also view further information about P0147 and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!