PA0123 SAP (Infotype 0123 (Default Disrup. Ev.-SI Income Thresh.Deficit) Table details

Dictionary Type: Table
Description: Infotype 0123 (Default Disrup. Ev.-SI Income Thresh.Deficit




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




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

PA0123 is a standard SAP Table which is used to store Infotype 0123 (Default Disrup. Ev.-SI Income Thresh.Deficit data and is available within R/3 SAP systems depending on the version and release level.

The PA0123 table consists of various fields, each holding specific information or linking keys about Infotype 0123 (Default Disrup. Ev.-SI Income Thresh.Deficit 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 PA0123 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
VGARTStandard Type of Disruptive Event SI in Infotype 0123 P01_VGBARTCHAR1P01_VGBART
KVZAJDefault Increase Disruptive Event ITD Current Year P01_KVZAJVCURR15(2) P01_VZLUFT
RVZAJDefault Increase Disruptive Event PI ITD Current Year P01_RVZAJVCURR15(2) P01_VZLUFT
RBZAJDefault Inc. Disr. Ev. PI ITD Current Year (Pension Scheme) P01_RBZAJVCURR15(2) P01_VZLUFT
AVZAJDefault Increase Disruptive Event UI ITD Current Year P01_AVZAJVCURR15(2) P01_VZLUFT
PVZAJDefault Increase Disruptive Event CI ITD Current Year P01_PVZAJVCURR15(2) P01_VZLUFT
KVZVJDefault Increase Disruptive Event HI ITD Previous Year P01_KVZVJVCURR15(2) P01_VZLUFT
RVZVJDefault Increase Disruptive Event PI ITD Previous Year P01_RVZVJVCURR15(2) P01_VZLUFT
RBZVJDefault Inc. Disr. Ev. PI ITD Previous Year (Pension Scheme) P01_RBZVJVCURR15(2) P01_VZLUFT
AVZVJDefault Increase Disruptive Event UI ITD Previous Year P01_AVZVJVCURR15(2) P01_VZLUFT
PVZVJDefault Increase Disruptive Event CI ITD Previous Year P01_PVZVJVCURR15(2) P01_VZLUFT
KVVVJDefault Total: Disruptive Event HI ITD to Year Before Last P01_KVVVJVCURR15(2) P01_VZLUFT
RVVVJDefault Total Disruptive Event PI ITD to Year before Last P01_RVVVJVCURR15(2) P01_VZLUFT
RBVVJDefault Total Disr. Ev. PI ITD (Pension Scheme) Year bf.Last P01_RBVVJVCURR15(2) P01_VZLUFT
AVVVJDefault Total Disruptive Event UI ITD to Year before Last P01_AVVVJVCURR15(2) P01_VZLUFT
PVVVJDefault Total Disruptive Event UI ITD to Year before Last P01_PVVVJVCURR15(2) P01_VZLUFT
KVKNZContribution Group Key: Health Insurance P01_KVKNZCHAR1P01_KVKNZ
RVKNZContribution Group Key: Pension Insurance P01_RVKNZCHAR1P01_RVKNZ
AVKNZContribution Group Key: Unemployment Insurance P01_AVKNZCHAR1P01_AVKNZ
PVKNZContribution Group Key: Care Insurance P01_PVKNZCHAR1P01_PVKNZ
WERKSDefault Personnel Area for Disruptive Event P01_WERKSVCHAR4T500PPERSA
BTRTLDefault Personnel Subarea for Disruptive Event P01_BTRTLVCHAR4T5D0PBTRTL

Key field Non-key field



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

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

SELECT SINGLE *
FROM PA0123
INTO CORRESPONDING FIELDS OF WA_PA0123
WHERE...

How to access SAP table PA0123

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