P11_P45_S SAP (HR IE: P45 SAP Script Structure) Structure details
Description: HR IE: P45 SAP Script Structure
Structure field list including key, data, relationships and ABAP select examples
P11_P45_S 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 IE: P45 SAP Script Structure" 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_P11_P45_S TYPE P11_P45_S.
The P11_P45_S table consists of various fields, each holding specific information or linking keys about HR IE: P45 SAP Script Structure data available in SAP. These include VORNA (First Name), RSINO (HR IE: PPS Number), PERNR (Personnel number), ERNIE (Employer's Registered Number).. 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 P11_P45_S 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 |
NACHN | Last Name | PAD_NACHN | CHAR | 40 | PAD_NACHN | ||||
VORNA | First Name | PAD_VORNA | CHAR | 40 | PAD_VORNM | ||||
RSINO | HR IE: PPS Number | PIE_PPSN | CHAR | 20 | CHAR20 | ||||
PERNR | Personnel number | PERSNO | NUMC | 8 | Assigned to domain | PERSNO | PER | ||
ERNIE | Employer's Registered Number | PIE_ERNIE | CHAR | 9 | PIE_ERNIE | ||||
EUNIE | Employer´s Unit Number | PIE_EUNIE | NUMC | 3 | PIE_EUNIE | ||||
PHIRE | P60-IE: Start date of work | P11_STARTD | DATS | 8 | DATUM | ||||
PFIRE | P60-IE: Leaving date | P11_LEAVED | DATS | 8 | DATUM | ||||
TXBEG | P60-IE: Start date of work | P11_STARTD | DATS | 8 | DATUM | ||||
PRTFA | HR-IE: P35L Tax Credit | P11_TFATO | CURR | 15(2) | PRBETRG | ||||
TFAFQ | HR IE: TFA frequency W eek, M onth | PIE_TFAFR | CHAR | 1 | CHAR1 | ||||
PERNO | HR IE: Number of TFA Periods | PIE_PERNO | CHAR | 2 | CHAR2 | ||||
MTFAS | Tax Credit (Monthly) | PIE_P45TF | CURR | 11(2) | PIE_CRNCY | ||||
MONUM | HR IE: P45 reporting Tax basis | P11_CHAR2 | CHAR | 2 | CHAR2 | ||||
TXBAS | HR IE: P45 reporting Tax basis | P11_CHAR2 | CHAR | 2 | CHAR2 | ||||
TXTBL | Tax Table | PIE_TXTBL | CHAR | 1 | PIE_TXTBL | ||||
CUTOF | Cut-Off Point | PIE_CUTOF | CURR | 11(2) | PIE_CRNCY | ||||
MUTOF | HR IE: Monthly Cut-Off | PIE_MUTOF | CURR | 15(2) | PRBETRG | ||||
WUTOF | HR IE: Weekly Cut-Off | PIE_WUTOF | CURR | 15(2) | PRBETRG | ||||
WTFAS | Tax Credit (Weekly) | PIE_TFAWK | CURR | 11(2) | PIE_CRNCY | ||||
DISW1 | HR IE: Disability tax wagetypes in P45 | P11_DISW1 | CURR | 11(2) | PIE_CRNCY | ||||
DISW2 | HR IE: Disability tax wagetypes in P45 | P11_DISW2 | CURR | 11(2) | PIE_CRNCY | ||||
DISW3 | HR IE: Disability tax wagetypes in P45 | P11_DISW3 | CURR | 11(2) | PIE_CRNCY | ||||
DISW4 | HR IE: Disability tax wagetypes in P45 | P11_DISW4 | CURR | 11(2) | PIE_CRNCY | ||||
WKNUM | HR IE: P45 reporting Tax basis | P11_CHAR2 | CHAR | 2 | CHAR2 | ||||
PYTO1 | HR IE: Total earnings from 1st Jan of current tax year | PIE_TEARN | CURR | 15(2) | PRBETRG | ||||
TXTO1 | HR IE: Total Tax from 1st Jan of current tax year | PIE_TTAX | CURR | 15(2) | PRBETRG | ||||
PYTO2 | HR IE: Earnings from Current Employment | PIE_CEARN | CURR | 15(2) | PRBETRG | ||||
TXTO2 | HR IE: Tax from Current Employment | PIE_CTAX | CURR | 15(2) | PRBETRG | ||||
SEQNO | Sequence Number | CDSEQ | NUMC | 5 | NUM5 | ||||
EEDOB | Date of Birth | GBDAT | DATS | 8 | PDATE | GBDAT | |||
REFUN | HR-IE: MM2 Tax refund symbol | P11_TXREF | CHAR | 1 | CHAR01 | ||||
TLUMP | HR IE: Lump Sum Payment | PIE_LSUM | CURR | 15(2) | PRBETRG | ||||
PRTOT | HR-IE: Total PRSI (EE+ER) | P11_TOPRS | CURR | 15(2) | PRBETRG | ||||
PREMP | HR-IE: Employee PRSI | P11_EEPRS | CURR | 15(2) | PRBETRG | ||||
WKSTO | HR-IE: P35L Total PRSI Weeks | P11_TWEEK | NUMC | 2 | NUMC2 | ||||
WKSTA | HR-IE: P35L Total No of Weeks at Class A or Subclass A | P11_TWCLA | NUMC | 2 | NUMC2 | ||||
CLS01 | Current PRSI Class | PIE_PRSIC | CHAR | 2 | PIE_PRSIC | ||||
WKS01 | Number of PRSI Contribution Weeks to be Allocated | PIE_STAMP | NUMC | 2 | PIE_STAMP | ||||
CLS02 | HR-IE: P35L Second PRSI Class | P11_CLAS2 | CHAR | 2 | PIE_PRSIC | ||||
WKS02 | HR-IE: P35L Number of PRSI Weeks in Second Class | P11_WEEK2 | NUMC | 2 | NUMC2 | ||||
CLS03 | HR-IE: P35L Third PRSI Class | P11_CLAS3 | CHAR | 2 | PIE_PRSIC | ||||
WKS03 | HR-IE: P35L Number of PRSI Weeks in Third Class | P11_WEEK3 | NUMC | 2 | NUMC2 | ||||
CLS04 | HR-IE: P35L Fourth PRSI Class | P11_CLAS4 | CHAR | 2 | PIE_PRSIC | ||||
WKS04 | HR-IE: P35L Number of PRSI Weeks in Fourth Class | P11_WEEK4 | NUMC | 2 | NUMC2 | ||||
CARE_OF | Name 2 | NAME2 | CHAR | 30 | TEXT30 | ||||
ADDR1 | HR-IE: Legal reporting Address line 1 | P11_ADRS1_IE | CHAR | 80 | CHAR80 | ||||
ADDR2 | HR-IE: Legal reporting Address line 2 | P11_ADRS2_IE | CHAR | 80 | CHAR80 | ||||
ADDR3 | HR-IE: Legal reporting Address line 3 | P11_ADRS3_IE | CHAR | 80 | CHAR80 | ||||
ADDR4 | HR-IE: Legal reporting Address line 4 | P11_ADRS4_IE | CHAR | 80 | CHAR80 | ||||
ER_NAME | Employer Name | PIE_ENAME | CHAR | 30 | PIE_ENAME | ||||
EEDEC | HR IE: Deceased Indicator | PIE_DECSD | CHAR | 1 | XFELD | ||||
ENAME | Formatted Name of Employee or Applicant | EMNAM | CHAR | 40 | TEXT40 | ||||
CLSOT | Current PRSI Class | PIE_PRSIC | CHAR | 2 | PIE_PRSIC | ||||
DATUM | P60-IE: Start date of work | P11_STARTD | DATS | 8 | DATUM | ||||
TOT_USC_PY | HR IE: Total USC Payable | P11_USC_PY | CURR | 15(2) | PRBETRG | ||||
TOT_USC_PD | HR IE: Total USC Paid | P11_USC_PD | CURR | 15(2) | PRBETRG | ||||
TOT_USC_PY_P45 | HR IE: Total USC Payable This Employment | P11_USC_PY_P45 | CURR | 15(2) | PRBETRG | ||||
TOT_USC_PD_P45 | HR IE: Total USC Paid this Employment | P11_USC_PD_P45 | CURR | 15(2) | PRBETRG | ||||
UTRY1 | USC Rate1 Cut Off Point ( Yearly ) | PIE_USC_TR_YR1 | CURR | 11(2) | PIE_CRNCY | ||||
UTRY2 | USC Rate2 Cut Off Point ( Yearly ) | PIE_USC_TR_YR2 | CURR | 11(2) | PIE_CRNCY | ||||
UTRM1 | USC Rate1 Cut Off Point ( Monthly ) | PIE_USC_TR_MR1 | CURR | 11(2) | PIE_CRNCY | ||||
UTRM2 | USC Rate2 Cut Off Point ( Monthly ) | PIE_USC_TR_MR2 | CURR | 11(2) | PIE_CRNCY | ||||
UTRW1 | USC Rate1 Cut Off Point ( Weekly ) | PIE_USC_TR_WR1 | CURR | 11(2) | PIE_CRNCY | ||||
UTRW2 | USC Rate2 Cut Off Point ( Weekly ) | PIE_USC_TR_WR2 | CURR | 11(2) | PIE_CRNCY | ||||
UTBAND1 | HR-IE: Legal reporting USC Band 1 | P11_UTBAND1_IE | CHAR | 10 | CHAR10 | ||||
UTBAND2 | HR-IE: Legal reporting USC Band 2 | P11_UTBAND2_IE | CHAR | 10 | CHAR10 | ||||
USCRFI | HR IE: Boolean True or False Value | PIE_BOLEAN | CHAR | 5 | CHAR5 | ||||
URAT1 | USC Rate1 Effective 2012 and onwards, | PIE_USC_RATE1 | DEC | 4(2) | DEC2_2 | ||||
URAT2 | USC Rate2 Effective 2012 and onwards, | PIE_USC_RATE2 | DEC | 4(2) | DEC2_2 | ||||
URAT3 | USC Rate3 Effective 2012 and onwards, | PIE_USC_RATE3 | DEC | 4(2) | DEC2_2 | ||||
LPT | Local Property Tax | PIE_LPTAX | CURR | 11(2) | PIE_CRNCY |
Key field | Non-key field |
How do I retrieve data from SAP structure P11_P45_S using ABAP code?
As P11_P45_S 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 P11_P45_S as there is no data to select.How to access SAP table P11_P45_S
Within an ECC or HANA version of SAP you can also view further information about P11_P45_S 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