SAP ABAP Table PTEX2000 (Interface Table for Attendances/Absences Infotype(2001/2002))

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	PTEX2000	Table Relationship Diagram
Short Description	Interface Table for Attendances/Absences Infotype(2001/2002)

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

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in