SAP ABAP Table TEXLGA (Employee Expenditures)

Hierarchy

☛ SAP_HRRXX (Software Component) Sub component SAP_HRRXX of SAP_HR
   ⤷ PT (Application Component) Personnel Time Management
     ⤷ PTIM (Package) HR Time Management Application Development

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	TEXLGA	Table Relationship Diagram
Short Description	Employee Expenditures

Delivery and Maintenance

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

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	PDSNR	☑	PDSNR_D	PDSNR	NUMC	12	0	Sequential number for PDC messages	PDSNR
3	PERNR	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
4	ZAUSW	☐	DZAUSW	ZAUSW	NUMC	8	0	Time Recording ID Number
5	LDATE	☐	LDATE	DATUM	DATS	8	0	Logical Date
6	LTIME	☐	LTIME	UZEIT	TIMS	6	0	Logical time
7	ERDAT	☐	PHDAT	DATUM	DATS	8	0	Created on
8	ERTIM	☐	PHTIM	UZEIT	TIMS	6	0	Created at
9	TERID	☐	TERID	TERID	CHAR	4	0	Terminal ID
10	EXLGA	☐	EXLGA	EXLGA	CHAR	4	0	Employee Expenditures
11	ZEINH	☐	PT_ZEINH	RPMSH	CHAR	3	0	Time/Measurement Unit	T538A
12	HRAZL	☐	HRAZL	PTM_DEC5_2S	DEC	7	2	Number
13	HRBET	☐	HRBET	WERTV5	CURR	9	2	Amount for remuneration information
14	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
15	.INCLUDE	☐				0	0	Substructure of Interface File for Log
16	UNAME1	☐	PW_UNAME1	UNAME	CHAR	12	0	User who wrote record to interface
17	DATUM1	☐	PW_DATUM1	DATUM	DATS	8	0	Date on which record was written to interface
18	UZEIT1	☐	PW_UZEIT1	UZEIT	TIMS	6	0	Time at which record was written to interface
19	PGMID1	☐	PW_PGMID1	PROGNAME	CHAR	40	0	Write Record to Interface Report
20	UNAME2	☐	PW_UNAME2	UNAME	CHAR	12	0	Name of user who initially accessed record
21	DATUM2	☐	PW_DATUM2	DATUM	DATS	8	0	Date on which record was initially accessed
22	UZEIT2	☐	PW_UZEIT2	UZEIT	TIMS	6	0	Time at which record was initially accessed
23	PGMID2	☐	PW_PGMID2	PROGNAME	CHAR	40	0	Report used to access record initially
24	STATU2	☐	PW_STATU2	PW_STATU	CHAR	1	0	Log status when record was first accessed
25	UNAME3	☐	PW_UNAME3	UNAME	CHAR	12	0	Last user to access record
26	DATUM3	☐	PW_DATUM3	DATUM	DATS	8	0	Date on which record was last accessed
27	UZEIT3	☐	PW_UZEIT3	UZEIT	TIMS	6	0	Time at which record was last accessed
28	PGMID3	☐	PW_PGMID3	PROGNAME	CHAR	40	0	Last Used to Access Record Program
29	STATU3	☐	PW_STATU3	PW_STATU	CHAR	1	0	Log status when record was last accessed
30	UNAME4	☐	PW_UNAME4	UNAME	CHAR	12	0	User who first retrieved the record successfully
31	DATUM4	☐	PW_DATUM4	DATUM	DATS	8	0	Date on which record was first retrieved successfully
32	UZEIT4	☐	PW_UZEIT4	UZEIT	TIMS	6	0	Time at which record was first retrieved successfully
33	PGMID4	☐	PW_PGMID4	PROGNAME	CHAR	40	0	Report first used to retrieve record successfully

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TEXLGA	MANDT	T000	MANDT
2	TEXLGA	PDSNR	PDSNR	PDSNR
3	TEXLGA	ZEINH	T538A	ZEINH

History

Last changed by/on	SAP	20020219
SAP Release Created in