1. SAP Tutorial
  2. SAP PSM

FMSPLITT SAP table for – Summary table

Here we would like to draw your attention to FMSPLITT 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). FMSPLITT is a SAP standard transp table used for storing Summary table related data in SAP. It comes under the package FMFS_E.

SAP FMSPLITT table

Table FMSPLITT technical data

TableFMSPLITT
Data storingSummary table
ModulePSM
Sub ModulePSM-FM
SAP PackageFMFS_E
Delivery ClassA – Application table (master and transaction data)
ComponentEA-PS
Table CategoryTRANSP

SAP FMSPLITT 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 FMSPLITT table.

  • RCLNT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • RLDNR : Ledger
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • RRCTY : Record Type
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • RVERS : Version
    Its a key field. Its data type is CHAR (Character String) with field length 3
  • RYEAR : Fiscal Year
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • ROBJNR : Object number for objects (account assignment elements)
    Its a key field. Its data type is CHAR (Character String) with field length 18
  • COBJNR : Object number for transaction attributes
    Its a key field. Its data type is CHAR (Character String) with field length 18
  • SOBJNR : Object number for partner objects (accnt assignmnt elements)
    Its a key field. Its data type is CHAR (Character String) with field length 18
  • RTCUR : Currency Key
    Its a key field. Its data type is CUKY (Currency key for a currency field) with field length 5
  • DRCRK : Debit/Credit Indicator
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • RPMAX : Period
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 3
  • RBUKRS : Company Code
    Its data type is CHAR (Character String) with field length 4
  • RACCT : Account Number
    Its data type is CHAR (Character String) with field length 10
  • RBUSA : Business Area
    Its data type is CHAR (Character String) with field length 4
  • RCNTR : Cost Center
    Its data type is CHAR (Character String) with field length 10
  • RPROJK : Work Breakdown Structure Element (WBS Element)
    Its data type is NUMC (Character String with Digits Only) with field length 8
  • RFAREA : Functional Area
    Its data type is CHAR (Character String) with field length 16
  • RFISTL : Funds Center
    Its data type is CHAR (Character String) with field length 16
  • RFUND : Fund
    Its data type is CHAR (Character String) with field length 10
  • RFUND_TYPE : FM Fund Type
    Its data type is CHAR (Character String) with field length 6
  • RAUFNR : Order Number
    Its data type is CHAR (Character String) with field length 12
  • RGRANT_NBR : Grant
    Its data type is CHAR (Character String) with field length 20
  • ACTIV : Business Transaction
    Its data type is CHAR (Character String) with field length 4
  • MEASURE : Funded Program
    Its data type is CHAR (Character String) with field length 24
  • LOGSYS : Logical system
    Its data type is CHAR (Character String) with field length 10
  • SBUKRS : Company code of partner
    Its data type is CHAR (Character String) with field length 4
  • SACCT : Partner account number
    Its data type is CHAR (Character String) with field length 10
  • SBUSA : Trading Partner Business Area of the Business Partner
    Its data type is CHAR (Character String) with field length 4
  • SCNTR : Partner cost center
    Its data type is CHAR (Character String) with field length 10
  • SFAREA : Partner Functional Area
    Its data type is CHAR (Character String) with field length 16
  • SFUND : Partner Fund
    Its data type is CHAR (Character String) with field length 10
  • SGRANT_NBR : Partner Grant
    Its data type is CHAR (Character String) with field length 20
  • TSLVT : Balance carried forward in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL01 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL02 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL03 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL04 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL05 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL06 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL07 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL08 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL09 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL10 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL11 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL12 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL13 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL14 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL15 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL16 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • HSLVT : Balance carried forward in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL01 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL02 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL03 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL04 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL05 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL06 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL07 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL08 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL09 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL10 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL11 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL12 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL13 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL14 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL15 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL16 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • CSPRED : Distribution key for currency amounts
    Its data type is CHAR (Character String) with field length 4
  • FIKRS : Financial Management Area
    Its data type is CHAR (Character String) with field length 4
  • KOKRS : Controlling Area
    Its data type is CHAR (Character String) with field length 4

    • FMSPLITT related tables

    • FMDERIVE007 : Derivation rule:WBS Element to Commitment Item/Funds Ctr/Fun
    • FMAC2 : FM to FI – GL Account Assignment
    • FMT003 : Funds Management Flags for FI Document Type
    • FMSPLITA : Actual line item table
    • FMDERIVEENVID : Assignment Company Code to Derivation Tool Strategy
    • FMDERIVE003 : Derivation rule:Cost Center to Commitment Item/Funds Ctr/Fun
    • FMSPLITT : Summary table
    • FMDERIVEFUNCID : LIST OF FUNCTIONS ASSIGNED TO DERIVATION STRATEGY
    • FMDERIVEFUNC : List of functions available in the FM Derivation tools
    • FM2BLTRFLD : FM2BL – Transfer Dimension fields
    • FMSPLITP : Plan line items table
    • FMBLPSTNG : FM BL posting customizing for GL line-items collection
    • FMSPLITC : Object table 2
    • FMFG_HEAD_INV : Header Data for Improper Invoices
    • FMDT_CHANGEDOC : Empty table for change document on DRULE derivation tables
    • FMSPLITO : Object table 1
    • FM2BLTR1 : FM2BL – Define on FM area level
    • FMDERIVE006 : Derivation rule:WBS Element/CE to Commitment Item/Funds Ctr/
    • FMDERIVE001 : Derivation rule:Cost Element to Commitment Item
    • FMDERIVE002 : Derivation rule:Cost Center/CE to Commitment Item/Funds Ctr/

    FMSPLITT related transaction codes under SAP package FMFS_E

    • FMRC22 : Reconciliation of Purch. Requisition
    • FMN3N : Reconstruction of Purch. Requisition
    • OBPE : C FI Penalty Interests
    • FM2BL_DERIVER : CO-PA Rule for FM transfer to BL
    • FMIR : Detail Maintenance of Open Int Rules
    • FMNSD : Rebuild FM Open Item of SD Orders
    • FMOD : Override FM Update Date
    • FMBTB : Transfer Budget Totals to FI-BL
    • OFFT : Create FM fund types
    • FMN4N : Reconstruction of Purchase Orders
    • OFMTOAC2 : Define Debit/Credit GL in FM to AC
    • FM2BL_DERIVE1 : Derive FM totals transfer to FI
    • FMPOPDERIVE : Principle of Prudence – Customizing
    • FMPOPDERIVER : Principle of Prudence – Maintenance
    • FMN5N : Reconstruction of Earmarked Funds
    • FMCOMPARESTRATEGY : Compare Derivation Strategy
    • FMTR : FM budgetary ledger trace
    • FM2BL_DERIVER1 : CO-PA Rule for FM transfer to FI
    • S_ALN_01000128 : IMG-Aktivität: SIMG_ISPSFM_V_T023G
    • FMNSDN : Reconstruction of Sales Orders

    Related References

    Related Tutorials

    GLT3 SAP table for – Summary Data Preparations for Consolidation

    GLT3 table in SAP FI (Consolidation in FI) module. This table is used for storing data of Summary Data Preparations...

    FMRBT SAP table for – Summary table

    FMRBT table in SAP PSM (Funds Management in PSM) module. This table is used for storing data of Summary table....

    FMAVCT SAP table for – AVC Summary Table (BCS)

    FMAVCT table in SAP PSM (Funds Management in PSM) module. This table is used for storing data of AVC Summary...

    GMIT SAP table for – Summary table

    GMIT table in SAP PSM (Grants Management in PSM) module. This table is used for storing data of Summary table....

    GMAVCT SAP table for – Summary table

    GMAVCT table in SAP PSM (Grants Management in PSM) module. This table is used for storing data of Summary table....

    FMUSFGFACTS1T SAP table for – Summary table

    FMUSFGFACTS1T table in SAP PSM (Funds Management in PSM) module. This table is used for storing data of Summary table....

    FMUSFGT SAP table for – Summary table for US Federal Government

    FMUSFGT table in SAP PSM (Funds Management in PSM) module. This table is used for storing data of Summary table...

    «
    »