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
⤷ 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 |