FMSPLIT_SPLIT SAP table for – Distributions for Rule-Based Account Distributions

Here we would like to draw your attention to FMSPLIT_SPLIT table in SAP. As we know it is being mainly used with the SAP PSM-FM (Funds Management in PSM) component which is coming under PSM module (Public Sector Management). FMSPLIT_SPLIT is a SAP standard transp table used for storing Distributions for Rule-Based Account Distributions related data in SAP. It comes under the package FM_SPLIT_E.

SAP FMSPLIT_SPLIT table

Table FMSPLIT_SPLIT technical data

TableFMSPLIT_SPLIT
Data storingDistributions for Rule-Based Account Distributions
ModulePSM
Sub ModulePSM-FM
SAP PackageFM_SPLIT_E
Delivery ClassA – Application table (master and transaction data)
ComponentEA-PS
Table CategoryTRANSP

SAP FMSPLIT_SPLIT Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in FMSPLIT_SPLIT table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • SPLIT_ID : Unique ID for Distribution in Rule-Based Acct Asst Distbtn
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 10
  • SPLIT_RULE : Identifier for Rule-Based Acct Asst Distributions Rule
    Its data type is CHAR (Character String) with field length 12
  • ALLOC_BLOCK : Allocation block for Rule-Based Acct Asst Distributions
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • SEQUENCE_NBR : Sequence number for Rule-Based Acct Asst Distributions
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • FROM_DATE : Start Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • TO_DATE : End Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DIST_METHOD : Distribution method for Rule-Based Acct Asst Distributions
    Its data type is CHAR (Character String) with field length 4
  • DIST_PERCENT : Distribution percentage for Rule-Based Acct Asst Distbtn
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 8
  • CURRENCY : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • DIST_AMOUNT : Distribution amount factor for Rule-Based Acct Acct Distbtn
    Its data type is CURR (Currency Field) with field length 13
  • EVENT_USED : Event to process if split is included in distribution
    Its data type is CHAR (Character String) with field length 12
  • EVENT_NUSED : Event to process if entry is NOT included in distribution
    Its data type is CHAR (Character String) with field length 12
  • FINAL_SPLIT : Indicator: no further assignment distn to be performed
    Its data type is CHAR (Character String) with field length 1
  • CREATED_BY : FIFM: Created by
    Its data type is CHAR (Character String) with field length 12
  • CREATED_ON : FIFM: Entry Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • MODIFIED_BY : FIFM: Name of Last Person to Make a Change
    Its data type is CHAR (Character String) with field length 12
  • MODIFIED_ON : FIFM: Changed on
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8