SAP ABAP Table CMACDB_FEEHD (Fee Calculation Document Header)
Hierarchy
☛
IS-PS-CA (Software Component) IS-PUBLIC SECTOR CONTRACT ACCOUNTING
⤷
IS-HER-CM-AC (Application Component) Student Accounting
⤷
CMAC_D (Package) Campus Management: Student Account
⤷
⤷
Basic Data
| Table Category | TRANSP | Transparent table |
| Transparent table | CMACDB_FEEHD |
|
| Short Description | Fee Calculation Document Header |
Delivery and Maintenance
| Pool/cluster | ||
| Delivery Class | A | Application Table (Master- and Transaction Data) |
| 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 | |
MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
| 2 | |
CMAC_FEE_DOCNR | CHAR20 | CHAR | 20 | 0 | Number of Fee Calculation Document | ||
| 3 | |
BU_PARTNER | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | * | |
| 4 | |
PERSL_KK | PERSL_KK | CHAR | 4 | 0 | Key for Period Assignment | TFK001P | |
| 5 | |
PIQ_FEE_GROUP | PIQ_FEE_GROUP | CHAR | 1 | 0 | Fee Calculation Base | ||
| 6 | |
PIQFEECALCMODE | PIQFEECALCMODE | CHAR | 1 | 0 | Processing Mode for Fee Calculation | T7PIQFEECTRLE | |
| 7 | |
CMAC_CALCDATE | DATE | DATS | 8 | 0 | Fee Calculation Date | ||
| 8 | |
CMAC_CPUDT | DATUM | DATS | 8 | 0 | Entry Date of Fee Calculation Document | ||
| 9 | |
CPUTM | UZEIT | TIMS | 6 | 0 | Time of data entry | ||
| 10 | |
CMAC_USER_NAME | USNAM | CHAR | 12 | 0 | User Name | ||
| 11 | |
CMAC_FEE_PROC | CHAR06 | CHAR | 6 | 0 | Fee Calculation Procedure | ||
| 12 | |
BALOGNR | BALOGNR | CHAR | 20 | 0 | Application log: log number | * | |
| 13 | |
CMAC_DOCAMT | WERTV7 | CURR | 13 | 2 | Calculated Amount in Document Currency | ||
| 14 | |
CMAC_DOCCURR | WAERS | CUKY | 5 | 0 | Document Currency | * | |
| 15 | |
0 | 0 | Student information | |||||
| 16 | |
PIQSTUDENT | HROBJID | NUMC | 8 | 0 | Object ID of Student | PLOGI | |
| 17 | |
CMAC_ST_NUMBER | TEXT12 | CHAR | 12 | 0 | Student Number | ||
| 18 | |
PERSL_KK | PERSL_KK | CHAR | 4 | 0 | Key for Period Assignment | * | |
| 19 | |
0 | 0 | Student information | |||||
| 20 | |
PIQSTFEECAT | PIQSTFEECAT | CHAR | 4 | 0 | Student Fee Category | T7PIQSTFEECAT | |
| 21 | |
PIQBENCAT | PIQBENCAT | CHAR | 4 | 0 | Benefit Category | T7PIQBENCAT | |
| 22 | |
PIQPREVHE | XFELD | CHAR | 1 | 0 | Indicator: Student Has Attended Other University | ||
| 23 | |
PIQSTGRP | PIQSTGRP | CHAR | 4 | 0 | Student Group | T7PIQSTGRP | |
| 24 | |
PIQPDISCT1 | PIQPDISCT1 | CHAR | 4 | 0 | Discount/Surcharge Category 1 | T7PIQPDISCT1 | |
| 25 | |
PIQPDISCT2 | PIQPDISCT2 | CHAR | 4 | 0 | Discount/Surcharge Category 2 | T7PIQPDISCT2 | |
| 26 | |
PIQPDISCT3 | PIQPDISCT3 | CHAR | 4 | 0 | Discount/Surcharge Category 3 | T7PIQPDISCT3 | |
| 27 | |
PIQPDISCT4 | PIQPDISCT4 | CHAR | 4 | 0 | Discount/Surcharge Category 4 | T7PIQPDISCT4 | |
| 28 | |
PIQPDISCT5 | PIQPDISCT5 | CHAR | 4 | 0 | Discount/Surcharge Category 5 | T7PIQPDISCT5 | |
| 29 | |
PIQPDISCT6 | PIQPDISCT6 | CHAR | 4 | 0 | Discount/Surcharge Category 6 | T7PIQPDISCT6 | |
| 30 | |
PIQNATSL | LAND1 | CHAR | 3 | 0 | Nationality (Citizenship) | T005 | |
| 31 | |
CMAC_LOCCURR | WAERS | CUKY | 5 | 0 | Local Currency | TCURC | |
| 32 | |
CMAC_DOCCURR | WAERS | CUKY | 5 | 0 | Document Currency | TCURC | |
| 33 | |
STDBK_KK | BUKRS | CHAR | 4 | 0 | Standard Company Code | * | |
| 34 | |
OPBUK_KK | OPBUK_KK | CHAR | 4 | 0 | Company Code Group | * | |
| 35 | |
CMAC_STCAMPUS | NUM08 | NUMC | 8 | 0 | Campus of Student | ||
| 36 | |
CMAC_ST_ORGUNIT | HROBJID | NUMC | 8 | 0 | Object ID of Student's Organizational Unit | PLOGI | |
| 37 | |
PIQ_ST_STATUS | PIQ_ST_STATUS | CHAR | 1 | 0 | Student Fee Calculation Status | ||
| 38 | |
PIQVISATYPE | PIQVISATYPE | CHAR | 4 | 0 | Visa/Registration Type | T7PIQVISATYPE | |
| 39 | |
PIQKEYDATE | DATUM | DATS | 8 | 0 | Key Date | ||
| 40 | |
0 | 0 |
Foreign Keys
| |
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right |
|---|---|---|---|---|---|---|---|
| 1 | CMACDB_FEEHD | CMBENCAT | |
|
1 | CN | |
| 2 | CMACDB_FEEHD | CMDOCCURR | |
|
|||
| 3 | CMACDB_FEEHD | CMLOCCURR | |
|
|||
| 4 | CMACDB_FEEHD | CMNATIO | |
|
REF | 1 | CN |
| 5 | CMACDB_FEEHD | CMPDISCT1 | |
|
1 | CN | |
| 6 | CMACDB_FEEHD | CMPDISCT2 | |
|
1 | CN | |
| 7 | CMACDB_FEEHD | CMPDISCT3 | |
|
1 | CN | |
| 8 | CMACDB_FEEHD | CMPDISCT4 | |
|
1 | CN | |
| 9 | CMACDB_FEEHD | CMPDISCT5 | |
|
1 | CN | |
| 10 | CMACDB_FEEHD | CMPDISCT6 | |
|
1 | CN | |
| 11 | CMACDB_FEEHD | CMSTCAT | |
|
1 | CN | |
| 12 | CMACDB_FEEHD | CMSTGRP | |
|
1 | CN | |
| 13 | CMACDB_FEEHD | CMSTID | |
|
|||
| 14 | CMACDB_FEEHD | CMSTORG | |
|
|||
| 15 | CMACDB_FEEHD | CMVISATYPE | |
|
1 | CN | |
| 16 | CMACDB_FEEHD | FEECALCMODE | |
|
1 | CN | |
| 17 | CMACDB_FEEHD | PERSL | |
|
1 | CN |
History
| Last changed by/on | SAP | 20110901 |
| SAP Release Created in | 472 |