SAP ABAP Table CMAC_ST_ALL (Student 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_ST_ALL	Table Relationship Diagram
Short Description	Student 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	Student information
2	CMSTID	☐	PIQSTUDENT	HROBJID	NUMC	8	0	Object ID of Student	PLOGI
3	CMSTNUM	☐	CMAC_ST_NUMBER	TEXT12	CHAR	12	0	Student Number
4	CMPERSL	☐	PERSL_KK	PERSL_KK	CHAR	4	0	Key for Period Assignment	*
5	.INCLUDE	☐				0	0	Student information
6	CMSTCAT	☐	PIQSTFEECAT	PIQSTFEECAT	CHAR	4	0	Student Fee Category	T7PIQSTFEECAT
7	CMBENCAT	☐	PIQBENCAT	PIQBENCAT	CHAR	4	0	Benefit Category	T7PIQBENCAT
8	CMPREVHE	☐	PIQPREVHE	XFELD	CHAR	1	0	Indicator: Student Has Attended Other University
9	CMSTGRP	☐	PIQSTGRP	PIQSTGRP	CHAR	4	0	Student Group	T7PIQSTGRP
10	CMPDISCT1	☐	PIQPDISCT1	PIQPDISCT1	CHAR	4	0	Discount/Surcharge Category 1	T7PIQPDISCT1
11	CMPDISCT2	☐	PIQPDISCT2	PIQPDISCT2	CHAR	4	0	Discount/Surcharge Category 2	T7PIQPDISCT2
12	CMPDISCT3	☐	PIQPDISCT3	PIQPDISCT3	CHAR	4	0	Discount/Surcharge Category 3	T7PIQPDISCT3
13	CMPDISCT4	☐	PIQPDISCT4	PIQPDISCT4	CHAR	4	0	Discount/Surcharge Category 4	T7PIQPDISCT4
14	CMPDISCT5	☐	PIQPDISCT5	PIQPDISCT5	CHAR	4	0	Discount/Surcharge Category 5	T7PIQPDISCT5
15	CMPDISCT6	☐	PIQPDISCT6	PIQPDISCT6	CHAR	4	0	Discount/Surcharge Category 6	T7PIQPDISCT6
16	CMNATIO	☐	PIQNATSL	LAND1	CHAR	3	0	Nationality (Citizenship)	T005
17	CMLOCCURR	☐	CMAC_LOCCURR	WAERS	CUKY	5	0	Local Currency	TCURC
18	CMDOCCURR	☐	CMAC_DOCCURR	WAERS	CUKY	5	0	Document Currency	TCURC
19	CMCOMPCODE	☐	STDBK_KK	BUKRS	CHAR	4	0	Standard Company Code	*
20	CMCOCDGRP	☐	OPBUK_KK	OPBUK_KK	CHAR	4	0	Company Code Group	*
21	CMSTCAMPUS	☐	CMAC_STCAMPUS	NUM08	NUMC	8	0	Campus of Student
22	CMSTORG	☐	CMAC_ST_ORGUNIT	HROBJID	NUMC	8	0	Object ID of Student's Organizational Unit	PLOGI
23	CMSTSTATUS	☐	PIQ_ST_STATUS	PIQ_ST_STATUS	CHAR	1	0	Student Fee Calculation Status
24	CMVISATYPE	☐	PIQVISATYPE	PIQVISATYPE	CHAR	4	0	Visa/Registration Type	T7PIQVISATYPE
25	CMSTKEYDAT	☐	PIQKEYDATE	DATUM	DATS	8	0	Key Date
26	.INCLUDE	☐				0	0
27	.INCLUDE	☐				0	0	Student data for display
28	CMSTCATT	☐	PIQSTFEECATT	TEXT30	CHAR	30	0	Student Fee Category (Description)
29	CMBENCATT	☐	PIQBENCATT	TEXT30	CHAR	30	0	Benefit Category (Description)
30	CMSTGRPT	☐	CMAC_STGRP_T	TEXT40	CHAR	40	0	Student Group (Description)
31	CMPDISCT1T	☐	PIQPDISCT1T	TEXT30	CHAR	30	0	Discount/Surcharge Category 1 (Description)
32	CMPDISCT2T	☐	PIQPDISCT2T	TEXT30	CHAR	30	0	Discount/Surcharge Category 2 (Description)
33	CMPDISCT3T	☐	PIQPDISCT3T	TEXT30	CHAR	30	0	Discount/Surcharge Category 3 (Description)
34	CMPDISCT4T	☐	PIQPDISCT4T	TEXT30	CHAR	30	0	Discount/Surcharge Category 4 (Description)
35	CMPDISCT5T	☐	PIQPDISCT5T	TEXT30	CHAR	30	0	Discount/Surcharge Category 5 (Description)
36	CMPDISCT6T	☐	PIQPDISCT6T	TEXT30	CHAR	30	0	Discount/Surcharge Category 6 (Description)
37	CMNATIOT	☐	PIQNATIO	TEXT15	CHAR	15	0	Nationality (Citizenship)
38	CMCOMPCODET	☐	CMAC_COMPCODE_T	TEXT25	CHAR	25	0	Company Code (Description)
39	CMSTORGT	☐	CMAC_ORG_UNIT	TEXT12	CHAR	12	0	Organizational Unit Abbreviation for Module
40	CMVISATYPET	☐	PIQVISATYPET	TEXT40	CHAR	40	0	Visa/Registration Type Description
41	CMSTCAMPUST	☐	CMAC_CAMPUS_T	TEXT12	CHAR	12	0	Campus Name
42	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CMAC_ST_ALL	CMBENCAT	T7PIQBENCAT	BENCAT		1	CN
2	CMAC_ST_ALL	CMDOCCURR	TCURC	WAERS
3	CMAC_ST_ALL	CMLOCCURR	TCURC	WAERS
4	CMAC_ST_ALL	CMNATIO	T005	LAND1	REF	1	CN
5	CMAC_ST_ALL	CMPDISCT1	T7PIQPDISCT1	PDISCT1		1	CN
6	CMAC_ST_ALL	CMPDISCT2	T7PIQPDISCT2	PDISCT2		1	CN
7	CMAC_ST_ALL	CMPDISCT3	T7PIQPDISCT3	PDISCT3		1	CN
8	CMAC_ST_ALL	CMPDISCT4	T7PIQPDISCT4	PDISCT4		1	CN
9	CMAC_ST_ALL	CMPDISCT5	T7PIQPDISCT5	PDISCT5		1	CN
10	CMAC_ST_ALL	CMPDISCT6	T7PIQPDISCT6	PDISCT6		1	CN
11	CMAC_ST_ALL	CMSTCAT	T7PIQSTFEECAT	STFEECAT		1	CN
12	CMAC_ST_ALL	CMSTGRP	T7PIQSTGRP	STGRP		1	CN
13	CMAC_ST_ALL	CMSTID	PLOGI	OBJID
14	CMAC_ST_ALL	CMSTORG	PLOGI	OBJID
15	CMAC_ST_ALL	CMVISATYPE	T7PIQVISATYPE	VISATYPE		1	CN

History

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