SAP ABAP Table FMSPLIT_DERIVE (Derivation Structure for Rule-Based Account Distributions)

Hierarchy

☛ EA-PS (Software Component) SAP Enterprise Extension Public Services
   ⤷ PSM-FM (Application Component) Funds Management
     ⤷ FM_SPLIT_E (Package) Automatic FM account assignment splitting tool

Basic Data

Table Category	INTTAB	Structure
Structure	FMSPLIT_DERIVE	Table Relationship Diagram
Short Description	Derivation Structure for Rule-Based Account Distributions

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	☐	ADATU	DATUM	DATS	8	0	Date for beginning of validity
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	USERTEMP1	☐	KEDRTMPVALUE1	KEDRVALUE	CHAR	32	0	Temporary field 1 (user-defined)
52	.INCLUDE	☐				0	0
53	.INCLUDE	☐				0	0
54	CONTRACT_NUMBER	☐	RECNNR	RECNNR	CHAR	13	0	Real Estate Contract Number
55	REVERSEDOC	☐	CO_STFLG	FLAG	CHAR	1	0	Identifier for reversal document
56	ORDER_NUMBER_PM	☐	PMAUFNR	AUFNR	CHAR	12	0	Order Number of a Maintenance Order	*
57	MOVE_TYPE	☐	BWART	BWART	CHAR	3	0	Movement type (inventory management)	T156
58	VAL_CLASS	☐	BKLAS	BKLAS	CHAR	4	0	Valuation Class	T025
59	FLG_INVNTRY_PSTNG	☐	FM_FLG_INVNTRY_PSTNG	FM_FLG_INVNTRY_PSTNG	CHAR	1	0	Indicates that current posting is an inventory posting
60	ASSETTRTYP	☐	BF_ANBWA	CHAR3	CHAR	3	0	Asset transaction type
61	AMOUNT	☐	WRBTR	WERT7	CURR	13	2	Amount in document currency
62	CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
63	VENDOR_OFFSET	☐	FM_OFF_LIFNR	LIFNR	CHAR	10	0	Offsetting vendor	*
64	CUSTOMER_OFFSET	☐	FM_OFF_KUNNR	KUNNR	CHAR	10	0	Offsetting Customer	*
65	FM_SPLIT	☐	FMSP_SPLIT_RESULT_FLAG	FLAG	CHAR	1	0	Line is Result of Account Assignment Distribution
66	SPLIT_RULE	☐	FMSP_RULE_ID	FMSP_RULE_ID	CHAR	12	0	Identifier for Rule-Based Acct Asst Distributions Rule	*
67	QUANTITY	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
68	UNIT	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
69	CATSAPPL	☐	FMSP_CATSAPPL	FMSP_CABAAPPL	CHAR	2	0	Target Component for CATS

Foreign Keys

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

History

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