PA0812 SAP (HR Master Record: Infotype 0812) Table details

Dictionary Type: Table
Description: HR Master Record: Infotype 0812




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




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

PA0812 is a standard SAP Table which is used to store HR Master Record: Infotype 0812 data and is available within R/3 SAP systems depending on the version and release level.

The PA0812 table consists of various fields, each holding specific information or linking keys about HR Master Record: Infotype 0812 data available in SAP. These include PERNR (Personnel number), SUBTY (Subtype), OBJPS (Object Identification), SPRPS (Lock Indicator for HR Master Data Record).. 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: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP PA0812 table 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
MANDTClient MANDTCLNT3Assigned to domainMANDT
PERNRPersonnel number PERSNONUMC8PA0003PERSNOPER
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
SUB01Subtype SUBTYCHAR4SUBTYSUB
OBJ01Object Identification OBJPSCHAR2OBJPSOPS
NUM01Biz number of supply PKR_SUPNRCHAR10BZNUMPKR_BZNUM
NAM01Name of supply PKR_SUPNMCHAR40CHAR40
CNT01Count for medical expense by cash PKR_MECNTNUMC5NUM05
AMT01Amount for medical expense paid by cash PKR_MEAMTCURR9(2) WERT05
CUR01Medical expense currency PKR_MECURCUKY5TCURCWAERSFWS
SUB02Subtype SUBTYCHAR4SUBTYSUB
OBJ02Object Identification OBJPSCHAR2OBJPSOPS
NUM02Biz number of supply PKR_SUPNRCHAR10BZNUMPKR_BZNUM
NAM02Name of supply PKR_SUPNMCHAR40CHAR40
CNT02Count for medical expense by cash PKR_MECNTNUMC5NUM05
AMT02Amount for medical expense paid by cash PKR_MEAMTCURR9(2) WERT05
CUR02Medical expense currency PKR_MECURCUKY5TCURCWAERSFWS
SUB03Subtype SUBTYCHAR4SUBTYSUB
OBJ03Object Identification OBJPSCHAR2OBJPSOPS
NUM03Biz number of supply PKR_SUPNRCHAR10BZNUMPKR_BZNUM
NAM03Name of supply PKR_SUPNMCHAR40CHAR40
CNT03Count for medical expense by cash PKR_MECNTNUMC5NUM05
AMT03Amount for medical expense paid by cash PKR_MEAMTCURR9(2) WERT05
CUR03Medical expense currency PKR_MECURCUKY5TCURCWAERSFWS
SUB04Subtype SUBTYCHAR4SUBTYSUB
OBJ04Object Identification OBJPSCHAR2OBJPSOPS
NUM04Biz number of supply PKR_SUPNRCHAR10BZNUMPKR_BZNUM
NAM04Name of supply PKR_SUPNMCHAR40CHAR40
CNT04Count for medical expense by cash PKR_MECNTNUMC5NUM05
AMT04Amount for medical expense paid by cash PKR_MEAMTCURR9(2) WERT05
CUR04Medical expense currency PKR_MECURCUKY5TCURCWAERSFWS
SUB05Subtype SUBTYCHAR4SUBTYSUB
OBJ05Object Identification OBJPSCHAR2OBJPSOPS
NUM05Biz number of supply PKR_SUPNRCHAR10BZNUMPKR_BZNUM
NAM05Name of supply PKR_SUPNMCHAR40CHAR40
CNT05Count for medical expense by cash PKR_MECNTNUMC5NUM05
AMT05Amount for medical expense paid by cash PKR_MEAMTCURR9(2) WERT05
CUR05Medical expense currency PKR_MECURCUKY5TCURCWAERSFWS
SUB06Subtype SUBTYCHAR4SUBTYSUB
OBJ06Object Identification OBJPSCHAR2OBJPSOPS
NUM06Biz number of supply PKR_SUPNRCHAR10BZNUMPKR_BZNUM
NAM06Name of supply PKR_SUPNMCHAR40CHAR40
CNT06Count for medical expense by cash PKR_MECNTNUMC5NUM05
AMT06Amount for medical expense paid by cash PKR_MEAMTCURR9(2) WERT05
CUR06Medical expense currency PKR_MECURCUKY5TCURCWAERSFWS
SUB07Subtype SUBTYCHAR4SUBTYSUB
OBJ07Object Identification OBJPSCHAR2OBJPSOPS
NUM07Biz number of supply PKR_SUPNRCHAR10BZNUMPKR_BZNUM
NAM07Name of supply PKR_SUPNMCHAR40CHAR40
CNT07Count for medical expense by cash PKR_MECNTNUMC5NUM05
AMT07Amount for medical expense paid by cash PKR_MEAMTCURR9(2) WERT05
CUR07Medical expense currency PKR_MECURCUKY5TCURCWAERSFWS
SUB08Subtype SUBTYCHAR4SUBTYSUB
OBJ08Object Identification OBJPSCHAR2OBJPSOPS
NUM08Biz number of supply PKR_SUPNRCHAR10BZNUMPKR_BZNUM
NAM08Name of supply PKR_SUPNMCHAR40CHAR40
CNT08Count for medical expense by cash PKR_MECNTNUMC5NUM05
AMT08Amount for medical expense paid by cash PKR_MEAMTCURR9(2) WERT05
CUR08Medical expense currency PKR_MECURCUKY5TCURCWAERSFWS
SUB09Subtype SUBTYCHAR4SUBTYSUB
OBJ09Object Identification OBJPSCHAR2OBJPSOPS
NUM09Biz number of supply PKR_SUPNRCHAR10BZNUMPKR_BZNUM
NAM09Name of supply PKR_SUPNMCHAR40CHAR40
CNT09Count for medical expense by cash PKR_MECNTNUMC5NUM05
AMT09Amount for medical expense paid by cash PKR_MEAMTCURR9(2) WERT05
CUR09Medical expense currency PKR_MECURCUKY5TCURCWAERSFWS
SUB10Subtype SUBTYCHAR4SUBTYSUB
OBJ10Object Identification OBJPSCHAR2OBJPSOPS
NUM10Biz number of supply PKR_SUPNRCHAR10BZNUMPKR_BZNUM
NAM10Name of supply PKR_SUPNMCHAR40CHAR40
CNT10Count for medical expense by cash PKR_MECNTNUMC5NUM05
AMT10Amount for medical expense paid by cash PKR_MEAMTCURR9(2) WERT05
CUR10Medical expense currency PKR_MECURCUKY5Assigned to domainWAERSFWS
SUB11Subtype SUBTYCHAR4SUBTYSUB
OBJ11Object Identification OBJPSCHAR2OBJPSOPS
NUM11Biz number of supply PKR_SUPNRCHAR10BZNUMPKR_BZNUM
NAM11Name of supply PKR_SUPNMCHAR40CHAR40
CNT11Count for medical expense by cash PKR_MECNTNUMC5NUM05
AMT11Amount for medical expense paid by cash PKR_MEAMTCURR9(2) WERT05
CUR11Medical expense currency PKR_MECURCUKY5TCURCWAERSFWS
SUB12Subtype SUBTYCHAR4SUBTYSUB
OBJ12Object Identification OBJPSCHAR2OBJPSOPS
NUM12Biz number of supply PKR_SUPNRCHAR10BZNUMPKR_BZNUM
NAM12Name of supply PKR_SUPNMCHAR40CHAR40
CNT12Count for medical expense by cash PKR_MECNTNUMC5NUM05
AMT12Amount for medical expense paid by cash PKR_MEAMTCURR9(2) WERT05
CUR12Medical expense currency PKR_MECURCUKY5TCURCWAERSFWS
SUB13Subtype SUBTYCHAR4SUBTYSUB
OBJ13Object Identification OBJPSCHAR2OBJPSOPS
NUM13Biz number of supply PKR_SUPNRCHAR10BZNUMPKR_BZNUM
NAM13Name of supply PKR_SUPNMCHAR40CHAR40
CNT13Count for medical expense by cash PKR_MECNTNUMC5NUM05
AMT13Amount for medical expense paid by cash PKR_MEAMTCURR9(2) WERT05
CUR13Medical expense currency PKR_MECURCUKY5TCURCWAERSFWS
SUB14Subtype SUBTYCHAR4SUBTYSUB
OBJ14Object Identification OBJPSCHAR2OBJPSOPS
NUM14Biz number of supply PKR_SUPNRCHAR10BZNUMPKR_BZNUM
NAM14Name of supply PKR_SUPNMCHAR40CHAR40
CNT14Count for medical expense by cash PKR_MECNTNUMC5NUM05
AMT14Amount for medical expense paid by cash PKR_MEAMTCURR9(2) WERT05
CUR14Medical expense currency PKR_MECURCUKY5TCURCWAERSFWS
SUB15Subtype SUBTYCHAR4SUBTYSUB
OBJ15Object Identification OBJPSCHAR2OBJPSOPS
NUM15Biz number of supply PKR_SUPNRCHAR10BZNUMPKR_BZNUM
NAM15Name of supply PKR_SUPNMCHAR40CHAR40
CNT15Count for medical expense by cash PKR_MECNTNUMC5NUM05
AMT15Amount for medical expense paid by cash PKR_MEAMTCURR9(2) WERT05
CUR15Medical expense currency PKR_MECURCUKY5TCURCWAERSFWS
SUB16Subtype SUBTYCHAR4SUBTYSUB
OBJ16Object Identification OBJPSCHAR2OBJPSOPS
NUM16Biz number of supply PKR_SUPNRCHAR10BZNUMPKR_BZNUM
NAM16Name of supply PKR_SUPNMCHAR40CHAR40
CNT16Count for medical expense by cash PKR_MECNTNUMC5NUM05
AMT16Amount for medical expense paid by cash PKR_MEAMTCURR9(2) WERT05
CUR16Medical expense currency PKR_MECURCUKY5TCURCWAERSFWS
SUB17Subtype SUBTYCHAR4SUBTYSUB
OBJ17Object Identification OBJPSCHAR2OBJPSOPS
NUM17Biz number of supply PKR_SUPNRCHAR10BZNUMPKR_BZNUM
NAM17Name of supply PKR_SUPNMCHAR40CHAR40
CNT17Count for medical expense by cash PKR_MECNTNUMC5NUM05
AMT17Amount for medical expense paid by cash PKR_MEAMTCURR9(2) WERT05
CUR17Medical expense currency PKR_MECURCUKY5TCURCWAERSFWS
SUB18Subtype SUBTYCHAR4SUBTYSUB
OBJ18Object Identification OBJPSCHAR2OBJPSOPS
NUM18Biz number of supply PKR_SUPNRCHAR10BZNUMPKR_BZNUM
NAM18Name of supply PKR_SUPNMCHAR40CHAR40
CNT18Count for medical expense by cash PKR_MECNTNUMC5NUM05
AMT18Amount for medical expense paid by cash PKR_MEAMTCURR9(2) WERT05
CUR18Medical expense currency PKR_MECURCUKY5TCURCWAERSFWS
CDT01Credit Card count for medical exp PKR_MECDTNUMC5NUM05
CDA01Credit amount for medical expense PKR_MECDACURR9(2) WERT05
CDT02Credit Card count for medical exp PKR_MECDTNUMC5NUM05
CDA02Credit amount for medical expense PKR_MECDACURR9(2) WERT05
CDT03Credit Card count for medical exp PKR_MECDTNUMC5NUM05
CDA03Credit amount for medical expense PKR_MECDACURR9(2) WERT05
CDT04Credit Card count for medical exp PKR_MECDTNUMC5NUM05
CDA04Credit amount for medical expense PKR_MECDACURR9(2) WERT05
CDT05Credit Card count for medical exp PKR_MECDTNUMC5NUM05
CDA05Credit amount for medical expense PKR_MECDACURR9(2) WERT05
CDT06Credit Card count for medical exp PKR_MECDTNUMC5NUM05
CDA06Credit amount for medical expense PKR_MECDACURR9(2) WERT05
CDT07Credit Card count for medical exp PKR_MECDTNUMC5NUM05
CDA07Credit amount for medical expense PKR_MECDACURR9(2) WERT05
CDT08Credit Card count for medical exp PKR_MECDTNUMC5NUM05
CDA08Credit amount for medical expense PKR_MECDACURR9(2) WERT05
CDT09Credit Card count for medical exp PKR_MECDTNUMC5NUM05
CDA09Credit amount for medical expense PKR_MECDACURR9(2) WERT05
CDT10Credit Card count for medical exp PKR_MECDTNUMC5NUM05
CDA10Credit amount for medical expense PKR_MECDACURR9(2) WERT05
CDT11Credit Card count for medical exp PKR_MECDTNUMC5NUM05
CDA11Credit amount for medical expense PKR_MECDACURR9(2) WERT05
CDT12Credit Card count for medical exp PKR_MECDTNUMC5NUM05
CDA12Credit amount for medical expense PKR_MECDACURR9(2) WERT05
CDT13Credit Card count for medical exp PKR_MECDTNUMC5NUM05
CDA13Credit amount for medical expense PKR_MECDACURR9(2) WERT05
CDT14Credit Card count for medical exp PKR_MECDTNUMC5NUM05
CDA14Credit amount for medical expense PKR_MECDACURR9(2) WERT05
CDT15Credit Card count for medical exp PKR_MECDTNUMC5NUM05
CDA15Credit amount for medical expense PKR_MECDACURR9(2) WERT05
CDT16Credit Card count for medical exp PKR_MECDTNUMC5NUM05
CDA16Credit amount for medical expense PKR_MECDACURR9(2) WERT05
CDT17Credit Card count for medical exp PKR_MECDTNUMC5NUM05
CDA17Credit amount for medical expense PKR_MECDACURR9(2) WERT05
CDT18Credit Card count for medical exp PKR_MECDTNUMC5NUM05
CDA18Credit amount for medical expense PKR_MECDACURR9(2) WERT05
FLNTSFlag for NTS data or others PKR_FLNTSCHAR1PKR_FLNTS
PCD01Proof Code for Medical Expense Classification PKR_MEPCDCHAR1PKR_MEPCD
PCD02Proof Code for Medical Expense Classification PKR_MEPCDCHAR1PKR_MEPCD
PCD03Proof Code for Medical Expense Classification PKR_MEPCDCHAR1PKR_MEPCD
PCD04Proof Code for Medical Expense Classification PKR_MEPCDCHAR1PKR_MEPCD
PCD05Proof Code for Medical Expense Classification PKR_MEPCDCHAR1PKR_MEPCD
PCD06Proof Code for Medical Expense Classification PKR_MEPCDCHAR1PKR_MEPCD
PCD07Proof Code for Medical Expense Classification PKR_MEPCDCHAR1PKR_MEPCD
PCD08Proof Code for Medical Expense Classification PKR_MEPCDCHAR1PKR_MEPCD
PCD09Proof Code for Medical Expense Classification PKR_MEPCDCHAR1PKR_MEPCD
PCD10Proof Code for Medical Expense Classification PKR_MEPCDCHAR1PKR_MEPCD
PCD11Proof Code for Medical Expense Classification PKR_MEPCDCHAR1PKR_MEPCD
PCD12Proof Code for Medical Expense Classification PKR_MEPCDCHAR1PKR_MEPCD
PCD13Proof Code for Medical Expense Classification PKR_MEPCDCHAR1PKR_MEPCD
PCD14Proof Code for Medical Expense Classification PKR_MEPCDCHAR1PKR_MEPCD
PCD15Proof Code for Medical Expense Classification PKR_MEPCDCHAR1PKR_MEPCD
PCD16Proof Code for Medical Expense Classification PKR_MEPCDCHAR1PKR_MEPCD
PCD17Proof Code for Medical Expense Classification PKR_MEPCDCHAR1PKR_MEPCD
PCD18Proof Code for Medical Expense Classification PKR_MEPCDCHAR1PKR_MEPCD

Key field Non-key field



How do I retrieve data from SAP table PA0812 using ABAP code

The following ABAP code Example will allow you to do a basic selection on PA0812 to SELECT all data from the table
DATA: WA_PA0812 TYPE PA0812.

SELECT SINGLE *
FROM PA0812
INTO CORRESPONDING FIELDS OF WA_PA0812
WHERE...

How to access SAP table PA0812

Within an ECC or HANA version of SAP you can also view further information about PA0812 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!