SAP Table PC22T

Payroll Results: Tax (U.S.)

PC22T (Payroll Results: Tax (U.S.)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link PC22T to other SAP tables.

PC22T table fields

Field Data element Checktable Datatype Length Decimals
CNTR1 SI split CNTR1 RAW 1 0
TAXLV Tax level TXLEV CHAR 1 0
A Federal
B State
C County
D City
E School District
F Other
TAXAU Tax authority TAXAT CHAR 4 0
TXSTA Filing status TXSTA_D NUMC 2 0
NBREX Number of exemptions NBREX NUMC 2 0
EICID Indicator: EIC EICID CHAR 1 0
X Yes
NULL No
EXAMT Additional tax amount EXAMT CURR 9 2
EXPCT Additional tax percentage EXPCT DEC 5 2
ADEXN Number of additional exemptions ADEXN NUMC 2 0
ADEXA Total additional exemption amount ADEXA CURR 9 2
AMTEX Exemption amount AMTEX CURR 9 2
PEREX Number of personal exemptions PERE1 NUMC 2 0
DEPEX Number of dependent exemptions DEPEX NUMC 2 0
EICST EIC status EICST CHAR 1 0
0 Not applicable
1 Single, head of household or qualifying widow(er)
2 Married, filing jointly, both spouses filing Form W-5
3 Married, filing jointly, spouse not filing Form W-5
EXTCD Addtional tax exempt amount code EXTCD NUMC 1 0
SUPCD Supplemental method SUPCD CHAR 2 0
NULL
00 Regular Method
01 Flat-Rate Method
02 Separate Aggregation Method
03 Rate-Table Method
04 Cummulative Method
05 Aggregation with Pay Periods Method
06 Wage Associated Method
07 Concurrent Method
08 Regular Method without Exemption
09 System-Selected Method
10 Commission Method
RECIN Reciprocity indicator RECIN CHAR 1 0
0 Do NOT perform reciprocal calculations
1 Perform reciprocal calculation
NULL Use system-level default
CERTF Certificate status CERTF NUMC 1 0
0 No certificate
1 Certificate of non-residence
2 Exempt from withholding
3 Withholding tax credit
TXCRD Tax credit balance TXCRD CURR 9 2
IRSTS Tax status TXSTA_CHAR CHAR 2 0
IRSNE Number of exemptions NBREX_CHAR CHAR 2 0
IRSAE Exemption amount AMTEX CURR 9 2
RSIND Letter PABCD_D CHAR 1 0
WKIND Letter PABCD_D CHAR 1 0
UIIND Letter PABCD_D CHAR 1 0
TYP01 Tax type TAXTY NUMC 2 0
FRM01 Formula number FRMNR NUMC 1 0
1 Formula one
2 Formula two
3 Formula three
4 Formula four
5 Formula five
6 Formula six
EXP01 Tax exemption indicator EXEMP CHAR 1 0
Y Exempt, not reportable
R Exempt, reportable
X Exempt, partly reportable
NULL Not exempt
TYP02 Tax type TAXTY NUMC 2 0
FRM02 Formula number FRMNR NUMC 1 0
1 Formula one
2 Formula two
3 Formula three
4 Formula four
5 Formula five
6 Formula six
EXP02 Tax exemption indicator EXEMP CHAR 1 0
Y Exempt, not reportable
R Exempt, reportable
X Exempt, partly reportable
NULL Not exempt
TYP03 Tax type TAXTY NUMC 2 0
FRM03 Formula number FRMNR NUMC 1 0
1 Formula one
2 Formula two
3 Formula three
4 Formula four
5 Formula five
6 Formula six
EXP03 Tax exemption indicator EXEMP CHAR 1 0
Y Exempt, not reportable
R Exempt, reportable
X Exempt, partly reportable
NULL Not exempt
TYP04 Tax type TAXTY NUMC 2 0
FRM04 Formula number FRMNR NUMC 1 0
1 Formula one
2 Formula two
3 Formula three
4 Formula four
5 Formula five
6 Formula six
EXP04 Tax exemption indicator EXEMP CHAR 1 0
Y Exempt, not reportable
R Exempt, reportable
X Exempt, partly reportable
NULL Not exempt
TYP05 Tax type TAXTY NUMC 2 0
FRM05 Formula number FRMNR NUMC 1 0
1 Formula one
2 Formula two
3 Formula three
4 Formula four
5 Formula five
6 Formula six
EXP05 Tax exemption indicator EXEMP CHAR 1 0
Y Exempt, not reportable
R Exempt, reportable
X Exempt, partly reportable
NULL Not exempt
TYP06 Tax type TAXTY NUMC 2 0
FRM06 Formula number FRMNR NUMC 1 0
1 Formula one
2 Formula two
3 Formula three
4 Formula four
5 Formula five
6 Formula six
EXP06 Tax exemption indicator EXEMP CHAR 1 0
Y Exempt, not reportable
R Exempt, reportable
X Exempt, partly reportable
NULL Not exempt
TYP07 Tax type TAXTY NUMC 2 0
FRM07 Formula number FRMNR NUMC 1 0
1 Formula one
2 Formula two
3 Formula three
4 Formula four
5 Formula five
6 Formula six
EXP07 Tax exemption indicator EXEMP CHAR 1 0
Y Exempt, not reportable
R Exempt, reportable
X Exempt, partly reportable
NULL Not exempt
TYP08 Tax type TAXTY NUMC 2 0
FRM08 Formula number FRMNR NUMC 1 0
1 Formula one
2 Formula two
3 Formula three
4 Formula four
5 Formula five
6 Formula six
EXP08 Tax exemption indicator EXEMP CHAR 1 0
Y Exempt, not reportable
R Exempt, reportable
X Exempt, partly reportable
NULL Not exempt
TYP09 Tax type TAXTY NUMC 2 0
FRM09 Formula number FRMNR NUMC 1 0
1 Formula one
2 Formula two
3 Formula three
4 Formula four
5 Formula five
6 Formula six
EXP09 Tax exemption indicator EXEMP CHAR 1 0
Y Exempt, not reportable
R Exempt, reportable
X Exempt, partly reportable
NULL Not exempt
TYP10 Tax type TAXTY NUMC 2 0
FRM10 Formula number FRMNR NUMC 1 0
1 Formula one
2 Formula two
3 Formula three
4 Formula four
5 Formula five
6 Formula six
EXP10 Tax exemption indicator EXEMP CHAR 1 0
Y Exempt, not reportable
R Exempt, reportable
X Exempt, partly reportable
NULL Not exempt
TYP11 Tax type TAXTY NUMC 2 0
FRM11 Formula number FRMNR NUMC 1 0
1 Formula one
2 Formula two
3 Formula three
4 Formula four
5 Formula five
6 Formula six
EXP11 Tax exemption indicator EXEMP CHAR 1 0
Y Exempt, not reportable
R Exempt, reportable
X Exempt, partly reportable
NULL Not exempt
TYP12 Tax type TAXTY NUMC 2 0
FRM12 Formula number FRMNR NUMC 1 0
1 Formula one
2 Formula two
3 Formula three
4 Formula four
5 Formula five
6 Formula six
EXP12 Tax exemption indicator EXEMP CHAR 1 0
Y Exempt, not reportable
R Exempt, reportable
X Exempt, partly reportable
NULL Not exempt
TYP13 Tax type TAXTY NUMC 2 0
FRM13 Formula number FRMNR NUMC 1 0
1 Formula one
2 Formula two
3 Formula three
4 Formula four
5 Formula five
6 Formula six
EXP13 Tax exemption indicator EXEMP CHAR 1 0
Y Exempt, not reportable
R Exempt, reportable
X Exempt, partly reportable
NULL Not exempt
TYP14 Tax type TAXTY NUMC 2 0
FRM14 Formula number FRMNR NUMC 1 0
1 Formula one
2 Formula two
3 Formula three
4 Formula four
5 Formula five
6 Formula six
EXP14 Tax exemption indicator EXEMP CHAR 1 0
Y Exempt, not reportable
R Exempt, reportable
X Exempt, partly reportable
NULL Not exempt
TYP15 Tax type TAXTY NUMC 2 0
FRM15 Formula number FRMNR NUMC 1 0
1 Formula one
2 Formula two
3 Formula three
4 Formula four
5 Formula five
6 Formula six
EXP15 Tax exemption indicator EXEMP CHAR 1 0
Y Exempt, not reportable
R Exempt, reportable
X Exempt, partly reportable
NULL Not exempt
TCCPM Common Paymaster Tax Company P10_COMPM CHAR 4 0
NBQLC Number of Qualifying Children P10_NBQLC NUMC 2 0
FNR01 Formula number P10_BSIFORMULA CHAR 1 0
FNR02 Formula number P10_BSIFORMULA CHAR 1 0
FNR03 Formula number P10_BSIFORMULA CHAR 1 0
FNR04 Formula number P10_BSIFORMULA CHAR 1 0
FNR05 Formula number P10_BSIFORMULA CHAR 1 0
FNR06 Formula number P10_BSIFORMULA CHAR 1 0
FNR07 Formula number P10_BSIFORMULA CHAR 1 0
FNR08 Formula number P10_BSIFORMULA CHAR 1 0
FNR09 Formula number P10_BSIFORMULA CHAR 1 0
FNR10 Formula number P10_BSIFORMULA CHAR 1 0
FNR11 Formula number P10_BSIFORMULA CHAR 1 0
FNR12 Formula number P10_BSIFORMULA CHAR 1 0
FNR13 Formula number P10_BSIFORMULA CHAR 1 0
FNR14 Formula number P10_BSIFORMULA CHAR 1 0
FNR15 Formula number P10_BSIFORMULA CHAR 1 0
NXIND Nexus Indicator P10_NXINDIC NUMC 1 0
0 Primary (Default) - Business tax registration not filed
1 Secondary (Nexus) - Business tax registration filed
PRWTA Predominant Tax Authority Flag P10_PRWTA CHAR 1 0
X Yes
NULL No
RTA01 Remittance Tax Authority P10_REMITTAXAU CHAR 4 0
RTA02 Remittance Tax Authority P10_REMITTAXAU CHAR 4 0
RTA03 Remittance Tax Authority P10_REMITTAXAU CHAR 4 0
RTA04 Remittance Tax Authority P10_REMITTAXAU CHAR 4 0
RTA05 Remittance Tax Authority P10_REMITTAXAU CHAR 4 0
RTA06 Remittance Tax Authority P10_REMITTAXAU CHAR 4 0
RTA07 Remittance Tax Authority P10_REMITTAXAU CHAR 4 0
RTA08 Remittance Tax Authority P10_REMITTAXAU CHAR 4 0
RTA09 Remittance Tax Authority P10_REMITTAXAU CHAR 4 0
RTA10 Remittance Tax Authority P10_REMITTAXAU CHAR 4 0
RTA11 Remittance Tax Authority P10_REMITTAXAU CHAR 4 0
RTA12 Remittance Tax Authority P10_REMITTAXAU CHAR 4 0
RTA13 Remittance Tax Authority P10_REMITTAXAU CHAR 4 0
RTA14 Remittance Tax Authority P10_REMITTAXAU CHAR 4 0
RTA15 Remittance Tax Authority P10_REMITTAXAU CHAR 4 0
COUWH Courtesy withholding P10_COURTESY_WH CHAR 1 0
NULL Allowed
2 Not allowed
COIND Coterminus indicator P10_COTERMINUS CHAR 1 0
REIND Restore Indicator P10_RESTOREAUTH CHAR 1 0