SAP ABAP Table PA2004 (HR Time Record: Infotype 2004 (Availability))

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	PA2004	Table Relationship Diagram
Short Description	HR Time Record: Infotype 2004 (Availability)

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	.INCLUDE	☑				0	0	Key for HR Master Data
3	PERNR	☑	PERSNO	PERSNO	NUMC	8	0	Personnel number	PA0003
4	SUBTY	☑	SUBTY	SUBTY	CHAR	4	0	Subtype
5	OBJPS	☑	OBJPS	OBJPS	CHAR	2	0	Object Identification
6	SPRPS	☑	SPRPS	SPRPS	CHAR	1	0	Lock Indicator for HR Master Data Record
7	ENDDA	☑	ENDDA	DATUM	DATS	8	0	End Date
8	BEGDA	☑	BEGDA	DATUM	DATS	8	0	Start Date
9	SEQNR	☑	SEQNR	NUM03	NUMC	3	0	Number of Infotype Record With Same Key
10	.INCLUDE	☐				0	0	HR Master Record: Control Field
11	AEDTM	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
12	UNAME	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
13	HISTO	☐	HISTO	CHAR1	CHAR	1	0	Historical Record Flag
14	ITXEX	☐	ITXEX	XFELD	CHAR	1	0	Text Exists for Infotype
15	REFEX	☐	PRFEX	XFELD	CHAR	1	0	Reference Fields Exist (Primary/Secondary Costs)
16	ORDEX	☐	ORDEX	XFELD	CHAR	1	0	Confirmation Fields Exist
17	ITBLD	☐	ITBLD	CHAR2	CHAR	2	0	Infotype Screen Control
18	PREAS	☐	PREAS	PREAS	CHAR	2	0	Reason for Changing Master Data	T530E
19	FLAG1	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
20	FLAG2	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
21	FLAG3	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
22	FLAG4	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
23	RESE1	☐	NUSED2	NUSED2	CHAR	2	0	Reserved Field/Unused Field of Length 2
24	RESE2	☐	NUSED2	NUSED2	CHAR	2	0	Reserved Field/Unused Field of Length 2
25	GRPVL	☐	PCCE_GPVAL	PCCE_GPVAL	CHAR	4	0	Grouping Value for Personnel Assignments
26	.INCLUDE	☐				0	0	HR Time Record: Infotype 2004 (Availability)
27	BEGUZ	☐	BEGUZ	UZEIT	TIMS	6	0	Start Time
28	ENDUZ	☐	ENDUZ	UZEIT	TIMS	6	0	End Time
29	VTKEN	☐	VTKEN	XFELD	CHAR	1	0	Previous Day Indicator
30	STNBY	☐	STNBY	STNBY	CHAR	2	0	Availability Subtype	T557
31	ZEITY	☐	DZEITY	ZEITY	CHAR	1	0	Employee Subgroup Grouping for Work Schedules
32	MOFID	☐	HIDENT	HIDENT	CHAR	2	0	Public Holiday Calendar	THOCI
33	MOSID	☐	MOSID	MOSID	NUMC	2	0	Personnel Subarea Grouping for Work Schedules	T508Z
34	SCHKZ	☐	SCHKN	SCHKN	CHAR	8	0	Work Schedule Rule	*
35	MOTPR	☐	MOTPR	MOTPR	NUMC	2	0	Personnel Subarea Grouping for Daily Work Schedules
36	TPROG	☐	TPROG	TPROG	CHAR	4	0	Daily Work Schedule	T550S
37	VARIA	☐	VARIA	VARIA	CHAR	1	0	Daily Work Schedule Variant
38	AUFKZ	☐	AUFKN	AUFKN	CHAR	1	0	Extra Pay Indicator
39	BWGRL	☐	PTM_VBAS7S	P_AMT07V	CURR	13	2	Valuation Basis for 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	*
46	EXBEL	☐	EXBEL	CHAR08	CHAR	8	0	External Document Number
47	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
48	WTART	☐	WTART	WRKAR	CHAR	4	0	Work tax area	*
49	ADPER	☐	TIM_AVAIL_DIST_PERC	DEC3_2	DEC	5	2	Availability Distribution Key (currently not functional)
50	.INCLUDE	☐				0	0	Infotype Fields Relevant for Short Descriptions
51	TDLANGU	☐	TMW_TDLANGU	TMW_TDLANGU	CHAR	10	0	Definition Set for IDs	*
52	TDSUBLA	☐	TMW_TDSUBLA	TMW_TDSUBLA	CHAR	3	0	Definition Subset for IDs	*
53	TDTYPE	☐	TDTYPE	TDKENN	CHAR	4	0	Time Data ID Type

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PA2004	MANDT	T000	MANDT	KEY	1	CN
2	PA2004	MOFID	THOCI	IDENT	REF	C	CN
3	PA2004	MOSID	T508Z	MOSID	REF	C	CN
4	PA2004	OTYPE	T778O	OTYPE	REF	C	CN
5	PA2004	PERNR	PA0003	PERNR	KEY	1	CN
6	PA2004	PRAKN	T510P	PRAKN	REF	C	CN
7	PA2004	PREAS	T530E	PREAS	REF	C	CN
8	PA2004	STNBY	T557	STNBY	REF	C	CN
9	PA2004	TPROG	T550S	TPROG	REF	C	CN
10	PA2004	WAERS	TCURC	WAERS

History

Last changed by/on	SAP	20080626
SAP Release Created in