T5R1P SAP table for – Rate for lump payment and CPF in case of semimonthly payroll

Here we would like to draw your attention to T5R1P 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). T5R1P is a SAP standard transp table used for storing Rate for lump payment and CPF in case of semimonthly payroll related data in SAP. If you want to download PDF material about SAP HR PA click here. It comes under the package PB25.

SAP T5R1P table

Table T5R1P technical data

TableT5R1P
Data storingRate for lump payment and CPF in case of semimonthly payroll
ModulePA
Sub ModulePA-PA-SG
SAP PackagePB25
Delivery ClassC – Customer table, data is only maintained by the customer
ComponentSAP_HRCSG
Table CategoryTRANSP

SAP T5R1P 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 T5R1P table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • WERKS : Personnel Area
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • BTRTL : Personnel Subarea
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • PERSG : Employee Group
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • PERSK : Employee Subgroup
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • SIGRP : Institution of soc. provident funds SG
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • FUNCL : Fund class
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • FUNTY : Fund type
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • ENDDA : End Date
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BEGDA : Start Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BSRAT : Pay rate regarding the base pay
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • BSLIM : Low wage limit for base pay
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • BSCPF : Mid-month deduction rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • OTRAT : Pay rate regarding overtime
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • OTLIM : Low limit for overtime pay
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • OTCPF : Contribution rate to CPF regarding overtime
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • ALRAT : Pay rate regarding the allowances (ALW)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • ALLIM : Low limit for allowances
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • ALCPF : Contribution rate to CPF regarding allowances (ALW)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • OHRAT : Pay rate regarding other wage types (OWT)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • OHLIM : Low limit for other wage types
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • OHCPF : Contribution rate to CPF regarding other wage types (OWT)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • CPFWG : Mid month gross amount flag for estimated or actual amount.
    Its data type is CHAR (Character String) with field length 1
  • CPFRT : Mid-month rate flag for estimated or actual amount.
    Its data type is CHAR (Character String) with field length 1