PA0012 SAP (HR Master Record: Infotype 0012 (Fiscal Data - Germany)) Table details

Dictionary Type: Table
Description: HR Master Record: Infotype 0012 (Fiscal Data - Germany)




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




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

PA0012 is a standard SAP Table which is used to store HR Master Record: Infotype 0012 (Fiscal Data - Germany) data and is available within R/3 SAP systems depending on the version and release level.

The PA0012 table consists of various fields, each holding specific information or linking keys about HR Master Record: Infotype 0012 (Fiscal Data - Germany) 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 PA0012 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 MANDTCLNT3T000MANDT
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
FZAMTTax Office Number (D) FZAMNNUMC4T5D2AFZAMN
GMDNRMunicipality Number (D) GMNDNNUMC8T5D2BGMNDN
STKNRTax Card Number STKNRNUMC12NUM12
STRKZIndicator: Tax Card Not Submitted STRKZCHAR1XFELD
STRKSReason for Not Submitting Tax Card STRKSCHAR1STRKS
STKRTCertification period STKRTNUMC2NUM2
STKAGDate of Issue of Tax Card STKAGDATS8DATUM
STRKLTax Class (D) STRKLCHAR1STRKL
STTABTax Table (D) STTABCHAR1STTAB
KDFBTNumber of Tax Exemptions for Children (D) KDFBTDEC3(1) DEC2_1
STRKDNumber of Children for Berlin Supplement STRKDDEC3DEC3
KISTAChurch tax deduction - employee KISTACHAR2KISTA
KISTEChurch Tax Deduction - Spouse KISTECHAR2KISTA
BRDLDChurch Tax Area (D) KISTGCHAR2T5D2LKISTG
STPFLTax Liability STPFLCHAR1T5D2DSTRMM
PRMNZTax procedure PRMNZCHAR1T5D2DSTRMM
STFRGFlat-Rate Tax Procedure STFRGCHAR1T5D2DSTRMM
STBFGTax Exemption Reason STBFGCHAR1T5D2DSTRMM
STRSOSpecial Rule for Taxation (D) STRSOCHAR1T5D2DSTRMM
STRS2Special Rule for Taxation (D) STRSOCHAR1T5D2DSTRMM
VFREIPension Tax Exemption Granted VFREICHAR1T5D2DSTRMM
FRB1MMonthly Personal Exemption According to Tax Card FRB1MCURR9(2) WERT5
FRB1JAnnual Personal Exemption According to Tax Card FRB1JCURR9(2) WERT5
FRB2MMonthly Exemption for Specific Occupational Groups FRB2MCURR9(2) WERT5
FRB2JAnnual Exemption for Specific Occupational Groups FRB2JCURR9(2) WERT5
STBELElster Special Processing STBELCHAR1STBEL
BEGVBStart Date of Benefit Payment BEGVBDATS8DATUM
VBEZLRegular Benefits Payment VBEZLCURR9(2) WERT5
VBEZSEstimated Special Payments VBEZSCURR9(2) WERT5
ENDVBBenefits Payment End Date ENDVBDATS8DATUM
KJAHRDifferent Start Year for Pension Income JAHRKNUMC4NUMC4
LGVBZBenefits Payments Wage Type Group LGVBZCHAR4T596GP_SUML
BEGV2Start Date of Benefit Payment BEGVBDATS8DATUM
VBE2LRegular Benefits Payment VBEZLCURR9(2) WERT5
VBE2SEstimated Special Payments VBEZSCURR9(2) WERT5
ENDV2Benefits Payment End Date ENDVBDATS8DATUM
KJAH2Different Start Year for Pension Income JAHRKNUMC4NUMC4
LGVB2Benefits Payments Wage Type Group LGVBZCHAR4T596GP_SUML
BEGV3Start Date of Benefit Payment BEGVBDATS8DATUM
VBE3LRegular Benefits Payment VBEZLCURR9(2) WERT5
VBE3SEstimated Special Payments VBEZSCURR9(2) WERT5
ENDV3Benefits Payment End Date ENDVBDATS8DATUM
KJAH3Different Start Year for Pension Income JAHRKNUMC4NUMC4
LGVB3Benefits Payments Wage Type Group LGVBZCHAR4T596GP_SUML
BEGV4Start Date of Benefit Payment BEGVBDATS8DATUM
VBE4LRegular Benefits Payment VBEZLCURR9(2) WERT5
VBE4SEstimated Special Payments VBEZSCURR9(2) WERT5
ENDV4Benefits Payment End Date ENDVBDATS8DATUM
KJAH4Different Start Year for Pension Income JAHRKNUMC4NUMC4
LGVB4Benefits Payments Wage Type Group LGVBZCHAR4T596GP_SUML
BEGV5Start Date of Benefit Payment BEGVBDATS8DATUM
VBE5LRegular Benefits Payment VBEZLCURR9(2) WERT5
VBE5SEstimated Special Payments VBEZSCURR9(2) WERT5
ENDV5Benefits Payment End Date ENDVBDATS8DATUM
KJAH5Different Start Year for Pension Income JAHRKNUMC4NUMC4
LGVB5Benefits Payments Wage Type Group LGVBZCHAR4T596GP_SUML
SIDNRTax Identification Number P01_SIDNRNUMC11
FAKTRFactor for Factor Procedure P01_TX_FDEC4(3)
E2HAGElster: Indicator Main Employer P01_TX_KNZ_HAUPTAGCHAR1XFELD
E2SONSpecial Processing for ELStAM Procedure P01_TX_E2_SONDERCHAR1P01_TX_E2_SONDER
E2SON_ANSpecial Processing of Registration for ELStAM Procedure P01_TX_E2_SONDER_ANCHAR1P01_TX_E2_SONDER_ANAB
E2SON_ABSpecial Processing of Deregistration for ELStAM Procedure P01_TX_E2_SONDER_ABCHAR1P01_TX_E2_SONDER_ANAB
E2ABMELStAM: Date Deregistration On P01_TX_E2_DATUM_ABMDATS8DATUM
E2SON_GRUNDReason for Special Processing for ELStAM Procedure P01_TX_E2_SONDER_GRUNDCHAR1P01_TX_E2_SONDER_GRUND
E2ELSTAMChange by ELStAM P01_TX_E2_KNZ_ELSTAMCHAR1XFELD
E2SPERREELStAM Block P01_TX_E2_SPERRECHAR1P01_TX_E2_SPERRE
E2SPERRE_GRUNDELStAM: Reason for Block P01_TX_E2_SPERRE_GRUNDCHAR1P01_TX_E2_SPERRE_GRUND

Key field Non-key field



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

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

SELECT SINGLE *
FROM PA0012
INTO CORRESPONDING FIELDS OF WA_PA0012
WHERE...

How to access SAP table PA0012

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