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

Hierarchy

☛ SAP_HRCAT (Software Component) Sub component SAP_HRCAT of SAP_HR
   ⤷ PA-PA-AT (Application Component) Austria
     ⤷ PB03 (Package) HR Master Data: Austria

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	T5A9A	Table Relationship Diagram
Short Description	Created Statement of Employment (A)

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	PERNR	☑	PERNR_D	PERNR	NUMC	8	0	Personnel Number
3	FIRED	☑	P03_FIRED	DATUM	DATS	8	0	Leaving Date
4	AUSST	☑	P03_AUSST	DATUM	DATS	8	0	Date of Issue
5	ZWEIT	☑	P03_ZWEIT	CHAR1	CHAR	1	0	Cancelation/Duplicate Indicator
6	HIRED	☐	P03_HIRED	DATUM	DATS	8	0	Entry Date
7	FORML	☐	TDFORM	TDFORM	CHAR	16	0	Form name
8	AUSVL	☐	AUSVL	NUM4	NUMC	4	0	1st part of SI number (sequential number)
9	AUSVG	☐	AUSVG	NUM8	NUMC	8	0	2nd part of SI number (birthdate)
10	NACHN	☐	PAD_NACHN	PAD_NACHN	CHAR	40	0	Last Name
11	VORNA	☐	PAD_VORNA	PAD_VORNM	CHAR	40	0	First Name
12	ADDRE	☐	P03_ADDRE	TEXT50	CHAR	50	0	Employee Address: Street, Number, Postal Code, City
13	NATIO	☐	NATIO	TEXT15	CHAR	15	0	Nationality
14	ENTGB	☐	P03_ENTGB	DATUM	DATS	8	0	End of Payment Entitlement (A)
15	BEALS	☐	P03_BEALS	TEXT30	CHAR	30	0	Occupation
16	LEHRV	☐	P03_LEHRV	DATUM	DATS	8	0	Start of Apprenticeship
17	LEHRB	☐	P03_LEHRB	DATUM	DATS	8	0	End of Apprenticeship
18	ASVGR	☐	ASVGR	ASVGR	CHAR	1	0	SI group	T5A1A
19	AUSVA	☐	AUSVA	AUSVA	CHAR	2	0	Social Insurance Body	T5A1T
20	ANSTA	☐	ANSTA	NUM1	NUMC	1	0	Employment status
21	GESCH	☐	GESCH	GESCH	CHAR	1	0	Gender Key
22	DGSVN	☐	P03_DGSVN	CHAR20	CHAR	20	0	SI Contribution Account Number with Special Characters
23	AUSTG	☐	P03_AUSTG	PB03_AGRD0	CHAR	2	0	Reason for leaving company
24	GRTXT	☐	P03_GRTXT	TEXT18	CHAR	18	0	Reason for Leaving (Immediately/Early)
25	UETAG	☐	P03_UETAG		CHAR	5	0	No. of Working Days for Which UE/UA Was Paid
26	NIUEG	☐	P03_NIUEG	P03_NIUEG	CHAR	2	0	Reason for Nonpayment of UE/UA
27	KEVON	☐	PB03_KEAB0	DATS	DATS	8	0	Pay in Lieu of Notice From
28	KEBIS	☐	PB03_KEBI0	DATS	DATS	8	0	Pay in Lieu of Notice To
29	NIKEG	☐	P03_NIKEG	P03_NIKEG	CHAR	2	0	Reason for Nonpayment of Pay in Lieu of Notice
30	BEZBI	☐	P03_ENTGB	DATUM	DATS	8	0	End of Payment Entitlement (A)
31	DGTEL	☐	P03_DGTEL		CHAR	30	0	Employer's Telephone Number
32	DGADR	☐	P03_DGADR		CHAR	30	0	Employer's Postal Code and City
33	ADRL1	☐	LINES	LINES	CHAR	80	0	Address line
34	ADRL2	☐	LINES	LINES	CHAR	80	0	Address line
35	ADRL3	☐	LINES	LINES	CHAR	80	0	Address line
36	ADRL4	☐	LINES	LINES	CHAR	80	0	Address line
37	ADRL5	☐	LINES	LINES	CHAR	80	0	Address line
38	UNAME	☐	SYUNAME	SYCHAR12	CHAR	12	0	User Name
39	DATUM	☐	SYDATUM	SYDATS	DATS	8	0	System Date
40	UZEIT	☐	SYUZEIT	SYTIME	TIMS	6	0	System Time
41	TEILV	☐	P03_TEILV	DATUM	DATS	8	0	Start of Part-Time Work
42	TEILB	☐	P03_TEILB	DATUM	DATS	8	0	End of Part-Time Work

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	T5A9A	ASVGR	T5A1A	ASVGR
2	T5A9A	AUSVA	T5A1T	AUSVA
3	T5A9A	MANDT	T000	MANDT

History

Last changed by/on	SAP	20140121
SAP Release Created in