SAP ABAP Table CMACGRANT (Grant Master Data)

Hierarchy

☛ IS-PS-CA (Software Component) IS-PUBLIC SECTOR CONTRACT ACCOUNTING
   ⤷ IS-HER-CM-AC (Application Component) Student Accounting
     ⤷ CMACGM_D (Package) Campus Management: Grant Master und Grant Evaluation

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	CMACGRANT	Table Relationship Diagram
Short Description	Grant Master Data

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	GRANT_NBR	☑	PSGRANT_PS	PSGRANT_PS	CHAR	20	0	Grant
3	GRANT_TYPE	☐	CMAC_AID_TYPE	CMAC_AID_TYPE	CHAR	2	0	Grant Type	TCMAC05A
4	SPPAT	☐	CMAC_SPPAT	CMAC_SPPAT	CHAR	4	0	Grant Appropriation	TCMACSPPAT
5	PERS_REL	☐	CMAC_PERS_REL	FLAG	CHAR	1	0	Person-Related Grant
6	SPONSOR	☐	PIQNUSED_TEXT40	TEXT40	CHAR	40	0	Unused Field: 40 Chars in Length
7	SPONSOR_CA	☐	CMAC_SPONSOR_CA	VKONT_KK	CHAR	12	0	Sponsor's Contract Account Number	FKKVK
8	GR_CURR	☐	CMAC_GR_CURRENCY	WAERS	CUKY	5	0	Grant Currency	TCURC
9	STSMA	☐	CMAC_STSMA	CMAC_STSMA	CHAR	8	0	Grants Management System	TCMAC05S
10	DEF_COGRP	☐	CMAC_DEF_COGRP	CMAC_COOBGRP	CHAR	6	0	Default Contract Object Type Grouping	TCMACCOTYGRP
11	PAY_MIN	☐	CMAC_PAY_MIN	WRTV7	CURR	13	2	Minimum Disbursement Amount for Grant
12	REPAY_EXCL	☐	CMAC_REPAY_EXCL	FLAG	CHAR	1	0	Non-Repayable Grant
13	REPAY_MIN	☐	CMAC_REPAY_MIN	WRTV7	CURR	13	2	Minimum Repayment Amount per Academic Session
14	REPAY_PRIO	☐	CMAC_REPAY_PRIO	NUM03	NUMC	3	0	Repayment Priority
15	FIKRS	☐	FIKRS	FIKRS	CHAR	4	0	Financial Management Area	FM01
16	FISTL	☐	FISTL	FISTL	CHAR	16	0	Funds Center	FMFCTR
17	FONDS	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	FMFINCODE
18	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
19	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
20	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
21	POSNR	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	PRPS
22	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	CEPC
23	FKBER	☐	FKBER	FKBER	CHAR	16	0	Functional Area	TFKB
24	GM_GRANT_NBR	☐	GM_GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	Grant	GMGR
25	SEGMENT	☐	FB_SEGMENT	FB_SEGMENT	CHAR	10	0	Segment for Segmental Reporting	FAGL_SEGM
26	GRANT_LOCK	☐	CMACGRANT_LOCK	FLAG	CHAR	1	0	Grant Locked

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CMACGRANT	AUFNR	AUFK	AUFNR	REF	C	CN
2	CMACGRANT	DEF_COGRP	TCMACCOTYGRP	COOBGRP	REF	1	CN
3	CMACGRANT	FIKRS	FM01	FIKRS	REF	1	CN
4	CMACGRANT	FISTL	FMFCTR	FICTR	REF	1	CN
5	CMACGRANT	FKBER	TFKB	FKBER	REF	C	CN
6	CMACGRANT	FONDS	FMFINCODE	FINCODE	REF	1	CN
7	CMACGRANT	GM_GRANT_NBR	GMGR	GRANT_NBR	REF	1	CN
8	CMACGRANT	GRANT_TYPE	TCMAC05A	AIDTYPE	REF	1	CN
9	CMACGRANT	GR_CURR	TCURC	WAERS	REF	1	CN
10	CMACGRANT	GSBER	TGSB	GSBER	REF	C	CN
11	CMACGRANT	KOSTL	CSKS	KOSTL	REF	C	CN
12	CMACGRANT	MANDT	T000	MANDT	KEY	1	CN
13	CMACGRANT	POSNR	PRPS	PSPNR	REF	C	CN
14	CMACGRANT	PRCTR	CEPC	PRCTR	REF	C	CN
15	CMACGRANT	SEGMENT	FAGL_SEGM	SEGMENT	REF	1	CN
16	CMACGRANT	SPONSOR_CA	FKKVK	VKONT	REF	1	CN
17	CMACGRANT	SPPAT	TCMACSPPAT	SPPAT	REF	1	CN
18	CMACGRANT	STSMA	TCMAC05S	STSMA	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	463