SAP ABAP Table CMAC_SC_ALL (Program 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_SC_ALL	Table Relationship Diagram
Short Description	Program 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	Program of Study
2	CMSCID	☐	PIQSCOBJID	HROBJID	NUMC	8	0	Program ID	PLOGI
3	CMSCNAME	☐	CMAC_SC_NAME	TEXT12	CHAR	12	0	Program (Abbreviation)
4	CMPERYR	☐	PIQPERYR	PIQPERYR	NUMC	4	0	Academic Year	*
5	CMPERID	☐	PIQPERID	PIQPERID	NUMC	3	0	Academic Session	*
6	.INCLUDE	☐				0	0	Program of Study
7	CMSCCAT	☐	PIQSCFEECAT	PIQSCFEECAT	CHAR	4	0	Program Fee Category	*
8	CMENTYEAR	☐	PIQ_ENTERING_YEAR	PIQPERYR	NUMC	4	0	Year of Entrance	*
9	CMSTAGE	☐	PIQLEVEL	PIQLEVEL	NUMC	2	0	Stage	*
10	CMPTIME	☐	PIQPARTT	XFELD	CHAR	1	0	Indicator: Part-Time Study
11	CMSCLENGTH	☐	PIQLENGTH	PIQLENGTH	NUMC	4	0	Program Duration
12	CMSCTUNIT	☐	PIQTIMEUNIT	PIQTIMEUNIT	NUMC	2	0	Time Unit for Program Duration	*
13	CMSCREGDAT	☐	PIQREGDATE	DATUM	DATS	8	0	Activity Key Date for Start of Study Segment
14	CMSCCAID	☐	PIQCAOBJID	HROBJID	NUMC	8	0	Academic Calendar Object ID	*
15	CMSCREGP1	☐	CMAC_SC_REG_PER1	PIQTIMELIMIT	CHAR	4	0	First Registration Period for Program	*
16	CMSCREGP2	☐	CMAC_SC_REG_PER2	PIQTIMELIMIT	CHAR	4	0	Second Registration Period for Program	*
17	CMSCWDDAT	☐	PIQDERDATE	DATUM	DATS	8	0	Activity Key Date of De-registration
18	CMSCWDTYP	☐	PIQPROCESS_END	PIQPROCESS	CHAR	4	0	Activity for De-registration from Program	*
19	CMSCDREGP1	☐	CMAC_SC_DREG_PER1	PIQTIMELIMIT	CHAR	4	0	First De-registration Period for Program	*
20	CMSCDREGP2	☐	CMAC_SC_DREG_PER2	PIQTIMELIMIT	CHAR	4	0	Second De-registration Period for Program	*
21	CMSCORG	☐	CMAC_SC_ORGUNIT	HROBJID	NUMC	8	0	Object ID of Organizational Unit for Program	PLOGI
22	CMSCCOCD	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
23	CMSCMAIN	☐	PIQ_MAIN_PROGRAM_FLAG	FLAG	CHAR	1	0	Main Program
24	CMSCDREGR	☐	PIQDERREASON	PIQAPPREASON	NUMC	4	0	De-registration Reason	*
25	CMREGTYPE	☐	PIQAPPTYPE_503	PIQPROCESS	CHAR	4	0	Activity for Sessional Registration (OBSOLETE)	*
26	CMSCLABSR	☐	PIQLEAREASON	PIQAPPREASON	NUMC	4	0	Leave of Absence Reason	*
27	CMCANCTYPE	☐	PIQREGCANCPROCESS	PIQPROCESS	CHAR	4	0	Cancellation Activity (For Registration)	*
28	CMCANCREAN	☐	PIQREGCANCREASON	PIQAPPREASON	NUMC	4	0	Cancellation Reason (For Registration)	*
29	CMCANCDATE	☐	PIQREGCANCDATE	DATUM	DATS	8	0	Cancellation Date (Registration)
30	CMPERCT	☐	PIQPERCT	PIQPERCT	NUMC	3	0	Completed Length of Study
31	CMREPSTAGE	☐	PIQ_REPEAT_PROGRAM	FLAG	CHAR	1	0	Indicator: Repeat Stage
32	CMCPTHD	☐	PIQCPTHD	PIQCP	QUAN	10	5	Credit Lower Limit
33	CMSCCPUNIT	☐	PIQCPUNIT	MEINS	UNIT	3	0	Unit of Measurement for Credits	*
34	CMFVALTHD	☐	PIQFEEVALTHD	PIQCP	QUAN	10	5	Lower Limit of Module Fee
35	CMSCMVUNIT	☐	PIQMVUNIT	MEINS	UNIT	3	0	Unit for Module Fee Calculation	*
36	CMSCKEYDAT	☐	PIQKEYDATE	DATUM	DATS	8	0	Key Date
37	CMCHOICE	☐	PIQ_STUDY_CHOICE	PIQ_STUDY_CHOICE	NUMC	2	0	Program Choice
38	CMCATEG	☐	PIQADM_CATEG	PIQADM_CATEG	CHAR	2	0	Admission Category	*
39	CMSCDDSHED	☐	PIQDDSCHED	PIQDDSCHED	CHAR	6	0	Due Date Schedule	T7PIQDDSCHED
40	CMPROGCLS	☐	PIQPROGCLASS	PIQPROGCLASS	CHAR	4	0	Progress Classification	*
41	CMREGCLS	☐	PIQREGCLASS	PIQREGCLASS	CHAR	2	0	Registration Classification	*
42	CMSTATUS	☐	PIQREG_PERIODSTATUS	PIQREG_PERIODSTATUS	CHAR	1	0	Sessional Registration Status
43	CMSTATE	☐	PIQREG_PRS_STATE	PIQHS_STATE	CHAR	1	0	Sessional Registration Status Specification
44	CMENRCATEG	☐	PIQENRCATEG	PIQENRCATEG	CHAR	2	0	Registration Type	*
45	CMPROGCVAR	☐	PIQPROGC_VAR	PIQPROGC_VAR	CHAR	4	0	Program Type	T7PIQPROGCVAR
46	CMACST	☐	PIQPROG_GR_ACST	PIQPROG_GR_ACST	CHAR	4	0	Academic Standing	T7PIQPROG_ACST
47	CMACST_STATUS	☐	PIQPROG_GR_RESULT_STATUS	PIQPROG_GR_RESULT_STATUS	CHAR	1	0	Result Status
48	CMACSTFA	☐	PIQPROG_GR_ACSTFA	PIQPROG_GR_ACSTFA	CHAR	4	0	Academic Standing Based on Financial Aid Regulations	T7PIQPROG_ACSTF
49	CMACSTFA_STATUS	☐	PIQPROG_GR_RESULT_STATUS	PIQPROG_GR_RESULT_STATUS	CHAR	1	0	Result Status
50	CMPRCL	☐	PIQPROGCLASS	PIQPROGCLASS	CHAR	4	0	Progress Classification	T7PIQPROGCLASS
51	CMPRCL_STATUS	☐	PIQPROG_GR_RESULT_STATUS	PIQPROG_GR_RESULT_STATUS	CHAR	1	0	Result Status
52	CMPRCLFA	☐	PIQPROGCLASSFA	PIQPROGCLASS	CHAR	4	0	Progress Classification for Financial Aid	T7PIQPROGCLASS
53	CMPRCLFA_STATUS	☐	PIQPROG_GR_RESULT_STATUS	PIQPROG_GR_RESULT_STATUS	CHAR	1	0	Result Status
54	CMAWARD	☐	PIQPROG_GR_AWARD	PIQPROG_GR_AWARD	CHAR	4	0	Academic Honors	T7PIQPROG_AWARD
55	CMAWARD_STATUS	☐	PIQPROG_GR_RESULT_STATUS	PIQPROG_GR_RESULT_STATUS	CHAR	1	0	Result Status
56	CMCGOBJID	☐	PIQCGOBJID	HROBJID	NUMC	8	0	Module Group ID	PLOGI
57	CMSCGRPVAR	☐	PIQSCCGVAR	PIQSCCGVAR	NUMC	3	0	Module Group Variant for Program	T7PIQSC_CGVAR
58	CMCGFEECAT	☐	PIQCGFEECAT	PIQCGFEECAT	CHAR	4	0	Fee Category of Module Group	T7PIQCGFEECAT
59	CMCGCATEG	☐	PIQMODGRPCAT	PIQMODGRPCAT	CHAR	4	0	Module Group Category	T7PIQMODGRPCAT
60	.INCLUDE	☐				0	0
61	.INCLUDE	☐				0	0	Program of study data for output
62	CMVARIDT	☐	CMAC_VARID_T	TEXT20	CHAR	20	0	Session Variant (Description)
63	CMSCCATT	☐	PIQSCFEECATT	TEXT30	CHAR	30	0	Program Fee Category (Description)
64	CMSTAGET	☐	CMAC_LEVEL_T	TEXT30	CHAR	30	0	Stage (Description)
65	CMPTIMET	☐	CMAC_FULLTPARTT_T	TEXT20	CHAR	20	0	Full-Time/Part-Time Indicator for Program
66	CMSCTUNITT	☐	CMAC_TIMEUNIT_T	TEXT20	CHAR	20	0	Time Unit for Program Duration (Description)
67	CMSCORGT	☐	CMAC_ORG_UNIT	TEXT12	CHAR	12	0	Organizational Unit Abbreviation for Module
68	CMSCCAIDT	☐	CMAC_CALENDAR_T	TEXT12	CHAR	12	0	Academic Calendar (Description)
69	CMSCWDTYPT	☐	CMAC_SC_DEREGTYP_T	TEXT40	CHAR	40	0	De-registration Activity for Registration (Description)
70	CMSCDREGRT	☐	CMAC_SC_DEREGRES_T	TEXT25	CHAR	25	0	Reason for De-registration Activity (Description)
71	CMREGTYPET	☐	CMAC_SC_REGTYP_T	TEXT40	CHAR	40	0	Re-registration Activity for Registration (Description)
72	CMSCLABSRT	☐	CMAC_SC_LABSRES_T	TEXT25	CHAR	25	0	Reason for Absence or Leave of Absence Activity (Desc.)
73	CMCANCTYPET	☐	CMAC_SC_CANCTYP_T	TEXT40	CHAR	40	0	Cancellation Activity for Registration (Description)
74	CMCANCREANT	☐	CMAC_SC_CANCRES_T	TEXT25	CHAR	25	0	Reason for Cancellation Activity (Description)
75	CMCATEGT	☐	PIQADM_CATEGT	TEXT30	CHAR	30	0	Admission Category (Description)
76	CMSCDDSHEDT	☐	PIQDDSCHEDT	CHAR30	CHAR	30	0	Due Date Schedule (Description)
77	CMPROGCLST	☐	PIQPROGCLASST	TEXT30	CHAR	30	0	Progress Classification (Description)
78	CMREGCLST	☐	PIQREGCLASST	TEXT30	CHAR	30	0	Registration Classification Description
79	CMENRCATEGT	☐	PIQENRCATEGT	TEXT30	CHAR	30	0	Registration Type (Description)
80	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CMAC_SC_ALL	CMACST	T7PIQPROG_ACST	ACST
2	CMAC_SC_ALL	CMACSTFA	T7PIQPROG_ACSTF	ACSTFA
3	CMAC_SC_ALL	CMAWARD	T7PIQPROG_AWARD	AWARD
4	CMAC_SC_ALL	CMCGCATEG	T7PIQMODGRPCAT	CATEGORY	REF	1	CN
5	CMAC_SC_ALL	CMCGFEECAT	T7PIQCGFEECAT	FEECAT	REF	1	CN
6	CMAC_SC_ALL	CMCGOBJID	PLOGI	OBJID
7	CMAC_SC_ALL	CMPRCL	T7PIQPROGCLASS	PROGCLASS
8	CMAC_SC_ALL	CMPRCLFA	T7PIQPROGCLASS	PROGCLASS
9	CMAC_SC_ALL	CMPROGCVAR	T7PIQPROGCVAR	PROGC_VAR
10	CMAC_SC_ALL	CMSCDDSHED	T7PIQDDSCHED	DDSCHED	REF	1	CN
11	CMAC_SC_ALL	CMSCGRPVAR	T7PIQSC_CGVAR	GRPVAR	REF	1	CN
12	CMAC_SC_ALL	CMSCID	PLOGI	OBJID
13	CMAC_SC_ALL	CMSCORG	PLOGI	OBJID

History

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