SAP ABAP Table Q0965 (Screen Fields: Infotype 0965 Education Grant)

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	Q0965	Table Relationship Diagram
Short Description	Screen Fields: Infotype 0965 Education Grant

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	HR Master Record: Infotype 0021 (Family)
2	FAMSA	☐	FAMSA	SUBTY	CHAR	4	0	Type of Family Record
3	FGBDT	☐	GBDAT	GBDAT	DATS	8	0	Date of Birth
4	FGBLD	☐	GBLND	LAND1	CHAR	3	0	Country of Birth	T005
5	FANAT	☐	NATSL	LAND1	CHAR	3	0	Nationality	T005
6	FASEX	☐	GESCH	GESCH	CHAR	1	0	Gender Key
7	FAVOR	☐	PAD_VORNA	PAD_VORNM	CHAR	40	0	First Name
8	FANAM	☐	PAD_NACHN	PAD_NACHN	CHAR	40	0	Last Name
9	FGBOT	☐	PAD_GBORT	PAD_ORT01	CHAR	40	0	Birthplace
10	FGDEP	☐	GBDEP	REGIO	CHAR	3	0	State	T005S
11	ERBNR	☐	ERBNR	CHAR12	CHAR	12	0	Reference Personnel Number for Family Member
12	FGBNA	☐	PAD_NAME2	PAD_NACHN	CHAR	40	0	Name at Birth
13	FNAC2	☐	PAD_NACH2	PAD_NACHN	CHAR	40	0	Second Name
14	FCNAM	☐	PAD_CNAME	TEXT80	CHAR	80	0	Complete Name
15	FKNZN	☐	KNZNM	KNZN2	NUMC	2	0	Name Format Indicator for Employee in a List
16	FINIT	☐	INITS	TEXT10	CHAR	10	0	Initials
17	FVRSW	☐	VORSW	TITEL	CHAR	15	0	Name Prefix	T535N
18	FVRS2	☐	VORSW	TITEL	CHAR	15	0	Name Prefix	T535N
19	FNMZU	☐	NAMZU	TITEL	CHAR	15	0	Other Title	T535N
20	AHVNR	☐	AHVNR	P02_AHVNR	CHAR	11	0	AHV Number
21	KDSVH	☐	KDSVH	AUSPR	CHAR	2	0	Relationship to Child	T577
22	KDBSL	☐	KDBSL	AUSPR	CHAR	2	0	Allowance Authorization	T577
23	KDUTB	☐	KDUTB	AUSPR	CHAR	2	0	Address of Child	T577
24	KDGBR	☐	KDGBR	AUSPR	CHAR	2	0	Child Allowance Entitlement	T577
25	KDART	☐	KDART	AUSPR	CHAR	2	0	Child Type	T577
26	KDZUG	☐	KDZUG	AUSPR	CHAR	2	0	Child Bonuses	T577
27	KDZUL	☐	KDZUL	AUSPR	CHAR	2	0	Child Allowances	T577
28	KDVBE	☐	KDVBE	AUSPR	CHAR	2	0	Sickness Certificate Authorization	T577
29	ERMNR	☐	ERMNR	CHAR8	CHAR	8	0	Authority Number
30	AUSVL	☐	AUSVL	NUM4	NUMC	4	0	1st part of SI number (sequential number)
31	AUSVG	☐	AUSVG	NUM8	NUMC	8	0	2nd part of SI number (birthdate)
32	FASDT	☐	FASDT	DATUM	DATS	8	0	End of Family Member's Education/Training
33	FASAR	☐	FASAR	SLART	CHAR	2	0	School Type of Family Member	T517T
34	FASIN	☐	FASIN	TEXT20	CHAR	20	0	Educational Institute
35	EGAGA	☐	EGAGA	VARGA	CHAR	8	0	Employer of Family Member
36	FANA2	☐	NATS2	LAND1	CHAR	3	0	Second Nationality	T005
37	FANA3	☐	NATS3	LAND1	CHAR	3	0	Third Nationality	T005
38	BETRG	☐	BETRG	WERTV5	CURR	9	2	Amount
39	TITEL	☐	TITEL	TITEL	CHAR	15	0	Title	T535N
40	EMRGN	☐	PAD_EMRGN	XFELD	CHAR	1	0	Emergency Contact
41	.INCLUDE	☐				0	0
42	.INCLUDE	☐				0	0	Additional Family Data(NPO)
43	MIDNM	☐	PAD_MIDNM	PAD_VORNM	CHAR	40	0	Middle Name
44	FAMST	☐	FAMST	FAMST	CHAR	1	0	Marital Status Key	T502T
45	FAMDT	☐	FAMDT	DATUM	DATS	8	0	Valid From Date of Current Marital Status
46	IRDOA	☐	PUN_IRDOA	DATE	DATS	8	0	In receipt date of allowance
47	BETR3	☐	PAD_AMT7S	P_AMT07V	CURR	13	2	Wage Type Amount for Payments
48	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
49	LGART	☐	LGART	LGART	CHAR	4	0	Wage Type	*
50	OPKEN	☐	OPKEN	OPKEN	CHAR	1	0	Operation Indicator for Wage Types
51	.INCLUDE	☐				0	0
52	EGAGE	☐	PUN_EGAGE	NUMC2	NUMC	2	0	EG Computed Age
53	DSTAT	☐	PUN_DSTAT	PUN_DSTAT	CHAR	4	0	Duty Station	T7UNPAD_DS
54	EGDDS	☐	PUN_EGDDS	XFELD	CHAR	1	0	Duty Station flag for designated
55	GBLND	☐	GBLND	LAND1	CHAR	3	0	Country of Birth	T005
56	NATIO	☐	NATSL	LAND1	CHAR	3	0	Nationality	T005
57	CTTYP	☐	CTTYP	CTTYP	CHAR	2	0	Contract Type	T547V
58	CTEDT	☐	CTEDT	DATUM	DATS	8	0	Contract End Date
59	EGSSL	☐	PUN_EGSSL	PUN_EGSSL	CHAR	10	0	EG School Identifier	*
60	ENDDA	☐	ENDDA	DATUM	DATS	8	0	End Date
61	BEGDA	☐	BEGDA	DATUM	DATS	8	0	Start Date
62	EGSNA	☐	PUN_EGSNA	TEXT50	CHAR	50	0	EG School Name
63	SLART	☐	SLART	SLART	CHAR	2	0	Educational establishment	T517T
64	PSTLZ	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
65	ORT01	☐	ORT01	TEXT25	CHAR	25	0	City
66	EGSCT	☐	PUN_EGSCT	LAND1	CHAR	3	0	EG: School Country	T005
67	STATE	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
68	STRAS	☐	STRAS	TEXT30	CHAR	30	0	House number and street
69	TELNR	☐	TELNR	TELNR	CHAR	14	0	Telephone Number
70	EGADV_PYDATE	☐	PUN_EGADV_PYDT	DATS	DATS	8	0	EG Paydate
71	ADVPY_MANUAL	☐	PUN_EGADV	GESBE	CURR	10	2	NPO: EG Advance Amount
72	ADVPY_WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
73	DSTAT_O	☐	PUN_DSTAT	PUN_DSTAT	CHAR	4	0	Duty Station	*
74	SNAME	☐	SMNAM	CHAR30	CHAR	30	0	Employee's Name (Sortable by LAST NAME FIRST NAME)
75	EGSTY	☐	PUN_EGSTY	PUN_EGSTY	CHAR	1	0	NPO: Education Grant school type CCAQ
76	EGCDF	☐	PUN_EGCDF	XFELD	CHAR	1	0	NPO: Education Grant Commuting Distance Flag
77	NACHN	☐	PAD_NACHN	PAD_NACHN	CHAR	40	0	Last Name
78	VORNA	☐	PAD_VORNA	PAD_VORNM	CHAR	40	0	First Name
79	LSELE	☐	PUN_SELECT_DTA	XFELD	CHAR	1	0	NPO : Selection Field - Selection of Data Records

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	Q0965	CTTYP	T547V	CTTYP		1	CN
2	Q0965	DSTAT	T7UNPAD_DS	DSTAT
3	Q0965	EGSCT	T005	LAND1		1	CN
4	Q0965	FAMST	T502T	FAMST
5	Q0965	FANA2	T005	LAND1
6	Q0965	FANA3	T005	LAND1
7	Q0965	FANAT	T005	LAND1
8	Q0965	FASAR	T517T	SLART
9	Q0965	FGBLD	T005	LAND1
10	Q0965	FGDEP	T005S	BLAND
11	Q0965	FNMZU	T535N	TITEL
12	Q0965	FVRS2	T535N	TITEL
13	Q0965	FVRSW	T535N	TITEL
14	Q0965	GBLND	T005	LAND1
15	Q0965	KDART	T577	AUSPR
16	Q0965	KDBSL	T577	AUSPR
17	Q0965	KDGBR	T577	AUSPR
18	Q0965	KDSVH	T577	AUSPR
19	Q0965	KDUTB	T577	AUSPR
20	Q0965	KDVBE	T577	AUSPR
21	Q0965	KDZUG	T577	AUSPR
22	Q0965	KDZUL	T577	AUSPR
23	Q0965	NATIO	T005	LAND1		1	CN
24	Q0965	SLART	T517T	SLART		1	CN
25	Q0965	STATE	T005S	BLAND		C	CN
26	Q0965	TITEL	T535N	TITEL

History

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