PAYCA_NATIONAL_CE SAP (Additional tables for payroll image (Canada)) Structure details
Description: Additional tables for payroll image (Canada)
Related tables to PAYCA_NATIONAL_CE
Access table PAYCA_NATIONAL_CE
Structure field list including key, data, relationships and ABAP select examples
PAYCA_NATIONAL_CE 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 "Additional tables for payroll image (Canada)" 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_PAYCA_NATIONAL_CE TYPE PAYCA_NATIONAL_CE.
The PAYCA_NATIONAL_CE table consists of various fields, each holding specific information or linking keys about Additional tables for payroll image (Canada) data available in SAP. These include EVP (), SEQNR (Sequence Number), ABKRS (Payroll Area), FPPER (For-period for payroll).. 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 (Deep)
SAP PAYCA_NATIONAL_CE 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 |
CUMUL_TAB_ALL | 0 | ||||||||
EVP | 0 | ||||||||
SEQNR | Sequence Number | CDSEQ | NUMC | 5 | NUM5 | ||||
ABKRS | Payroll Area | ABKRS | CHAR | 2 | ABKRS | ABK | |||
FPPER | For-period for payroll | FAPER | CHAR | 6 | CHAR6 | ||||
FPBEG | Start date of payroll period (FOR period) | FPBEG | DATS | 8 | DATUM | ||||
FPEND | End of payroll period (for-period) | FPEND | DATS | 8 | DATUM | ||||
IABKRS | Payroll Area | ABKRS | CHAR | 2 | ABKRS | ABK | |||
IPERM | Period Parameters | PERMO | NUMC | 2 | PERMO | ||||
INPER | In-period for payroll | IPERI | CHAR | 6 | CHAR6 | ||||
IPEND | End of payroll period (IN period) | IPEND | DATS | 8 | DATUM | ||||
JUPER | Legal Person | JUPER | CHAR | 4 | JUPER | ||||
SRTZA | Indicator: Status of record | SRTZA | CHAR | 1 | SRTZA | ||||
PAYTY | Payroll type | PAYTY | CHAR | 1 | PAYTY | ||||
PAYID | Payroll Identifier | PAYID | CHAR | 1 | CHAR1 | ||||
VOID | Reversal Indicator | VOID | CHAR | 1 | XFELD | ||||
BONDT | Off-cycle payroll payment date | BONDT | DATS | 8 | DATUM | ||||
RUNDT | Date of payroll run | RUNDT | DATS | 8 | DATUM | ||||
RUNTM | Time of payroll run | RUNTM | TIMS | 6 | UZEIT | ||||
PERMO | Period Parameters | PERMO | NUMC | 2 | PERMO | ||||
VOIDD | Void date for payroll results | VOID_DATE | DATS | 8 | DATUM | ||||
VOIDT | Void time for payroll results | VOID_TIME | TIMS | 6 | UZEIT | ||||
VOIDR | Cancellation reason for payroll results | VOID_CODE | CHAR | 2 | VOID_CODE | ||||
PAYDT | Pay date for payroll result | PAY_DATE | DATS | 8 | DATUM | ||||
DUMMY | Indicator: Dummy result | RP_DUMMY | CHAR | 1 | XFELD | ||||
INPTY | Payroll type | PAYTY | CHAR | 1 | PAYTY | ||||
INPID | Payroll Identifier | PAYID | CHAR | 1 | CHAR1 | ||||
OCRSN | Reason for Off-Cycle Payroll | PAY_OCRSN | CHAR | 4 | PAY_OCRSN | OCR | |||
INOCR | Reason for Off-Cycle Payroll | PAY_OCRSN | CHAR | 4 | PAY_OCRSN | OCR | |||
OCCAT | Category for off-cycle reason | PAY_OCCAT | CHAR | 2 | PAY_OCCAT | ||||
INOCC | Category for off-cycle reason | PAY_OCCAT | CHAR | 2 | PAY_OCCAT | ||||
REVERSAL | Reversal Indicator | VOID | CHAR | 1 | XFELD | ||||
OUTOFSEQ | Out-Of-Sequence-Check Indicator | PAY_OUTOFSEQ | CHAR | 1 | PAY_OUTOFSEQ | ||||
OOSDATE | Create Out-Of-Sequence Check (acc. to Payroll Control Rec.) | PAY_OOSDATE | DATS | 8 | DATUM | ||||
ARC_GROUP | Archiving Group | ARC_GROUP | NUMC | 6 | NUM06 | ||||
CALCD | Payroll Already Run for Indicator Period | CALCD | CHAR | 1 | CALCD | ||||
PERSON | Technical Person Number | PERSONID | NUMC | 8 | PERSONID | ||||
PERSDATA | Personnel Number | PERNR_D | NUMC | 8 | PERNR | PER | |||
BRACKET | Bracket for a Period and its Supplementals | PAY_BRACKET | NUMC | 5 | NUMC5 | ||||
INTER | 0 | ||||||||
VERSION | 0 | ||||||||
SAPRL | Release of SAP System | SYSAPRL | CHAR | 4 | SYCHAR04 | ||||
NUMBER | HR version number | RPVNR | RAW | 1 | RAW1 | ||||
UNAME | User Name | UNAME | CHAR | 12 | UNAME | ||||
DATUM | Date | DATUM | DATS | 8 | DATUM | ||||
UZEIT | Time | UZEIT | TIMS | 6 | UZEIT | ||||
PGMID | ABAP Program Name | PROGNAME | CHAR | 40 | PROGNAME | ||||
SCHEM | Personnel calculation schema | SCHEM | CHAR | 4 | CSCHM | SCE | |||
VERSC | 0 | ||||||||
MOLGA | Country Grouping | MOLGA | CHAR | 2 | MOLGA | MOL | |||
ABKRS | Payroll Area | ABKRS | CHAR | 2 | ABKRS | ABK | |||
JUPER | Legal Person | JUPER | CHAR | 4 | JUPER | ||||
WAERS | Currency Key | WAERS | CUKY | 5 | WAERS | FWS | |||
GROSS | Payroll performed for gross part | BRUTTO | CHAR | 1 | XFELD | ||||
GDATE | Retro.acct.for gross part as of | BRDAT | DATS | 8 | DATUM | ||||
NET | Payroll performed for net part | NETTO | CHAR | 1 | XFELD | ||||
NDATE | Retro.acct.for net part as of | NDATE | DATS | 8 | DATUM | ||||
FPBEG | Start date of payroll period (FOR period) | FPBEG | DATS | 8 | DATUM | ||||
FPEND | End of payroll period (for-period) | FPEND | DATS | 8 | DATUM | ||||
IPERM | Period modifier | IPERM | CHAR | 2 | CHAR2 | ||||
INPER | In-period for payroll | IPERI | CHAR | 6 | CHAR6 | ||||
BONDT | Off-cycle payroll payment date | BONDT | DATS | 8 | DATUM | ||||
PAYTY | Payroll type | PAYTY | CHAR | 1 | PAYTY | ||||
PAYID | Payroll Identifier | PAYID | CHAR | 1 | CHAR1 | ||||
VOID | Reversal Indicator | VOID | CHAR | 1 | XFELD | ||||
VOIDD | Void date for payroll results | VOID_DATE | DATS | 8 | DATUM | ||||
VOIDT | Void time for payroll results | VOID_TIME | TIMS | 6 | UZEIT | ||||
VOIDR | Cancellation reason for payroll results | VOID_CODE | CHAR | 2 | VOID_CODE | ||||
PAYDT | Pay date for payroll result | PAY_DATE | DATS | 8 | DATUM | ||||
FPPER | For-period for payroll | FAPER | CHAR | 6 | CHAR6 | ||||
PERMO | Period Parameters | PERMO | NUMC | 2 | PERMO | ||||
INPTY | Payroll type | PAYTY | CHAR | 1 | PAYTY | ||||
INPID | Payroll Identifier | PAYID | CHAR | 1 | CHAR1 | ||||
IPEND | End of payroll period (IN period) | IPEND | DATS | 8 | DATUM | ||||
RUNDT | Date of payroll run | RUNDT | DATS | 8 | DATUM | ||||
RUNTM | Time of payroll run | RUNTM | TIMS | 6 | UZEIT | ||||
IABKRS | Payroll subunit IP | IABKR | CHAR | 2 | ABKRS | ||||
OCRSN | Reason for Off-Cycle Payroll | PAY_OCRSN | CHAR | 4 | PAY_OCRSN | OCR | |||
INOCR | Reason for Off-Cycle Payroll | PAY_OCRSN | CHAR | 4 | PAY_OCRSN | OCR | |||
OCCAT | Category for off-cycle reason | PAY_OCCAT | CHAR | 2 | PAY_OCCAT | ||||
INOCC | Category for off-cycle reason | PAY_OCCAT | CHAR | 2 | PAY_OCCAT | ||||
REVERSAL | Reversal Indicator | VOID | CHAR | 1 | XFELD | ||||
OUTOFSEQ | Out-Of-Sequence-Check Indicator | PAY_OUTOFSEQ | CHAR | 1 | PAY_OUTOFSEQ | ||||
OOSDATE | Create Out-Of-Sequence Check (acc. to Payroll Control Rec.) | PAY_OOSDATE | DATS | 8 | DATUM | ||||
PERSON | Technical Person Number | PERSONID | NUMC | 8 | PERSONID | ||||
PERSDATA | Personnel Number | PERNR_D | NUMC | 8 | PERNR | PER | |||
BRACKET | Bracket for a Period and its Supplementals | PAY_BRACKET | NUMC | 5 | NUMC5 | ||||
WPBP | 0 | ||||||||
ABC | 0 | ||||||||
RT | 0 | ||||||||
CRT | 0 | ||||||||
BT | 0 | ||||||||
C0 | 0 | ||||||||
C1 | 0 | ||||||||
V0 | 0 | ||||||||
VCP | 0 | ||||||||
ALP | 0 | ||||||||
DFT | 0 | ||||||||
GRT | 0 | ||||||||
LS | 0 | ||||||||
STATUS | 0 | ||||||||
SW01 | Status | PRSTA | CHAR | 1 | CHAR1 | ||||
SW02 | Status | PRSTA | CHAR | 1 | CHAR1 | ||||
SW03 | Status | PRSTA | CHAR | 1 | CHAR1 | ||||
SW04 | Status | PRSTA | CHAR | 1 | CHAR1 | ||||
SW05 | Status | PRSTA | CHAR | 1 | CHAR1 | ||||
SW06 | Status | PRSTA | CHAR | 1 | CHAR1 | ||||
SW07 | Status | PRSTA | CHAR | 1 | CHAR1 | ||||
SW08 | Status | PRSTA | CHAR | 1 | CHAR1 | ||||
ARRRS | 0 | ||||||||
DDNTK | 0 | ||||||||
ACCR | 0 | ||||||||
BENTAB | 0 | ||||||||
AB | 0 | ||||||||
FUND | 0 | ||||||||
AVERAGE | 0 | ||||||||
MODIF | 0 | ||||||||
RT_GP | 0 | ||||||||
CODIST | 0 | ||||||||
LIFL | 0 | ||||||||
LIDI | 0 | ||||||||
NAT | 0 | ||||||||
NAME | 0 | ||||||||
NACHN | Last Name | PAD_NACHN | CHAR | 40 | PAD_NACHN | ||||
VORNA | First Name | PAD_VORNA | CHAR | 40 | PAD_VORNM | ||||
ANRED | Form-of-Address Key | ANRDE | CHAR | 1 | ANRDE | ||||
INITS | Initials | INITS | CHAR | 10 | TEXT10 | ||||
ADR | 0 | ||||||||
STRAS | Street and House Number | PAD_STRAS | CHAR | 60 | PAD_STRAS | ||||
LOCAT | 2nd Address Line | LOCAT | CHAR | 30 | TEXT30 | ||||
ORT01 | City | PAD_ORT01 | CHAR | 40 | PAD_ORT01 | ||||
ORT02 | District | PAD_ORT02 | CHAR | 40 | PAD_ORT01 | ||||
STATE | STATE (State, Province, County) | REGIO | CHAR | 3 | REGIO | ||||
PSTLZ | Postal Code | PSTLZ_HR | CHAR | 10 | PSTLZ | ||||
LAND1 | Country Key | LAND1 | CHAR | 3 | LAND1 | LND | |||
PERM | 0 | ||||||||
GESCH | Gender Key | GESCH | CHAR | 1 | GESCH | ||||
GBDAT | Date of Birth | GBDAT | DATS | 8 | PDATE | GBDAT | |||
PERID | Personnel ID Number | PRDNI | CHAR | 20 | CHAR20 | ||||
TXCMP | Tax company | TXCMP | CHAR | 4 | TXCMP | ||||
TCCPM | Common Paymaster Tax Company | P10_COMPM | CHAR | 4 | TXCMP | ||||
TAX1 | 0 | ||||||||
TAXO | 0 | ||||||||
TAX2 | 0 | ||||||||
TAXI | 0 | ||||||||
TCRT | 0 | ||||||||
TCRTI | 0 | ||||||||
ROE | 0 | ||||||||
VC1 | 0 | ||||||||
VC2 | 0 | ||||||||
CUST | 0 | ||||||||
GRORD | 0 | ||||||||
GRDBT | 0 | ||||||||
GRREC | 0 | ||||||||
GRCUM | 0 | ||||||||
DOWP | 0 | ||||||||
DOC0 | 0 | ||||||||
WCB1 | 0 | ||||||||
WTDT | 0 | ||||||||
IT_DIFF | 0 | ||||||||
TAXA | 0 | ||||||||
NUMPY | Integer 1 | INTEGER1 | INT1 | 3 | INT1 | ||||
NUMPR | Integer 1 | INTEGER1 | INT1 | 3 | INT1 | ||||
NUMPM | Integer 1 | INTEGER1 | INT1 | 3 | INT1 | ||||
AGEEE | Integer 1 | INTEGER1 | INT1 | 3 | INT1 | ||||
DISAB | Tax indicator / exemption code | PCA_EXIND | CHAR | 1 | PCA_EXIND | ||||
ICFED | Tax indicator / exemption code | PCA_EXIND | CHAR | 1 | PCA_EXIND | ||||
ICPRV | Tax indicator / exemption code | PCA_EXIND | CHAR | 1 | PCA_EXIND | ||||
ICCPP | Tax indicator / exemption code | PCA_EXIND | CHAR | 1 | PCA_EXIND | ||||
ICEI | Tax indicator / exemption code | PCA_EXIND | CHAR | 1 | PCA_EXIND | ||||
LSTPY | Date of last irregular pay (for CPP/QPP exemption) | PCA_LSTPY | DATS | 8 | DATUM | ||||
NXT_CHKDT | Date | PCA_CDATE | DATS | 8 | DATUM | ||||
NXT_PBEGD | Start Date | BEGDA | DATS | 8 | DATUM | ||||
NXT_PENDD | End Date | ENDDA | DATS | 8 | DATUM | ||||
NXT_PERMO | Period Parameters | PERMO | NUMC | 2 | PERMO | ||||
NXT_PABRJ | Payroll Year | PABRJ | NUMC | 4 | GJAHR | GJAHR | |||
NXT_PABRP | Payroll Period | PABRP | NUMC | 2 | PABRP | ||||
ICPPIP | Tax indicator / exemption code | PCA_EXIND | CHAR | 1 | PCA_EXIND | ||||
ICQHC | Tax indicator / exemption code | PCA_EXIND | CHAR | 1 | PCA_EXIND | ||||
BPIT | 0 | ||||||||
LVC1 | 0 | ||||||||
LVC2 | 0 | ||||||||
LROE | 0 | ||||||||
LTAXI | 0 | ||||||||
TAXO_RT | 0 | ||||||||
XTBLGART | 0 |
Key field | Non-key field |
How do I retrieve data from SAP structure PAYCA_NATIONAL_CE using ABAP code?
As PAYCA_NATIONAL_CE 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 PAYCA_NATIONAL_CE as there is no data to select.How to access SAP table PAYCA_NATIONAL_CE
Within an ECC or HANA version of SAP you can also view further information about PAYCA_NATIONAL_CE 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