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 |