SAP FMSPLIT_VALUES Assignment field values for Rule-Based Account Distribution Table data and field list

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

The FMSPLIT_VALUES table consists of various fields, each holding specific information or linking keys about Assignment field values for Rule-Based Account Distribution data available in SAP. These include SPLIT_ID (Unique ID for Distribution in Rule-Based Acct Asst Distbtn), FIELD_NAME (Field Name), FIELD_VALUE (Account assignment value for Rule-Based Acct Asst Disbtn), OVERRIDE_FLAG (Indicator: Value From Distribution Can Replace Non-Blank)... 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_VALUES 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_VALUES 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_VALUES 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_IDUnique ID for Distribution in Rule-Based Acct Asst Distbtn FMSP_SPLIT_IDNUMC10FMSPLIT_SPLITFMSP_SPLIT_ID
FIELD_NAMEField Name FIELDNAMECHAR30Assigned to domainFDNAMEDFD
FIELD_VALUEAccount assignment value for Rule-Based Acct Asst Disbtn FMSP_FIELD_VALUECHAR60TEXT60
OVERRIDE_FLAGIndicator: Value From Distribution Can Replace Non-Blank FMSP_OVERRIDE_FLGCHAR1XFELD

Key field Non-key field



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

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

SELECT SINGLE *
FROM FMSPLIT_VALUES
INTO CORRESPONDING FIELDS OF WA_FMSPLIT_VALUES
WHERE...

How to access SAP table FMSPLIT_VALUES

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

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