T5QLR SAP table for – Leave Accrual Rules Australia

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

SAP T5QLR table

Table T5QLR technical data

TableT5QLR
Data storingLeave Accrual Rules Australia
ModulePA
Sub ModulePA-PA-AU
SAP PackagePB13
Delivery ClassC – Customer table, data is only maintained by the customer
ComponentSAP_HRCAU
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • MOURA : Personnel Subarea Grouping for Leave Types
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 2
  • URART : Leave type
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • ACCID : Leave Accrual Identifier Australia
    Its a key field. Its data type is NUMC (Character String with Digits Only) 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
  • ACCFL : Leave Accrual – Accrual Flag
    Its data type is CHAR (Character String) with field length 1
  • ACCRT : Leave Accrual Rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • ACCFR : Leave Accrual Frequency
    Its data type is CHAR (Character String) with field length 1
  • ACCWV : Leave Accrual Warning Value
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 6
  • ACCMV : Leave Accrual Maximum Value
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 6
  • ACCDV : Leave Accrual Default Value
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 6
  • ANNTY : Leave Accrual Anniversary Type
    Its data type is CHAR (Character String) with field length 1
  • ANNDU : Leave Accrual Anniversary Distance
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • ANNDT : Leave Accrual Anniversary Distance Type
    Its data type is CHAR (Character String) with field length 1
  • INTNR : Internal Number for Leave Type Assignment
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • ANNFD : Leave Accrual Anniversary Fixed Date
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • ANNFV : Leave Accrual Anniversary Fixed Value
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 6
  • ANNOP : Leave Accrual Anniversary Operation
    Its data type is CHAR (Character String) with field length 1
  • NACID : Leave Accrual Identifier Australia
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • NALTY : Leave type
    Its data type is CHAR (Character String) with field length 2
  • LLDTY : Leave Loading Type
    Its data type is CHAR (Character String) with field length 1
  • LLPER : Leave Loading Percentage
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • LLWTY : Payable Leave Loading Wage Type
    Its data type is CHAR (Character String) with field length 4
  • LLFDT : Fixed Date for Leave Loading
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • LVGRP : Leave Type/Quota Grouping
    Its data type is CHAR (Character String) with field length 2