1. SAP Tutorial
  2. HR Module

PA0581 SAP table for – Housing

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

SAP PA0581 table

Table PA0581 technical data

TablePA0581
Data storingHousing
ModulePA
Sub ModulePA-PA-IN
SAP PackagePB40
Delivery ClassA – Application table (master and transaction data)
ComponentSAP_HRCIN
Table CategoryTRANSP

SAP PA0581 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 PA0581 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 : Housing ( HRA / CLA / COA )
  • METRO : Whether metro
    Its data type is CHAR (Character String) with field length 1
  • HRTXE : Whether HRA to be tax-exempted
    Its data type is CHAR (Character String) with field length 1
  • ELGMT : Eligible amount for housing(HRA/CLA/COA)
    Its data type is CURR (Currency Field) with field length 12
  • ELGWT : Wage Type
    Its data type is CHAR (Character String) with field length 4
  • RTAMT : Rent amount (rented/ company leased accommodation)
    Its data type is CURR (Currency Field) with field length 12
  • ACCOM : Code for Housing type
    Its data type is CHAR (Character String) with field length 1
  • HLPMN : Number of helpers(gardener/maid servant/sweeper)
    Its data type is NUMC (Character String with Digits Only) with field length 5
  • WAEHI : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • TFURV : Total furniture value
    Its data type is CURR (Currency Field) with field length 9
  • HCFUR : Hiring charges of furniture
    Its data type is CURR (Currency Field) with field length 9
  • FRAMT : Fair rental value of CLA /COA
    Its data type is CURR (Currency Field) with field length 12
  • LDAD1 : Landlord’s address
    Its data type is CHAR (Character String) with field length 35
  • LDAD2 : Landlord’s address
    Its data type is CHAR (Character String) with field length 35
  • LDAD3 : Landlord’s address
    Its data type is CHAR (Character String) with field length 35
  • HLAMT : Helper Cost
    Its data type is CURR (Currency Field) with field length 12
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes

    • PA0581 related tables

    • T7INF7 : Provident fund trust details
    • T7INI9 : Subsection division details
    • PA0586 : Section 88 – Tax rebate
    • T7INF5 : Company rates for provident fund
    • T7INU2 : Text for Universal Grouping
    • T7INT1 : Slab codes for taxation
    • T7INB7 : Basic Slabs
    • T7INT7 : Taxabilty codes for rule based tax exemptions
    • T7INS5 : Superannuation ID and Related Wagetypes
    • T7IND3 : Dearness allowance consumer price index value
    • T7INAE : Claims carry forward
    • T7INB9 : Increment criteria
    • PA0585 : Section 80 – Tax Exemptions
    • T7INC7 : Eligibility for car schemes(COCS/OYCS)
    • T7INE3 : Employees’ state insurance contribution rates
    • T7INT8 : Text for taxability codes
    • PA0589 : Individual Reimbursements
    • T7INU1 : State for Universal Grouping
    • T7INF2 : Provident fund trust text
    • T7INC9 : Conveyance Eligibilty

    PA0581 related transaction codes under SAP package PB40

    • PC00_M40_BSP : Basic – Promotions
    • PC00_M40_ESIB : ESI Batch Program
    • PC00_M40_REMP : Disbursement of claims
    • PZ80 : ESS Investment detls – IT585 -Sec80
    • PC00_M40_ALR : Allowance Restructuring
    • HRESSIN_F16 : Display Form 16
    • PC00_M40_ESIU : Utility Program for ESI
    • PC00_M40_HRA : Rent receipt updation report
    • PC00_M40_DAB : Batch program for Dearness Allowance
    • PC00_M40_REMS : Status for claims
    • PZ88 : ESS Sec 80C Deduction details- IT586
    • PC00_M40_S80 : Batch program for Section80
    • PC00_M40_BSG : Basic – General Increments
    • PC00_M40_S88 : Batch program for Section80

    Related References

    Related Tutorials

    PA0530 SAP table for – HR Master Record: Infotype 0530 (Public Housing Fund)

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

    T7VEL1 SAP table for – Transfer of ext. payroll res.: Housing Scheme (RPVH) contr.

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

    PA0371 SAP table for – Master Data: Infotype 0371 (Tax on previous employment)

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

    PA0437 SAP table for – Multiple employment (BR)

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

    T7INR9 SAP table for – City category for housing type

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

    PA0370 SAP table for – Master data: Infotype 0370 (INFONAVIT credit data)

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

    PA0589 SAP table for – Individual Reimbursements

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

    «
    »