SAP FMSPLIT_SPLIT Distributions for Rule-Based Account Distributions Table data and field list

FMSPLIT_SPLIT is a standard SAP Table which is used to store Distributions for Rule-Based Account Distributions data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The FMSPLIT_SPLIT table consists of various fields, each holding specific information or linking keys about Distributions for Rule-Based Account Distributions data available in SAP. These include SPLIT_ID (Unique ID for Distribution in Rule-Based Acct Asst Distbtn), SPLIT_RULE (Identifier for Rule-Based Acct Asst Distributions Rule), ALLOC_BLOCK (Allocation block for Rule-Based Acct Asst Distributions), SEQUENCE_NBR (Sequence number for Rule-Based Acct Asst Distributions)... 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. .

FMSPLIT_SPLIT table Technical Details:

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)

SAP FMSPLIT_SPLIT table 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 FMSPLIT_SPLIT 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
MANDT	Client	MANDT	CLNT	3	T000		MANDT
SPLIT_ID	Unique ID for Distribution in Rule-Based Acct Asst Distbtn	FMSP_SPLIT_ID	NUMC	10			FMSP_SPLIT_ID
SPLIT_RULE	Identifier for Rule-Based Acct Asst Distributions Rule	FMSP_RULE_ID	CHAR	12	FMSPLIT_RULE		FMSP_RULE_ID
ALLOC_BLOCK	Allocation block for Rule-Based Acct Asst Distributions	FMSP_ALLOC_BLOCK	NUMC	2			NUMC2
SEQUENCE_NBR	Sequence number for Rule-Based Acct Asst Distributions	FMSP_SEQUENCE_NBR	NUMC	2			NUMC2
FROM_DATE	Start Date	BEGDATUM	DATS	8			DATUM	BEG
TO_DATE	End Date	ENDDATUM	DATS	8			DATUM	END
DIST_METHOD	Distribution method for Rule-Based Acct Asst Distributions	FMSP_DIST_METHOD	CHAR	4	FMSPLIT_DIST		FMSP_DIST_METHOD
DIST_PERCENT	Distribution percentage for Rule-Based Acct Asst Distbtn	FMSP_DIST_PERCENT	DEC	8(5)			FMSP_PERCENT
CURRENCY	Currency Key	WAERS	CUKY	5	TCURC		WAERS	FWS
DIST_AMOUNT	Distribution amount factor for Rule-Based Acct Acct Distbtn	FMSP_DIST_AMOUNT	CURR	13(2)			WERT7
EVENT_USED	Event to process if split is included in distribution	FMSP_EVENT_USED	CHAR	12			FMSP_EVENT
EVENT_NUSED	Event to process if entry is NOT included in distribution	FMSP_EVENT_NUSED	CHAR	12			FMSP_EVENT
FINAL_SPLIT	Indicator: no further assignment distn to be performed	FMSP_FINAL_SPLIT	CHAR	1			XFELD
CREATED_BY	FIFM: Created by	FM_ERFNAME	CHAR	12			USNAM
CREATED_ON	FIFM: Entry Date	FM_ERFDAT	DATS	8			DATUM
MODIFIED_BY	FIFM: Name of Last Person to Make a Change	FM_AENNAME	CHAR	12			USNAM
MODIFIED_ON	FIFM: Changed on	FM_AENDAT	DATS	8			DATUM

Key field

Non-key field

< FMSPLIT_RULETPT - Rule type for Rule-Based Account Distributions FMSPLIT_VALUES - Assignment field values for Rule-Based Account Distribution >

How do I retrieve data from SAP table FMSPLIT_SPLIT using ABAP code

The following ABAP code Example will allow you to do a basic selection on FMSPLIT_SPLIT to SELECT all data from the table
DATA: WA_FMSPLIT_SPLIT TYPE FMSPLIT_SPLIT.

SELECT SINGLE *
FROM FMSPLIT_SPLIT
INTO CORRESPONDING FIELDS OF WA_FMSPLIT_SPLIT
WHERE...

How to access SAP table FMSPLIT_SPLIT

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

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