CMACDB_FEEHD

Fee Calculation Document Header | #header | Component: Student Accounting

🔑 Keys (2)
💰 Amounts (1)
∑ Quantities
📅 Dates (4)
☰ Categorical (3)
Other (10)
🔗 Relations (17)

Column Name	Description
MANDT	Client
DOCNR	Number of Fee Calculation Document

Column Name	Description
💲 Document Currency (DOCCUKY):
DOCAMT	Calculated Amount in Document Currency

Column Name	Description

Column Name	Description
CALCDATE	Fee Calculation Date
CPUDT	Entry Date of Fee Calculation Document
CPUTM	Time of Entry
CMSTKEYDAT	Key Date

Column Name	Description
CALC_BASE	Fee Calculation Base	Show values
CMPREVHE	Indicator: Student Has Attended Other University	Show values
CMSTSTATUS	Student Fee Calculation Status	Show values

Column Name	Description	Domain name
PARTNER	Business Partner Number	BU_PARTNER
UNAME	User Name	USNAM
FEEPROC	Fee Calculation Procedure	CHAR06
BALOGNR	Application Log: Log Number	BALOGNR
CMSTNUM	Student Number	TEXT12
CMPERSL	Key for Period Assignment	PERSL_KK
CMCOMPCODE	Standard Company Code	BUKRS
CMCOCDGRP	Company Code Group	OPBUK_KK
CMSTCAMPUS	Campus of Student	NUM08
FEE_ILM_BLOCK	Fee document blocking flag for ILM enablement

Master Data Relations	Join Conditions
Benefit Category Benefit Category Client	`CMACDB_FEEHD.CMBENCAT == T7PIQBENCAT.BENCAT` `CMACDB_FEEHD.MANDT == T7PIQBENCAT.MANDT`
Document Currency	`CMACDB_FEEHD.MANDT == TCURC.MANDT` `CMACDB_FEEHD.CMDOCCURR == TCURC.WAERS`
Local Currency	`CMACDB_FEEHD.MANDT == TCURC.MANDT` `CMACDB_FEEHD.CMLOCCURR == TCURC.WAERS`
Nationality (Citizenship) Nationality (Citizenship) Client	`CMACDB_FEEHD.CMNATIO == T005.LAND1` `CMACDB_FEEHD.MANDT == T005.MANDT`
Discount/Surcharge Category 1	`CMACDB_FEEHD.MANDT == T7PIQPDISCT1.MANDT` `CMACDB_FEEHD.CMPDISCT1 == T7PIQPDISCT1.PDISCT1`
Discount/Surcharge Category 2	`CMACDB_FEEHD.MANDT == T7PIQPDISCT2.MANDT` `CMACDB_FEEHD.CMPDISCT2 == T7PIQPDISCT2.PDISCT2`
Discount/Surcharge Category 3	`CMACDB_FEEHD.MANDT == T7PIQPDISCT3.MANDT` `CMACDB_FEEHD.CMPDISCT3 == T7PIQPDISCT3.PDISCT3`
Discount/Surcharge Category 4 Discount/Surcharge Category 4 Client	`CMACDB_FEEHD.CMPDISCT4 == T7PIQPDISCT4.PDISCT4` `CMACDB_FEEHD.MANDT == T7PIQPDISCT4.MANDT`
Discount/Surcharge Category 5	`CMACDB_FEEHD.MANDT == T7PIQPDISCT5.MANDT` `CMACDB_FEEHD.CMPDISCT5 == T7PIQPDISCT5.PDISCT5`
Discount/Surcharge Category 6	`CMACDB_FEEHD.MANDT == T7PIQPDISCT6.MANDT` `CMACDB_FEEHD.CMPDISCT6 == T7PIQPDISCT6.PDISCT6`
Student Fee Category	`CMACDB_FEEHD.MANDT == T7PIQSTFEECAT.MANDT` `CMACDB_FEEHD.CMSTCAT == T7PIQSTFEECAT.STFEECAT`
Student Group	`CMACDB_FEEHD.MANDT == T7PIQSTGRP.MANDT` `CMACDB_FEEHD.CMSTGRP == T7PIQSTGRP.STGRP`
Object ID of Student ? ? Client Object ID of Student	`CMACDB_FEEHD.[column in domain "OTYPE"] == PLOGI.OTYPE` `CMACDB_FEEHD.[column in domain "PLVAR"] == PLOGI.PLVAR` `CMACDB_FEEHD.MANDT == PLOGI.MANDT` `CMACDB_FEEHD.CMSTID == PLOGI.OBJID`
Object ID of Student's Organizational Unit ? ? Client Object ID of Student's Organizational Unit	`CMACDB_FEEHD.[column in domain "OTYPE"] == PLOGI.OTYPE` `CMACDB_FEEHD.[column in domain "PLVAR"] == PLOGI.PLVAR` `CMACDB_FEEHD.MANDT == PLOGI.MANDT` `CMACDB_FEEHD.CMSTORG == PLOGI.OBJID`
Visa or Registration Type Visa or Registration Type Client	`CMACDB_FEEHD.CMVISATYPE == T7PIQVISATYPE.VISATYPE` `CMACDB_FEEHD.MANDT == T7PIQVISATYPE.MANDT`
Processing Mode for Fee Calculation	`CMACDB_FEEHD.MANDT == T7PIQFEECTRLE.MANDT` `CMACDB_FEEHD.FEECALCMODE == T7PIQFEECTRLE.FEECALCMODE`
Key for Period Assignment	`CMACDB_FEEHD.MANDT == TFK001P.MANDT` `CMACDB_FEEHD.PERSL == TFK001P.PERSL`