SAP ABAP Table V_TCMAC_ST (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_TCMAC_ST	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	PLOGI
3	CMPERSL	☑	PERSL_KK	PERSL_KK	CHAR	4	0	Key for Period Assignment	TFK001P
4	CMSTNUM	☐	CMAC_ST_NUMBER	TEXT12	CHAR	12	0	Student Number
5	CMSTCAT	☐	PIQSTFEECAT	PIQSTFEECAT	CHAR	4	0	Student Fee Category	T7PIQSTFEECAT
6	CMBENCAT	☐	PIQBENCAT	PIQBENCAT	CHAR	4	0	Benefit Category	T7PIQBENCAT
7	CMPREVHE	☐	PIQPREVHE	XFELD	CHAR	1	0	Indicator: Student Has Attended Other University
8	CMSTGRP	☐	PIQSTGRP	PIQSTGRP	CHAR	4	0	Student Group	T7PIQSTGRP
9	CMPDISCT1	☐	PIQPDISCT1	PIQPDISCT1	CHAR	4	0	Discount/Surcharge Category 1	T7PIQPDISCT1
10	CMPDISCT2	☐	PIQPDISCT2	PIQPDISCT2	CHAR	4	0	Discount/Surcharge Category 2	T7PIQPDISCT2
11	CMPDISCT3	☐	PIQPDISCT3	PIQPDISCT3	CHAR	4	0	Discount/Surcharge Category 3	T7PIQPDISCT3
12	CMPDISCT4	☐	PIQPDISCT4	PIQPDISCT4	CHAR	4	0	Discount/Surcharge Category 4	T7PIQPDISCT4
13	CMPDISCT5	☐	PIQPDISCT5	PIQPDISCT5	CHAR	4	0	Discount/Surcharge Category 5	T7PIQPDISCT5
14	CMPDISCT6	☐	PIQPDISCT6	PIQPDISCT6	CHAR	4	0	Discount/Surcharge Category 6	T7PIQPDISCT6
15	CMNATIO	☐	PIQNATSL	LAND1	CHAR	3	0	Nationality (Citizenship)	T005
16	CMLOCCURR	☐	CMAC_LOCCURR	WAERS	CUKY	5	0	Local Currency	TCURC
17	CMDOCCURR	☐	CMAC_DOCCURR	WAERS	CUKY	5	0	Document Currency	TCURC
18	CMCOMPCODE	☐	STDBK_KK	BUKRS	CHAR	4	0	Standard Company Code
19	CMSTCAMPUS	☐	CMAC_STCAMPUS	NUM08	NUMC	8	0	Campus of Student
20	CMSTORG	☐	CMAC_ST_ORGUNIT	HROBJID	NUMC	8	0	Object ID of Student's Organizational Unit	PLOGI
21	CMSTSTATUS	☐	PIQ_ST_STATUS	PIQ_ST_STATUS	CHAR	1	0	Student Fee Calculation Status
22	CMVISATYPE	☐	PIQVISATYPE	PIQVISATYPE	CHAR	4	0	Visa/Registration Type	T7PIQVISATYPE
23	CMSTKEYDAT	☐	PIQKEYDATE	DATUM	DATS	8	0	Key Date

Foreign Keys

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

History

Last changed by/on	SAP	20110901
SAP Release Created in