1. SAP Tutorial
  2. HR Module

PA0224 SAP table for – Tax information – infotype 0224 – Canada

Here we would like to draw your attention to PA0224 table in SAP. As we know it is being mainly used with the SAP PA-PA (Personnel Administration in PA) component which is coming under HR (HCM) PA module (Personnel Management). PA0224 is a SAP standard transp table used for storing Tax information – infotype 0224 – Canada related data in SAP. If you want to download PDF material about SAP HR PA click here. It comes under the package PB07.

SAP PA0224 table

Table PA0224 technical data

TablePA0224
Data storingTax information – infotype 0224 – Canada
ModulePA
Sub ModulePA-PA-CA
SAP PackagePB07
Delivery ClassA – Application table (master and transaction data)
ComponentSAP_HRCCA
Table CategoryTRANSP

SAP PA0224 Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in PA0224 table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • .INCLUDE : Key for HR Master Data
    Its a key field.
  • PERNR : Personnel number
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 8
  • SUBTY : Subtype
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • OBJPS : Object Identification
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • SPRPS : Lock Indicator for HR Master Data Record
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • ENDDA : End Date
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BEGDA : Start Date
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SEQNR : Number of Infotype Record With Same Key
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 3
  • .INCLUDE : HR Master Record: Control Field
  • AEDTM : Last Changed On
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • UNAME : Name of Person Who Changed Object
    Its data type is CHAR (Character String) with field length 12
  • HISTO : Historical Record Flag
    Its data type is CHAR (Character String) with field length 1
  • ITXEX : Text Exists for Infotype
    Its data type is CHAR (Character String) with field length 1
  • REFEX : Reference Fields Exist (Primary/Secondary Costs)
    Its data type is CHAR (Character String) with field length 1
  • ORDEX : Confirmation Fields Exist
    Its data type is CHAR (Character String) with field length 1
  • ITBLD : Infotype Screen Control
    Its data type is CHAR (Character String) with field length 2
  • PREAS : Reason for Changing Master Data
    Its data type is CHAR (Character String) with field length 2
  • FLAG1 : Reserved Field/Unused Field
    Its data type is CHAR (Character String) with field length 1
  • FLAG2 : Reserved Field/Unused Field
    Its data type is CHAR (Character String) with field length 1
  • FLAG3 : Reserved Field/Unused Field
    Its data type is CHAR (Character String) with field length 1
  • FLAG4 : Reserved Field/Unused Field
    Its data type is CHAR (Character String) with field length 1
  • RESE1 : Reserved Field/Unused Field of Length 2
    Its data type is CHAR (Character String) with field length 2
  • RESE2 : Reserved Field/Unused Field of Length 2
    Its data type is CHAR (Character String) with field length 2
  • GRPVL : Grouping Value for Personnel Assignments
    Its data type is CHAR (Character String) with field length 4
  • .INCLUDE : Tax information of Infotype 0224 – Canada
  • WRKAR : Province of employment
    Its data type is CHAR (Character String) with field length 4
  • RESAR : Employment standard jurisdiction
    Its data type is CHAR (Character String) with field length 4
  • RCITY : Designated CMA
    Its data type is CHAR (Character String) with field length 4
  • CBUSN : Business number
    Its data type is CHAR (Character String) with field length 15
  • CGSTN : GST number
    Its data type is CHAR (Character String) with field length 15
  • OPTIO : Option for tax calculation
    Its data type is CHAR (Character String) with field length 1
  • TOTCR : Total personal tax credit amount
    Its data type is CURR (Currency Field) with field length 9
  • CLAIM : Claim Code
    Its data type is CHAR (Character String) with field length 2
  • TNIND : Total non-indexed personal tax credit amount
    Its data type is CURR (Currency Field) with field length 9
  • ADDTX : Additional tax
    Its data type is CURR (Currency Field) with field length 9
  • ADDTP : Additional Tax (%) – Canada
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 3
  • TEXHD : Designated area deduction
    Its data type is CURR (Currency Field) with field length 9
  • NODEP : No. of dependants under 18 yrs.
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • NODIS : No. of dependants 18 yrs. or older and disabled
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • MNTDE : Annual authorized federal deductions
    Its data type is CURR (Currency Field) with field length 9
  • OTXCR : Annual authorized federal tax credits
    Its data type is CURR (Currency Field) with field length 9
  • LBTCR : Amount paid for purchase of labour-sponsored funds
    Its data type is CURR (Currency Field) with field length 9
  • CRTDE : Court Order Deduction – Alimony Maintenance Payments
    Its data type is CURR (Currency Field) with field length 9
  • LBTCP : Provincial Labour-Sponsored Tax Credit
    Its data type is CURR (Currency Field) with field length 9
  • COMRE : Estimated total remuneration
    Its data type is CURR (Currency Field) with field length 9
  • COMEX : Estimated expenses
    Its data type is CURR (Currency Field) with field length 9
  • QCTXI : Taxation identification number – QC
    Its data type is CHAR (Character String) with field length 16
  • QGSTN : QST number – QC
    Its data type is CHAR (Character String) with field length 16
  • TOTCQ : Total personal tax credit amount – QC
    Its data type is CURR (Currency Field) with field length 9
  • CLAQC : Claim code Québec
    Its data type is CHAR (Character String) with field length 2
  • ADDTQ : Additional tax deduction – Provincial
    Its data type is CURR (Currency Field) with field length 9
  • OTHDE : Other annual deductions and credits – QC
    Its data type is CURR (Currency Field) with field length 9
  • OTXCQ : Other annual authorized tax credits – QC
    Its data type is CURR (Currency Field) with field length 9
  • OTADE : Other annual authorized deductions – QC
    Its data type is CURR (Currency Field) with field length 9
  • INDYR : Base Year QC
    Its data type is CHAR (Character String) with field length 1
  • COMRQ : Gross Commission Income – Québec
    Its data type is CURR (Currency Field) with field length 9
  • COMEQ : Estimated annual net commission income – QC
    Its data type is CURR (Currency Field) with field length 9
  • COMPQ : Percentage of Commission – Québec
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 3
  • TAX01 : Tax authority
    Its data type is CHAR (Character String) with field length 4
  • EXI01 : Tax indicator / exemption code
    Its data type is CHAR (Character String) with field length 1
  • TAX02 : Tax authority
    Its data type is CHAR (Character String) with field length 4
  • EXI02 : Tax indicator / exemption code
    Its data type is CHAR (Character String) with field length 1
  • TAX03 : Tax authority
    Its data type is CHAR (Character String) with field length 4
  • EXI03 : Tax indicator / exemption code
    Its data type is CHAR (Character String) with field length 1
  • TAX04 : Tax authority
    Its data type is CHAR (Character String) with field length 4
  • EXI04 : Tax indicator / exemption code
    Its data type is CHAR (Character String) with field length 1
  • TAX05 : Tax authority
    Its data type is CHAR (Character String) with field length 4
  • EXI05 : Tax indicator / exemption code
    Its data type is CHAR (Character String) with field length 1
  • TAX06 : Tax authority
    Its data type is CHAR (Character String) with field length 4
  • EXI06 : Tax indicator / exemption code
    Its data type is CHAR (Character String) with field length 1
  • TAX07 : Tax authority
    Its data type is CHAR (Character String) with field length 4
  • EXI07 : Tax indicator / exemption code
    Its data type is CHAR (Character String) with field length 1
  • TAX08 : Tax authority
    Its data type is CHAR (Character String) with field length 4
  • EXI08 : Tax indicator / exemption code
    Its data type is CHAR (Character String) with field length 1
  • TAX09 : Tax authority
    Its data type is CHAR (Character String) with field length 4
  • EXI09 : Tax indicator / exemption code
    Its data type is CHAR (Character String) with field length 1
  • TAX10 : Tax authority
    Its data type is CHAR (Character String) with field length 4
  • EXI10 : Tax indicator / exemption code
    Its data type is CHAR (Character String) with field length 1
  • TAX11 : Tax authority
    Its data type is CHAR (Character String) with field length 4
  • EXI11 : Tax indicator / exemption code
    Its data type is CHAR (Character String) with field length 1
  • TAX12 : Tax authority
    Its data type is CHAR (Character String) with field length 4
  • EXI12 : Tax indicator / exemption code
    Its data type is CHAR (Character String) with field length 1
  • TAX13 : Tax authority
    Its data type is CHAR (Character String) with field length 4
  • EXI13 : Tax indicator / exemption code
    Its data type is CHAR (Character String) with field length 1
  • TAX14 : Tax authority
    Its data type is CHAR (Character String) with field length 4
  • EXI14 : Tax indicator / exemption code
    Its data type is CHAR (Character String) with field length 1
  • TAX15 : Tax authority
    Its data type is CHAR (Character String) with field length 4
  • EXI15 : Tax indicator / exemption code
    Its data type is CHAR (Character String) with field length 1
  • MARRD : Married or equivalent-to-spouse
    Its data type is CHAR (Character String) with field length 1
  • PROVR : Province of residence
    Its data type is CHAR (Character String) with field length 4
  • WNSBN : Business Number for WCB purposes
    Its data type is CHAR (Character String) with field length 15
  • TOTCP : Provincial total tax credits
    Its data type is CURR (Currency Field) with field length 9
  • OTXCP : Other provincial authorized tax credits
    Its data type is CURR (Currency Field) with field length 9
  • TNINP : Total non-indexed personal tax credit amount
    Its data type is CURR (Currency Field) with field length 9
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes

    • PA0224 related tables

    • T5KE2_T : Text Table for Designated Groups
    • T5KAW : Work tax area – Canada
    • T5KET : Tax types – texts – Canada
    • PA0463 : HR Master Record: Infotype 0463
    • T5KTL : Tax area – Canada
    • PA0461 : HR Master Record: Infotype 0461 (Tax Assignment CA)
    • T5KSN : ROE Serial Number
    • T5KTV : Tax level
    • T5KE1 : Group Types
    • T5KFT : Tax claim codes – federal – texts – Canada
    • T5KNO : National Occupational Classification (NOC) codes
    • T5KRM : Canadian Tax Remittance Form PD7A Data
    • T5KNT : National Occupational Classification (NOC) codes – text
    • T5K1M : Master data reason relevant to ROE
    • T5K1E : Event reason relevant to ROE (Canada)
    • T5KRT : Tax types for employer – texts – Canada
    • T5KVT : Tax levels – texts – Canada
    • T5KAT : Tax areas – texts – Canada
    • T5K13 : Jobs
    • T5K1A : Absence type reason relevant to ROE (Canada)

    PA0224 related transaction codes under SAP package PB07

    • B1B2 : Create Magnetic Media files
    • P000_M07_GRVS : Grievance summary
    • PC00_M07_SEET : Emplmt.Equity Assessment 07
    • P000_M07_EEA : EEA report (Canada)
    • PZ13 : Personal Data
    • EEAK : Employment equity – Canada
    • PC00_M07_SEEA : Emplmt.Equity Assessment 07
    • OHX2 : Maintain wage types for remittance
    • PZ08 : Taxes
    • OHX3 : Maintain number ranges for 3PR
    • PC00_M07_UNTU : Start of Year Cred/Ded. Update 07
    • OHX4 : Number range for 3PR
    • PZ56 : Additional Personal Data
    • P000_M07_TXUP : New year tax update utility

    Related References

    Related Tutorials

    PA0095 SAP table for – HR Master Record: Infotype 0095 (Tax Canada)

    PA0095 table in SAP HR PA (Personnel Administration in PA) module. This table is used for storing data of HR...

    T5KAM SAP table for – Tax area / tax model Canada

    T5KAM table in SAP HR PA (Personnel Administration in PA) module. This table is used for storing data of Tax...

    T5KIN SAP table for – Tax indicators – Canada

    T5KIN table in SAP HR PA (Personnel Administration in PA) module. This table is used for storing data of Tax...

    T5KIT SAP table for – Tax indicator texts – Canada

    T5KIT table in SAP HR PA (Personnel Administration in PA) module. This table is used for storing data of Tax...

    T5KTL SAP table for – Tax area – Canada

    T5KTL table in SAP HR PA (Personnel Administration in PA) module. This table is used for storing data of Tax...

    T5KET SAP table for – Tax types – texts – Canada

    T5KET table in SAP HR PA (Personnel Administration in PA) module. This table is used for storing data of Tax...

    T5KMT SAP table for – Tax models – texts – Canada

    T5KMT table in SAP HR PA (Personnel Administration in PA) module. This table is used for storing data of Tax...

    «
    »