SAP ABAP Table PTEXLST (List Output for External Interfaces)

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	INTTAB	Structure
Structure	PTEXLST	Table Relationship Diagram
Short Description	List Output for External Interfaces

Delivery and Maintenance

Pool/cluster
Delivery Class
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	.INCLUDE	☐				0	0	Interface Table for Attendances/Absences Infotype(2001/2002)
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
3	LOGSYS	☐	AWSYS	LOGSYS	CHAR	10	0	Logical system of source document	*
4	AWTYP	☐	AWTYP	AWTYP	CHAR	5	0	Reference procedure	*
5	AWKEY	☐	AWKEY	AWKEY	CHAR	20	0	Object key
6	STOKZ	☐	HR_STOKZ	FLAG	CHAR	1	0	Indicator: Data Record Canceled
7	CUSTFLD	☐	HR_USRFLD	CHAR40	CHAR	40	0	Customer-Specific Field
8	PERNR	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
9	BEGDA	☐	BEGDA	DATUM	DATS	8	0	Start Date
10	ENDDA	☐	ENDDA	DATUM	DATS	8	0	End Date
11	SPRPS	☐	SPRPS	SPRPS	CHAR	1	0	Lock Indicator for HR Master Data Record
12	.INCLUDE	☐				0	0	Substructure of Interface File for Log
13	UNAME1	☐	PW_UNAME1	UNAME	CHAR	12	0	User who wrote record to interface
14	DATUM1	☐	PW_DATUM1	DATUM	DATS	8	0	Date on which record was written to interface
15	UZEIT1	☐	PW_UZEIT1	UZEIT	TIMS	6	0	Time at which record was written to interface
16	PGMID1	☐	PW_PGMID1	PROGNAME	CHAR	40	0	Write Record to Interface Report
17	UNAME2	☐	PW_UNAME2	UNAME	CHAR	12	0	Name of user who initially accessed record
18	DATUM2	☐	PW_DATUM2	DATUM	DATS	8	0	Date on which record was initially accessed
19	UZEIT2	☐	PW_UZEIT2	UZEIT	TIMS	6	0	Time at which record was initially accessed
20	PGMID2	☐	PW_PGMID2	PROGNAME	CHAR	40	0	Report used to access record initially
21	STATU2	☐	PW_STATU2	PW_STATU	CHAR	1	0	Log status when record was first accessed
22	UNAME3	☐	PW_UNAME3	UNAME	CHAR	12	0	Last user to access record
23	DATUM3	☐	PW_DATUM3	DATUM	DATS	8	0	Date on which record was last accessed
24	UZEIT3	☐	PW_UZEIT3	UZEIT	TIMS	6	0	Time at which record was last accessed
25	PGMID3	☐	PW_PGMID3	PROGNAME	CHAR	40	0	Last Used to Access Record Program
26	STATU3	☐	PW_STATU3	PW_STATU	CHAR	1	0	Log status when record was last accessed
27	UNAME4	☐	PW_UNAME4	UNAME	CHAR	12	0	User who first retrieved the record successfully
28	DATUM4	☐	PW_DATUM4	DATUM	DATS	8	0	Date on which record was first retrieved successfully
29	UZEIT4	☐	PW_UZEIT4	UZEIT	TIMS	6	0	Time at which record was first retrieved successfully
30	PGMID4	☐	PW_PGMID4	PROGNAME	CHAR	40	0	Report first used to retrieve record successfully
31	.INCLUDE	☐				0	0	Interface Structure for IT 2001/2 (Field Seln for PS2001/2)
32	AWART	☐	AWART	AWART	CHAR	4	0	Attendance or Absence Type	*
33	BEGUZ	☐	BEGUZ	UZEIT	TIMS	6	0	Start Time
34	ENDUZ	☐	ENDUZ	UZEIT	TIMS	6	0	End Time
35	STDAZ	☐	ABSTD	JRSTD	DEC	7	2	Absence hours
36	VTKEN	☐	VTKEN	XFELD	CHAR	1	0	Previous Day Indicator
37	ALLDF	☐	ALLDF	XFELD	CHAR	1	0	Record is for Full Day
38	VERSL	☐	VRSCH	VRSCH	CHAR	1	0	Overtime Compensation Type	*
39	.INCLUDE	☐				0	0	Different Payment
40	TRFGR	☐	TRFGR	TRFGR	CHAR	8	0	Pay Scale Group	*
41	TRFST	☐	TRFST	TRFST	CHAR	2	0	Pay Scale Level	*
42	PRAKN	☐	PRAKN	PRAKN	CHAR	2	0	Premium Number	T510P
43	PRAKZ	☐	PRAKZ	PRAKZ	NUMC	4	0	Premium Indicator
44	OTYPE	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	T778O
45	PLANS	☐	PLANS	PLANS	NUMC	8	0	Position	T528B
46	AUFKZ	☐	AUFKN	AUFKN	CHAR	1	0	Extra Pay Indicator
47	BWGRL	☐	PTM_VBAS7S	P_AMT07V	CURR	13	2	Valuation Basis for Different Payment
48	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
49	WTART	☐	WTART	WRKAR	CHAR	4	0	Work tax area	T5UTB
50	.INCLUDE	☐				0	0	Interface Table for Infotypes: Acct Assgnmnt Objects
51	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
52	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
53	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
54	LTLST	☐	LSTAR	LSTAR	CHAR	6	0	Activity Type	*
55	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
56	KSTRG	☐	KSTRG	KSTRG	CHAR	12	0	Cost Object	*
57	PS_POSID	☐	PS_POSID	PS_POSID	CHAR	24	0	Work Breakdown Structure Element (WBS Element)
58	NPLNR	☐	NPLNR	AUFNR	CHAR	12	0	Network Number for Account Assignment	*
59	VORNR	☐	VORNR	VORNR	CHAR	4	0	Operation/Activity Number
60	KDAUF	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	*
61	KDPOS	☐	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
62	PRZNR	☐	CO_PRZNR	CO_PRZNR	CHAR	12	0	Business Process	*
63	FISTL	☐	FISTL	FISTL	CHAR	16	0	Funds Center	*
64	FIPOS	☐	FIPOS	FIPOS	CHAR	14	0	Commitment Item	*
65	GEBER	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	*
66	EBELN	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	*
67	EBELP	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	*
68	LSTNR	☐	ASNUM	ASNUM	CHAR	18	0	Activity Number	*
69	STELL	☐	STELL	STELL	NUMC	8	0	Job	*
70	SBUKR	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
71	SGSBR	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
72	SKOST	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
73	LSTAR	☐	LSTAR	LSTAR	CHAR	6	0	Activity Type	*
74	SGTXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
75	DART	☐	DART	DART	CHAR	2	0	Service Type (Public Service Germany)	T5D7C
76	UDART	☐	UDART	UDART	CHAR	2	0	Service Category (Public Service Germany)	T5D7E
77	FKBER	☐	FKBER	FKBER	CHAR	16	0	Functional Area	*
78	GRANT_NBR	☐	GM_GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	Grant
79	SGEBER	☐	FM_SFONDS	BP_GEBER	CHAR	10	0	Sender fund	*
80	SFKBER	☐	SFKTBER	FKBER	CHAR	16	0	Sending Functional Area	*
81	SGRANT_NBR	☐	GM_GRANT_SENDER	GM_GRANT_NBR	CHAR	20	0	Sender Grant
82	FIPEX	☐	FM_FIPEX	FM_FIPEX	CHAR	24	0	Commitment item	*
83	LGART	☐	LGART	LGART	CHAR	4	0	Wage Type	*
84	ANZHL	☐	ANZHL	ANZHL	DEC	7	2	Number
85	ZEINH	☐	PT_ZEINH	RPMSH	CHAR	3	0	Time/Measurement Unit	T538A
86	BETRG	☐	PAD_AMT7S	P_AMT07V	CURR	13	2	Wage Type Amount for Payments
87	EXBEL	☐	EXBEL	CHAR08	CHAR	8	0	External Document Number
88	.INCLUDE	☐				0	0	Planned Time Specification for a Day: General Specifications
89	VTART	☐	VTART	VTART	CHAR	2	0	Substitution Type	*
90	TPROG	☐	TPROG	TPROG	CHAR	4	0	Daily Work Schedule	*
91	VARIA	☐	VARIA	VARIA	CHAR	1	0	Daily Work Schedule Variant
92	PAMOD	☐	PAMOD	PAMOD	CHAR	4	0	Work Break Schedule	*
93	NO_BREAKS	☐	RP_XFELD	XFELD	CHAR	1	0	Checkbox
94	TPKLA	☐	TPKLA	TPKLA	CHAR	1	0	Daily Work Schedule Class
95	TAGTY	☐	TAGTY	TAGTY	CHAR	1	0	Day Type
96	LIGHTS	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
97	CHECKBOX	☐	XFELD	XFELD	CHAR	1	0	Checkbox
98	ROW	☐	INT4	INT4	INT4	10	0	Natural number

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PTEXLST	BUKRS	T001	BUKRS
2	PTEXLST	DART	T5D7C	DART
3	PTEXLST	GSBER	TGSB	GSBER
4	PTEXLST	OTYPE	T778O	OTYPE
5	PTEXLST	PLANS	T528B	PLANS
6	PTEXLST	PRAKN	T510P	PRAKN
7	PTEXLST	SBUKR	T001	BUKRS
8	PTEXLST	SGSBR	TGSB	GSBER
9	PTEXLST	UDART	T5D7E	UDART
10	PTEXLST	WAERS	TCURC	WAERS
11	PTEXLST	WTART	T5UTB	TAXAR
12	PTEXLST	ZEINH	T538A	ZEINH

History

Last changed by/on	SAP	20130529
SAP Release Created in