SAP ABAP Table V_TCMAC_SC (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_TCMAC_SC	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

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	CMSCID	☑	PIQSCOBJID	HROBJID	NUMC	8	0	Program ID	PLOGI
5	CMPERYR	☑	PIQPERYR	PIQPERYR	NUMC	4	0	Academic Year	T7PIQYEAR
6	CMPERID	☑	PIQPERID	PIQPERID	NUMC	3	0	Academic Session	T7PIQPERIOD
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	CMSCMAIN	☐	PIQ_MAIN_PROGRAM_FLAG	FLAG	CHAR	1	0	Main Program
23	CMSCDREGR	☐	PIQDERREASON	PIQAPPREASON	NUMC	4	0	De-registration Reason
24	CMREGTYPE	☐	PIQAPPTYPE_503	PIQPROCESS	CHAR	4	0	Activity for Sessional Registration (OBSOLETE)
25	CMSCLABSR	☐	PIQLEAREASON	PIQAPPREASON	NUMC	4	0	Leave of Absence Reason
26	CMCANCTYPE	☐	PIQREGCANCPROCESS	PIQPROCESS	CHAR	4	0	Cancellation Activity (For Registration)
27	CMCANCREAN	☐	PIQREGCANCREASON	PIQAPPREASON	NUMC	4	0	Cancellation Reason (For Registration)
28	CMCANCDATE	☐	PIQREGCANCDATE	DATUM	DATS	8	0	Cancellation Date (Registration)
29	CMPERCT	☐	PIQPERCT	PIQPERCT	NUMC	3	0	Completed Length of Study
30	CMREPSTAGE	☐	PIQ_REPEAT_PROGRAM	FLAG	CHAR	1	0	Indicator: Repeat Stage
31	CMCPTHD	☐	PIQCPTHD	PIQCP	QUAN	10	5	Credit Lower Limit
32	CMSCCPUNIT	☐	PIQCPUNIT	MEINS	UNIT	3	0	Unit of Measurement for Credits
33	CMFVALTHD	☐	PIQFEEVALTHD	PIQCP	QUAN	10	5	Lower Limit of Module Fee
34	CMSCMVUNIT	☐	PIQMVUNIT	MEINS	UNIT	3	0	Unit for Module Fee Calculation
35	CMSCKEYDAT	☐	PIQKEYDATE	DATUM	DATS	8	0	Key Date
36	CMCHOICE	☐	PIQ_STUDY_CHOICE	PIQ_STUDY_CHOICE	NUMC	2	0	Program Choice
37	CMCATEG	☐	PIQADM_CATEG	PIQADM_CATEG	CHAR	2	0	Admission Category
38	CMSCDDSHED	☐	PIQDDSCHED	PIQDDSCHED	CHAR	6	0	Due Date Schedule	T7PIQDDSCHED
39	CMPROGCLS	☐	PIQPROGCLASS	PIQPROGCLASS	CHAR	4	0	Progress Classification
40	CMREGCLS	☐	PIQREGCLASS	PIQREGCLASS	CHAR	2	0	Registration Classification
41	CMSTATUS	☐	PIQREG_PERIODSTATUS	PIQREG_PERIODSTATUS	CHAR	1	0	Sessional Registration Status
42	CMSTATE	☐	PIQREG_PRS_STATE	PIQHS_STATE	CHAR	1	0	Sessional Registration Status Specification
43	CMENRCATEG	☐	PIQENRCATEG	PIQENRCATEG	CHAR	2	0	Registration Type

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	V_TCMAC_SC	CMPERID	T7PIQPERIOD	PERID	KEY	1	CN
2	V_TCMAC_SC	CMPERSL	TCMAC_ST	CMPERSL	KEY	1	CN
3	V_TCMAC_SC	CMPERYR	T7PIQYEAR	PERYR	KEY	1	CN
4	V_TCMAC_SC	CMSCDDSHED	T7PIQDDSCHED	DDSCHED	REF	1	CN
5	V_TCMAC_SC	CMSCID	PLOGI	OBJID	KEY	1	CN
6	V_TCMAC_SC	CMSCORG	PLOGI	OBJID
7	V_TCMAC_SC	CMSTID	TCMAC_ST	CMSTID	KEY	1	CN
8	V_TCMAC_SC	MANDT	T000	MANDT	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in