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

FMSP_SPLIT 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 "Distribution settings for Rule-Based Account Distributions" 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_SPLIT TYPE FMSP_SPLIT.

The FMSP_SPLIT table consists of various fields, each holding specific information or linking keys about Distribution settings for Rule-Based Account Distributions data available in SAP. These include SEQUENCE_NBR (Sequence number for Rule-Based Acct Asst Distributions), SPLIT_ID (Unique ID for Distribution in Rule-Based Acct Asst Distbtn), FROM_DATE (Start Date), TO_DATE (End Date)... 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_SPLIT 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_SPLIT 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_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
ALLOC_BLOCKAllocation block for Rule-Based Acct Asst Distributions FMSP_ALLOC_BLOCKNUMC2NUMC2
SEQUENCE_NBRSequence number for Rule-Based Acct Asst Distributions FMSP_SEQUENCE_NBRNUMC2NUMC2
SPLIT_IDUnique ID for Distribution in Rule-Based Acct Asst Distbtn FMSP_SPLIT_IDNUMC10Assigned to domainFMSP_SPLIT_ID
FROM_DATEStart Date BEGDATUMDATS8DATUMBEG
TO_DATEEnd Date ENDDATUMDATS8DATUMEND
DIST_METHODDistribution method for Rule-Based Acct Asst Distributions FMSP_DIST_METHODCHAR4FMSPLIT_DISTFMSP_DIST_METHOD
DIST_PERCENTDistribution percentage for Rule-Based Acct Asst Distbtn FMSP_DIST_PERCENTDEC8(5) FMSP_PERCENT
CURRENCYCurrency Key WAERSCUKY5TCURCWAERSFWS
DIST_AMOUNTDistribution amount factor for Rule-Based Acct Acct Distbtn FMSP_DIST_AMOUNTCURR13(2) WERT7
EVENT_USEDEvent to process if split is included in distribution FMSP_EVENT_USEDCHAR12FMSP_EVENT
EVENT_NUSEDEvent to process if entry is NOT included in distribution FMSP_EVENT_NUSEDCHAR12FMSP_EVENT
FINAL_SPLITIndicator: no further assignment distn to be performed FMSP_FINAL_SPLITCHAR1XFELD
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
T_SPLITVAL 0

Key field Non-key field



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

As FMSP_SPLIT 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_SPLIT as there is no data to select.

How to access SAP table FMSP_SPLIT

Within an ECC or HANA version of SAP you can also view further information about FMSP_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).