The CMACDB_FEEHD table in SAP ERP or S/4HANA stores Fee Calculation Document Header data. There are total 37 fields in CMACDB_FEEHD table. The Fee Calculation Document Header table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of CMACDB_FEEHD table. It is in Campus Management: Student Account (CMAC_D) ABAP package and is part of the Student Accounting (IS-HER-CM-AC) module.
SAP CMACDB_FEEHD Table Fields
Following is the list of fields that are available in SAP CMACDB_FEEHD table. The primary key fields of the table are MANDT (Client), DOCNR (Number of Fee Calculation Document).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT (3) |
| DOCNR | Number of Fee Calculation Document | CMAC_FEE_DOCNR | CHAR (20) | |
| PARTNER | Business Partner Number | BU_PARTNER | * | CHAR (10) |
| PERSL | Key for Period Assignment | PERSL_KK | TFK001P | CHAR (4) |
| CALC_BASE | Fee Calculation Base | PIQ_FEE_GROUP | CHAR (1) | |
| FEECALCMODE | Processing Mode for Fee Calculation | PIQFEECALCMODE | T7PIQFEECTRLE | CHAR (1) |
| CALCDATE | Fee Calculation Date | CMAC_CALCDATE | DATS (8) | |
| CPUDT | Entry Date of Fee Calculation Document | CMAC_CPUDT | DATS (8) | |
| CPUTM | Time of Entry | CPUTM | TIMS (6) | |
| UNAME | User Name | CMAC_USER_NAME | CHAR (12) | |
| FEEPROC | Fee Calculation Procedure | CMAC_FEE_PROC | CHAR (6) | |
| BALOGNR | Application log: log number | BALOGNR | * | CHAR (20) |
| DOCAMT | Calculated Amount in Document Currency | CMAC_DOCAMT | CURR (13) | |
| DOCCUKY | Document Currency | CMAC_DOCCURR | * | CUKY (5) |
| CMSTID | Object ID of Student | PIQSTUDENT | PLOGI | NUMC (8) |
| CMSTNUM | Student Number | CMAC_ST_NUMBER | CHAR (12) | |
| CMPERSL | Key for Period Assignment | PERSL_KK | * | CHAR (4) |
| CMSTCAT | Student Fee Category | PIQSTFEECAT | T7PIQSTFEECAT | CHAR (4) |
| CMBENCAT | Benefit Category | PIQBENCAT | T7PIQBENCAT | CHAR (4) |
| CMPREVHE | Indicator: Student Has Attended Other University | PIQPREVHE | CHAR (1) | |
| CMSTGRP | Student Group | PIQSTGRP | T7PIQSTGRP | CHAR (4) |
| CMPDISCT1 | Discount/Surcharge Category 1 | PIQPDISCT1 | T7PIQPDISCT1 | CHAR (4) |
| CMPDISCT2 | Discount/Surcharge Category 2 | PIQPDISCT2 | T7PIQPDISCT2 | CHAR (4) |
| CMPDISCT3 | Discount/Surcharge Category 3 | PIQPDISCT3 | T7PIQPDISCT3 | CHAR (4) |
| CMPDISCT4 | Discount/Surcharge Category 4 | PIQPDISCT4 | T7PIQPDISCT4 | CHAR (4) |
| CMPDISCT5 | Discount/Surcharge Category 5 | PIQPDISCT5 | T7PIQPDISCT5 | CHAR (4) |
| CMPDISCT6 | Discount/Surcharge Category 6 | PIQPDISCT6 | T7PIQPDISCT6 | CHAR (4) |
| CMNATIO | Nationality (Citizenship) | PIQNATSL | T005 | CHAR (3) |
| CMLOCCURR | Local Currency | CMAC_LOCCURR | TCURC | CUKY (5) |
| CMDOCCURR | Document Currency | CMAC_DOCCURR | TCURC | CUKY (5) |
| CMCOMPCODE | Standard Company Code | STDBK_KK | * | CHAR (4) |
| CMCOCDGRP | Company Code Group | OPBUK_KK | * | CHAR (4) |
| CMSTCAMPUS | Campus of Student | CMAC_STCAMPUS | NUMC (8) | |
| CMSTORG | Object ID of Student’s Organizational Unit | CMAC_ST_ORGUNIT | PLOGI | NUMC (8) |
| CMSTSTATUS | Student Fee Calculation Status | PIQ_ST_STATUS | CHAR (1) | |
| CMVISATYPE | Visa or Registration Type | PIQVISATYPE | T7PIQVISATYPE | CHAR (4) |
| CMSTKEYDAT | Key Date | PIQKEYDATE | DATS (8) |
