P05_PENSIOEN SAP (Structure for Pension Accounting (NL)) Structure details
Description: Structure for Pension Accounting (NL)
Structure field list including key, data, relationships and ABAP select examples
P05_PENSIOEN 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 "Structure for Pension Accounting (NL)" 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_P05_PENSIOEN TYPE P05_PENSIOEN.
The P05_PENSIOEN table consists of various fields, each holding specific information or linking keys about Structure for Pension Accounting (NL) data available in SAP. These include PENSK (Pension Indicator), ENDDA (End Date), BEGDA (Start Date), PENRG (Pension Scheme).. 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 P05_PENSIOEN 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 |
PERNR | Personnel Number | P_PERNR | NUMC | 8 | PERNR | ||||
PENSK | Pension Indicator | P05_PENSK | CHAR | 3 | PENSK | ||||
ENDDA | End Date | ENDDA | DATS | 8 | DATUM | ||||
BEGDA | Start Date | BEGDA | DATS | 8 | DATUM | ||||
PENRG | Pension Scheme | P05_PENRG | CHAR | 3 | P05_PENRG | P05_PENRG | |||
LCGSL | Wage Type for Pensionable Salary | P05_LCGSL | CHAR | 4 | Assigned to domain | LGART | |||
LCHPG | Wage Type for 100% Pensionable Salary | P05_LCHPG | CHAR | 4 | Assigned to domain | LGART | |||
LCVRG | Wage Type for Variable Part of Pensionable Salary | P05_LCVRG | CHAR | 4 | Assigned to domain | LGART | |||
LCVSG | Wage Type for Fixed Part of Pensionable Salary | P05_LCVSG | CHAR | 4 | Assigned to domain | LGART | |||
LCGBB | Wage Type for Pensionable Salary SP | P05_LCGBB | CHAR | 4 | Assigned to domain | LGART | |||
LCPGS_WG | Wage Type for Pensionable Salary ER | P05_LCPGS_WG | CHAR | 4 | Assigned to domain | LGART | |||
LCPGS_WN | Wage Type for Pensionable Salary EE | P05_LCPGS_WN | CHAR | 4 | Assigned to domain | LGART | |||
LCPWG | Wage Type for ER Contribution | P05_LCPWG | CHAR | 4 | Assigned to domain | LGART | |||
LCPWN | Wage Type for EE Contribution | P05_LCPWN | CHAR | 4 | Assigned to domain | LGART | |||
LCPWN_BB | Wage Type EE Contribution SP | P05_LCPWN_BB | CHAR | 4 | Assigned to domain | LGART | |||
LCPTP | Wage Type for Part-time Percentage | P05_LCPTP | CHAR | 4 | Assigned to domain | LGART | |||
PP_WG | ER Contribution Percentage | P05_PPWG | DEC | 7(4) | P05_PPWG | ||||
PP_WN | EE Contribution Percentage | P05_PPWN | DEC | 7(4) | P05_PPWN | ||||
OPWG1 | Increment Percentage for Annual Salary | P05_OPWG | DEC | 7(4) | P05_OPWG | ||||
OPWG2 | Increment Percentage for Annual Salary | P05_OPWG | DEC | 7(4) | P05_OPWG | ||||
OPWN1 | Increment Percentage for Annual Salary Plus 1st Increment | P05_OPWN | DEC | 7(4) | P05_OPWN | ||||
OPWN2 | Increment Percentage for Annual Salary Plus 1st Increment | P05_OPWN | DEC | 7(4) | P05_OPWN | ||||
OWGMN | Minimum Increment 1 | P05_OPWGMN | CURR | 9(2) | P05_OPWGMN | ||||
OWGMX | Maximum Increment 1 | P05_OPWGMX | CURR | 9(2) | P05_OPWGMX | ||||
OWNMN | Minimum Increment 2 | P05_OPWNMN | CURR | 9(2) | P05_OPWNMN | ||||
OWNMX | Maximum Increment 2 | P05_OPWNMX | CURR | 9(2) | P05_OPWNMX | ||||
MXGWG | Maximum Pensionable Salary ER | P05_MXGWG | CURR | 9(2) | P05_MXGWG | ||||
MXGWN | Maximum Pensionable Salary EE | P05_MXGWN | CURR | 9(2) | P05_MXGWN | ||||
MNGWG | Minimum Pensionable Salary ER | P05_MNGWG | CURR | 9(2) | P05_MNGWG | ||||
MNGWN | Minimum Pensionable Salary EE | P05_MNGWN | CURR | 9(2) | P05_MNGWN | ||||
MXPWG | Maximum ER Contribution | P05_MXPWG | CURR | 9(2) | P05_MXPWG | ||||
MXPWN | Maximum EE Contribution | P05_MXPWN | CURR | 9(2) | P05_MXPWN | ||||
MNPWG | Minimum ER Contribution | P05_MNPWG | CURR | 9(2) | P05_MNPWG | ||||
MNPWN | Minimum EE Contribution | P05_MNPWN | CURR | 9(2) | P05_MNPWN | ||||
FRCWG | Employer 'Franchise' (Port.of Sal.Disreg.in Calc.Pens.Contr) | P05_FRCWG | CURR | 9(2) | P05_FRCWG | ||||
FRCWN | Employee 'Franchise' (Port.of Sal.Disreg.in Calc.Pens.Contr) | P05_FRCWN | CURR | 9(2) | P05_FRCWN | ||||
VPAWG | Fixed ER Contribution Allowance | P05_VPAWG | CURR | 9(2) | P05_VPAWG | ||||
VPAWN | Fixed EE Contribution Allowance | P05_VPAWN | CURR | 9(2) | P05_VPAWN | ||||
AWGWN | Employer's Share in EE Contribution | P05_AWGWN | DEC | 7(4) | P05_DEC7_4 | ||||
APSJB | Payroll Period Start Annual Accounting | P05_APSJB | NUMC | 2 | P05_APSJB | ||||
MNLFT | Minimum Age | LEEF2 | DEC | 3 | DEC3 | ||||
LFTBM | Age Determination Date | P05_LFTBM | CHAR | 1 | P05_LFTBM | ||||
STLFT | Age for Pensionable Salary Freeze | STLFT | DEC | 3 | DEC3 | ||||
STPCT | Increase Percentage for Pensionable Salary | P05_STPCT | DEC | 7(4) | P05_STPCT | ||||
STPRD | Increase Period | P05_STPRD | NUMC | 2 | P05_STPRD | ||||
PTBER | Part-time Calculation Method | P05_PTBER | CHAR | 1 | P05_PTBER | ||||
RKHER | Routine Indicator for Cumulative Retroactive Accounting | P05_RKHER | CHAR | 1 | P05_RKHER | ||||
RCODE | Routine Indicator | P05_RCODE | CHAR | 3 | Assigned to domain | P05_RCODE | |||
CUMHB | Cumulative Retroactive Accounting | P05_CUMHB | CHAR | 1 | P05_CUMHB | ||||
NRATO | Factoring | P05_NRATO | CHAR | 1 | CHAR1 | ||||
AFRPG | Rounding Method for Pensionable Salary | P05_AFRPG | CHAR | 1 | P05_AFRND | ||||
AFRWG | Rounding Method ER Contribution | P05_AFRWG | CHAR | 1 | P05_AFRND | ||||
AFRWN | Rounding Method EE Contribution | P05_AFRWN | CHAR | 1 | P05_AFRND | ||||
CLCPS | Wage Type Code for Pensionable Salary | P05_CLCPS | CHAR | 1 | P05_CLCPS | ||||
PARM1 | First parameter | PARM1 | CHAR | 4 | PARMS | ||||
TIJDV | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
PERMO | Period Parameters | PERMO | NUMC | 2 | Assigned to domain | PERMO | |||
PABRJ | Payroll year for determining time period | PNPPABRJ | NUMC | 4 | GJAHR | GJAHR | |||
PABRP | Payroll period for determining time period | PNPPABRP | NUMC | 2 | PABRP | ||||
LABRP | Payroll period for determining time period | PNPPABRP | NUMC | 2 | PABRP | ||||
PERIODES | Numc3, internal use | NUMC3 | NUMC | 3 | NUMC3 | ||||
TEILK | Indicator Part-Time Employee | TEILK | CHAR | 1 | XFELD | ||||
HIRE | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
FIRE | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
EINTRITT | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
AUSTRITT | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
HIRE_DATE | Field of type DATS | DATS | DATS | 8 | DATS | ||||
FIRE_DATE | Field of type DATS | DATS | DATS | 8 | DATS | ||||
CALCULATE | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
SVDAY | Indicator for Calculation of SI Days | P05_SVDAY | CHAR | 1 | P05_SVDAY | ||||
SVWNB | HR payroll: Number | PRANZ | DEC | 15(2) | PRANZHL | ||||
SVWRB | HR payroll: Number | PRANZ | DEC | 15(2) | PRANZHL | ||||
SVWPP | HR payroll: Number | PRANZ | DEC | 15(2) | PRANZHL | ||||
SVDPP | HR payroll: Number | PRANZ | DEC | 15(2) | PRANZHL | ||||
SVWDV | HR payroll: Number | PRANZ | DEC | 15(2) | PRANZHL | ||||
SVWDK | HR payroll: Number | PRANZ | DEC | 15(2) | PRANZHL | ||||
SVB1J | HR payroll: Number | PRANZ | DEC | 15(2) | PRANZHL | ||||
SVBPP | HR payroll: Number | PRANZ | DEC | 15(2) | PRANZHL | ||||
WKWDY | Weekly Workdays | WARST | DEC | 4(2) | DEC2_2 | ||||
LEEFTIJD | Minimum Age | LEEF2 | DEC | 3 | DEC3 | ||||
PTP | HR payroll: Number | PRANZ | DEC | 15(2) | PRANZHL | ||||
OPTP | HR payroll: Number | PRANZ | DEC | 15(2) | PRANZHL | ||||
PWG | HR Payroll: Amount | MAXBT | CURR | 15(2) | PRBETRG | ||||
PWN | HR Payroll: Amount | MAXBT | CURR | 15(2) | PRBETRG | ||||
PWN_BB | HR Payroll: Amount | MAXBT | CURR | 15(2) | PRBETRG | ||||
PGSL_OLD | HR Payroll: Amount | MAXBT | CURR | 15(2) | PRBETRG | ||||
HPGS_OLD | HR Payroll: Amount | MAXBT | CURR | 15(2) | PRBETRG | ||||
PGSL_NEW | HR Payroll: Amount | MAXBT | CURR | 15(2) | PRBETRG | ||||
HPGS_NEW | HR Payroll: Amount | MAXBT | CURR | 15(2) | PRBETRG | ||||
PGBB_NEW | HR Payroll: Amount | MAXBT | CURR | 15(2) | PRBETRG | ||||
VRGSL | HR Payroll: Amount | MAXBT | CURR | 15(2) | PRBETRG | ||||
VSGSL | HR Payroll: Amount | MAXBT | CURR | 15(2) | PRBETRG | ||||
CUM_PR_WG | HR Payroll: Amount | MAXBT | CURR | 15(2) | PRBETRG | ||||
CUM_PR_WN | HR Payroll: Amount | MAXBT | CURR | 15(2) | PRBETRG | ||||
CUM_PTP | HR payroll: Number | PRANZ | DEC | 15(2) | PRANZHL | ||||
PGSWG | HR Payroll: Amount | MAXBT | CURR | 15(2) | PRBETRG | ||||
PGSWN | HR Payroll: Amount | MAXBT | CURR | 15(2) | PRBETRG | ||||
CUMHB_IP | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
NABRJ | Payroll year for determining time period | PNPPABRJ | NUMC | 4 | GJAHR | GJAHR | |||
NABRP | Payroll period for determining time period | PNPPABRP | NUMC | 2 | PABRP | ||||
CUM_KAL | HR payroll: Number | PRANZ | DEC | 15(2) | PRANZHL | ||||
CUM_WDG | HR payroll: Number | PRANZ | DEC | 15(2) | PRANZHL | ||||
CUM_360 | HR payroll: Number | PRANZ | DEC | 15(2) | PRANZHL | ||||
WDG | HR payroll: Number | PRANZ | DEC | 15(2) | PRANZHL | ||||
KAL | HR payroll: Number | PRANZ | DEC | 15(2) | PRANZHL | ||||
D360 | Natural Number | INT4 | INT4 | 10 | INT4 | ||||
CUM_PGSL | HR Payroll: Amount | MAXBT | CURR | 15(2) | PRBETRG | ||||
CUM_PGBB | HR Payroll: Amount | MAXBT | CURR | 15(2) | PRBETRG | ||||
CUM_VRGSL | HR Payroll: Amount | MAXBT | CURR | 15(2) | PRBETRG | ||||
CUM_VSGSL | HR Payroll: Amount | MAXBT | CURR | 15(2) | PRBETRG | ||||
CUM_PER | HR payroll: Number | PRANZ | DEC | 15(2) | PRANZHL | ||||
PER | HR payroll: Number | PRANZ | DEC | 15(2) | PRANZHL | ||||
CUM_PERIODE | HR payroll: Number | PRANZ | DEC | 15(2) | PRANZHL | ||||
CUM_FACT | HR payroll: Number | PRANZ | DEC | 15(2) | PRANZHL | ||||
CUM_FACT_2 | HR payroll: Number | PRANZ | DEC | 15(2) | PRANZHL | ||||
BETDA | End Date | ENDDA | DATS | 8 | DATUM | ||||
LEEFTIJD_VP | Minimum Age | LEEF2 | DEC | 3 | DEC3 | ||||
1ST_PART | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
LCJGS | Wage type annual basis (100%) | P05_LCJGS | CHAR | 4 | Assigned to domain | LGART | |||
JRGSL | HR Payroll: Amount | MAXBT | CURR | 15(2) | PRBETRG | ||||
CUM_PTP_OLD | HR payroll: Number | PRANZ | DEC | 15(2) | PRANZHL | ||||
CUM_PGSL_200 | HR Payroll: Amount | MAXBT | CURR | 15(2) | PRBETRG | ||||
CUM_PGBB_200 | HR Payroll: Amount | MAXBT | CURR | 15(2) | PRBETRG | ||||
ECCPB | Exclude Company Car from Pensionable Wage | P05_EXCLUDE_COMP_CAR | CHAR | 1 | XFELD |
Key field | Non-key field |
How do I retrieve data from SAP structure P05_PENSIOEN using ABAP code?
As P05_PENSIOEN 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 P05_PENSIOEN as there is no data to select.How to access SAP table P05_PENSIOEN
Within an ECC or HANA version of SAP you can also view further information about P05_PENSIOEN and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects