SAP ABAP Table CMACDB_FEESM (Fee Calculation Document Items (Module))
Hierarchy
☛
IS-PS-CA (Software Component) IS-PUBLIC SECTOR CONTRACT ACCOUNTING
⤷ IS-HER-CM-AC (Application Component) Student Accounting
⤷ CMAC_D (Package) Campus Management: Student Account
⤷ IS-HER-CM-AC (Application Component) Student Accounting
⤷ CMAC_D (Package) Campus Management: Student Account
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | CMACDB_FEESM | Table Relationship Diagram |
Short Description | Fee Calculation Document Items (Module) |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
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 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
2 | DOCNR | CMAC_FEE_DOCNR | CHAR20 | CHAR | 20 | 0 | Number of Fee Calculation Document | ||
3 | ITEMNR | CMAC_ITEM_NBR | NUMC4 | NUMC | 4 | 0 | Item Number | ||
4 | .INCLUDE | 0 | 0 | Modules information | |||||
5 | CMSMID | PIQ_SM_OBJID | HROBJID | NUMC | 8 | 0 | Module Object ID | PLOGI | |
6 | CMSMNAME | CMAC_SM_NAME | TEXT12 | CHAR | 12 | 0 | Module (Abbreviation) | ||
7 | CMPERYR | PIQPERYR | PIQPERYR | NUMC | 4 | 0 | Academic Year | * | |
8 | CMPERID | PIQPERID | PIQPERID | NUMC | 3 | 0 | Academic Session | * | |
9 | .INCLUDE | 0 | 0 | Modules information | |||||
10 | CMSMCAT | PIQSMFEECAT | PIQSMFEECAT | CHAR | 4 | 0 | Module Fee Category | * | |
11 | CMLEVCAT | PIQLEVYFEECAT | PIQLEVYFEECAT | CHAR | 4 | 0 | Special Fee Category for Module | * | |
12 | CMCRHRS | PIQCPOPT | PIQCP | QUAN | 10 | 5 | Optimum Credit Value | ||
13 | CMCPUNIT | PIQCPUNIT | MEINS | UNIT | 3 | 0 | Unit of Measurement for Credits | * | |
14 | CMOUTPROG | PIQSC_VS_D | FLAG | CHAR | 1 | 0 | Module Excluded from Program of Study | ||
15 | CMSMSTATS | PIQSMSTATUS | PIQSMSTATUS | NUMC | 2 | 0 | Module Booking Status | * | |
16 | CMSMREGDAT | PIQDATE | DATUM | DATS | 8 | 0 | Booking Date | ||
17 | CMSMREGREA | PIQBOOKREASON | PIQBOOKREASON | CHAR | 4 | 0 | Module Booking Reason | * | |
18 | CMSMCAID | PIQCAOBJID | HROBJID | NUMC | 8 | 0 | Academic Calendar Object ID | * | |
19 | CMSMREGP1 | CMAC_SM_REG_PER1 | PIQTIMELIMIT | CHAR | 4 | 0 | First Booking Period for Module | * | |
20 | CMSMREGP2 | CMAC_SM_REG_PER2 | PIQTIMELIMIT | CHAR | 4 | 0 | Second Booking Period for Module | * | |
21 | CMSMWDDATE | PIQSTORDATE | PIQSTORDATE | DATS | 8 | 0 | Cancellation Date | ||
22 | CMSMWDREA | PIQSTORREASON | PIQSTORREASON | CHAR | 4 | 0 | Cancellation Reason | * | |
23 | CMSMDREGP1 | CMAC_SM_DREG_PER1 | PIQTIMELIMIT | CHAR | 4 | 0 | First Cancellation Period for Module | * | |
24 | CMSMDREGP2 | CMAC_SM_DREG_PER2 | PIQTIMELIMIT | CHAR | 4 | 0 | Second Cancellation Period for Module | * | |
25 | CMSMCPTEMP | PIQCPATTEMP | PIQCP | QUAN | 10 | 5 | Attempted Credits | ||
26 | CMSMCPUNIT | PIQCPUNIT | MEINS | UNIT | 3 | 0 | Unit of Measurement for Credits | * | |
27 | CMSMEXMPT | PIQCHARGE | PIQCHARGE | CHAR | 1 | 0 | Free of Charge | ||
28 | CMSMTRANSF | PIQTRANSFER | PIQTRANSFER | CHAR | 1 | 0 | External Academic Work or Qualification Transferred | ||
29 | CMSMRATING | PIQSMRATING | PIQSMRATING | CHAR | 3 | 0 | Alternative Assessment Method for Module | * | |
30 | CMSMSCALID | PIQSCALE_ID | PIQSCALE_ID | CHAR | 4 | 0 | Academic Scale Identification (ID) | * | |
31 | CMSMVALUE | PIQSMFEEVAL | PIQCP | QUAN | 10 | 5 | Module Value for Module Fee Calculation | ||
32 | CMMVUNIT | PIQMVUNIT | MEINS | UNIT | 3 | 0 | Unit for Module Fee Calculation | * | |
33 | CMSMORG | CMAC_SM_ORGUNIT | HROBJID | NUMC | 8 | 0 | Object ID of Organizational Unit for Module | PLOGI | |
34 | CMSMCOCD | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | * | |
35 | CMREFTYPE | PIQREFUNDTYP | PIQREFUNDTYP | CHAR | 4 | 0 | Module Refund Type | * | |
36 | CMSMKEYDAT | PIQKEYDATE | DATUM | DATS | 8 | 0 | Key Date | ||
37 | CMSEOBJID | PIQSEOBJID | HROBJID | NUMC | 8 | 0 | Object ID of Event Package | PLOGI | |
38 | CMSMSECAT1 | PIQSECCAT1 | PIQSECCAT1 | CHAR | 4 | 0 | Event Package Category 1 | * | |
39 | CMSMDDSHED | PIQDDSCHED | PIQDDSCHED | CHAR | 6 | 0 | Due Date Schedule | T7PIQDDSCHED | |
40 | CMSEDDSHED | CMAC_SEDDS | PIQDDSCHED | CHAR | 6 | 0 | Due Date Schedule of Event Package | T7PIQDDSCHED | |
41 | CMSMCAMPUS | CMAC_SMCAMPUS | NUM08 | NUMC | 8 | 0 | Campus for Module | ||
42 | CMSMDELMOD | PIQDELMODE | PIQDELMODE | CHAR | 4 | 0 | Delivery Mode | * | |
43 | CMPROGCVAR | PIQPROGC_VAR | PIQPROGC_VAR | CHAR | 4 | 0 | Program Type | * | |
44 | CMMULTPROGCVAR | PIQMULTPROGCVAR | FLAG | CHAR | 1 | 0 | Multiple Use for Program Types (Fee Calculation) | ||
45 | CMSMWAITLIST | PIQWAITL_WAITL | XFELD | CHAR | 1 | 0 | Indicator: Waiting List Booking | ||
46 | .INCLUDE | 0 | 0 |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | CMACDB_FEESM | CMSEDDSHED | T7PIQDDSCHED | DDSCHED | REF | 1 | CN |
2 | CMACDB_FEESM | CMSEOBJID | PLOGI | OBJID | |||
3 | CMACDB_FEESM | CMSMDDSHED | T7PIQDDSCHED | DDSCHED | REF | 1 | CN |
4 | CMACDB_FEESM | CMSMID | PLOGI | OBJID | |||
5 | CMACDB_FEESM | CMSMORG | PLOGI | OBJID |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 472 |