SAP ABAP Table V_TCMAC_SM (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_TCMAC_SM	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	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	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	CMSMCAID	☐	PIQCAOBJID	HROBJID	NUMC	8	0	Academic Calendar Object ID
15	CMSMREGP1	☐	CMAC_SM_REG_PER1	PIQTIMELIMIT	CHAR	4	0	First Booking Period for Module
16	CMSMREGP2	☐	CMAC_SM_REG_PER2	PIQTIMELIMIT	CHAR	4	0	Second Booking Period for Module
17	CMSMWDDATE	☐	PIQSTORDATE	PIQSTORDATE	DATS	8	0	Cancellation Date
18	CMSMDREGP1	☐	CMAC_SM_DREG_PER1	PIQTIMELIMIT	CHAR	4	0	First Cancellation Period for Module
19	CMSMDREGP2	☐	CMAC_SM_DREG_PER2	PIQTIMELIMIT	CHAR	4	0	Second Cancellation Period for Module
20	CMSMEXMPT	☐	PIQCHARGE	PIQCHARGE	CHAR	1	0	Free of Charge
21	CMSMVALUE	☐	PIQSMFEEVAL	PIQCP	QUAN	10	5	Module Value for Module Fee Calculation
22	CMMVUNIT	☐	PIQMVUNIT	MEINS	UNIT	3	0	Unit for Module Fee Calculation
23	CMSMORG	☐	CMAC_SM_ORGUNIT	HROBJID	NUMC	8	0	Object ID of Organizational Unit for Module	PLOGI
24	CMREFTYPE	☐	PIQREFUNDTYP	PIQREFUNDTYP	CHAR	4	0	Module Refund Type
25	CMSMKEYDAT	☐	PIQKEYDATE	DATUM	DATS	8	0	Key Date
26	CMSEOBJID	☐	PIQSEOBJID	HROBJID	NUMC	8	0	Object ID of Event Package	PLOGI
27	CMSMSECAT1	☐	PIQSECCAT1	PIQSECCAT1	CHAR	4	0	Event Package Category 1
28	CMSMDDSHED	☐	PIQDDSCHED	PIQDDSCHED	CHAR	6	0	Due Date Schedule	T7PIQDDSCHED
29	CMSEDDSHED	☐	CMAC_SEDDS	PIQDDSCHED	CHAR	6	0	Due Date Schedule of Event Package	T7PIQDDSCHED
30	CMSMCAMPUS	☐	CMAC_SMCAMPUS	NUM08	NUMC	8	0	Campus for Module

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in