PC294 SAP (Payroll results - master data from infotypes 0461-0463) Structure details
Description: Payroll results - master data from infotypes 0461-0463
Structure field list including key, data, relationships and ABAP select examples
PC294 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 "Payroll results - master data from infotypes 0461-0463" 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_PC294 TYPE PC294.
The PC294 table consists of various fields, each holding specific information or linking keys about Payroll results - master data from infotypes 0461-0463 data available in SAP. These include BEGDA (Start Date), ENDDA (End Date), STAT2 (Employment Status), WRKAR (Province of employment).. 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: Cannot Be Enhanced
SAP PC294 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 |
CNTR1 | National assignment indicator | CNTRN | RAW | 1 | RAW1 | ||||
BEGDA | Start Date | BEGDA | DATS | 8 | DATUM | ||||
ENDDA | End Date | ENDDA | DATS | 8 | DATUM | ||||
STAT2 | Employment Status | STAT2 | CHAR | 1 | STATA | ||||
WRKAR | Province of employment | PCA_WRKAR | CHAR | 4 | Assigned to domain | PCA_WRKAR | |||
RESAR | Employment standard jurisdiction | PCA_RESAR | CHAR | 4 | Assigned to domain | PCA_WRKAR | |||
RCITY | Employment standard jurisdiction | PCA_RESAR | CHAR | 4 | Assigned to domain | PCA_WRKAR | |||
REGNR | Registration Number | PCA_REGNR | NUMC | 9 | NUMC09 | ||||
ACNBF | Account number | PCA_ACNBF | NUMC | 4 | Assigned to domain | PCA_ACNBF | |||
CGSTN | GST number | PCA_CGSTN | CHAR | 15 | PCA_CGSTN | ||||
OPTIO | Option for tax calculation | PCA_OPTIO | CHAR | 1 | PCA_OPTIO | ||||
TOTCR | Total personal tax credit amount | PCA_TOTCR | CURR | 9(2) | PCA_AMT | ||||
CLAIM | Claim Code | PCA_CLAIM | CHAR | 2 | Assigned to domain | PCA_CLAIM | |||
TNIND | Total non-indexed personal tax credit amount | PCA_TNIND | CURR | 9(2) | PCA_AMT | ||||
ADDTX | Additional tax | PCA_ADDTX | CURR | 9(2) | PCA_AMT | ||||
TEXHD | Designated area deduction | PCA_TEXHD | CURR | 9(2) | PCA_AMT | ||||
NODEP | No. of dependants under 18 yrs. | PCA_NODEP | NUMC | 2 | PCA_NODEP | ||||
NODIS | No. of dependants 18 yrs. or older and disabled | PCA_NODIS | NUMC | 2 | PCA_NODEP | ||||
MNTDE | Annual authorized federal deductions | PCA_MNTDE | CURR | 9(2) | PCA_AMT | ||||
OTXCR | Annual authorized federal tax credits | PCA_OTXCR | CURR | 9(2) | PCA_AMT | ||||
LBTCR | Amount paid for purchase of labour-sponsored funds | PCA_LBTCR | CURR | 9(2) | PCA_AMT | ||||
CRTDE | Court Order Deduction - Alimony Maintenance Payments | PCA_CRTDE | CURR | 9(2) | PCA_AMT | ||||
COMRE | Estimated total remuneration | PCA_COMRE | CURR | 9(2) | PCA_AMT | ||||
COMEX | Estimated expenses | PCA_COMEX | CURR | 9(2) | PCA_AMT | ||||
QCTXI | Taxation identification number - QC | PCA_QCTXI | CHAR | 16 | PCA_QCTXI | ||||
QGSTN | QST number - QC | PCA_QGSTN | CHAR | 16 | PCA_QGSTN | ||||
TOTCQ | Total personal tax credit amount - QC | PCA_TOTCQ | CURR | 9(2) | PCA_AMT | ||||
CLAQC | Claim code Québec | PCA_CLAQC | CHAR | 2 | Assigned to domain | PCA_CLAQC | |||
ADDTQ | Additional tax deduction - Provincial | PCA_ADDTQ | CURR | 9(2) | PCA_AMT | ||||
OTHDE | Other annual deductions and credits - QC | PCA_OTHDE | CURR | 9(2) | PCA_AMT | ||||
OTXCQ | Other annual authorized tax credits - QC | PCA_OTXCQ | CURR | 9(2) | PCA_AMT | ||||
OTADE | Other annual authorized deductions - QC | PCA_OTADE | CURR | 9(2) | PCA_AMT | ||||
COMEQ | Estimated annual net commission income - QC | PCA_COMEQ | CURR | 9(2) | PCA_AMT | ||||
MARRD | Married or equivalent-to-spouse | PCA_MARRD | CHAR | 1 | PCA_MARRD | ||||
LSTPY | Date of last irregular pay (for CPP/QPP exemption) | PCA_LSTPY | DATS | 8 | DATUM | ||||
PROVR | Province of residence | PCA_PROVR | CHAR | 4 | Assigned to domain | PCA_WRKAR | |||
WNSBN | Business Number for WCB purposes | PCA_WNSBN | CHAR | 15 | PCA_CBUSN | ||||
TOTCP | Provincial total tax credits | PCA_TOTCP | CURR | 9(2) | PCA_AMT | ||||
OTXCP | Other provincial authorized tax credits | PCA_OTXCP | CURR | 9(2) | PCA_AMT | ||||
LBTCP | Provincial Labour-Sponsored Tax Credit | PCA_LBTCP | CURR | 9(2) | PCA_AMT | ||||
PVTAX | Province of taxation (CE) | PCA_PVTAX | CHAR | 4 | Assigned to domain | PCA_PVTAX | |||
PHLTH | Province of Health Tax | PCA_PHLTH | CHAR | 4 | Assigned to domain | PCA_WRKAR |
Key field | Non-key field |
How do I retrieve data from SAP structure PC294 using ABAP code?
As PC294 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 PC294 as there is no data to select.How to access SAP table PC294
Within an ECC or HANA version of SAP you can also view further information about PC294 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