PA0261 SAP (Leave Accrual Australia) Table details

Dictionary Type: Table
Description: Leave Accrual Australia




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




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

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

The PA0261 table consists of various fields, each holding specific information or linking keys about Leave Accrual Australia data available in SAP. These include PERNR (Personnel number), SUBTY (Subtype), OBJPS (Object Identification), SPRPS (Lock Indicator for HR Master Data Record).. 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 PA0261 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
PERNRPersonnel number PERSNONUMC8PA0003PERSNOPER
SUBTYSubtype SUBTYCHAR4SUBTYSUB
OBJPSObject Identification OBJPSCHAR2OBJPSOPS
SPRPSLock Indicator for HR Master Data Record SPRPSCHAR1SPRPS
ENDDAEnd Date ENDDADATS8DATUM
BEGDAStart Date BEGDADATS8DATUM
SEQNRNumber of Infotype Record with Same Key SEQNRNUMC3NUM03
AEDTMChanged On AEDATDATS8DATUM
UNAMEName of Person Who Changed Object AENAMCHAR12USNAM
HISTOHistorical Record Flag HISTOCHAR1CHAR1
ITXEXText Exists for Infotype ITXEXCHAR1XFELD
REFEXReference Fields Exist (Primary/Secondary Costs) PRFEXCHAR1XFELD
ORDEXConfirmation Fields Exist ORDEXCHAR1XFELD
ITBLDInfotype Screen Control ITBLDCHAR2CHAR2
PREASReason for Changing Master Data PREASCHAR2T530EPREAS
FLAG1Reserved Field/Unused Field NUSEDCHAR1NUSED
FLAG2Reserved Field/Unused Field NUSEDCHAR1NUSED
FLAG3Reserved Field/Unused Field NUSEDCHAR1NUSED
FLAG4Reserved Field/Unused Field NUSEDCHAR1NUSED
RESE1Reserved Field/Unused Field of Length 2 NUSED2CHAR2NUSED2
RESE2Reserved Field/Unused Field of Length 2 NUSED2CHAR2NUSED2
GRPVLGrouping Value for Personnel Assignments PCCE_GPVALCHAR4PCCE_GPVAL
UAR01Leave type URARTCHAR2T533URART
AID01Leave Accrual Identifier Australia P13Q_ACCIDNUMC2Assigned to domainP13Q_ACCID
ANN01Last Anniversary Date (Leave Accrual Australia) P13Q_LTANNDATS8DATUM
ENT01Leave entitlement PTM_HENTITLEDEC10(5) PTM_QUONUM
ACC01Leave Accrual Adjustment Amount P13Q_ACCRUDEC8(5) P13Q_ACCRU
STA01Status of Record (Loading Leave Balances Australia) P13Q_STATUCHAR2P13Q_STATU
UAR02Leave type URARTCHAR2T533URART
AID02Leave Accrual Identifier Australia P13Q_ACCIDNUMC2Assigned to domainP13Q_ACCID
ANN02Last Anniversary Date (Leave Accrual Australia) P13Q_LTANNDATS8DATUM
ENT02Leave entitlement PTM_HENTITLEDEC10(5) PTM_QUONUM
ACC02Leave Accrual Adjustment Amount P13Q_ACCRUDEC8(5) P13Q_ACCRU
STA02Status of Record (Loading Leave Balances Australia) P13Q_STATUCHAR2P13Q_STATU
UAR03Leave type URARTCHAR2T533URART
AID03Leave Accrual Identifier Australia P13Q_ACCIDNUMC2Assigned to domainP13Q_ACCID
ANN03Last Anniversary Date (Leave Accrual Australia) P13Q_LTANNDATS8DATUM
ENT03Leave entitlement PTM_HENTITLEDEC10(5) PTM_QUONUM
ACC03Leave Accrual Adjustment Amount P13Q_ACCRUDEC8(5) P13Q_ACCRU
STA03Status of Record (Loading Leave Balances Australia) P13Q_STATUCHAR2P13Q_STATU
UAR04Leave type URARTCHAR2T533URART
AID04Leave Accrual Identifier Australia P13Q_ACCIDNUMC2Assigned to domainP13Q_ACCID
ANN04Last Anniversary Date (Leave Accrual Australia) P13Q_LTANNDATS8DATUM
ENT04Leave entitlement PTM_HENTITLEDEC10(5) PTM_QUONUM
ACC04Leave Accrual Adjustment Amount P13Q_ACCRUDEC8(5) P13Q_ACCRU
STA04Status of Record (Loading Leave Balances Australia) P13Q_STATUCHAR2P13Q_STATU
UAR05Leave type URARTCHAR2T533URART
AID05Leave Accrual Identifier Australia P13Q_ACCIDNUMC2Assigned to domainP13Q_ACCID
ANN05Last Anniversary Date (Leave Accrual Australia) P13Q_LTANNDATS8DATUM
ENT05Leave entitlement PTM_HENTITLEDEC10(5) PTM_QUONUM
ACC05Leave Accrual Adjustment Amount P13Q_ACCRUDEC8(5) P13Q_ACCRU
STA05Status of Record (Loading Leave Balances Australia) P13Q_STATUCHAR2P13Q_STATU
UAR06Leave type URARTCHAR2T533URART
AID06Leave Accrual Identifier Australia P13Q_ACCIDNUMC2Assigned to domainP13Q_ACCID
ANN06Last Anniversary Date (Leave Accrual Australia) P13Q_LTANNDATS8DATUM
ENT06Leave entitlement PTM_HENTITLEDEC10(5) PTM_QUONUM
ACC06Leave Accrual Adjustment Amount P13Q_ACCRUDEC8(5) P13Q_ACCRU
STA06Status of Record (Loading Leave Balances Australia) P13Q_STATUCHAR2P13Q_STATU
UAR07Leave type URARTCHAR2T533URART
AID07Leave Accrual Identifier Australia P13Q_ACCIDNUMC2Assigned to domainP13Q_ACCID
ANN07Last Anniversary Date (Leave Accrual Australia) P13Q_LTANNDATS8DATUM
ENT07Leave entitlement PTM_HENTITLEDEC10(5) PTM_QUONUM
ACC07Leave Accrual Adjustment Amount P13Q_ACCRUDEC8(5) P13Q_ACCRU
STA07Status of Record (Loading Leave Balances Australia) P13Q_STATUCHAR2P13Q_STATU
UAR08Leave type URARTCHAR2T533URART
AID08Leave Accrual Identifier Australia P13Q_ACCIDNUMC2Assigned to domainP13Q_ACCID
ANN08Last Anniversary Date (Leave Accrual Australia) P13Q_LTANNDATS8DATUM
ENT08Leave entitlement PTM_HENTITLEDEC10(5) PTM_QUONUM
ACC08Leave Accrual Adjustment Amount P13Q_ACCRUDEC8(5) P13Q_ACCRU
STA08Status of Record (Loading Leave Balances Australia) P13Q_STATUCHAR2P13Q_STATU
UAR09Leave type URARTCHAR2T533URART
AID09Leave Accrual Identifier Australia P13Q_ACCIDNUMC2Assigned to domainP13Q_ACCID
ANN09Last Anniversary Date (Leave Accrual Australia) P13Q_LTANNDATS8DATUM
ENT09Leave entitlement PTM_HENTITLEDEC10(5) PTM_QUONUM
ACC09Leave Accrual Adjustment Amount P13Q_ACCRUDEC8(5) P13Q_ACCRU
STA09Status of Record (Loading Leave Balances Australia) P13Q_STATUCHAR2P13Q_STATU
UAR10Leave type URARTCHAR2T533URART
AID10Leave Accrual Identifier Australia P13Q_ACCIDNUMC2Assigned to domainP13Q_ACCID
ANN10Last Anniversary Date (Leave Accrual Australia) P13Q_LTANNDATS8DATUM
ENT10Leave entitlement PTM_HENTITLEDEC10(5) PTM_QUONUM
ACC10Leave Accrual Adjustment Amount P13Q_ACCRUDEC8(5) P13Q_ACCRU
STA10Status of Record (Loading Leave Balances Australia) P13Q_STATUCHAR2P13Q_STATU
UAR11Leave type URARTCHAR2T533URART
AID11Leave Accrual Identifier Australia P13Q_ACCIDNUMC2Assigned to domainP13Q_ACCID
ANN11Last Anniversary Date (Leave Accrual Australia) P13Q_LTANNDATS8DATUM
ENT11Leave entitlement PTM_HENTITLEDEC10(5) PTM_QUONUM
ACC11Leave Accrual Adjustment Amount P13Q_ACCRUDEC8(5) P13Q_ACCRU
STA11Status of Record (Loading Leave Balances Australia) P13Q_STATUCHAR2P13Q_STATU
UAR12Leave type URARTCHAR2T533URART
AID12Leave Accrual Identifier Australia P13Q_ACCIDNUMC2Assigned to domainP13Q_ACCID
ANN12Last Anniversary Date (Leave Accrual Australia) P13Q_LTANNDATS8DATUM
ENT12Leave entitlement PTM_HENTITLEDEC10(5) PTM_QUONUM
ACC12Leave Accrual Adjustment Amount P13Q_ACCRUDEC8(5) P13Q_ACCRU
STA12Status of Record (Loading Leave Balances Australia) P13Q_STATUCHAR2P13Q_STATU
UAR13Leave type URARTCHAR2T533URART
AID13Leave Accrual Identifier Australia P13Q_ACCIDNUMC2Assigned to domainP13Q_ACCID
ANN13Last Anniversary Date (Leave Accrual Australia) P13Q_LTANNDATS8DATUM
ENT13Leave entitlement PTM_HENTITLEDEC10(5) PTM_QUONUM
ACC13Leave Accrual Adjustment Amount P13Q_ACCRUDEC8(5) P13Q_ACCRU
STA13Status of Record (Loading Leave Balances Australia) P13Q_STATUCHAR2P13Q_STATU
UAR14Leave type URARTCHAR2T533URART
AID14Leave Accrual Identifier Australia P13Q_ACCIDNUMC2Assigned to domainP13Q_ACCID
ANN14Last Anniversary Date (Leave Accrual Australia) P13Q_LTANNDATS8DATUM
ENT14Leave entitlement PTM_HENTITLEDEC10(5) PTM_QUONUM
ACC14Leave Accrual Adjustment Amount P13Q_ACCRUDEC8(5) P13Q_ACCRU
STA14Status of Record (Loading Leave Balances Australia) P13Q_STATUCHAR2P13Q_STATU
UAR15Leave type URARTCHAR2T533URART
AID15Leave Accrual Identifier Australia P13Q_ACCIDNUMC2Assigned to domainP13Q_ACCID
ANN15Last Anniversary Date (Leave Accrual Australia) P13Q_LTANNDATS8DATUM
ENT15Leave entitlement PTM_HENTITLEDEC10(5) PTM_QUONUM
ACC15Leave Accrual Adjustment Amount P13Q_ACCRUDEC8(5) P13Q_ACCRU
STA15Status of Record (Loading Leave Balances Australia) P13Q_STATUCHAR2P13Q_STATU
UAR16Leave type URARTCHAR2T533URART
AID16Leave Accrual Identifier Australia P13Q_ACCIDNUMC2Assigned to domainP13Q_ACCID
ANN16Last Anniversary Date (Leave Accrual Australia) P13Q_LTANNDATS8DATUM
ENT16Leave entitlement PTM_HENTITLEDEC10(5) PTM_QUONUM
ACC16Leave Accrual Adjustment Amount P13Q_ACCRUDEC8(5) P13Q_ACCRU
STA16Status of Record (Loading Leave Balances Australia) P13Q_STATUCHAR2P13Q_STATU
UAR17Leave type URARTCHAR2T533URART
AID17Leave Accrual Identifier Australia P13Q_ACCIDNUMC2Assigned to domainP13Q_ACCID
ANN17Last Anniversary Date (Leave Accrual Australia) P13Q_LTANNDATS8DATUM
ENT17Leave entitlement PTM_HENTITLEDEC10(5) PTM_QUONUM
ACC17Leave Accrual Adjustment Amount P13Q_ACCRUDEC8(5) P13Q_ACCRU
STA17Status of Record (Loading Leave Balances Australia) P13Q_STATUCHAR2P13Q_STATU
UAR18Leave type URARTCHAR2T533URART
AID18Leave Accrual Identifier Australia P13Q_ACCIDNUMC2Assigned to domainP13Q_ACCID
ANN18Last Anniversary Date (Leave Accrual Australia) P13Q_LTANNDATS8DATUM
ENT18Leave entitlement PTM_HENTITLEDEC10(5) PTM_QUONUM
ACC18Leave Accrual Adjustment Amount P13Q_ACCRUDEC8(5) P13Q_ACCRU
STA18Status of Record (Loading Leave Balances Australia) P13Q_STATUCHAR2P13Q_STATU
UAR19Leave type URARTCHAR2T533URART
AID19Leave Accrual Identifier Australia P13Q_ACCIDNUMC2Assigned to domainP13Q_ACCID
ANN19Last Anniversary Date (Leave Accrual Australia) P13Q_LTANNDATS8DATUM
ENT19Leave entitlement PTM_HENTITLEDEC10(5) PTM_QUONUM
ACC19Leave Accrual Adjustment Amount P13Q_ACCRUDEC8(5) P13Q_ACCRU
STA19Status of Record (Loading Leave Balances Australia) P13Q_STATUCHAR2P13Q_STATU
UAR20Leave type URARTCHAR2T533URART
AID20Leave Accrual Identifier Australia P13Q_ACCIDNUMC2Assigned to domainP13Q_ACCID
ANN20Last Anniversary Date (Leave Accrual Australia) P13Q_LTANNDATS8DATUM
ENT20Leave entitlement PTM_HENTITLEDEC10(5) PTM_QUONUM
ACC20Leave Accrual Adjustment Amount P13Q_ACCRUDEC8(5) P13Q_ACCRU
STA20Status of Record (Loading Leave Balances Australia) P13Q_STATUCHAR2P13Q_STATU

Key field Non-key field



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

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

SELECT SINGLE *
FROM PA0261
INTO CORRESPONDING FIELDS OF WA_PA0261
WHERE...

How to access SAP table PA0261

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