1. SAP Tutorial
  2. HR Module

PA0626 SAP table for –

Here we would like to draw your attention to PA0626 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). PA0626 is a SAP standard transp table used for storing related data in SAP. If you want to download PDF material about SAP HR PA click here. It comes under the package PB13.

SAP PA0626 table

Table PA0626 technical data

TablePA0626
Data storing
ModulePA
Sub ModulePA-PA-AU
SAP PackagePB13
Delivery ClassA – Application table (master and transaction data)
ComponentSAP_HRCAU
Table CategoryTRANSP

SAP PA0626 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 PA0626 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 : Payment Summary Infotype Fields
  • PYBDT : Payment Summary Start Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • PYEDT : Payment Summary End Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • PYFIN : Final Payment Summary
    Its data type is CHAR (Character String) with field length 1
  • PYETP : ETP Payment Summary
    Its data type is CHAR (Character String) with field length 1
  • PYTIM : Payment Summary Creation Time
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • PYDAT : Payment Summary Creation Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • PYNUM : Number of Payment Summary prints
    Its data type is INT1 (Two-byte integer – Dictionry type INT2) with field length 3
  • PYLTM : Last PS print Time
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • PYLDT : Last PS print Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • PYATO : Number of ATO Files Created
    Its data type is INT1 (Two-byte integer – Dictionry type INT2) with field length 3
  • PYATM : Last ATO File Creation Time
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • PYADT : Last ATO File Creation Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • PYWIT : Payment summary has been withdrawn
    Its data type is CHAR (Character String) with field length 1
  • PYMAN : Manual payment summary/group certificate has been created
    Its data type is CHAR (Character String) with field length 1
  • PYSEQ : Sequence Number
    Its data type is NUMC (Character String with Digits Only) with field length 5
  • PYTAX : Tax Instalment Deductions
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • PYGRO : Gross income
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • PYLSA : Lump Sum A
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • PYLSB : Lump Sum B
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • PYLSD : Lump sum D
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • PYLSE : Lump Sum E
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • PYTAL : Total Allowances
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • PYFBT : Reportable Fringe Benefits Tax
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • PYCDP : Commonwealth Development Employment Project Amount
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • PYP83 : Number of ETP days before 1 July 1983
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 8
  • PYA83 : Number of ETP days after 30 June 1983
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 8
  • PYCGT : CGT Exempt Component
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • PYNQC : Non-Qualifying Component
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • PYUCO : Undeducted Contributions
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • PYCON : Concessional Component
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • PYE83 : Pre July 1983 Component
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • PYU83 : Post June 1983 Untaxed Element
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • PYT83 : Post June 1983 Taxed Element
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • PYI94 : Post June 1994 Invalidity Component
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • PYEGR : Gross Amount of Payment
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • PYETA : Tax Instalment Deductions
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • PYEAS : Assessable Amount
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • PYDEA : Death Benefit ETP
    Its data type is CHAR (Character String) with field length 1
  • PYDTY : Type of Death Benefit
    Its data type is CHAR (Character String) with field length 1
  • PYOTI : Other income
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • PYUNI : Union deduction fees
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • PYABN : Australian business number
    Its data type is NUMC (Character String with Digits Only) with field length 11
  • PYABR : GST branch registration number
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • PYW01 : Wagetype for allowance
    Its data type is CHAR (Character String) with field length 4
  • PYA01 : Allowance value
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • PYW02 : Wagetype for allowance
    Its data type is CHAR (Character String) with field length 4
  • PYA02 : Allowance value
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • PYW03 : Wagetype for allowance
    Its data type is CHAR (Character String) with field length 4
  • PYA03 : Allowance value
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • PYW04 : Wagetype for allowance
    Its data type is CHAR (Character String) with field length 4
  • PYA04 : Allowance value
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • PYW05 : Wagetype for allowance
    Its data type is CHAR (Character String) with field length 4
  • PYA05 : Allowance value
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • PYW06 : Wagetype for allowance
    Its data type is CHAR (Character String) with field length 4
  • PYA06 : Allowance value
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • PYW07 : Wagetype for allowance
    Its data type is CHAR (Character String) with field length 4
  • PYA07 : Allowance value
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • PYW08 : Wagetype for allowance
    Its data type is CHAR (Character String) with field length 4
  • PYA08 : Allowance value
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • PYW09 : Wagetype for allowance
    Its data type is CHAR (Character String) with field length 4
  • PYA09 : Allowance value
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • PYW10 : Wagetype for allowance
    Its data type is CHAR (Character String) with field length 4
  • PYA10 : Allowance value
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • PYW11 : Wagetype for allowance
    Its data type is CHAR (Character String) with field length 4
  • PYA11 : Allowance value
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • PYW12 : Wagetype for allowance
    Its data type is CHAR (Character String) with field length 4
  • PYA12 : Allowance value
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • PYW13 : Wagetype for allowance
    Its data type is CHAR (Character String) with field length 4
  • PYA13 : Allowance value
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • PYW14 : Wagetype for allowance
    Its data type is CHAR (Character String) with field length 4
  • PYA14 : Allowance value
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • PYW15 : Wagetype for allowance
    Its data type is CHAR (Character String) with field length 4
  • PYA15 : Allowance value
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • PYENM : Number of ETP Summary prints
    Its data type is INT1 (Two-byte integer – Dictionry type INT2) with field length 3
  • PYETM : Last ETP print time
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • PYETD : Last ETP print date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • PYTNA : Total number of allowances
    Its data type is INT1 (Two-byte integer – Dictionry type INT2) with field length 3
  • PYTUF : Total number of Union fees
    Its data type is INT1 (Two-byte integer – Dictionry type INT2) with field length 3
  • PYEDP : ETP date of payment
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • PYEDS : ETP date started
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • PYUFW : Wagetype for Union fees
    Its data type is CHAR (Character String) with field length 4
  • PYWPG : Workplace Giving
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • PYTWG : Total number of Workplace Giving
    Its data type is INT1 (Two-byte integer – Dictionry type INT2) with field length 3
  • ETTXC : ETP Taxable component
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • ETTFC : ETP Tax Free component
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • PUW01 : Wagetype for allowance
    Its data type is CHAR (Character String) with field length 4
  • PUA01 : Allowance value
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • PUW02 : Wagetype for allowance
    Its data type is CHAR (Character String) with field length 4
  • PUA02 : Allowance value
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • PUW03 : Wagetype for allowance
    Its data type is CHAR (Character String) with field length 4
  • PUA03 : Allowance value
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • PUW04 : Wagetype for allowance
    Its data type is CHAR (Character String) with field length 4
  • PUA04 : Allowance value
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • PUW05 : Wagetype for allowance
    Its data type is CHAR (Character String) with field length 4
  • PUA05 : Allowance value
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • PUW06 : Wagetype for allowance
    Its data type is CHAR (Character String) with field length 4
  • PUA06 : Allowance value
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • PUW07 : Wagetype for allowance
    Its data type is CHAR (Character String) with field length 4
  • PUA07 : Allowance value
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • PUW08 : Wagetype for allowance
    Its data type is CHAR (Character String) with field length 4
  • PUA08 : Allowance value
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • PUW09 : Wagetype for allowance
    Its data type is CHAR (Character String) with field length 4
  • PUA09 : Allowance value
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • PUW10 : Wagetype for allowance
    Its data type is CHAR (Character String) with field length 4
  • PUA10 : Allowance value
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • PUW11 : Wagetype for allowance
    Its data type is CHAR (Character String) with field length 4
  • PUA11 : Allowance value
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • PUW12 : Wagetype for allowance
    Its data type is CHAR (Character String) with field length 4
  • PUA12 : Allowance value
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • PUW13 : Wagetype for allowance
    Its data type is CHAR (Character String) with field length 4
  • PUA13 : Allowance value
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • PUW14 : Wagetype for allowance
    Its data type is CHAR (Character String) with field length 4
  • PUA14 : Allowance value
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • PUW15 : Wagetype for allowance
    Its data type is CHAR (Character String) with field length 4
  • PUA15 : Allowance value
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • PUW16 : Wagetype for allowance
    Its data type is CHAR (Character String) with field length 4
  • PUA16 : Allowance value
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • PUW17 : Wagetype for allowance
    Its data type is CHAR (Character String) with field length 4
  • PUA17 : Allowance value
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • PUW18 : Wagetype for allowance
    Its data type is CHAR (Character String) with field length 4
  • PUA18 : Allowance value
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • PUW19 : Wagetype for allowance
    Its data type is CHAR (Character String) with field length 4
  • PUA19 : Allowance value
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • PYAMD : Amended Payment Summary/ETP has been created
    Its data type is CHAR (Character String) with field length 1
  • ETAMD : Amended Payment Summary/ETP has been created
    Its data type is CHAR (Character String) with field length 1
  • TRTAX : Transitional – Tax Instalment Deductions
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • LBTAX : Life Benefit – Tax Instalment Deductions
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • DBTAX : Death Benefit – Tax Instalment Deductions
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • TRTCP : Transitional – ETP Taxable component
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • LBTCP : Life Benefit – ETP Taxable component
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • DBTCP : Death Benefit – ETP Taxable component
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • TRTFP : Transitional – ETP Tax Free component
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • LBTFP : Life Benefit – ETP Tax Free component
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • DBTFP : Death Benefit – ETP Tax Free component
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • SPLIT : Payment Summary for Split ETP
    Its data type is CHAR (Character String) with field length 1
  • PYSUP : Reportable superannuation contribution amount
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • PYFET : Exempt foreign employment income
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • PYLAT : Lump sum payment A type
    Its data type is CHAR (Character String) with field length 1
  • PYDPA : Deductible amount of the unded purchase price of the annuity
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes

    • PA0626 related tables

    • T5QTC : Tax Scale Australia
    • T5QTK : State/Territory Code Australia
    • T5QTM : Taxation Australia Medicare Levy
    • T5QGT : Messages Area Check Table Australia
    • T5QLP : Leave Provisions – Australia
    • PA0227 : Tax file number (Australia)
    • T5QRL : Taxation Australia – Rebate language table
    • T5QSW : Superannuation Wage Type Assignment
    • T5QLT : Leave Accrual-Id description Australia
    • PA0261 : Leave Accrual Australia
    • T5QRP : Redundancy Packages Australia
    • T5QGM : Payroll Highlight Messages Australia
    • T5Q0P : Personnel area, business subsection (Australia)
    • PA0220 : Superannuation (Australia)
    • T5QRB : Taxation – Rebates (Australia)
    • PA0849 : Infotype for Payment Summary
    • PA3348 : HR Master Record: Infotype 3348
    • T5QSS : Superannuation Defined Salary Australia
    • T5QLR : Leave Accrual Rules Australia
    • T5QSG : Superannuation Guarantee Contribution Admin Australia

    PA0626 related transaction codes under SAP package PB13

    • PZ27 : ESS Superannuation Australia
    • PZ25 : ESS Australian Taxes

    Related References

    Related Tutorials

    PA0849 SAP table for – Infotype for Payment Summary

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

    PA0850 SAP table for – Infotype for Eligible Termination Payment

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

    PA0817 SAP table for – Income Tax Withholding Variation(Australia)

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

    PA0261 SAP table for – Leave Accrual Australia

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

    PA0701 SAP table for – HR Terminations Data Container : Infotype 0701

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

    PA0851 SAP table for – HR Master Record: Infotype 0851

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

    PA0645 SAP table for – Termination of contract: General data

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

    «
    »