SAP ABAP Table GMDERIVE (Grants Management Derivation Structure)

Hierarchy

☛ EA-PS (Software Component) SAP Enterprise Extension Public Services
   ⤷ PSM-GM-GTE-MD (Application Component) Master Data
     ⤷ GMMASTERDATA_E (Package) Grants management (master data)

Basic Data

Table Category	INTTAB	Structure
Structure	GMDERIVE	Table Relationship Diagram
Short Description	Grants Management Derivation Structure

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	ADATU	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
2	DOC_TYPE	☐	BLART	BLART	CHAR	2	0	Document type	T003
3	COMP_CODE	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
4	BUS_AREA	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
5	CO_AREA	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
6	FM_AREA	☐	FIKRS	FIKRS	CHAR	4	0	Financial Management Area	FM01
7	DISTR_CHAN	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
8	SALESORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
9	DIVISION	☐	SPART	SPART	CHAR	2	0	Division	*
10	PLANT	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
11	ASSET_NO	☐	ANLN1	ANLN1	CHAR	12	0	Main Asset Number	ANLH
12	SUB_NUMBER	☐	ANLN2	ANLN2	CHAR	4	0	Asset Subnumber	ANLA
13	GL_ACCOUNT	☐	SAKNR	SAKNR	CHAR	10	0	G/L Account Number	SKA1
14	COST_ELEM	☐	KSTAR	KSTAR	CHAR	10	0	Cost Element	CSKA
15	COSTCENTER	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
16	PROFIT_CTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
17	ORDERID	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
18	NETWORK	☐	NPLNR	AUFNR	CHAR	12	0	Network Number for Account Assignment	*
19	ROUTING_NO	☐	CO_AUFPL	AUFPL	NUMC	10	0	Routing number of operations in the order	AFVC
20	COUNTER	☐	CO_APLZL	CO_APLZL	NUMC	8	0	General counter for order	AFVC
21	SD_DOC	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	VBUK
22	ITM_NUMBER	☐	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item	VBUP
23	WBS_ELEMENT	☐	PS_POSID	PS_POSID	CHAR	24	0	Work Breakdown Structure Element (WBS Element)
24	CMMT_ITEM	☐	FM_FIPEX	FM_FIPEX	CHAR	24	0	Commitment item	*
25	FUNDS_CTR	☐	FISTL	FISTL	CHAR	16	0	Funds Center	*
26	FUND	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	*
27	FUNC_AREA	☐	FKBER	FKBER	CHAR	16	0	Functional Area	*
28	MEASURE	☐	FM_MEASURE	FM_MEASURE	CHAR	24	0	Funded Program	*
29	BUSINESS_ENTITY	☐	SWENR	SWENR	CHAR	8	0	Business Entity Number	VIOB01
30	PROPERTY	☐	SGRNR	SGRNR	CHAR	8	0	Land Number for BE	VIOB02
31	BUILDING	☐	SGENR	SGENR	CHAR	8	0	Building Number	VIOB03
32	RENTAL_UNIT	☐	SMENR	SMENR	CHAR	8	0	Number of Rental Unit	*
33	RENTAL_AGREEMENT	☐	SMIVE	VVSMIVE	CHAR	13	0	Lease-Out Number
34	SETTLEMENT_UNIT	☐	SEMPSL	SEMPSL	CHAR	5	0	Settlement Unit	*
35	TRANS	☐	J_VORGANG	J_VORGANG	CHAR	4	0	Business Transaction	TJ01
36	CS_TRANS_T	☐	RMVCT	RMVCT	CHAR	3	0	Transaction type	*
37	MATERIAL	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
38	GRANT_NBR	☐	GM_GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	Grant
39	GRANT_TYPE	☐	GM_GRANT_TYPE	GM_GRANT_TYPE	CHAR	2	0	Grant Type	*
40	PARTNER	☐	GM_SPONSOR	BU_PARTNER	CHAR	10	0	Grant Sponsor	BUT000
41	SPONSORED_PROG	☐	GM_SPONSORED_PROG	GM_SPONSORED_PROG	CHAR	20	0	Sponsored Program	*
42	SPONSORED_CLASS	☐	GM_SPONSORED_CLASS	GM_SPONSORED_CLASS	CHAR	20	0	Sponsored Class	*
43	REVERSEDOC	☐	CO_STFLG	FLAG	CHAR	1	0	Identifier for reversal document
44	USERTEMP1	☐	KEDRTMPVALUE1	KEDRVALUE	CHAR	32	0	Temporary field 1 (user-defined)
45	FM_SPLIT	☐	FMSP_SPLIT_RESULT_FLAG	FLAG	CHAR	1	0	Line is Result of Account Assignment Distribution
46	.INCLUDE	☐				0	0
47	STATKEYFIG	☐	STAGR	STAGR	CHAR	6	0	Statistical key figure	TKA03

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	GMDERIVE	ASSET_NO	ANLH	ANLN1
2	GMDERIVE	BUILDING	VIOB03	SGENR
3	GMDERIVE	BUSINESS_ENTITY	VIOB01	SWENR
4	GMDERIVE	COST_ELEM	CSKA	KSTAR
5	GMDERIVE	COUNTER	AFVC	APLZL
6	GMDERIVE	CO_AREA	TKA01	KOKRS
7	GMDERIVE	DOC_TYPE	T003	BLART
8	GMDERIVE	FM_AREA	FM01	FIKRS
9	GMDERIVE	GL_ACCOUNT	SKA1	SAKNR
10	GMDERIVE	ITM_NUMBER	VBUP	POSNR
11	GMDERIVE	MATERIAL	MARA	MATNR
12	GMDERIVE	PARTNER	BUT000	PARTNER
13	GMDERIVE	PROPERTY	VIOB02	SGRNR
14	GMDERIVE	ROUTING_NO	AFVC	AUFPL
15	GMDERIVE	SD_DOC	VBUK	VBELN
16	GMDERIVE	STATKEYFIG	TKA03	STAGR
17	GMDERIVE	SUB_NUMBER	ANLA	ANLN2
18	GMDERIVE	TRANS	TJ01	VRGNG

History

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