SAP ABAP Table P0965 (HR Master Record for Infotype 0965)

Hierarchy

☛ SAP_HRCUN (Software Component) Sub component SAP_HRCUN of SAP_HR
   ⤷ PY-NPO (Application Component) Non Profit Organizations
     ⤷ PBUN (Package) Master Data Non Profit Organizations

Basic Data

Table Category	INTTAB	Structure
Structure	P0965	Table Relationship Diagram
Short Description	HR Master Record for Infotype 0965

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	Headers for Infotype Records
2	.INCLUDE	☐				0	0	Keys for HR Master Data
3	PERNR	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
4	INFTY	☐	INFTY	INFOTYP	CHAR	4	0	Infotype	T582A
5	SUBTY	☐	SUBTY	SUBTY	CHAR	4	0	Subtype
6	OBJPS	☐	OBJPS	OBJPS	CHAR	2	0	Object Identification
7	SPRPS	☐	SPRPS	SPRPS	CHAR	1	0	Lock Indicator for HR Master Data Record
8	ENDDA	☐	ENDDA	DATUM	DATS	8	0	End Date
9	BEGDA	☐	BEGDA	DATUM	DATS	8	0	Start Date
10	SEQNR	☐	SEQNR	NUM03	NUMC	3	0	Number of Infotype Record With Same Key
11	.INCLUDE	☐				0	0	HR Master Record: Control Field
12	AEDTM	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
13	UNAME	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
14	HISTO	☐	HISTO	CHAR1	CHAR	1	0	Historical Record Flag
15	ITXEX	☐	ITXEX	XFELD	CHAR	1	0	Text Exists for Infotype
16	REFEX	☐	PRFEX	XFELD	CHAR	1	0	Reference Fields Exist (Primary/Secondary Costs)
17	ORDEX	☐	ORDEX	XFELD	CHAR	1	0	Confirmation Fields Exist
18	ITBLD	☐	ITBLD	CHAR2	CHAR	2	0	Infotype Screen Control
19	PREAS	☐	PREAS	PREAS	CHAR	2	0	Reason for Changing Master Data	T530E
20	FLAG1	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
21	FLAG2	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
22	FLAG3	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
23	FLAG4	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
24	RESE1	☐	NUSED2	NUSED2	CHAR	2	0	Reserved Field/Unused Field of Length 2
25	RESE2	☐	NUSED2	NUSED2	CHAR	2	0	Reserved Field/Unused Field of Length 2
26	GRPVL	☐	PCCE_GPVAL	PCCE_GPVAL	CHAR	4	0	Grouping Value for Personnel Assignments
27	.INCLUDE	☐				0	0	HR master data: Infotype 0965: Education Grant
28	FAMSA	☐	FAMSA	SUBTY	CHAR	4	0	Type of Family Record	V_7UNPAD_P0021
29	EXMAPPL	☐	PUN_EGEXPAPL	PUN_EGEXPAPL	CHAR	6	0	Exp. MM: Application	*
30	EXMNR	☐	PUN_EGEXPNRR	PUN_EGEXPNRR	NUMC	10	0	Exp. MM: Numberrange No.
31	SEQNO	☐	SEQNO	SEQNO	CHAR	3	0	Sequence Number
32	EGSST	☐	PUN_EGSST	PUN_EGSST	CHAR	1	0	EG System Validation Status
33	EGCST	☐	PUN_EGCST	PUN_EGCST	CHAR	1	0	EG Customer Validation Status
34	EGCRS	☐	PREAS	PREAS	CHAR	2	0	Reason for Changing Master Data	T530E
35	EGDIS	☐	PUN_EGDIS	XFELD	CHAR	1	0	EG: Disability status special Education Grant
36	EGTYP	☐	PUN_EGTYP	PUN_EGTYP	CHAR	4	0	EG Type or classification	T7UNPAD_EGST
37	EGYEA	☐	PUN_EGYEA	PUN_EGYEA	NUMC	2	0	EG Schoolyear Identifier
38	EGYFR	☐	BEGDA	DATUM	DATS	8	0	Start Date
39	EGYTO	☐	ENDDA	DATUM	DATS	8	0	End Date
40	EGCUR	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
41	EGEUC	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
42	EGSCT	☐	PUN_EGSCT	LAND1	CHAR	3	0	EG: School Country	T005
43	ORT01	☐	PUN_EGSCY	PAD_ORT01	CHAR	40	0	EG: School City
44	EGSDS	☐	PUN_DSTAT	PUN_DSTAT	CHAR	4	0	Duty Station	T7UNPAD_DS
45	EGFAC	☐	PUN_EGFAC	PUN_DSPCT	DEC	5	2	EG Proration Factor
46	EGCLS	☐	PUN_EGCLS	PUN_EGCLS	CHAR	4	0	EG School Classification
47	EGGRD	☐	PUN_EGGRD	PUN_EGGRD	CHAR	4	0	EG School Grade	T7UNPAD_EGSG
48	EGSSL	☐	PUN_EGSSL	PUN_EGSSL	CHAR	10	0	EG School Identifier	*
49	EGC01	☐	PUN_EGCAT	XFELD	CHAR	1	0	EG Category
50	EGC02	☐	PUN_EGCAT	XFELD	CHAR	1	0	EG Category
51	EGC03	☐	PUN_EGCAT	XFELD	CHAR	1	0	EG Category
52	EGC04	☐	PUN_EGCAT	XFELD	CHAR	1	0	EG Category
53	EGC05	☐	PUN_EGCAT	XFELD	CHAR	1	0	EG Category
54	.INCLUDE	☐				0	0	EG Advance Structure
55	EGADV_VERSION	☐	PUN_EGVRSN	NUM03	NUMC	3	0	EG: Version
56	EGADV_PYDATE	☐	PUN_EGADV_PYDT	DATS	DATS	8	0	EG Paydate
57	EGRCD	☐	PUN_EGRCD	DATS	DATS	8	0	EG: Recovery Date
58	EGRIN	☐	PUN_EGRIN	NUMC02	NUMC	2	0	EG: Recovery Installment
59	EGDRP	☐	PUN_EGDRP	XFELD	CHAR	1	0	EG Flag for Proration Drop out
60	EGOYF	☐	BEGDA	DATUM	DATS	8	0	Start Date
61	EGOYT	☐	ENDDA	DATUM	DATS	8	0	End Date
62	EGSCD	☐	PUN_EGSCD	DATUM	DATS	8	0	NPO: EG: Settlement Date
63	EGSNA	☐	PUN_EGSNA	TEXT50	CHAR	50	0	EG School Name
64	EGBRS	☐	PUN_EGBRS	PUN_EGBRS	CHAR	2	0	EG Reason for Boarding	T7UNPAD_EGRS
65	EGBSG	☐	BSGRD	BSGRD	DEC	5	2	Capacity Utilization Level
66	TRFGR	☐	TRFGR	TRFGR	CHAR	8	0	Pay Scale Group	*
67	TRFST	☐	TRFST	TRFST	CHAR	2	0	Pay Scale Level	*
68	EGSTY	☐	PUN_EGSTY	PUN_EGSTY	CHAR	1	0	NPO: Education Grant school type CCAQ
69	EGCDF	☐	PUN_EGCDF	XFELD	CHAR	1	0	NPO: Education Grant Commuting Distance Flag
70	EGPST	☐	PUN_EGPST	PUN_EGPST	CHAR	2	0	NPO: Education Grant Record Status
71	EGLIN	☐	PUN_EGLIN	PUN_EGLIN	DEC	10	0	NPO: Education Grant Number of lines
72	TUITION_WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	P0965	EGBRS	T7UNPAD_EGRS	EGBRS		1	CN
2	P0965	EGCRS	T530E	PREAS		1	CN
3	P0965	EGCUR	TCURC	WAERS		1	CN
4	P0965	EGGRD	T7UNPAD_EGSG	EGGRD		1	CN
5	P0965	EGSCT	T005	LAND1		1	CN
6	P0965	EGSDS	T7UNPAD_DS	DSTAT		1	CN
7	P0965	EGTYP	T7UNPAD_EGST	EGTYP		1	CN
8	P0965	FAMSA	V_7UNPAD_P0021	SUBTY
9	P0965	INFTY	T582A	INFTY
10	P0965	PREAS	T530E	PREAS
11	P0965	TUITION_WAERS	TCURC	WAERS

History

Last changed by/on	SAP	20130529
SAP Release Created in	200