SAP ABAP Table CMACDB_FEESM (Fee Calculation Document Items (Module))

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_FEESM	Table Relationship Diagram
Short Description	Fee Calculation Document Items (Module)

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	MANDT	CLNT	3	0	Client	*
2	DOCNR	☑	CMAC_FEE_DOCNR	CHAR20	CHAR	20	0	Number of Fee Calculation Document
3	ITEMNR	☑	CMAC_ITEM_NBR	NUMC4	NUMC	4	0	Item Number
4	.INCLUDE	☐				0	0	Modules information
5	CMSMID	☐	PIQ_SM_OBJID	HROBJID	NUMC	8	0	Module Object ID	PLOGI
6	CMSMNAME	☐	CMAC_SM_NAME	TEXT12	CHAR	12	0	Module (Abbreviation)
7	CMPERYR	☐	PIQPERYR	PIQPERYR	NUMC	4	0	Academic Year	*
8	CMPERID	☐	PIQPERID	PIQPERID	NUMC	3	0	Academic Session	*
9	.INCLUDE	☐				0	0	Modules information
10	CMSMCAT	☐	PIQSMFEECAT	PIQSMFEECAT	CHAR	4	0	Module Fee Category	*
11	CMLEVCAT	☐	PIQLEVYFEECAT	PIQLEVYFEECAT	CHAR	4	0	Special Fee Category for Module	*
12	CMCRHRS	☐	PIQCPOPT	PIQCP	QUAN	10	5	Optimum Credit Value
13	CMCPUNIT	☐	PIQCPUNIT	MEINS	UNIT	3	0	Unit of Measurement for Credits	*
14	CMOUTPROG	☐	PIQSC_VS_D	FLAG	CHAR	1	0	Module Excluded from Program of Study
15	CMSMSTATS	☐	PIQSMSTATUS	PIQSMSTATUS	NUMC	2	0	Module Booking Status	*
16	CMSMREGDAT	☐	PIQDATE	DATUM	DATS	8	0	Booking Date
17	CMSMREGREA	☐	PIQBOOKREASON	PIQBOOKREASON	CHAR	4	0	Module Booking Reason	*
18	CMSMCAID	☐	PIQCAOBJID	HROBJID	NUMC	8	0	Academic Calendar Object ID	*
19	CMSMREGP1	☐	CMAC_SM_REG_PER1	PIQTIMELIMIT	CHAR	4	0	First Booking Period for Module	*
20	CMSMREGP2	☐	CMAC_SM_REG_PER2	PIQTIMELIMIT	CHAR	4	0	Second Booking Period for Module	*
21	CMSMWDDATE	☐	PIQSTORDATE	PIQSTORDATE	DATS	8	0	Cancellation Date
22	CMSMWDREA	☐	PIQSTORREASON	PIQSTORREASON	CHAR	4	0	Cancellation Reason	*
23	CMSMDREGP1	☐	CMAC_SM_DREG_PER1	PIQTIMELIMIT	CHAR	4	0	First Cancellation Period for Module	*
24	CMSMDREGP2	☐	CMAC_SM_DREG_PER2	PIQTIMELIMIT	CHAR	4	0	Second Cancellation Period for Module	*
25	CMSMCPTEMP	☐	PIQCPATTEMP	PIQCP	QUAN	10	5	Attempted Credits
26	CMSMCPUNIT	☐	PIQCPUNIT	MEINS	UNIT	3	0	Unit of Measurement for Credits	*
27	CMSMEXMPT	☐	PIQCHARGE	PIQCHARGE	CHAR	1	0	Free of Charge
28	CMSMTRANSF	☐	PIQTRANSFER	PIQTRANSFER	CHAR	1	0	External Academic Work or Qualification Transferred
29	CMSMRATING	☐	PIQSMRATING	PIQSMRATING	CHAR	3	0	Alternative Assessment Method for Module	*
30	CMSMSCALID	☐	PIQSCALE_ID	PIQSCALE_ID	CHAR	4	0	Academic Scale Identification (ID)	*
31	CMSMVALUE	☐	PIQSMFEEVAL	PIQCP	QUAN	10	5	Module Value for Module Fee Calculation
32	CMMVUNIT	☐	PIQMVUNIT	MEINS	UNIT	3	0	Unit for Module Fee Calculation	*
33	CMSMORG	☐	CMAC_SM_ORGUNIT	HROBJID	NUMC	8	0	Object ID of Organizational Unit for Module	PLOGI
34	CMSMCOCD	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
35	CMREFTYPE	☐	PIQREFUNDTYP	PIQREFUNDTYP	CHAR	4	0	Module Refund Type	*
36	CMSMKEYDAT	☐	PIQKEYDATE	DATUM	DATS	8	0	Key Date
37	CMSEOBJID	☐	PIQSEOBJID	HROBJID	NUMC	8	0	Object ID of Event Package	PLOGI
38	CMSMSECAT1	☐	PIQSECCAT1	PIQSECCAT1	CHAR	4	0	Event Package Category 1	*
39	CMSMDDSHED	☐	PIQDDSCHED	PIQDDSCHED	CHAR	6	0	Due Date Schedule	T7PIQDDSCHED
40	CMSEDDSHED	☐	CMAC_SEDDS	PIQDDSCHED	CHAR	6	0	Due Date Schedule of Event Package	T7PIQDDSCHED
41	CMSMCAMPUS	☐	CMAC_SMCAMPUS	NUM08	NUMC	8	0	Campus for Module
42	CMSMDELMOD	☐	PIQDELMODE	PIQDELMODE	CHAR	4	0	Delivery Mode	*
43	CMPROGCVAR	☐	PIQPROGC_VAR	PIQPROGC_VAR	CHAR	4	0	Program Type	*
44	CMMULTPROGCVAR	☐	PIQMULTPROGCVAR	FLAG	CHAR	1	0	Multiple Use for Program Types (Fee Calculation)
45	CMSMWAITLIST	☐	PIQWAITL_WAITL	XFELD	CHAR	1	0	Indicator: Waiting List Booking
46	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CMACDB_FEESM	CMSEDDSHED	T7PIQDDSCHED	DDSCHED	REF	1	CN
2	CMACDB_FEESM	CMSEOBJID	PLOGI	OBJID
3	CMACDB_FEESM	CMSMDDSHED	T7PIQDDSCHED	DDSCHED	REF	1	CN
4	CMACDB_FEESM	CMSMID	PLOGI	OBJID
5	CMACDB_FEESM	CMSMORG	PLOGI	OBJID

History

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