T5A9A SAP (Created Statement of Employment (A)) Table details

Dictionary Type: Table
Description: Created Statement of Employment (A)




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




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

T5A9A is a standard SAP Table which is used to store Created Statement of Employment (A) data and is available within R/3 SAP systems depending on the version and release level.

The T5A9A table consists of various fields, each holding specific information or linking keys about Created Statement of Employment (A) data available in SAP. These include PERNR (Personnel Number), FIRED (Leaving Date), AUSST (Date of Issue), ZWEIT (Cancelation/Duplicate Indicator).. 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)


SAP T5A9A 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 PERNR_DNUMC8PERNRPER
FIREDLeaving Date P03_FIREDDATS8DATUM
AUSSTDate of Issue P03_AUSSTDATS8DATUM
ZWEITCancelation/Duplicate Indicator P03_ZWEITCHAR1CHAR1
HIREDEntry Date P03_HIREDDATS8DATUM
FORMLForm Name TDFORMCHAR16TDFORM
AUSVL1st Part of SI Number (Sequential Number) AUSVLNUMC4NUM4
AUSVG2nd Part of SI Number (Birth Date) AUSVGNUMC8NUM8
NACHNLast Name PAD_NACHNCHAR40PAD_NACHN
VORNAFirst Name PAD_VORNACHAR40PAD_VORNM
ADDREEmployee Address: Street, Number, Postal Code, City P03_ADDRECHAR50TEXT50
NATIONationality NATIOCHAR15TEXT15
ENTGBEnd of Payment Entitlement (A) P03_ENTGBDATS8DATUM
BEALSOccupation P03_BEALSCHAR30TEXT30
LEHRVStart of Apprenticeship P03_LEHRVDATS8DATUM
LEHRBEnd of Apprenticeship P03_LEHRBDATS8DATUM
ASVGRSI group ASVGRCHAR1T5A1AASVGR
AUSVASocial Insurance Body AUSVACHAR2T5A1TAUSVA
ANSTAEmployment status ANSTANUMC1NUM1
GESCHGender Key GESCHCHAR1GESCH
DGSVNSI Contribution Account Number with Special Characters P03_DGSVNCHAR20CHAR20
AUSTGReason for leaving company P03_AUSTGCHAR2PB03_AGRD0
GRTXTReason for Leaving (Immediately/Early) P03_GRTXTCHAR18TEXT18
UETAGNo. of Working Days for Which UE/UA Was Paid P03_UETAGCHAR5
NIUEGReason for Nonpayment of UE/UA P03_NIUEGCHAR2P03_NIUEG
KEVONPay in Lieu of Notice From PB03_KEAB0DATS8DATS
KEBISPay in Lieu of Notice To PB03_KEBI0DATS8DATS
NIKEGReason for Nonpayment of Pay in Lieu of Notice P03_NIKEGCHAR2P03_NIKEG
BEZBIEnd of Payment Entitlement (A) P03_ENTGBDATS8DATUM
DGTELEmployer's Telephone Number P03_DGTELCHAR30
DGADREmployer's Postal Code and City P03_DGADRCHAR30
ADRL1Address line LINESCHAR80LINES
ADRL2Address line LINESCHAR80LINES
ADRL3Address line LINESCHAR80LINES
ADRL4Address line LINESCHAR80LINES
ADRL5Address line LINESCHAR80LINES
UNAMEUser Name SYUNAMECHAR12SYCHAR12
DATUMSystem Date SYDATUMDATS8SYDATS
UZEITSystem Time SYUZEITTIMS6SYTIME
TEILVStart of Part-Time Work P03_TEILVDATS8DATUM
TEILBEnd of Part-Time Work P03_TEILBDATS8DATUM

Key field Non-key field



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

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

SELECT SINGLE *
FROM T5A9A
INTO CORRESPONDING FIELDS OF WA_T5A9A
WHERE...

How to access SAP table T5A9A

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