SAP FMSP_RULE_RESULT One split result from Rule-Based Account Distribution Table data and field list

FMSP_RULE_RESULT is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "One split result from Rule-Based Account Distribution" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_FMSP_RULE_RESULT TYPE FMSP_RULE_RESULT.

The FMSP_RULE_RESULT table consists of various fields, each holding specific information or linking keys about One split result from Rule-Based Account Distribution data available in SAP. These include DIST_PERCENT (Distribution percentage for Rule-Based Acct Asst Distbtn), DIST_BEGRU (Authorization group for PSM account assignment distribution), DIST_CURRENCY (Currency Key), DIST_AMOUNT (Distribution amount factor for Rule-Based Acct Acct Distbtn)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

FMSP_RULE_RESULT structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)

SAP FMSP_RULE_RESULT structure fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the FMSP_RULE_RESULT table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.

Field	Description	Data Element	Data Type	length (Dec)	Check table	Conversion Routine	Domain Name	MemoryID	SHLP
SEQUENCE_NBR	Sequence number for Rule-Based Acct Asst Distributions	FMSP_SEQUENCE_NBR	NUMC	2			NUMC2
DIST_PERCENT	Distribution percentage for Rule-Based Acct Asst Distbtn	FMSP_DIST_PERCENT	DEC	8(5)			FMSP_PERCENT
DIST_BEGRU	Authorization group for PSM account assignment distribution	FMSP_SPLIT_AUTG	CHAR	4	Assigned to domain		FMSP_SPLIT_AUTG
DIST_CURRENCY	Currency Key	WAERS	CUKY	5	Assigned to domain		WAERS	FWS
DIST_AMOUNT	Distribution amount factor for Rule-Based Acct Acct Distbtn	FMSP_DIST_AMOUNT	CURR	13(2)			WERT7
DIST_QUANTITY	Quantity	MENGE_D	QUAN	13(3)			MENG13
DIST_UNIT	Base Unit of Measure	MEINS	UNIT	3	Assigned to domain	CUNIT	MEINS
FINAL_SPLIT	Indicator: no further assignment distn to be performed	FMSP_FINAL_SPLIT	CHAR	1			XFELD
AA				0
COMPANY_CODE	Company Code	BUKRS	CHAR	4			BUKRS	BUK	C_T001
CO_AREA	Controlling Area	KOKRS	CHAR	4			CACCD	CAC
FM_AREA	Financial Management Area	FIKRS	CHAR	4			FIKRS	FIK
ACCOUNT_NUMBER	G/L Account Number	SAKNR	CHAR	10		ALPHA	SAKNR	SAK	C_SAKNR
ASSET	Main Asset Number	ANLN1	CHAR	12		ALPHA	ANLN1	AN1
SUB_ASSET	Asset Subnumber	ANLN2	CHAR	4		ALPHA	ANLN2	AN2
COST_ELEMENT	Cost Element	KSTAR	CHAR	10		ALPHA	KSTAR	KAT
COST_CENTER	Cost Center	KOSTL	CHAR	10		ALPHA	KOSTL	KOS
ORDER_NUMBER	Order Number	AUFNR	CHAR	12		ALPHA	AUFNR	ANR
WBS_ELEMENT	Work Breakdown Structure Element (WBS Element)	PS_POSID	CHAR	24		PROJN	PS_POSID	PRO
PROFIT_CENTER	Profit Center	PRCTR	CHAR	10		ALPHA	PRCTR	PRC	PRCTR_EMPTY
BUSINESS_ENTITY	Site Number	SWENR	CHAR	8		SWENR	SWENR	WEH	MCWE
PROPERTY_NUMBER	Property Number for BE	SGRNR	CHAR	8		SGRNR	SGRNR	GRS	MCGR
BUILDING_NUMBER	Building Number	SGENR	CHAR	8		SGENR	SGENR	GEB	MCGE
RENTAL_UNIT	Number of Rental Unit	SMENR	CHAR	8		SMENR	SMENR	MEH	MCME
LEASE_NUMBER	Lease-Out Number	SMIVE	CHAR	13		ALPHA	VVSMIVE	MIV	MRTA
SETTLEMENT_UNIT	Settlement Unit	SEMPSL	CHAR	5		ALPHA	SEMPSL	EMP	MCEM
COMMIT_ITEM	Commitment Item	FM_FIPEX	CHAR	24			FM_FIPEX	FPS
FUND_CENTER	Funds Center	FISTL	CHAR	16			FISTL	FIS
FUND	Fund	BP_GEBER	CHAR	10			BP_GEBER	FIC
FUND_TYP	FM Fund Type	FM_FUNDTYPE	CHAR	6			FM_FUNDTYPE
FUNCTION_AREA	Functional Area	FKBER	CHAR	16			FKBER	FBE
POSTING_DATE	Date for beginning of validity	ADATU	DATS	8			DATUM	ADT
ORDER_NUMBER_NP	Network Number for Account Assignment	NPLNR	CHAR	12		ALPHA	AUFNR	NET
ORDER_NUMBER_NV	Routing number of operations in the order	CO_AUFPL	NUMC	10			AUFPL
ORDER_POSNR_NV	General counter for order	CO_APLZL	NUMC	8			CO_APLZL
ORDER_NUMBER_SD	Sales and Distribution Document Number	VBELN	CHAR	10		ALPHA	VBELN	AUN
ORDER_POSNR_SD	Sales Document Item	POSNR_VA	NUMC	6			POSNR	APO
DR_CR_IND	Debit/Credit Indicator	SHKZG	CHAR	1			SHKZG
TRANSAC	Business Transaction	J_VORGANG	CHAR	4			J_VORGANG
TRANSAC_TYPE	Transaction Type	RMVCT	CHAR	3			RMVCT
FIVOR	Financial transaction	FIVOR	NUMC	2			FIVOR
PARTNER_FUND	Partner Fund	FM_PFUND	CHAR	10			BP_GEBER	PARTNER_FUND
PARTNER_FUND_TYP	FM Fund Type	FM_FUNDTYPE	CHAR	6			FM_FUNDTYPE
FLG_CO_RECON	CO reconciliation object	FM_FLG_AO	CHAR	1			XFELD
DISTR_CHAN	Distribution Channel	VTWEG	CHAR	2			VTWEG	VTW	C_VTWEG
SALESORG	Sales Organization	VKORG	CHAR	4			VKORG	VKO	C_VKORG
DIVISION	Division	SPART	CHAR	2			SPART	SPA	C_SPART
PLANT	Plant	WERKS_D	CHAR	4			WERKS	WRK	H_T001W_C
MATERIAL_NUMBER	Material Number	MATNR	CHAR	18		MATN1	MATNR	MAT	S_MAT1
BUS_AREA	Business Area	GSBER	CHAR	4			GSBER	GSB
CO_BUSPROC	Business Process	CO_PRZNR	CHAR	12		ALPHA	CO_PRZNR	KWP
COSTOBJECT	Cost Object	KSTRG	CHAR	12			KSTRG	KTR
VAL_TYPE	Valuation Type	BWTAR_D	CHAR	10			BWTAR	BWT
VAL_AREA	Valuation Area	BWKEY	CHAR	4			BWKEY	BWK
SPEC_STOCK	Special Stock Indicator	SOBKZ	CHAR	1			SOBKZ
TR_PART_BA	Trading partner's business area	PARGB	CHAR	4			GSBER	GSB
PART_PRCTR	Partner Profit Center	PPRCTR	CHAR	10		ALPHA	PRCTR	PPC
GRANT_NBR	Grant	GM_GRANT_NBR	CHAR	20		ALPHA	GM_GRANT_NBR	GM_GRANT_NBR	GRANTS_GENERIC
MEASURE	Funded Program	FM_MEASURE	CHAR	24			FM_MEASURE	FM_MEASURE
USERTEMP1	Temporary field 1 (user-defined)	KEDRTMPVALUE1	CHAR	32			KEDRVALUE
CONTRACT_NUMBER	Real Estate Contract Number	RECNNR	CHAR	13		ALPHA	RECNNR	RECNNR
REVERSEDOC	Identifier for reversal document	CO_STFLG	CHAR	1			FLAG
ORDER_NUMBER_PM	Order Number of a Maintenance Order	PMAUFNR	CHAR	12		ALPHA	AUFNR
MOVE_TYPE	Movement Type (Inventory Management)	BWART	CHAR	3			BWART	BWA
VAL_CLASS	Valuation Class	BKLAS	CHAR	4			BKLAS
FLG_INVNTRY_PSTNG	Indicates that current posting is an inventory posting	FM_FLG_INVNTRY_PSTNG	CHAR	1			FM_FLG_INVNTRY_PSTNG
ASSETTRTYP	Asset Transaction Type	BF_ANBWA	CHAR	3			CHAR3		SSH_TABW
AMOUNT	Amount in document currency	WRBTR	CURR	13(2)			WERT7
CURRENCY	Currency Key	WAERS	CUKY	5			WAERS	FWS
VENDOR_OFFSET	Offsetting vendor	FM_OFF_LIFNR	CHAR	10		ALPHA	LIFNR		KRED_C
CUSTOMER_OFFSET	Offsetting Customer	FM_OFF_KUNNR	CHAR	10		ALPHA	KUNNR		C_KUNNR
FM_SPLIT	Line is Result of Account Assignment Distribution	FMSP_SPLIT_RESULT_FLAG	CHAR	1			FLAG
SPLIT_RULE	Identifier for Rule-Based Acct Asst Distributions Rule	FMSP_RULE_ID	CHAR	12			FMSP_RULE_ID
QUANTITY	Quantity	MENGE_D	QUAN	13(3)			MENG13
UNIT	Base Unit of Measure	MEINS	UNIT	3		CUNIT	MEINS
CATSAPPL	Target Component for CATS	FMSP_CATSAPPL	CHAR	2			FMSP_CABAAPPL
BUDGET_PD	FM: Budget Period	FM_BUDGET_PERIOD	CHAR	10			FM_BUDGET_PERIOD	BUDPER
PBUDGET_PD	FM: Partner Budget Period	FM_PBUDGET_PERIOD	CHAR	10			FM_BUDGET_PERIOD	BUDPER
T_FIELDS				0
SPLIT_ID	Unique ID for Distribution in Rule-Based Acct Asst Distbtn	FMSP_SPLIT_ID	NUMC	10	Assigned to domain		FMSP_SPLIT_ID
TRACE_STEP_NBR	Natural Number	INT4	INT4	10			INT4

Key field

Non-key field

< FMSP_RULE_EDIT - Editing structure for Rule-Based Account Distribution Rule FMSP_SPLIT - Distribution settings for Rule-Based Account Distributions >

How do I retrieve data from SAP structure FMSP_RULE_RESULT using ABAP code?

As FMSP_RULE_RESULT is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on FMSP_RULE_RESULT as there is no data to select.

How to access SAP table FMSP_RULE_RESULT

Within an ECC or HANA version of SAP you can also view further information about FMSP_RULE_RESULT and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).