SAP ABAP Table CMAC_SM_ALL (Module data including technical data and data for display)

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	INTTAB	Structure
Structure	CMAC_SM_ALL	Table Relationship Diagram
Short Description	Module data including technical data and data for display

Delivery and Maintenance

Pool/cluster
Delivery Class
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	.INCLUDE	☐				0	0	Modules information
2	CMSMID	☐	PIQ_SM_OBJID	HROBJID	NUMC	8	0	Module Object ID	PLOGI
3	CMSMNAME	☐	CMAC_SM_NAME	TEXT12	CHAR	12	0	Module (Abbreviation)
4	CMPERYR	☐	PIQPERYR	PIQPERYR	NUMC	4	0	Academic Year	*
5	CMPERID	☐	PIQPERID	PIQPERID	NUMC	3	0	Academic Session	*
6	.INCLUDE	☐				0	0	Modules information
7	CMSMCAT	☐	PIQSMFEECAT	PIQSMFEECAT	CHAR	4	0	Module Fee Category	*
8	CMLEVCAT	☐	PIQLEVYFEECAT	PIQLEVYFEECAT	CHAR	4	0	Special Fee Category for Module	*
9	CMCRHRS	☐	PIQCPOPT	PIQCP	QUAN	10	5	Optimum Credit Value
10	CMCPUNIT	☐	PIQCPUNIT	MEINS	UNIT	3	0	Unit of Measurement for Credits	*
11	CMOUTPROG	☐	PIQSC_VS_D	FLAG	CHAR	1	0	Module Excluded from Program of Study
12	CMSMSTATS	☐	PIQSMSTATUS	PIQSMSTATUS	NUMC	2	0	Module Booking Status	*
13	CMSMREGDAT	☐	PIQDATE	DATUM	DATS	8	0	Booking Date
14	CMSMREGREA	☐	PIQBOOKREASON	PIQBOOKREASON	CHAR	4	0	Module Booking Reason	*
15	CMSMCAID	☐	PIQCAOBJID	HROBJID	NUMC	8	0	Academic Calendar Object ID	*
16	CMSMREGP1	☐	CMAC_SM_REG_PER1	PIQTIMELIMIT	CHAR	4	0	First Booking Period for Module	*
17	CMSMREGP2	☐	CMAC_SM_REG_PER2	PIQTIMELIMIT	CHAR	4	0	Second Booking Period for Module	*
18	CMSMWDDATE	☐	PIQSTORDATE	PIQSTORDATE	DATS	8	0	Cancellation Date
19	CMSMWDREA	☐	PIQSTORREASON	PIQSTORREASON	CHAR	4	0	Cancellation Reason	*
20	CMSMDREGP1	☐	CMAC_SM_DREG_PER1	PIQTIMELIMIT	CHAR	4	0	First Cancellation Period for Module	*
21	CMSMDREGP2	☐	CMAC_SM_DREG_PER2	PIQTIMELIMIT	CHAR	4	0	Second Cancellation Period for Module	*
22	CMSMCPTEMP	☐	PIQCPATTEMP	PIQCP	QUAN	10	5	Attempted Credits
23	CMSMCPUNIT	☐	PIQCPUNIT	MEINS	UNIT	3	0	Unit of Measurement for Credits	*
24	CMSMEXMPT	☐	PIQCHARGE	PIQCHARGE	CHAR	1	0	Free of Charge
25	CMSMTRANSF	☐	PIQTRANSFER	PIQTRANSFER	CHAR	1	0	External Academic Work or Qualification Transferred
26	CMSMRATING	☐	PIQSMRATING	PIQSMRATING	CHAR	3	0	Alternative Assessment Method for Module	*
27	CMSMSCALID	☐	PIQSCALE_ID	PIQSCALE_ID	CHAR	4	0	Academic Scale Identification (ID)	*
28	CMSMVALUE	☐	PIQSMFEEVAL	PIQCP	QUAN	10	5	Module Value for Module Fee Calculation
29	CMMVUNIT	☐	PIQMVUNIT	MEINS	UNIT	3	0	Unit for Module Fee Calculation	*
30	CMSMORG	☐	CMAC_SM_ORGUNIT	HROBJID	NUMC	8	0	Object ID of Organizational Unit for Module	PLOGI
31	CMSMCOCD	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
32	CMREFTYPE	☐	PIQREFUNDTYP	PIQREFUNDTYP	CHAR	4	0	Module Refund Type	*
33	CMSMKEYDAT	☐	PIQKEYDATE	DATUM	DATS	8	0	Key Date
34	CMSEOBJID	☐	PIQSEOBJID	HROBJID	NUMC	8	0	Object ID of Event Package	PLOGI
35	CMSMSECAT1	☐	PIQSECCAT1	PIQSECCAT1	CHAR	4	0	Event Package Category 1	*
36	CMSMDDSHED	☐	PIQDDSCHED	PIQDDSCHED	CHAR	6	0	Due Date Schedule	T7PIQDDSCHED
37	CMSEDDSHED	☐	CMAC_SEDDS	PIQDDSCHED	CHAR	6	0	Due Date Schedule of Event Package	T7PIQDDSCHED
38	CMSMCAMPUS	☐	CMAC_SMCAMPUS	NUM08	NUMC	8	0	Campus for Module
39	CMSMDELMOD	☐	PIQDELMODE	PIQDELMODE	CHAR	4	0	Delivery Mode	*
40	CMPROGCVAR	☐	PIQPROGC_VAR	PIQPROGC_VAR	CHAR	4	0	Program Type	*
41	CMMULTPROGCVAR	☐	PIQMULTPROGCVAR	FLAG	CHAR	1	0	Multiple Use for Program Types (Fee Calculation)
42	CMSMWAITLIST	☐	PIQWAITL_WAITL	XFELD	CHAR	1	0	Indicator: Waiting List Booking
43	.INCLUDE	☐				0	0
44	.INCLUDE	☐				0	0	Module data for output
45	CMSMCATT	☐	PIQSMFEECATT	TEXT30	CHAR	30	0	Module Fee Category (Description)
46	CMLEVCATT	☐	PIQLEVYFEECATT	TXT30	CHAR	30	0	Special Fee Category for Module (Description)
47	CMSMSTATST	☐	CMAC_SMSTATUS_T	TEXT25	CHAR	25	0	Module Booking Status
48	CMSMREGREAT	☐	PIQBOOKREASONT	TEXT40	CHAR	40	0	Module Booking Reason (Description)
49	CMSMCAIDT	☐	CMAC_CALENDAR_T	TEXT12	CHAR	12	0	Academic Calendar (Description)
50	CMSMWDREAT	☐	PIQSTORREASONT	PIQSTORREASONT	CHAR	40	0	Cancellation Reason (Description)
51	CMSMRATINGT	☐	PIQSMRATINGT	PIQSMRATINGT	CHAR	40	0	Alternative Assessment Method for Module (Description)
52	CMSMSCALIDT	☐	PIQSCALE_TEXT	PIQSCALE_TEXT	CHAR	30	0	Academic Scale (Description)
53	CMSMORGT	☐	CMAC_ORG_UNIT	TEXT12	CHAR	12	0	Organizational Unit Abbreviation for Module
54	CMREFTYPT	☐	PIQREFUNDTYPT	TEXT30	CHAR	30	0	Module Refund Type (Description)
55	CMSEOBJIDT	☐	CMAC_SE_NAME	TEXT12	CHAR	12	0	Event Package (Abbreviation)
56	CMSMSECAT1T	☐	PIQSECCAT1T	TEXT30	CHAR	30	0	Event Package Category 1 (Description)
57	CMSMDDSHEDT	☐	PIQDDSCHEDT	CHAR30	CHAR	30	0	Due Date Schedule (Description)
58	CMSEDDSHEDT	☐	CMAC_SEDDS_T	CHAR30	CHAR	30	0	Due Date Schedule of Event Package (Description)
59	CMSMCAMPUST	☐	CMAC_CAMPUS_T	TEXT12	CHAR	12	0	Campus Name
60	CMSMDELMODT	☐	PIQDELMODET	TEXT40	CHAR	40	0	Delivery Mode (Description)
61	.INCLUDE	☐				0	0

Foreign Keys

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

History

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