T5QLR SAP (Leave Accrual Rules Australia) Table details

Dictionary Type: Table
Description: Leave Accrual Rules Australia




ABAP Code to SELECT data from T5QLR
Related tables to T5QLR
Access table T5QLR




Table field list including key, data, relationships and ABAP select examples

T5QLR is a standard SAP Table which is used to store Leave Accrual Rules Australia data and is available within R/3 SAP systems depending on the version and release level.

The T5QLR table consists of various fields, each holding specific information or linking keys about Leave Accrual Rules Australia data available in SAP. These include MOURA (Personnel Subarea Grouping for Leave Types), URART (Leave type), ACCID (Leave Accrual Identifier Australia), ENDDA (End Date).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: C - Customising table, maintenance only by cust
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)

Text table = T5QLT


SAP T5QLR table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
MOURAPersonnel Subarea Grouping for Leave Types MOURANUMC2MODIF
URARTLeave type URARCHAR2T533URART
ACCIDLeave Accrual Identifier Australia P13Q_ACCIDNUMC2Assigned to domainP13Q_ACCID
ENDDAEnd Date ENDDADATS8DATUM
BEGDAStart Date BEGDADATS8DATUM
ACCFLLeave Accrual - Accrual Flag P13Q_ACCFLCHAR1P13Q_ACCFL
ACCRTLeave Accrual Rate P13Q_ACCRTDEC9(5) P13Q_ACCRT
ACCFRLeave Accrual Frequency P13Q_ACCFRCHAR1P13Q_ACCFR
ACCWVLeave Accrual Warning Value P13Q_ACCWVDEC6(2) P13Q_ACCWV
ACCMVLeave Accrual Maximum Value P13Q_ACCMVDEC6(2) P13Q_ACCMV
ACCDVLeave Accrual Default Value P13Q_ACCDVDEC6(2) P13Q_ACCDV
ANNTYLeave Accrual Anniversary Type P13Q_ANNTYCHAR1P13Q_ANNTY
ANNDULeave Accrual Anniversary Distance P13Q_ANNDUNUMC3P13Q_ANNDU
ANNDTLeave Accrual Anniversary Distance Type P13Q_ANNDTCHAR1P13Q_ANNDT
INTNRInternal Number for Leave Type Assignment P13Q_INTNRNUMC4P13Q_INTNR
ANNFDLeave Accrual Anniversary Fixed Date P13Q_ANNFDNUMC4P13Q_ANNFD
ANNFVLeave Accrual Anniversary Fixed Value P13Q_ANNFVDEC6(2) P13Q_ANNFV
ANNOPLeave Accrual Anniversary Operation P13Q_ANNOPCHAR1P13Q_ANNOP
NACIDLeave Accrual Identifier Australia P13Q_ACCIDNUMC2T5QLRP13Q_ACCID
NALTYLeave type URARCHAR2T533URART
LLDTYLeave Loading Type P13Q_LLDTYCHAR1P13Q_LLDTY
LLPERLeave Loading Percentage P13Q_LLPERDEC5(2) P13Q_LLPER
LLWTYPayable Leave Loading Wage Type P13Q_LLWTYCHAR4T512WLGART
LLFDTFixed Date for Leave Loading P13Q_LLFDTNUMC4P13Q_LLFDT
LVGRPLeave Type/Quota Grouping P13Q_LVGRPCHAR2T5QLGP13Q_LVGRP

Key field Non-key field



How do I retrieve data from SAP table T5QLR using ABAP code

The following ABAP code Example will allow you to do a basic selection on T5QLR to SELECT all data from the table
DATA: WA_T5QLR TYPE T5QLR.

SELECT SINGLE *
FROM T5QLR
INTO CORRESPONDING FIELDS OF WA_T5QLR
WHERE...

How to access SAP table T5QLR

Within an ECC or HANA version of SAP you can also view further information about T5QLR and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!