T5LES SAP (ESS Malaysia: TP1 TP2) Table details

Dictionary Type: Table
Description: ESS Malaysia: TP1 TP2




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




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

T5LES is a standard SAP Table which is used to store ESS Malaysia: TP1 TP2 data and is available within R/3 SAP systems depending on the version and release level.

The T5LES table consists of various fields, each holding specific information or linking keys about ESS Malaysia: TP1 TP2 data available in SAP. These include RETYP (Request Type), OPDTY (Optional Deduction Type), PERNR (Personnel number), 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: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP T5LES 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
RETYPRequest Type PMY_RETYPCHAR4T5LRET
OPDTYOptional Deduction Type PMY_OPDTYCHAR5CHAR5
PERNRPersonnel number PERSNONUMC8PA0003PERSNOPER
ENDDAEnd Date ENDDADATS8DATUM
SEQNRSequence number PMY_SEQNRNUMC4NUMC4
BEGDAStart Date BEGDADATS8DATUM
REFNOReference No. PMY_REFNOCHAR17CHAR17
RQCIDRequest Creator PMY_RQCIDCHAR12CHAR12
RQCDTRequest Creation Date PMY_RQCDTDATS8DATUM
RQCTMRequest Creation Time PMY_RQCTMTIMS6TIME
RSNCDReason Code for Reject / Delete PMY_RSNCDCHAR3CHAR3
ARDDTApprove / Reject / Delete Date PMY_ARDDTDATS8DATUM
ITUDTInfotype Update Date PMY_ITUDTDATS8DATUM
PAYDTPayment Date PMY_PMTDTDATS8DATUM
CODATCompleted Date PMY_CODATDATS8DATUM
ITBDTInfotype Begin Date PMY_ITBDTDATS8DATUM
PHASEPhase Of the Request PMY_PHASECHAR1PMY_CPHAS
CSTATStatus Of the Request PMY_REQSTATUSCHAR1PMY_REQSTATUS
APUIDLast / Latest Approver User ID PMY_USRIDCHAR12UNAME
APLVLApprover Level PMY_APLVLCHAR2
APGRPApprover Group PMY_APRVR_GRPCHAR15CHAR15
LCUIDLast Change By User ID PMY_LCUIDCHAR12USRID
LCHDTLast Change Date PMY_LCHDTDATS8DATUM
LCHTMLast Change Time PMY_LCHTMTIMS6TIME
ISMSTMail Sent PMY_ISMSTCHAR1FLAG
EEMOBSAPoffice: ID of a SAPoffice object SO_OBJ_IDCHAR17SO_OBJ_ID
APMOBSAPoffice: ID of a SAPoffice object SO_OBJ_IDCHAR17SO_OBJ_ID
ADMOBSAPoffice: ID of a SAPoffice object SO_OBJ_IDCHAR17SO_OBJ_ID
RQAMTRequested Amount PMY_RQAMTCURR15(2) PRBETRG
APAMTApproved Amount PMY_APAMTCURR15(2) PRBETRG
UNITUnit Key PMY_CLM_UNITCHAR3Assigned to domainRPMSH
WAERSCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
CAPMTApproved Amount PMY_APAMTCURR15(2) PRBETRG
TDAMTApproved Amount PMY_APAMTCURR15(2) PRBETRG
RMAMTApproved Amount PMY_APAMTCURR15(2) PRBETRG
RECNOReceipt Number PMY_RECNOCHAR30CHAR30
RDATERequest Date PMY_RDATEDATS8DATUM
DESCRDescription PMY_DESCRCHAR120PMY_DESCR
SDAT1General Amount Field PMY_GENAMCURR15(2) PRBETRG
SDAT2General Amount Field PMY_GENAMCURR15(2) PRBETRG
DELFGBoolean Variable (X=True, -=False, Space=Unknown) BOOLEANCHAR1BOOLEAN
PAUIDLast / Latest Approver User ID PMY_USRIDCHAR12UNAME
REJDSRejection Description PMY_REJDSCHAR80TEXT80

Key field Non-key field



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

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

SELECT SINGLE *
FROM T5LES
INTO CORRESPONDING FIELDS OF WA_T5LES
WHERE...

How to access SAP table T5LES

Within an ECC or HANA version of SAP you can also view further information about T5LES 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!