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

FMSPLIT_RULE is a standard SAP Table which is used to store Distribution Rule 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_RULE table consists of various fields, each holding specific information or linking keys about Distribution Rule for Rule-Based Account Distributions data available in SAP. These include SPLIT_RULE (Identifier for Rule-Based Acct Asst Distributions Rule), GROUP_ID (Group ID for Rule-Based Account Asst Distributions), STATUS (Activation status for Rule-Based Acct Asst Distributions), FPROF_ID (Field Profile ID for Rule-Based Account 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_RULE 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)

Text table = FMSPLIT_RULET


SAP FMSPLIT_RULE 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_RULE 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
MANDTClient MANDTCLNT3T000MANDT
SPLIT_RULEIdentifier for Rule-Based Acct Asst Distributions Rule FMSP_RULE_IDCHAR12FMSP_RULE_ID
GROUP_IDGroup ID for Rule-Based Account Asst Distributions FMSP_GROUP_IDCHAR4FMSPLIT_GROUPFMSP_GROUP_IDFM_SPLIT_GROUP
STATUSActivation status for Rule-Based Acct Asst Distributions FMSP_STATUSCHAR1FMSP_STATUS
FPROF_IDField Profile ID for Rule-Based Account Asst Distributions FMSP_FPROF_IDCHAR12FMSPLIT_FPROFFMSP_FPROF_ID
APROF_IDRule-Based Account Assignment Distbtns Action Profile ID FMSP_APROF_IDCHAR12FMSPLIT_APROFFMSP_APROF_ID
RULE_TYPERule Type for Rule-Based Account Assignment Distributions FMSP_RULE_TPCHAR4FMSPLIT_RULETPFMSP_RULE_TP
BINDING_TYPEControls whether rule results are binding or may be changed FMSP_BINDING_TPCHAR1FMSP_BINDING_TP
CREATED_BYFIFM: Created by FM_ERFNAMECHAR12USNAM
CREATED_ONFIFM: Entry Date FM_ERFDATDATS8DATUM
MODIFIED_BYFIFM: Name of Last Person to Make a Change FM_AENNAMECHAR12USNAM
MODIFIED_ONFIFM: Changed on FM_AENDATDATS8DATUM
REMAINDER_TYPERemainder Handling for Partial Allocation by Distribution FMSP_REMAINDER_TYPECHAR1FMSP_REMAINDER_TYPE

Key field Non-key field



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

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

SELECT SINGLE *
FROM FMSPLIT_RULE
INTO CORRESPONDING FIELDS OF WA_FMSPLIT_RULE
WHERE...

How to access SAP table FMSPLIT_RULE

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

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