P2RU_TAX

Payroll Results: Tax (U.S.) | #transactional | Component: USA
Column Name Description
MANDT Client
DCT_PERNR Personnel Number
DCT_SEQNR FK Sequence Number
DCT_ROWID Unique Row Number
Column Name Description
💲 Currency Key (WAERS):
EXAMT Additional tax amount
ADEXA Total additional exemption amount
AMTEX Exemption amount
TXCRD Tax credit balance
IRSAE Exemption amount
DEPS_TOTAL_AMT W-4: Total credits for dependents
OTHER_INC_AMT W-4: Other Income
DEDUCT_AMT W-4: Additional deductions
Column Name Description
Column Name Description
Column Name Description
TAXLV Tax level Show values
EICID Indicator: EIC Show values
EICST EIC status Show values
SUPCD Supplemental method Show values
RECIN Reciprocity indicator Show values
CERTF Certificate status Show values
FRM01 Formula number Show values
EXP01 Tax exemption indicator Show values
FRM02 Formula number Show values
EXP02 Tax exemption indicator Show values
FRM03 Formula number Show values
EXP03 Tax exemption indicator Show values
FRM04 Formula number Show values
EXP04 Tax exemption indicator Show values
FRM05 Formula number Show values
EXP05 Tax exemption indicator Show values
FRM06 Formula number Show values
EXP06 Tax exemption indicator Show values
FRM07 Formula number Show values
EXP07 Tax exemption indicator Show values
FRM08 Formula number Show values
EXP08 Tax exemption indicator Show values
FRM09 Formula number Show values
EXP09 Tax exemption indicator Show values
FRM10 Formula number Show values
EXP10 Tax exemption indicator Show values
FRM11 Formula number Show values
EXP11 Tax exemption indicator Show values
FRM12 Formula number Show values
EXP12 Tax exemption indicator Show values
FRM13 Formula number Show values
EXP13 Tax exemption indicator Show values
FRM14 Formula number Show values
EXP14 Tax exemption indicator Show values
FRM15 Formula number Show values
EXP15 Tax exemption indicator Show values
NXIND Nexus Indicator Show values
PRWTA Predominant Tax Authority Flag Show values
COUWH Courtesy withholding Show values
EXWOS Resident Tax Exemption Show values
EXP16 Tax exemption indicator Show values
EXP17 Tax exemption indicator Show values
EXP18 Tax exemption indicator Show values
EXP19 Tax exemption indicator Show values
EXP20 Tax exemption indicator Show values
EXP21 Tax exemption indicator Show values
EXP22 Tax exemption indicator Show values
EXP23 Tax exemption indicator Show values
EXP24 Tax exemption indicator Show values
EXP25 Tax exemption indicator Show values
EXP26 Tax exemption indicator Show values
EXP27 Tax exemption indicator Show values
EXP28 Tax exemption indicator Show values
EXP29 Tax exemption indicator Show values
EXP30 Tax exemption indicator Show values
MULTJ W-4: Use Higher Withholding Rates Schedule Show values
Column Name Description Domain name
CNTR1 SI split RAW1
TAXAU Tax authority TAXAT
TXSTA Filing status TXSTA
NBREX Number of exemptions NUM2
EXPCT Additional tax percentage DEC3_2
ADEXN Number of additional exemptions NUMC2
PEREX Number of personal exemptions NUM2
DEPEX Number of dependent exemptions NUM2
EXTCD Addtional tax exempt amount code NUM1
IRSTS Tax status CHAR2
IRSNE Number of exemptions CHAR2
RSIND Letter CHAR1
WKIND Letter CHAR1
UIIND Letter CHAR1
TYP01 Tax type TAXT1
TYP02 Tax type TAXT1
TYP03 Tax type TAXT1
TYP04 Tax type TAXT1
TYP05 Tax type TAXT1
TYP06 Tax type TAXT1
TYP07 Tax type TAXT1
TYP08 Tax type TAXT1
TYP09 Tax type TAXT1
TYP10 Tax type TAXT1
TYP11 Tax type TAXT1
TYP12 Tax type TAXT1
TYP13 Tax type TAXT1
TYP14 Tax type TAXT1
TYP15 Tax type TAXT1
TCCPM Common Paymaster Tax Company TXCMP
NBQLC Number of Qualifying Children NUM2
FNR01 Formula number P10_BSIFORMULA
FNR02 Formula number P10_BSIFORMULA
FNR03 Formula number P10_BSIFORMULA
FNR04 Formula number P10_BSIFORMULA
FNR05 Formula number P10_BSIFORMULA
FNR06 Formula number P10_BSIFORMULA
FNR07 Formula number P10_BSIFORMULA
FNR08 Formula number P10_BSIFORMULA
FNR09 Formula number P10_BSIFORMULA
FNR10 Formula number P10_BSIFORMULA
FNR11 Formula number P10_BSIFORMULA
FNR12 Formula number P10_BSIFORMULA
FNR13 Formula number P10_BSIFORMULA
FNR14 Formula number P10_BSIFORMULA
FNR15 Formula number P10_BSIFORMULA
RTA01 Remittance Tax Authority TAXAT
RTA02 Remittance Tax Authority TAXAT
RTA03 Remittance Tax Authority TAXAT
RTA04 Remittance Tax Authority TAXAT
RTA05 Remittance Tax Authority TAXAT
RTA06 Remittance Tax Authority TAXAT
RTA07 Remittance Tax Authority TAXAT
RTA08 Remittance Tax Authority TAXAT
RTA09 Remittance Tax Authority TAXAT
RTA10 Remittance Tax Authority TAXAT
RTA11 Remittance Tax Authority TAXAT
RTA12 Remittance Tax Authority TAXAT
RTA13 Remittance Tax Authority TAXAT
RTA14 Remittance Tax Authority TAXAT
RTA15 Remittance Tax Authority TAXAT
COIND Coterminus indicator CHAR1
REIND Restore Indicator CHAR1
PRFEI Proration of Foreign Earned Income HRPAYUS_FEI_PRORATION
TTY01 Tax type HRPAYUS_TAX_TYPE
TTY02 Tax type HRPAYUS_TAX_TYPE
TTY03 Tax type HRPAYUS_TAX_TYPE
TTY04 Tax type HRPAYUS_TAX_TYPE
TTY05 Tax type HRPAYUS_TAX_TYPE
TTY06 Tax type HRPAYUS_TAX_TYPE
TTY07 Tax type HRPAYUS_TAX_TYPE
TTY08 Tax type HRPAYUS_TAX_TYPE
TTY09 Tax type HRPAYUS_TAX_TYPE
TTY10 Tax type HRPAYUS_TAX_TYPE
TTY11 Tax type HRPAYUS_TAX_TYPE
TTY12 Tax type HRPAYUS_TAX_TYPE
TTY13 Tax type HRPAYUS_TAX_TYPE
TTY14 Tax type HRPAYUS_TAX_TYPE
TTY15 Tax type HRPAYUS_TAX_TYPE
XRT01 Experience Rate
XRT02 Experience Rate
XRT03 Experience Rate
XRT04 Experience Rate
XRT05 Experience Rate
XRT06 Experience Rate
XRT07 Experience Rate
XRT08 Experience Rate
XRT09 Experience Rate
XRT10 Experience Rate
XRT11 Experience Rate
XRT12 Experience Rate
XRT13 Experience Rate
XRT14 Experience Rate
XRT15 Experience Rate
MWG01 Maximum Wages
MWG02 Maximum Wages
MWG03 Maximum Wages
MWG04 Maximum Wages
MWG05 Maximum Wages
MWG06 Maximum Wages
MWG07 Maximum Wages
MWG08 Maximum Wages
MWG09 Maximum Wages
MWG10 Maximum Wages
MWG11 Maximum Wages
MWG12 Maximum Wages
MWG13 Maximum Wages
MWG14 Maximum Wages
MWG15 Maximum Wages
TTY16 Tax type HRPAYUS_TAX_TYPE
TTY17 Tax type HRPAYUS_TAX_TYPE
TTY18 Tax type HRPAYUS_TAX_TYPE
TTY19 Tax type HRPAYUS_TAX_TYPE
TTY20 Tax type HRPAYUS_TAX_TYPE
TTY21 Tax type HRPAYUS_TAX_TYPE
TTY22 Tax type HRPAYUS_TAX_TYPE
TTY23 Tax type HRPAYUS_TAX_TYPE
TTY24 Tax type HRPAYUS_TAX_TYPE
TTY25 Tax type HRPAYUS_TAX_TYPE
TTY26 Tax type HRPAYUS_TAX_TYPE
TTY27 Tax type HRPAYUS_TAX_TYPE
TTY28 Tax type HRPAYUS_TAX_TYPE
TTY29 Tax type HRPAYUS_TAX_TYPE
TTY30 Tax type HRPAYUS_TAX_TYPE
FNR16 Formula number P10_BSIFORMULA
FNR17 Formula number P10_BSIFORMULA
FNR18 Formula number P10_BSIFORMULA
FNR19 Formula number P10_BSIFORMULA
FNR20 Formula number P10_BSIFORMULA
FNR21 Formula number P10_BSIFORMULA
FNR22 Formula number P10_BSIFORMULA
FNR23 Formula number P10_BSIFORMULA
FNR24 Formula number P10_BSIFORMULA
FNR25 Formula number P10_BSIFORMULA
FNR26 Formula number P10_BSIFORMULA
FNR27 Formula number P10_BSIFORMULA
FNR28 Formula number P10_BSIFORMULA
FNR29 Formula number P10_BSIFORMULA
FNR30 Formula number P10_BSIFORMULA
RTA16 Remittance Tax Authority TAXAT
RTA17 Remittance Tax Authority TAXAT
RTA18 Remittance Tax Authority TAXAT
RTA19 Remittance Tax Authority TAXAT
RTA20 Remittance Tax Authority TAXAT
RTA21 Remittance Tax Authority TAXAT
RTA22 Remittance Tax Authority TAXAT
RTA23 Remittance Tax Authority TAXAT
RTA24 Remittance Tax Authority TAXAT
RTA25 Remittance Tax Authority TAXAT
RTA26 Remittance Tax Authority TAXAT
RTA27 Remittance Tax Authority TAXAT
RTA28 Remittance Tax Authority TAXAT
RTA29 Remittance Tax Authority TAXAT
RTA30 Remittance Tax Authority TAXAT
XRT16 Experience Rate
XRT17 Experience Rate
XRT18 Experience Rate
XRT19 Experience Rate
XRT20 Experience Rate
XRT21 Experience Rate
XRT22 Experience Rate
XRT23 Experience Rate
XRT24 Experience Rate
XRT25 Experience Rate
XRT26 Experience Rate
XRT27 Experience Rate
XRT28 Experience Rate
XRT29 Experience Rate
XRT30 Experience Rate
MWG16 Maximum Wages
MWG17 Maximum Wages
MWG18 Maximum Wages
MWG19 Maximum Wages
MWG20 Maximum Wages
MWG21 Maximum Wages
MWG22 Maximum Wages
MWG23 Maximum Wages
MWG24 Maximum Wages
MWG25 Maximum Wages
MWG26 Maximum Wages
MWG27 Maximum Wages
MWG28 Maximum Wages
MWG29 Maximum Wages
MWG30 Maximum Wages
RWAMT Reduced Withholding Amount
WHFYR W-4: Withholding Form Year
Master Data Relations Join Conditions
Currency Key
  • P2RU_TAX.MANDT == TCURC.MANDT
  • P2RU_TAX.WAERS == TCURC.WAERS