SAP ABAP Table FMDERIVE (FM Derivation Structure)

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ FI-FM (Application Component) Funds Management
     ⤷ FMFS_CORE (Package) Update Funds Management Core Objects

Basic Data

Table Category	INTTAB	Structure
Structure	FMDERIVE	Table Relationship Diagram
Short Description	FM 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	COMPANY_CODE	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
2	CO_AREA	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
3	FM_AREA	☐	FIKRS	FIKRS	CHAR	4	0	Financial Management Area	FM01
4	ACCOUNT_NUMBER	☐	SAKNR	SAKNR	CHAR	10	0	G/L Account Number	SKA1
5	ASSET	☐	ANLN1	ANLN1	CHAR	12	0	Main Asset Number	ANLA
6	SUB_ASSET	☐	ANLN2	ANLN2	CHAR	4	0	Asset Subnumber	ANLA
7	COST_ELEMENT	☐	KSTAR	KSTAR	CHAR	10	0	Cost Element	CSKA
8	COST_CENTER	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
9	ORDER_NUMBER	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
10	WBS_ELEMENT	☐	PS_POSID	PS_POSID	CHAR	24	0	Work Breakdown Structure Element (WBS Element)
11	PROFIT_CENTER	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
12	BUSINESS_ENTITY	☐	SWENR	SWENR	CHAR	8	0	Business Entity Number	VIOB01
13	PROPERTY_NUMBER	☐	SGRNR	SGRNR	CHAR	8	0	Land Number for BE	VIOB02
14	BUILDING_NUMBER	☐	SGENR	SGENR	CHAR	8	0	Building Number	VIOB03
15	RENTAL_UNIT	☐	SMENR	SMENR	CHAR	8	0	Number of Rental Unit	*
16	LEASE_NUMBER	☐	SMIVE	VVSMIVE	CHAR	13	0	Lease-Out Number
17	SETTLEMENT_UNIT	☐	SEMPSL	SEMPSL	CHAR	5	0	Settlement Unit	*
18	COMMIT_ITEM	☐	FM_FIPEX	FM_FIPEX	CHAR	24	0	Commitment item	*
19	FUND_CENTER	☐	FISTL	FISTL	CHAR	16	0	Funds Center	*
20	FUND	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	*
21	FUND_TYP	☐	FM_FUNDTYPE	FM_FUNDTYPE	CHAR	6	0	FM Fund Type	FMFUNDTYPE
22	FUNCTION_AREA	☐	FKBER	FKBER	CHAR	16	0	Functional Area	*
23	POSTING_DATE	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
24	ORDER_NUMBER_NP	☐	NPLNR	AUFNR	CHAR	12	0	Network Number for Account Assignment	*
25	ORDER_NUMBER_NV	☐	CO_AUFPL	AUFPL	NUMC	10	0	Routing number of operations in the order	AFVC
26	ORDER_POSNR_NV	☐	CO_APLZL	CO_APLZL	NUMC	8	0	General counter for order	AFVC
27	ORDER_NUMBER_SD	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	VBUK
28	ORDER_POSNR_SD	☐	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item	VBUP
29	DR_CR_IND	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
30	TRANSAC	☐	J_VORGANG	J_VORGANG	CHAR	4	0	Business Transaction	TJ01
31	TRANSAC_TYPE	☐	RMVCT	RMVCT	CHAR	3	0	Transaction type	*
32	FIVOR	☐	FIVOR	FIVOR	NUMC	2	0	Financial transaction
33	PARTNER_FUND	☐	FM_PFUND	BP_GEBER	CHAR	10	0	Partner Fund	*
34	PARTNER_FUND_TYP	☐	FM_FUNDTYPE	FM_FUNDTYPE	CHAR	6	0	FM Fund Type	FMFUNDTYPE
35	FLG_CO_RECON	☐	FM_FLG_AO	XFELD	CHAR	1	0	CO reconciliation object
36	DISTR_CHAN	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
37	SALESORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
38	DIVISION	☐	SPART	SPART	CHAR	2	0	Division	*
39	PLANT	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
40	MATERIAL_NUMBER	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
41	BUS_AREA	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
42	CO_BUSPROC	☐	CO_PRZNR	CO_PRZNR	CHAR	12	0	Business Process	CBPR
43	COSTOBJECT	☐	KSTRG	KSTRG	CHAR	12	0	Cost Object	CKPH
44	VAL_TYPE	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	T149D
45	VAL_AREA	☐	BWKEY	BWKEY	CHAR	4	0	Valuation area	T001K
46	SPEC_STOCK	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	T148
47	TR_PART_BA	☐	PARGB	GSBER	CHAR	4	0	Trading partner's business area	TGSB
48	PART_PRCTR	☐	PPRCTR	PRCTR	CHAR	10	0	Partner Profit Center	CEPC
49	GRANT_NBR	☐	GM_GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	Grant
50	MEASURE	☐	FM_MEASURE	FM_MEASURE	CHAR	24	0	Funded Program	*
51	EE_GROUPING_FOR_FIXED_ACCT	☐	EG_ACCT_ASSGMT_FIX_FMGM	CHAR03	CHAR	3	0	Employee Grouping Fixed Account Assignment FM/GM
52	FLG_FUND_NOT_VALID	☐	FM_FLG_FUND_NOT_VALID	XFELD	CHAR	1	0	Fund for Posting Date Not Valid
53	FLG_FUND_CENTER_NOT_VALID	☐	FM_FLG_FUND_CENTER_NOT_VALID	XFELD	CHAR	1	0	Funds Center for Posting Date Not Valid
54	FLG_FUNCTION_NOT_VALID	☐	FM_FLG_FUNCTION_NOT_VALID	XFELD	CHAR	1	0	Functional Area Not Valid for Key Date
55	USERTEMP1	☐	KEDRTMPVALUE1	KEDRVALUE	CHAR	32	0	Temporary field 1 (user-defined)
56	BUS_TRANS_CAT	☐	TCR_BUSTRANSCAT	TCR_BUSTRANSCAT	NUMC	4	0	Business Transaction Category
57	DIST_FLOWTYPE	☐	TCR_DIS_FLOWTYPE	TCR_DIS_FLOWTYPE	CHAR	8	0	Update Type
58	PRODUCT_TYPE	☐	VVSART	VVSART	CHAR	3	0	Product Type	*
59	PORTFOLIO	☐	RPORTB	RPORTB	CHAR	10	0	Portfolio	*
60	DOCUMENT_DATE	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
61	.INCLUDE	☐				0	0
62	.INCLUDE	☐				0	0	Additional Fields for FM Derivation in FI-CA
63	.INCLU--AP	☐				0	0	Enhancement of FMDERIVE in the Enterprise Extension
64	CONTRACT_NUMBER	☐	RECNNR	RECNNR	CHAR	13	0	Real Estate Contract Number
65	REVERSEDOC	☐	CO_STFLG	FLAG	CHAR	1	0	Identifier for reversal document
66	ORDER_NUMBER_PM	☐	PMAUFNR	AUFNR	CHAR	12	0	Order Number of a Maintenance Order	*
67	MOVE_TYPE	☐	BWART	BWART	CHAR	3	0	Movement type (inventory management)	T156
68	VAL_CLASS	☐	BKLAS	BKLAS	CHAR	4	0	Valuation Class	T025
69	FLG_INVNTRY_PSTNG	☐	FM_FLG_INVNTRY_PSTNG	FM_FLG_INVNTRY_PSTNG	CHAR	1	0	Indicates that current posting is an inventory posting
70	ASSETTRTYP	☐	BWASL	BWASL	CHAR	3	0	Asset Transaction Type	TABW
71	DOC_TYPE	☐	FM_DOCUMENT_TYPE	FM_DOCUMENT_TYPE	CHAR	2	0	Document Type
72	FM_SPLIT	☐	FMSP_SPLIT_RESULT_FLAG	FLAG	CHAR	1	0	Line is Result of Account Assignment Distribution
73	SERVICE_CHARGE_KEY	☐	SNKSL	SNKSL	CHAR	4	0	Service Charge Key	*
74	.INCLU--AP	☐				0	0	Additional fields for FMDERIVE Master Data Read Functions
75	FLG_MEASURE_NOT_VALID	☐	FM_FLG_MEASURE_NOT_VALID	XFELD	CHAR	1	0	Funded Program for Posting Date Not Valid
76	FLG_COMMIT_ITEM_NOT_VALID	☐	FM_FLG_COMMIT_ITEM_NOT_VALID	XFELD	CHAR	1	0	Commitment Item for Posting date Not Valid
77	FLG_GRANT_NOT_VALID	☐	FM_FLG_GRANT_NOT_VALID	XFELD	CHAR	1	0	Grant for Posting Date Not valid
78	.INCLU--AP	☐				0	0	Additional Temporary Fields for FMDERIVE
79	USERTEMP2	☐	KEDRTMPVALUE2	KEDRVALUE	CHAR	32	0	Temporary field 2 (user-defined)
80	USERTEMP3	☐	KEDRTMPVALUE3	KEDRVALUE	CHAR	32	0	Temporary field 3 (user-defined)
81	USERTEMP4	☐	KEDRTMPVALUE4	KEDRVALUE	CHAR	32	0	Temporary field 4 (user-defined)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FMDERIVE	ACCOUNT_NUMBER	SKA1	SAKNR
2	FMDERIVE	ASSET	ANLA	ANLN1
3	FMDERIVE	ASSETTRTYP	TABW	BWASL
4	FMDERIVE	BUILDING_NUMBER	VIOB03	SGENR
5	FMDERIVE	BUSINESS_ENTITY	VIOB01	SWENR
6	FMDERIVE	BUS_AREA	TGSB	GSBER
7	FMDERIVE	COSTOBJECT	CKPH	KSTRG
8	FMDERIVE	COST_ELEMENT	CSKA	KSTAR
9	FMDERIVE	CO_AREA	TKA01	KOKRS
10	FMDERIVE	CO_BUSPROC	CBPR	PRZNR
11	FMDERIVE	FM_AREA	FM01	FIKRS
12	FMDERIVE	FUND_TYP	FMFUNDTYPE	FUND_TYPE
13	FMDERIVE	MOVE_TYPE	T156	BWART
14	FMDERIVE	ORDER_NUMBER	AUFK	AUFNR
15	FMDERIVE	ORDER_NUMBER_NV	AFVC	AUFPL
16	FMDERIVE	ORDER_NUMBER_SD	VBUK	VBELN
17	FMDERIVE	ORDER_POSNR_NV	AFVC	APLZL
18	FMDERIVE	ORDER_POSNR_SD	VBUP	POSNR
19	FMDERIVE	PARTNER_FUND_TYP	FMFUNDTYPE	FUND_TYPE
20	FMDERIVE	PART_PRCTR	CEPC	PRCTR
21	FMDERIVE	PROPERTY_NUMBER	VIOB02	SGRNR
22	FMDERIVE	SPEC_STOCK	T148	SOBKZ
23	FMDERIVE	SUB_ASSET	ANLA	ANLN2
24	FMDERIVE	TRANSAC	TJ01	VRGNG
25	FMDERIVE	TR_PART_BA	TGSB	GSBER
26	FMDERIVE	VAL_AREA	T001K	BWKEY
27	FMDERIVE	VAL_CLASS	T025	BKLAS
28	FMDERIVE	VAL_TYPE	T149D	BWTAR

History

Last changed by/on	SAP	20130529
SAP Release Created in	46C