SAP table PA0202 (HR Master Record Infotype 0202 (Entitlements))

SAP table PA0202 has 8 primary key fields being MANDT,PERNR,SUBTY,OBJPS,SPRPS,ENDDA,BEGDA,SEQNR.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
PERNR Personnel Number NUMC 8 0 PA0003 PERSNO
SUBTY Subtype CHAR 4 0 SUBTY
OBJPS Object Identification CHAR 2 0 OBJPS
SPRPS Lock Indicator for HR Master Data Record CHAR 1 0 SPRPS
ENDDA End Date DATS 8 0 ENDDA
BEGDA Start Date DATS 8 0 BEGDA
SEQNR Number of Infotype Record With Same Key NUMC 3 0 SEQNR
AEDTM Last Changed On DATS 8 0 AEDAT
UNAME Name of Person Who Changed Object CHAR 12 0 AENAM
HISTO Historical Record Flag CHAR 1 0 HISTO
ITXEX Text Exists for Infotype CHAR 1 0 ITXEX
REFEX Reference Fields Exist (Primary/Secondary Costs) CHAR 1 0 PRFEX
ORDEX Confirmation Fields Exist CHAR 1 0 ORDEX
ITBLD Infotype Screen Control CHAR 2 0 ITBLD
PREAS Reason for Changing Master Data CHAR 2 0 T530E PREAS
FLAG1 Reserved Field/Unused Field CHAR 1 0 NUSED
FLAG2 Reserved Field/Unused Field CHAR 1 0 NUSED
FLAG3 Reserved Field/Unused Field CHAR 1 0 NUSED
FLAG4 Reserved Field/Unused Field CHAR 1 0 NUSED
RESE1 Reserved Field/Unused Field of Length 2 CHAR 2 0 NUSED2
RESE2 Reserved Field/Unused Field of Length 2 CHAR 2 0 NUSED2
GRPVL Grouping Value for Personnel Assignments CHAR 4 0 PCCE_GPVAL
HANSP Company Pension Scheme Entitlement CHAR 4 0 T5DWB P01C_HANSP
MODBV Calculation Variant for Entitlement CHAR 2 0 T5DWE P01C_MODBV
LURSP Company Responsible CHAR 4 0 T5DC3 P01C_LURSP
ANGRP Pension Plan CHAR 4 0 T5DWA P01C_ANGRP
LTRGR Benefits Provider CHAR 4 0 T5DCU P01C_LTRGR
BETFI Fixed Amount of Benefit CURR 9 2 P01C_BETFI
BTFKZ Indicator for Annual/Monthly Benefit CHAR 1 0 P01C_BTFKZ
BETMA Maximum Benefit CURR 9 2 P01C_BETMA
BETMI Minimum Benefit CURR 9 2 P01C_BETMI
ANZHL Number DEC 7 2 ANZHL
ZEINH Time/measurement unit CHAR 3 0 T538A P01C_PT_ZEINH
TBEGA Technical Start Date of Entitlement DATS 8 0 P01C_TBEGA
TBGDZ Technical Start Date for Valuation of Employment Period DATS 8 0 P01C_TBGDZ
BEGUA Technical Start Date for Vesting Check DATS 8 0 P01C_BEGUA
UAVER Waiver VE Check CHAR 1 0 P01C_UAVER
STAUA Vesting Status CHAR 1 0 P01C_STAUA
Unchecked
1 Forfeited
2 Vested
3 Only Company Vesting
4 Only Statutory Vesting
5 Statutory and Company Vesting
DATRD Different Valuation Date DATS 8 0 P01C_DATRD
DATUA Vested Since DATS 8 0 P01C_DATUA
DATRG Different Rule Date DATS 8 0 P01C_DATRG
WZVER Waiver of Waiting Period Check CHAR 1 0 P01C_WZVER
BEGWZ Technical Start Date for Waiting Period Check DATS 8 0 P01C_BEGWZ
KZKWZ Indicator for Reduced Waiting Period CHAR 1 0 P01C_KZKWZ
MMKWZ Months of Waiting Period Reduction NUMC 3 0 P01C_MMKWZ
ARTUE Method of Capital Transfer (Sender/Recipient) CHAR 1 0 P01C_ARTUE
1 Payee
2 Sender
BETUE Transferred Capital CURR 9 2 P01C_BETUE
DATUE Date of Capital Transfer DATS 8 0 P01C_DATUE
EWERK Receiving/Sending Company CHAR 4 0 T5DC3 P01C_WRKUE
DATRU Date of Reimbursement DATS 8 0 P01C_DATRU
RELAB Base Determination through Payroll Accounting CHAR 1 0 P01C_RELAB
MITST Entitlement Status CHAR 1 0 T5DCV P01C_MITST
MITNR Membership Number/File Number CHAR 15 0 P01C_MITNR
MGLST Member Status CHAR 1 0 T5DWV P01C_MGLST
PNRBZ Personnel Number of Contribution Payer NUMC 8 0 P01C_PNRBZ
EINZV Debit Procedure for Contributions CHAR 1 0 P01C_EINZV
1 External System
2 Debit Memo
3 Payroll
4 Other Personnel Number
5 Cash Payer
6 Bank Transfer
DATMS Creation Date of Membership Certificate DATS 8 0 P01C_DATMS
BEITR Contribution CURR 9 2 P01C_BEITR
BEIKZ Contribution Indicator CHAR 1 0 P01C_BEIKZ
1 Fixed value
2 Additional
BEITR_ABR Contribution CURR 9 2 P01C_BEITR
BEIKZ_ABR Contribution Indicator CHAR 1 0 P01C_BEIKZ
1 Fixed value
2 Additional
MODBV_ABR Calculation Variant for Entitlement CHAR 2 0 * P01C_MODBV
DZPRZ Percentage Rate for Valuation of Employment Period DEC 5 2 P01C_DZPRZ
RSTGR Reserve Group CHAR 4 0 T5DW1 P01C_RSTGR
KFUNK Fund Function CHAR 1 0 T5DCG P01C_KFUNK
LGABZ Contribution Retention CHAR 1 0 P01C_LGABZ
ALDAT Date DATS 8 0 P01C_ALDAT
VTBET Maximum Conversion CURR 9 2 P01C_VTBET
VTPER Contract Duration in Years NUMC 2 0 P01C_VTPER
ZNRUA Assignment Number for Vested Entitlements NUMC 4 0 P01C_ZNRUA
ZNRGP Assignment Number for Vested Payments NUMC 4 0 P01C_ZNRGP
ZNRBT Assignment Number for Transfer Records for Cont.Reimbursmnt NUMC 4 0 P01C_ZNRBT
ZNRRB Assignment Number for Pension Payments NUMC 4 0 P01C_ZNRRB
BTTYP Type of Amount Calculation CHAR 1 0 P01C_BTTYP
BTRGL Rule for Amount Calculation CHAR 4 0 P01C_BTRGL
VZKRZ Waiver Bonuses/Deductions CHAR 1 0 P01C_VZKRZ
VMANR Identification Number for Assessor CHAR 15 0 P01C_VMANR
VMBEG Financing Start for Reserves DATS 8 0 P01C_VMBEG
DZALT Compensated Employment Years DEC 4 2 P01C_DZJJA
WAERS Currency key CUKY 5 0 TCURC P01C_WAERS
ZFPER First payment period NUMC 2 0 DZFPER
ZANZL Number for determining further payment dates DEC 3 0 DZANZL
JBEWE Year for Valuation in Pension Calculation CHAR 1 0 P01C_JBEWE
1 Previous year
2 Current year
JGEVE Calendar Year for First Payment CHAR 1 0 P01C_JGEVE
BEGAZ Start of Conversion Period DATS 8 0 P01C_BEGAZ
ENDAZ End of Conversion Period DATS 8 0 P01C_ENDAZ
IDAUS Rule for Payment Control CHAR 4 0 T5DWX P01C_IDAUS
METH1 Method for Calculation of Conversion Amount CHAR 2 0 T5DCF P01C_WMETH
LGAG1 Wage Type Grouping for Payroll Control CHAR 2 0 T5DC7 P01C_LGAGP
VBEL1 Maximum Conversion CURR 9 2 P01C_VTBET
VBEE1 Maximum Conversion CURR 9 2 P01C_VTBET
SBEL1 Base Amount CURR 9 2 P01C_SOBET
SBEE1 Base Amount CURR 9 2 P01C_SOBET
PROL1 Percentage Rate for Conversion DEC 5 2 P01C_WAPRZ
PROE1 Percentage Rate for Conversion DEC 5 2 P01C_WAPRZ
METH2 Method for Calculation of Conversion Amount CHAR 2 0 T5DCF P01C_WMETH
LGAG2 Wage Type Grouping for Payroll Control CHAR 2 0 T5DC7 P01C_LGAGP
VBEL2 Maximum Conversion CURR 9 2 P01C_VTBET
VBEE2 Maximum Conversion CURR 9 2 P01C_VTBET
SBEL2 Base Amount CURR 9 2 P01C_SOBET
SBEE2 Base Amount CURR 9 2 P01C_SOBET
PROL2 Percentage Rate for Conversion DEC 5 2 P01C_WAPRZ
PROE2 Percentage Rate for Conversion DEC 5 2 P01C_WAPRZ
METH3 Method for Calculation of Conversion Amount CHAR 2 0 T5DCF P01C_WMETH
LGAG3 Wage Type Grouping for Payroll Control CHAR 2 0 T5DC7 P01C_LGAGP
VBEL3 Maximum Conversion CURR 9 2 P01C_VTBET
VBEE3 Maximum Conversion CURR 9 2 P01C_VTBET
SBEL3 Base Amount CURR 9 2 P01C_SOBET
SBEE3 Base Amount CURR 9 2 P01C_SOBET
PROL3 Percentage Rate for Conversion DEC 5 2 P01C_WAPRZ
PROE3 Percentage Rate for Conversion DEC 5 2 P01C_WAPRZ
METH4 Method for Calculation of Conversion Amount CHAR 2 0 T5DCF P01C_WMETH
LGAG4 Wage Type Grouping for Payroll Control CHAR 2 0 T5DC7 P01C_LGAGP
VBEL4 Maximum Conversion CURR 9 2 P01C_VTBET
VBEE4 Maximum Conversion CURR 9 2 P01C_VTBET
SBEL4 Base Amount CURR 9 2 P01C_SOBET
SBEE4 Base Amount CURR 9 2 P01C_SOBET
PROL4 Percentage Rate for Conversion DEC 5 2 P01C_WAPRZ
PROE4 Percentage Rate for Conversion DEC 5 2 P01C_WAPRZ
METH5 Method for Calculation of Conversion Amount CHAR 2 0 T5DCF P01C_WMETH
LGAG5 Wage Type Grouping for Payroll Control CHAR 2 0 T5DC7 P01C_LGAGP
VBEL5 Maximum Conversion CURR 9 2 P01C_VTBET
VBEE5 Maximum Conversion CURR 9 2 P01C_VTBET
SBEL5 Base Amount CURR 9 2 P01C_SOBET
SBEE5 Base Amount CURR 9 2 P01C_SOBET
PROL5 Percentage Rate for Conversion DEC 5 2 P01C_WAPRZ
PROE5 Percentage Rate for Conversion DEC 5 2 P01C_WAPRZ
METH6 Method for Calculation of Conversion Amount CHAR 2 0 T5DCF P01C_WMETH
LGAG6 Wage Type Grouping for Payroll Control CHAR 2 0 T5DC7 P01C_LGAGP
VBEL6 Maximum Conversion CURR 9 2 P01C_VTBET
VBEE6 Maximum Conversion CURR 9 2 P01C_VTBET
SBEL6 Base Amount CURR 9 2 P01C_SOBET
SBEE6 Base Amount CURR 9 2 P01C_SOBET
PROL6 Percentage Rate for Conversion DEC 5 2 P01C_WAPRZ
PROE6 Percentage Rate for Conversion DEC 5 2 P01C_WAPRZ
NVAEG New Contract under German Pension Tax Law CHAR 1 0 P01A_NVAEG
TLREL Split Relevance CHAR 1 0 P01_VA_TLREL
Relevant for Split
1 Not Relevant for Split
2 Not Ready for Split
AF100 Remove Subsidy Eligibility Sec. 100 EStG CHAR 1 0 P01A_FP100_AUFH

PA0202 foreign key relationships

Table Field Check Table Check Field
0 PA0202 ANGRP T5DWA CPS Pension Plans MANDT
0 PA0202 ANGRP T5DWA CPS Pension Plans ANGRP
0 PA0202 ANGRP T5DWA CPS Pension Plans ENDDA
1 PA0202 EWERK T5DC3 Pension Organization for Company Pension Scheme MANDT
0 PA0202 HANSP T5DWB Entitlements of a Pension Plan MANDT
0 PA0202 HANSP T5DWB Entitlements of a Pension Plan ANGRP
0 PA0202 HANSP T5DWB Entitlements of a Pension Plan HANSP
0 PA0202 HANSP T5DWB Entitlements of a Pension Plan ENDDA
1 PA0202 IDAUS T5DWX Payment control MANDT
1 PA0202 IDAUS T5DWX Payment control SEQNO
1 PA0202 IDAUS T5DWX Payment control ENDDA
0 PA0202 KFUNK T5DCG CPS Indicator MANDT
0 PA0202 KFUNK T5DCG CPS Indicator KZTYP
1 PA0202 LGAG1 T5DC7 CPS Groupings MANDT
0 PA0202 LGAG2 T5DC7 CPS Groupings MANDT
1 PA0202 LGAG3 T5DC7 CPS Groupings MANDT
0 PA0202 LGAG4 T5DC7 CPS Groupings MANDT
1 PA0202 LGAG5 T5DC7 CPS Groupings MANDT
0 PA0202 LGAG6 T5DC7 CPS Groupings MANDT
1 PA0202 LTRGR T5DCU Account Assignment: Basic Pension Pay MANDT
1 PA0202 LTRGR T5DCU Account Assignment: Basic Pension Pay LTRGR
1 PA0202 LTRGR T5DCU Account Assignment: Basic Pension Pay ENDDA
0 PA0202 LURSP T5DC3 Pension Organization for Company Pension Scheme MANDT
1 PA0202 MANDT T000 Clients MANDT
0 PA0202 METH1 T5DCF Method for Calculation of Conversion Amount MANDT
0 PA0202 METH1 T5DCF Method for Calculation of Conversion Amount WMETH
1 PA0202 METH2 T5DCF Method for Calculation of Conversion Amount MANDT
1 PA0202 METH2 T5DCF Method for Calculation of Conversion Amount WMETH
0 PA0202 METH3 T5DCF Method for Calculation of Conversion Amount MANDT
0 PA0202 METH3 T5DCF Method for Calculation of Conversion Amount WMETH
1 PA0202 METH4 T5DCF Method for Calculation of Conversion Amount MANDT
1 PA0202 METH4 T5DCF Method for Calculation of Conversion Amount WMETH
0 PA0202 METH5 T5DCF Method for Calculation of Conversion Amount MANDT
0 PA0202 METH5 T5DCF Method for Calculation of Conversion Amount WMETH
1 PA0202 METH6 T5DCF Method for Calculation of Conversion Amount MANDT
1 PA0202 METH6 T5DCF Method for Calculation of Conversion Amount WMETH
0 PA0202 MGLST T5DWV Member Status MANDT
0 PA0202 MGLST T5DWV Member Status HANSP
1 PA0202 MITST T5DCV Entitlement Status MANDT
1 PA0202 MITST T5DCV Entitlement Status HANSP
1 PA0202 MITST T5DCV Entitlement Status MITST
0 PA0202 MODBV T5DWE Calculation Variants per Entitlement MANDT
0 PA0202 MODBV T5DWE Calculation Variants per Entitlement ANTYP
0 PA0202 MODBV T5DWE Calculation Variants per Entitlement ANSPR
1 PA0202 PERNR PA0003 HR Master Record: Infotype 0003 (Payroll Status) MANDT
1 PA0202 PERNR PA0003 HR Master Record: Infotype 0003 (Payroll Status) PERNR
0 PA0202 PREAS T530E Reasons for Changes MANDT
0 PA0202 PREAS T530E Reasons for Changes INFTY
0 PA0202 PREAS T530E Reasons for Changes PREAS
1 PA0202 RSTGR T5DW1 CPS Identification Features MANDT
1 PA0202 RSTGR T5DW1 CPS Identification Features GRTP4
0 PA0202 WAERS TCURC Currency Codes MANDT
0 PA0202 WAERS TCURC Currency Codes WAERS
1 PA0202 ZEINH T538A HR Time/Measurement Units MANDT
1 PA0202 ZEINH T538A HR Time/Measurement Units ZEINH