SAP ABAP Table PUNPAD_EGCCAQ (NPO: EG file structure for CCAQ Reporting)

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	PUNPAD_EGCCAQ	Table Relationship Diagram
Short Description	NPO: EG file structure for CCAQ Reporting

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	EGYEAR	☐	PUN_EGYEAR	CHAR4	CHAR	4	0	NPO EG Year of Claim
2	PERNR	☐	PUN_IDNUM2	CHAR20	CHAR	20	0	NPO: EG CCAQ Identification Number
3	ORGCODE	☐	PUN_EGORGC	PUN_EGORGC	CHAR	4	0	NPO: Education Grant CCAQ organizational code	*
4	NACHN	☐	PUN_CCAQNN	PUN_CCAQNN	CHAR	50	0	NPO: EG Last Name for CCAQ records
5	VORNA	☐	PUN_CCAQVN	PUN_CCAQVN	CHAR	50	0	NPO: EG First name for CCAQ records
6	LAND1	☐	PUN_EGCEB	PUN_EGCEB	CHAR	4	0	NPO: Education Grant CEB Country code	*
7	DSTAT	☐	PUN_CEBDSTAT	PUN_CEBDSTAT	CHAR	5	0	NPO: Education Grant CEB Duty Station	*
8	TRFST	☐	PUN_CCAQSTAFF	PUN_CCAQTRFGR	CHAR	4	0	NPO: EG Staff grade for CCAQ
9	FANAM	☐	PUN_CCAQNN	PUN_CCAQNN	CHAR	50	0	NPO: EG Last Name for CCAQ records
10	FAVOR	☐	PUN_CCAQVN	PUN_CCAQVN	CHAR	50	0	NPO: EG First name for CCAQ records
11	FGBDT	☐	PUN_CCAQBDAT	PUN_CCAQDATE	CHAR	10	0	NPO: EG Date of Birth for CCAQ
12	EGYFR	☐	PUN_CCAQSDAT	PUN_CCAQDATE	CHAR	10	0	NPO: EG Attendance begin date for CCAQ
13	EGYTO	☐	PUN_CCAQEDAT	PUN_CCAQDATE	CHAR	10	0	NPO: EG Attendance end date for CCAQ
14	EGCAL	☐	PUN_EGCAL	PUN_EGCAL	CHAR	1	0	NPO: EG Child Attendance Level for Statistic
15	SYEAR	☐	PUN_SYEAR	PUN_SYEAR	CHAR	1	0	NPO EG Full School Year
16	EGDIS	☐	PUN_EGDIS	XFELD	CHAR	1	0	EG: Disability status special Education Grant
17	EGSNA	☐	PUN_CCAQSCNA	PUN_CCAQSCNA	CHAR	80	0	NPO: EG School name for CCAQ
18	ORT01	☐	PUN_CCAQSCCT	PUN_CCAQSCCT	CHAR	100	0	NPO: EG School City for CCAQ
19	EGSCT	☐	PUN_EGCEBSC	PUN_EGCEB	CHAR	4	0	NPO: EG CEB School Country	*
20	EGSTY	☐	PUN_EGSTY	PUN_EGSTY	CHAR	1	0	NPO: Education Grant school type CCAQ
21	EGCDF	☐	PUN_EGCDF	XFELD	CHAR	1	0	NPO: Education Grant Commuting Distance Flag
22	BEGDA	☐	PUN_CCAQSDAT	PUN_CCAQDATE	CHAR	10	0	NPO: EG Attendance begin date for CCAQ
23	ENDDA	☐	PUN_CCAQEDAT	PUN_CCAQDATE	CHAR	10	0	NPO: EG Attendance end date for CCAQ
24	TUITION_WAERS	☐	PUN_CCAQWAER	PUN_CCAQCURR	CHAR	3	0	NPO: EG Currency Key for CCAQ
25	TUITION_EXCHG	☐	PUN_EGEXC	PUN_EGEXC	CHAR	13	0	NPO: EG Exchange Rate (no commas)
26	TUITION	☐	PUN_EGTUIT	CHAR16	CHAR	16	0	NPO EG Tuition
27	TRANSPORTATION	☐	PUN_EGTRANS	CHAR16	CHAR	16	0	NPO EG Transportation
28	MEALS	☐	PUN_EGMEALS	PUN_CCAQETYP	CHAR	16	0	NPO: EG CCAQ Meals fee
29	BOOKS	☐	PUN_CCAQBOOK	PUN_CCAQETYP	CHAR	16	0	NPO: EG Books fee for CCAQ
30	MOTHERTONGUE	☐	PUN_EGMTONG	PUN_CCAQETYP	CHAR	16	0	NPO: EG CCAQ Mother tongue fee
31	OTHER	☐	PUN_EGOTHER	PUN_CCAQETYP	CHAR	16	0	NPO: Education Grant Other permissible costs
32	TOTALCST	☐	PUN_EGCCAQTOT	PUN_CCAQATYP	CHAR	19	0	NPO: EG Total admissible fees
33	BWAERS	☐	PUN_CCAQWAER	PUN_CCAQCURR	CHAR	3	0	NPO: EG Currency Key for CCAQ
34	BEXC_RATE	☐	PUN_EGEXC	PUN_EGEXC	CHAR	13	0	NPO: EG Exchange Rate (no commas)
35	BCTYPE	☐	PUN_BCTYPE	PUN_BCTYPE	CHAR	1	0	NPO: EG Boarding Cost Type
36	BOARDING	☐	PUN_CCAQBOARD	PUN_CCAQETYP	CHAR	16	0	NPO: EG Boarding Cost in CCAQ Report with Length 16
37	ALLOWABLE	☐	PUN_CCAQALLOWABLE	PUN_CCAQATYP	CHAR	19	0	NPO: EG Total Admissible Fees and Boarding costs
38	CALC_WAERS	☐	PUN_CCAQWAER	PUN_CCAQCURR	CHAR	3	0	NPO: EG Currency Key for CCAQ
39	ADDRA	☐	PUN_EGADDAM	PUN_CCAQETYP	CHAR	16	0	NPO: EG Additional Reimbursement Amount
40	ACTRA	☐	PUN_EGACTAM	PUN_CCAQETYP	CHAR	16	0	NPO: EG Actual Reimbursement Amount

History

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