SAP ABAP Table TCMAC_SM (Module Data for Fee Calculation Test Run)

Hierarchy

☛ IS-PS-CA (Software Component) IS-PUBLIC SECTOR CONTRACT ACCOUNTING
   ⤷ IS-HER-CM-AC (Application Component) Student Accounting
     ⤷ CMAC_E (Package) Campus Management: Student Account

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	TCMAC_SM	Table Relationship Diagram
Short Description	Module Data for Fee Calculation Test Run

Delivery and Maintenance

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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TCMAC_SM	CMPERID	T7PIQPERIOD	PERID	KEY	1	CN
2	TCMAC_SM	CMPERSL	TCMAC_ST	CMPERSL	KEY	1	CN
3	TCMAC_SM	CMPERYR	T7PIQYEAR	PERYR	KEY	1	CN
4	TCMAC_SM	CMSEDDSHED	T7PIQDDSCHED	DDSCHED	REF	1	CN
5	TCMAC_SM	CMSEOBJID	PLOGI	OBJID
6	TCMAC_SM	CMSMDDSHED	T7PIQDDSCHED	DDSCHED	REF	1	CN
7	TCMAC_SM	CMSMID	PLOGI	OBJID	KEY	1	CN
8	TCMAC_SM	CMSMORG	PLOGI	OBJID
9	TCMAC_SM	CMSTID	TCMAC_ST	CMSTID	KEY	1	CN
10	TCMAC_SM	MANDT	T000	MANDT	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in