SAP ABAP Table PTEX2003GEN (Interface Table for IT 2003: General Information)

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	PTEX2003GEN	Table Relationship Diagram
Short Description	Interface Table for IT 2003: General Information

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	DATUM	☐	HR_DATE	DATUM	DATS	8	0	Validity Date
9	SPRPS	☐	SPRPS	SPRPS	CHAR	1	0	Lock Indicator for HR Master Data Record
10	.INCLUDE	☐				0	0	Substructure of Interface File for Log
11	UNAME1	☐	PW_UNAME1	UNAME	CHAR	12	0	User who wrote record to interface
12	DATUM1	☐	PW_DATUM1	DATUM	DATS	8	0	Date on which record was written to interface
13	UZEIT1	☐	PW_UZEIT1	UZEIT	TIMS	6	0	Time at which record was written to interface
14	PGMID1	☐	PW_PGMID1	PROGNAME	CHAR	40	0	Write Record to Interface Report
15	UNAME2	☐	PW_UNAME2	UNAME	CHAR	12	0	Name of user who initially accessed record
16	DATUM2	☐	PW_DATUM2	DATUM	DATS	8	0	Date on which record was initially accessed
17	UZEIT2	☐	PW_UZEIT2	UZEIT	TIMS	6	0	Time at which record was initially accessed
18	PGMID2	☐	PW_PGMID2	PROGNAME	CHAR	40	0	Report used to access record initially
19	STATU2	☐	PW_STATU2	PW_STATU	CHAR	1	0	Log status when record was first accessed
20	UNAME3	☐	PW_UNAME3	UNAME	CHAR	12	0	Last user to access record
21	DATUM3	☐	PW_DATUM3	DATUM	DATS	8	0	Date on which record was last accessed
22	UZEIT3	☐	PW_UZEIT3	UZEIT	TIMS	6	0	Time at which record was last accessed
23	PGMID3	☐	PW_PGMID3	PROGNAME	CHAR	40	0	Last Used to Access Record Program
24	STATU3	☐	PW_STATU3	PW_STATU	CHAR	1	0	Log status when record was last accessed
25	UNAME4	☐	PW_UNAME4	UNAME	CHAR	12	0	User who first retrieved the record successfully
26	DATUM4	☐	PW_DATUM4	DATUM	DATS	8	0	Date on which record was first retrieved successfully
27	UZEIT4	☐	PW_UZEIT4	UZEIT	TIMS	6	0	Time at which record was first retrieved successfully
28	PGMID4	☐	PW_PGMID4	PROGNAME	CHAR	40	0	Report first used to retrieve record successfully
29	.INCLUDE	☐				0	0	Planned Time Specification for a Day: General Specifications
30	VTART	☐	VTART	VTART	CHAR	2	0	Substitution Type	*
31	TPROG	☐	TPROG	TPROG	CHAR	4	0	Daily Work Schedule	*
32	VARIA	☐	VARIA	VARIA	CHAR	1	0	Daily Work Schedule Variant
33	PAMOD	☐	PAMOD	PAMOD	CHAR	4	0	Work Break Schedule	*
34	NO_BREAKS	☐	RP_XFELD	XFELD	CHAR	1	0	Checkbox
35	TPKLA	☐	TPKLA	TPKLA	CHAR	1	0	Daily Work Schedule Class
36	TAGTY	☐	TAGTY	TAGTY	CHAR	1	0	Day Type
37	.INCLUDE	☐				0	0	Different Payment
38	TRFGR	☐	TRFGR	TRFGR	CHAR	8	0	Pay Scale Group	*
39	TRFST	☐	TRFST	TRFST	CHAR	2	0	Pay Scale Level	*
40	PRAKN	☐	PRAKN	PRAKN	CHAR	2	0	Premium Number	T510P
41	PRAKZ	☐	PRAKZ	PRAKZ	NUMC	4	0	Premium Indicator
42	OTYPE	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	T778O
43	PLANS	☐	PLANS	PLANS	NUMC	8	0	Position	T528B
44	AUFKZ	☐	AUFKN	AUFKN	CHAR	1	0	Extra Pay Indicator
45	BWGRL	☐	PTM_VBAS7S	P_AMT07V	CURR	13	2	Valuation Basis for Different Payment
46	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
47	WTART	☐	WTART	WRKAR	CHAR	4	0	Work tax area	T5UTB
48	.INCLUDE	☐				0	0	Interface Table for Infotypes: Acct Assgnmnt Objects
49	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
50	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
51	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
52	LTLST	☐	LSTAR	LSTAR	CHAR	6	0	Activity Type	*
53	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
54	KSTRG	☐	KSTRG	KSTRG	CHAR	12	0	Cost Object	*
55	PS_POSID	☐	PS_POSID	PS_POSID	CHAR	24	0	Work Breakdown Structure Element (WBS Element)
56	NPLNR	☐	NPLNR	AUFNR	CHAR	12	0	Network Number for Account Assignment	*
57	VORNR	☐	VORNR	VORNR	CHAR	4	0	Operation/Activity Number
58	KDAUF	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	*
59	KDPOS	☐	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
60	PRZNR	☐	CO_PRZNR	CO_PRZNR	CHAR	12	0	Business Process	*
61	FISTL	☐	FISTL	FISTL	CHAR	16	0	Funds Center	*
62	FIPOS	☐	FIPOS	FIPOS	CHAR	14	0	Commitment Item	*
63	GEBER	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	*
64	EBELN	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	*
65	EBELP	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	*
66	LSTNR	☐	ASNUM	ASNUM	CHAR	18	0	Activity Number	*
67	STELL	☐	STELL	STELL	NUMC	8	0	Job	*
68	SBUKR	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
69	SGSBR	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
70	SKOST	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
71	LSTAR	☐	LSTAR	LSTAR	CHAR	6	0	Activity Type	*
72	SGTXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
73	DART	☐	DART	DART	CHAR	2	0	Service Type (Public Service Germany)	T5D7C
74	UDART	☐	UDART	UDART	CHAR	2	0	Service Category (Public Service Germany)	T5D7E
75	FKBER	☐	FKBER	FKBER	CHAR	16	0	Functional Area	*
76	GRANT_NBR	☐	GM_GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	Grant
77	SGEBER	☐	FM_SFONDS	BP_GEBER	CHAR	10	0	Sender fund	*
78	SFKBER	☐	SFKTBER	FKBER	CHAR	16	0	Sending Functional Area	*
79	SGRANT_NBR	☐	GM_GRANT_SENDER	GM_GRANT_NBR	CHAR	20	0	Sender Grant
80	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	PTEX2003GEN	BUKRS	T001	BUKRS
2	PTEX2003GEN	DART	T5D7C	DART
3	PTEX2003GEN	GSBER	TGSB	GSBER
4	PTEX2003GEN	OTYPE	T778O	OTYPE
5	PTEX2003GEN	PLANS	T528B	PLANS
6	PTEX2003GEN	PRAKN	T510P	PRAKN
7	PTEX2003GEN	SBUKR	T001	BUKRS
8	PTEX2003GEN	SGSBR	TGSB	GSBER
9	PTEX2003GEN	UDART	T5D7E	UDART
10	PTEX2003GEN	WAERS	TCURC	WAERS
11	PTEX2003GEN	WTART	T5UTB	TAXAR

History

Last changed by/on	SAP	20130529
SAP Release Created in	46B