SAP ABAP Table PEX2000REF (Interface Structure for Infotypes 2001/2002 (w/o AA Objects))

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	PEX2000REF	Table Relationship Diagram
Short Description	Interface Structure for Infotypes 2001/2002 (w/o AA Objects)

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	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	☐	HR_DATE	DATUM	DATS	8	0	Validity Date
9	ENDDA	☐	HR_DATE	DATUM	DATS	8	0	Validity Date
10	SPRPS	☐	SPRPS	SPRPS	CHAR	1	0	Lock Indicator for HR Master Data Record
11	.INCLUDE	☐				0	0	Interface Structure for IT 2001/2 (Field Seln for PS2001/2)
12	AWART	☐	AWART	AWART	CHAR	4	0	Attendance or Absence Type	*
13	BEGUZ	☐	BEGUZ	UZEIT	TIMS	6	0	Start Time
14	ENDUZ	☐	ENDUZ	UZEIT	TIMS	6	0	End Time
15	STDAZ	☐	ABSTD	JRSTD	DEC	7	2	Absence hours
16	VTKEN	☐	VTKEN	XFELD	CHAR	1	0	Previous Day Indicator
17	ALLDF	☐	ALLDF	XFELD	CHAR	1	0	Record is for Full Day
18	VERSL	☐	VRSCH	VRSCH	CHAR	1	0	Overtime Compensation Type	*
19	.INCLUDE	☐				0	0	Different Payment
20	TRFGR	☐	TRFGR	TRFGR	CHAR	8	0	Pay Scale Group	*
21	TRFST	☐	TRFST	TRFST	CHAR	2	0	Pay Scale Level	*
22	PRAKN	☐	PRAKN	PRAKN	CHAR	2	0	Premium Number	T510P
23	PRAKZ	☐	PRAKZ	PRAKZ	NUMC	4	0	Premium Indicator
24	OTYPE	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	T778O
25	PLANS	☐	PLANS	PLANS	NUMC	8	0	Position	T528B
26	AUFKZ	☐	AUFKN	AUFKN	CHAR	1	0	Extra Pay Indicator
27	BWGRL	☐	PTM_VBAS7S	P_AMT07V	CURR	13	2	Valuation Basis for Different Payment
28	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
29	WTART	☐	WTART	WRKAR	CHAR	4	0	Work tax area	T5UTB
30	.INCLUDE	☐				0	0	Interface Table for Infotypes: Acct Assgnmnt Objects
31	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
32	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
33	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
34	LTLST	☐	LSTAR	LSTAR	CHAR	6	0	Activity Type	*
35	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
36	KSTRG	☐	KSTRG	KSTRG	CHAR	12	0	Cost Object	*
37	PS_POSID	☐	PS_POSID	PS_POSID	CHAR	24	0	Work Breakdown Structure Element (WBS Element)
38	NPLNR	☐	NPLNR	AUFNR	CHAR	12	0	Network Number for Account Assignment	*
39	VORNR	☐	VORNR	VORNR	CHAR	4	0	Operation/Activity Number
40	KDAUF	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	*
41	KDPOS	☐	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
42	PRZNR	☐	CO_PRZNR	CO_PRZNR	CHAR	12	0	Business Process	*
43	FISTL	☐	FISTL	FISTL	CHAR	16	0	Funds Center	*
44	FIPOS	☐	FIPOS	FIPOS	CHAR	14	0	Commitment Item	*
45	GEBER	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	*
46	EBELN	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	*
47	EBELP	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	*
48	LSTNR	☐	ASNUM	ASNUM	CHAR	18	0	Activity Number	*
49	STELL	☐	STELL	STELL	NUMC	8	0	Job	*
50	SBUKR	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
51	SGSBR	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
52	SKOST	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
53	LSTAR	☐	LSTAR	LSTAR	CHAR	6	0	Activity Type	*
54	SGTXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
55	DART	☐	DART	DART	CHAR	2	0	Service Type (Public Service Germany)	T5D7C
56	UDART	☐	UDART	UDART	CHAR	2	0	Service Category (Public Service Germany)	T5D7E
57	FKBER	☐	FKBER	FKBER	CHAR	16	0	Functional Area	*
58	GRANT_NBR	☐	GM_GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	Grant
59	SGEBER	☐	FM_SFONDS	BP_GEBER	CHAR	10	0	Sender fund	*
60	SFKBER	☐	SFKTBER	FKBER	CHAR	16	0	Sending Functional Area	*
61	SGRANT_NBR	☐	GM_GRANT_SENDER	GM_GRANT_NBR	CHAR	20	0	Sender Grant
62	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	PEX2000REF	BUKRS	T001	BUKRS
2	PEX2000REF	DART	T5D7C	DART
3	PEX2000REF	GSBER	TGSB	GSBER
4	PEX2000REF	OTYPE	T778O	OTYPE
5	PEX2000REF	PLANS	T528B	PLANS
6	PEX2000REF	PRAKN	T510P	PRAKN
7	PEX2000REF	SBUKR	T001	BUKRS
8	PEX2000REF	SGSBR	TGSB	GSBER
9	PEX2000REF	UDART	T5D7E	UDART
10	PEX2000REF	WAERS	TCURC	WAERS
11	PEX2000REF	WTART	T5UTB	TAXAR

History

Last changed by/on	SAP	20130529
SAP Release Created in