P2RD_SP SAP (Payroll Results: Special Payments) Table details
Dictionary Type: Table
Description: Payroll Results: Special Payments
Description: Payroll Results: Special Payments
Table field list including key, data, relationships and ABAP select examples
P2RD_SP is a standard SAP Table which is used to store Payroll Results: Special Payments data and is available within R/3 SAP systems depending on the version and release level.
The P2RD_SP table consists of various fields, each holding specific information or linking keys about Payroll Results: Special Payments data available in SAP. These include MANDT (Client), DCT_PERNR (Personnel Number), DCT_SEQNR (Sequence Number), DCT_ROWID (Unique Row 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: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced
SAP P2RD_SP 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 |
MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
DCT_PERNR | Personnel Number | P_PERNR | NUMC | 8 | PERNR | ||||
DCT_SEQNR | Sequence Number | CDSEQ | NUMC | 5 | HRPY_RGDIR | NUM5 | |||
DCT_ROWID | Unique Row Number | HRDCT_ROWID | NUMC | 5 | HRDCT_ROWID | ||||
SPSPL | Tax split | PRSPL | RAW | 1 | RAW1 | ||||
BEGDA | Start Date | BEGDA | DATS | 8 | DATUM | ||||
ENDDA | End Date | ENDDA | DATS | 8 | DATUM | ||||
MODSZ | Special payment modifier | SZMOD | CHAR | 4 | CHAR4 | ||||
MOLGA | Country Grouping | MOLGA | CHAR | 2 | T500L | MOLGA | MOL | ||
LGART | Wage Type | LGART | CHAR | 4 | Assigned to domain | LGART | |||
BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
WERKS | Personnel Area | PERSA | CHAR | 4 | T500P | PERSA | PBR | ||
BTRTL | Personnel Subarea | BTRTL | CHAR | 4 | T001P | BTRTL | PBS | ||
PERSG | Employee Group | PERSG | CHAR | 1 | Assigned to domain | PERSG | PRG | ||
PERSK | Employee Subgroup | PERSK | CHAR | 2 | Assigned to domain | PERSK | PKR | ||
STAT3 | Special Payment Status | STAT3 | CHAR | 1 | STATA | ||||
MASSN | Action Type | MASSN | CHAR | 2 | T529A | MASSN | |||
MASSG | Reason for Action | MASSG | CHAR | 2 | T530 | MASSG | |||
PKSYM | PS symbol | PKSY1 | CHAR | 2 | CHAR2 | ||||
BSGRD | Capacity Utilization Level | BSGRD | DEC | 5(2) | BSGRD | ||||
WAERS | Currency Key | WAERS | CUKY | 5 | TCURC | WAERS | FWS | ||
TGAEX | Exact number of days of entitlement | TGAEX | DEC | 9(4) | DEC5_4 | ||||
TGGST | Days of rounded-off standard wage type | TGGST | DEC | 9(4) | DEC5_4 | ||||
TGGSO | Days of rounded-off special wage type | TGGSO | DEC | 9(4) | DEC5_4 | ||||
TGBST | Days standard wage type paid | TGBST | DEC | 9(4) | DEC5_4 | ||||
TGBSO | Days special wage type paid | TGBSO | DEC | 9(4) | DEC5_4 | ||||
BBSTA | Gross amount for standard wage type | BBSTA | CURR | 12(2) | CURR12 | ||||
BBSON | Gross amount for special wage type | BBSON | CURR | 12(2) | CURR12 | ||||
KZSSL | Indicator: Standard/special wage type | KZSSL | CHAR | 1 | CHAR1 | ||||
AUTOM | Automatic indicator | AUTO1 | CHAR | 1 | CHAR1 | ||||
BEWG1 | Valuation basis 1 | BEWG1 | CURR | 12(2) | CURR12 | ||||
BEWG2 | Valuation basis 2 | BEWG2 | CURR | 12(2) | CURR12 | ||||
PABRJ | Payroll Year | PABRJ | NUMC | 4 | GJAHR | GJAHR | |||
PABRP | Payroll Period | PABRP | NUMC | 2 | PABRP | ||||
AKTIV | Activity status | AKTI1 | CHAR | 1 | XFELD | ||||
BETAG | Indicator: Amount-Based Adjustment | BETAG | CHAR | 1 | XFELD |
Key field | Non-key field |
How do I retrieve data from SAP table P2RD_SP using ABAP code
The following ABAP code Example will allow you to do a basic selection on P2RD_SP to SELECT all data from the tableDATA: WA_P2RD_SP TYPE P2RD_SP.
SELECT SINGLE *
FROM P2RD_SP
INTO CORRESPONDING FIELDS OF WA_P2RD_SP
WHERE...
How to access SAP table P2RD_SP
Within an ECC or HANA version of SAP you can also view further information about P2RD_SP 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