1. SAP Tutorial
  2. SAP PSM

FMSPLITP SAP table for – Plan line items table

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

SAP FMSPLITP table

Table FMSPLITP technical data

TableFMSPLITP
Data storingPlan line items table
ModulePSM
Sub ModulePSM-FM
SAP PackageFMFS_E
Delivery ClassA – Application table (master and transaction data)
ComponentEA-PS
Table CategoryTRANSP

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

  • RCLNT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • GL_SIRID : Record number of the line item record
    Its a key field. Its data type is CHAR (Character String) with field length 18
  • RLDNR : Ledger
    Its data type is CHAR (Character String) with field length 2
  • RRCTY : Record Type
    Its data type is CHAR (Character String) with field length 1
  • RVERS : Version
    Its data type is CHAR (Character String) with field length 3
  • RYEAR : Fiscal Year
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • RTCUR : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • DRCRK : Debit/Credit Indicator
    Its data type is CHAR (Character String) with field length 1
  • RPMAX : Period
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • DOCCT : Document Type
    Its data type is CHAR (Character String) with field length 1
  • DOCNR : Accounting Document Number
    Its data type is CHAR (Character String) with field length 10
  • DOCLN : Six-Character Posting Item for Ledger
    Its data type is CHAR (Character String) with field length 6
  • 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
  • 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 : 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
  • SGTXT : Item Text
    Its data type is CHAR (Character String) with field length 50
  • DOCTY : FI-SL Document Type
    Its data type is CHAR (Character String) with field length 2
  • 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
  • BUDAT : Posting Date in the Document
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • WSDAT : Value Date for Currency Translation
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • REFDOCNR : Reference document number of an accounting document
    Its data type is CHAR (Character String) with field length 10
  • REFRYEAR : Reference fiscal year
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • REFDOCLN : Six-digit number of the reference posting line
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • REFDOCCT : Reference document category
    Its data type is CHAR (Character String) with field length 1
  • REFACTIV : FI-SL Business Reference Transaction
    Its data type is CHAR (Character String) with field length 4
  • CPUDT : Accounting document entry date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CPUTM : Time of data entry
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • USNAM : User name
    Its data type is CHAR (Character String) with field length 12
  • AWTYP : Reference procedure
    Its data type is CHAR (Character String) with field length 5
  • AWORG : Reference organisational units
    Its data type is CHAR (Character String) with field length 10

    • FMSPLITP related tables

    • FMDERIVE003 : Derivation rule:Cost Center to Commitment Item/Funds Ctr/Fun
    • FMDERIVE001 : Derivation rule:Cost Element to Commitment Item
    • FMSPLITP : Plan line items table
    • FMDERIVEFUNCID : LIST OF FUNCTIONS ASSIGNED TO DERIVATION STRATEGY
    • FMDERIVE005 : Derivation rule:Order to Commitment Item/Funds Ctr/Fund/Func
    • FMTABADR : Characteristic Derivation: Strategies
    • FMTOBL : FI documents with FM to BL balance information
    • FMDERIVE002 : Derivation rule:Cost Center/CE to Commitment Item/Funds Ctr/
    • FM2BLTR1 : FM2BL – Define on FM area level
    • FMDERIVEENVID : Assignment Company Code to Derivation Tool Strategy
    • FMDERIVE009 : Derivation rule:Profit Center to Commitment Item/Funds Ctr/F
    • FMSPLITT : Summary table
    • FMAC2 : FM to FI – GL Account Assignment
    • FMDERIVE008 : Profit Ctr/CE to Commit Item/Funds Center/Fund/Function
    • FM2BLACTC : FM2BL – Activation of Commitment/Actual Value Types
    • FMDERIVEFUNC : List of functions available in the FM Derivation tools
    • T023V : Fast Pay/Accelerated Pay table
    • FM2BLTRFLD : FM2BL – Transfer Dimension fields
    • FMDERIVE004 : Derivation rule:Order/CE to Commitment Item/Funds Ctr/Fund/F
    • FM2BLACT1 : FM2BL – Activate of FM area and FM Budget Category

    FMSPLITP related transaction codes under SAP package FMFS_E

    • OF39 : Customized update profile
    • FMFG_EF_POST : Post parked Earmark fund documents
    • FM2BL_DERIVE : Derive FM totals transfer to BL
    • FM2BL_DERIVER1 : CO-PA Rule for FM transfer to FI
    • OFFT : Create FM fund types
    • FMPOPDERIVER : Principle of Prudence – Maintenance
    • S_ALN_01000128 : IMG-Aktivität: SIMG_ISPSFM_V_T023G
    • FM_MRP_PR : Update MRP PR’s to FM
    • OFMTOAC2 : Define Debit/Credit GL in FM to AC
    • FMRULES : FM Objects: Predefined Rules
    • FM2BL_DERIVER : CO-PA Rule for FM transfer to BL
    • FMDERIVER : FM Object Assignment – Maintenance
    • FMN3N : Reconstruction of Purch. Requisition
    • FMDERIVETRACE : Activate FMDERIVE TRACE
    • FMNSDN : Reconstruction of Sales Orders
    • FMNSD : Rebuild FM Open Item of SD Orders
    • FM2BL_DERIVE1 : Derive FM totals transfer to FI
    • FMDERIVATIONANALYSIS : Analysis Report on FM Derivations
    • FMBTB : Transfer Budget Totals to FI-BL
    • FMMI : Mass Maintenance of Open Intervals

    Related References

    Related Tutorials

    FMGLFLEXP SAP table for – General Ledger: Plan Line Items

    FMGLFLEXP table in SAP PSM (Fund Accounting in PSM) module. This table is used for storing data of General Ledger:...

    FMRBP SAP table for – Plan line items table

    FMRBP table in SAP PSM (Funds Management in PSM) module. This table is used for storing data of Plan line...

    GMAVCP SAP table for – Plan line items table

    GMAVCP table in SAP PSM (Grants Management in PSM) module. This table is used for storing data of Plan line...

    GMIP SAP table for – Plan line items table

    GMIP table in SAP PSM (Grants Management in PSM) module. This table is used for storing data of Plan line...

    FMAVCP SAP table for – Plan line items table

    FMAVCP table in SAP PSM (Funds Management in PSM) module. This table is used for storing data of Plan line...

    FMUSFGP SAP table for – Plan line items table

    FMUSFGP table in SAP PSM (Funds Management in PSM) module. This table is used for storing data of Plan line...

    FMUSFGFACTS1P SAP table for – Plan line items table

    FMUSFGFACTS1P table in SAP PSM (Funds Management in PSM) module. This table is used for storing data of Plan line...

    «
    »