1. Home
  2. Resources
  3. SAP Tables
  4. PUNPAD_EGCCAQ - NPO: EG file structure for CCAQ Reporting

SAP Table PUNPAD_EGCCAQ

NPO: EG file structure for CCAQ Reporting

PUNPAD_EGCCAQ (NPO: EG file structure for CCAQ Reporting) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link PUNPAD_EGCCAQ to other SAP tables.

PUNPAD_EGCCAQ table fields

Field Data element Checktable Datatype Length Decimals
EGYEAR NPO EG Year of Claim PUN_EGYEAR CHAR 4 0
PERNR NPO: EG CCAQ Identification Number PUN_IDNUM2 CHAR 20 0
ORGCODE NPO: Education Grant CCAQ organizational code PUN_EGORGC CHAR 4 0
NACHN NPO: EG Last Name for CCAQ records PUN_CCAQNN CHAR 50 0
VORNA NPO: EG First name for CCAQ records PUN_CCAQVN CHAR 50 0
LAND1 NPO: Education Grant CEB Country code PUN_EGCEB CHAR 4 0
DSTAT NPO: Education Grant CEB Duty Station PUN_CEBDSTAT CHAR 5 0
TRFST NPO: EG Staff grade for CCAQ PUN_CCAQSTAFF CHAR 4 0
FANAM NPO: EG Last Name for CCAQ records PUN_CCAQNN CHAR 50 0
FAVOR NPO: EG First name for CCAQ records PUN_CCAQVN CHAR 50 0
FGBDT NPO: EG Date of Birth for CCAQ PUN_CCAQBDAT CHAR 10 0
EGYFR NPO: EG Attendance begin date for CCAQ PUN_CCAQSDAT CHAR 10 0
EGYTO NPO: EG Attendance end date for CCAQ PUN_CCAQEDAT CHAR 10 0
EGCAL NPO: EG Child Attendance Level for Statistic PUN_EGCAL CHAR 1 0
1 Primary
2 Secondary
3 Post-Secondary
4 Others
SYEAR NPO EG Full School Year PUN_SYEAR CHAR 1 0
Y Yes
N No
EGDIS EG: Disability status special Education Grant PUN_EGDIS CHAR 1 0
X Yes
NULL No
EGSNA NPO: EG School name for CCAQ PUN_CCAQSCNA CHAR 80 0
ORT01 NPO: EG School City for CCAQ PUN_CCAQSCCT CHAR 100 0
EGSCT NPO: EG CEB School Country PUN_EGCEBSC CHAR 4 0
EGSTY NPO: Education Grant school type CCAQ PUN_EGSTY CHAR 1 0
1 Private International School (no Government subsidy)
2 Public School (Government subsidy)
3 Private School (some Government subsidy + fee)
4 Other (special needs schools)
5 Not known
EGCDF NPO: Education Grant Commuting Distance Flag PUN_EGCDF CHAR 1 0
X Yes
NULL No
BEGDA NPO: EG Attendance begin date for CCAQ PUN_CCAQSDAT CHAR 10 0
ENDDA NPO: EG Attendance end date for CCAQ PUN_CCAQEDAT CHAR 10 0
TUITION_WAERS NPO: EG Currency Key for CCAQ PUN_CCAQWAER CHAR 3 0
TUITION_EXCHG NPO: EG Exchange Rate (no commas) PUN_EGEXC CHAR 13 0
TUITION NPO EG Tuition PUN_EGTUIT CHAR 16 0
TRANSPORTATION NPO EG Transportation PUN_EGTRANS CHAR 16 0
MEALS NPO: EG CCAQ Meals fee PUN_EGMEALS CHAR 16 0
BOOKS NPO: EG Books fee for CCAQ PUN_CCAQBOOK CHAR 16 0
MOTHERTONGUE NPO: EG CCAQ Mother tongue fee PUN_EGMTONG CHAR 16 0
OTHER NPO: Education Grant Other permissible costs PUN_EGOTHER CHAR 16 0
TOTALCST NPO: EG Total admissible fees PUN_EGCCAQTOT CHAR 19 0
BWAERS NPO: EG Currency Key for CCAQ PUN_CCAQWAER CHAR 3 0
BEXC_RATE NPO: EG Exchange Rate (no commas) PUN_EGEXC CHAR 13 0
BCTYPE NPO: EG Boarding Cost Type PUN_BCTYPE CHAR 1 0
0 No boarding Cost
1 Flat Rate Boarding Cost
2 Actual Boarding Cost
BOARDING NPO: EG Boarding Cost in CCAQ Report with Length 16 PUN_CCAQBOARD CHAR 16 0
ALLOWABLE NPO: EG Total Admissible Fees and Boarding costs PUN_CCAQALLOWABLE CHAR 19 0
CALC_WAERS NPO: EG Currency Key for CCAQ PUN_CCAQWAER CHAR 3 0
ADDRA NPO: EG Additional Reimbursement Amount PUN_EGADDAM CHAR 16 0
ACTRA NPO: EG Actual Reimbursement Amount PUN_EGACTAM CHAR 16 0