1. SAP Tutorial
  2. FI Module

FAGL_SPLINFO SAP table for – Splittling Information of Open Items

Here we would like to draw your attention to FAGL_SPLINFO table in SAP. As we know it is being mainly used with the SAP FI-GL (General Ledger Accounting in FI) component which is coming under FI module (Financial Accounting). FAGL_SPLINFO is a SAP standard transp table used for storing Splittling Information of Open Items related data in SAP. It comes under the package FAGL_ONLINE_SPLITTER.

SAP FAGL_SPLINFO table

Table FAGL_SPLINFO technical data

TableFAGL_SPLINFO
Data storingSplittling Information of Open Items
ModuleFI
Sub ModuleFI-GL
SAP PackageFAGL_ONLINE_SPLITTER
Delivery ClassA – Application table (master and transaction data)
ComponentSAP_FIN
Table CategoryTRANSP

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

  • .INCLUDE : Splitting Information: Open Items Key: Inx
    Its a key field.
  • .INCLUDE : Splitting Information: Open Items: Key
    Its a key field.
  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • BELNR : Accounting Document Number
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • GJAHR : Fiscal Year
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • BUKRS : Company Code
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • BUZEI : Number of Line Item Within Accounting Document
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 3
  • SPL_NO : Sequence Number of Splitting Information
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 6
  • .INCLUDE : AW Key
  • AWSYS : Logical system of source document
    Its data type is CHAR (Character String) with field length 10
  • AWTYP : Reference procedure
    Its data type is CHAR (Character String) with field length 5
  • AWREF : Reference document number
    Its data type is CHAR (Character String) with field length 10
  • AWORG : Reference organisational units
    Its data type is CHAR (Character String) with field length 10
  • .INCLUDE : Splitting Information on Open Items: Receiver Segmnt Objects
  • GSBER : Business Area
    Its data type is CHAR (Character String) with field length 4
  • PRCTR : Profit Center
    Its data type is CHAR (Character String) with field length 10
  • SEGMENT : Segment for Segmental Reporting
    Its data type is CHAR (Character String) with field length 10
  • .INCLUDE : Splitting Information on Open Items: Sender Segment Objects
  • PARGB : Trading partner’s business area
    Its data type is CHAR (Character String) with field length 4
  • PPRCTR : Partner Profit Center
    Its data type is CHAR (Character String) with field length 10
  • PSEGMENT : Partner Segment for Segmental Reporting
    Its data type is CHAR (Character String) with field length 10
  • .INCLUDE : Splitting Information on Open Items: CO Objects
  • AUFNR : Order Number
    Its data type is CHAR (Character String) with field length 12
  • IMKEY : Internal Key for Real Estate Object
    Its data type is CHAR (Character String) with field length 8
  • DABRZ : Reference date for settlement
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • KDAUF : Sales Order Number
    Its data type is CHAR (Character String) with field length 10
  • KDPOS : Item number in Sales Order
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • KOSTL : Cost Center
    Its data type is CHAR (Character String) with field length 10
  • KSTRG : Cost Object
    Its data type is CHAR (Character String) with field length 12
  • NPLNR : Network Number for Account Assignment
    Its data type is CHAR (Character String) with field length 12
  • APLZL : Internal counter
    Its data type is NUMC (Character String with Digits Only) with field length 8
  • AUFPL : Routing number of operations in the order
    Its data type is NUMC (Character String with Digits Only) with field length 10
  • PAOBJNR : Profitability Segment Number (CO-PA)
    Its data type is NUMC (Character String with Digits Only) with field length 10
  • PS_PSP_PNR : Work Breakdown Structure Element (WBS Element)
    Its data type is NUMC (Character String with Digits Only) with field length 8
  • .INCLUDE : Splitting Information on Open Items: Public Services
  • FIPOS : Commitment Item
    Its data type is CHAR (Character String) with field length 14
  • FISTL : Funds Center
    Its data type is CHAR (Character String) with field length 16
  • GEBER : Fund
    Its data type is CHAR (Character String) with field length 10
  • BUDGET_PD : FM: Budget Period
    Its data type is CHAR (Character String) with field length 10
  • PGEBER : Partner Fund
    Its data type is CHAR (Character String) with field length 10
  • PBUDGET_PD : FM: Partner Budget Period
    Its data type is CHAR (Character String) with field length 10
  • .INCLUDE : Account Assignment: Assets
  • ANLN1 : Main Asset Number
    Its data type is CHAR (Character String) with field length 12
  • ANLN2 : Asset Subnumber
    Its data type is CHAR (Character String) with field length 4
  • ANBWA : Asset Transaction Type
    Its data type is CHAR (Character String) with field length 3
  • BZDAT : Asset Value Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
  • .INCLUDE : Fields Required Internally
  • SHKZG : Debit/Credit Indicator
    Its data type is CHAR (Character String) with field length 1
  • BSCHL : Posting Key
    Its data type is CHAR (Character String) with field length 2
  • MWSKZ : Tax on sales/purchases code
    Its data type is CHAR (Character String) with field length 2
  • XSKRL : Indicator: Line item not liable to cash discount?
    Its data type is CHAR (Character String) with field length 1
  • FKBER : Functional Area
    Its data type is CHAR (Character String) with field length 16
  • HKONT : General Ledger Account
    Its data type is CHAR (Character String) with field length 10
  • PSWSL : Update Currency for General Ledger Transaction Figures
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • PSWBT : Amount for Updating in General Ledger
    Its data type is CURR (Currency Field) with field length 13
  • MENGE : Quantity
    Its data type is QUAN (Quantity field) with field length 13
  • MEINS : Base Unit of Measure
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • REL_VER : Release Version: New General Ledger with Document Splitting
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • FKIMG : Actual billed quantity
    Its data type is QUAN (Quantity field) with field length 13
  • VRKME : Sales unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • FKLMG : Billing quantity in stockkeeping unit
    Its data type is QUAN (Quantity field) with field length 13
  • .INCLU–AP : Split Fields for FM
  • .INCLUDE : Additional Acct Assignments in the Doc. Distribution for FM
  • GRANT_NRB : Grant
    Its data type is CHAR (Character String) with field length 20
  • GRANT_NBR : Grant
    Its data type is CHAR (Character String) with field length 20
  • PGRANT_NBR : Partner Grant
    Its data type is CHAR (Character String) with field length 20
  • MEASURE : Funded Program
    Its data type is CHAR (Character String) with field length 24
  • .INCLUDE : Extension for FM Update: FI Key of Invoice
  • KNBUKRS : Company Code
    Its data type is CHAR (Character String) with field length 4
  • KNGJAHR : Fiscal year for FI document number
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • KNBELNR : FI document number
    Its data type is CHAR (Character String) with field length 10
  • KNBUZEI : Document item for FI document number
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • .INCLUDE : Extension for FM Update: FI Key of Payment
  • VOBUKRS : Company code for payment document number
    Its data type is CHAR (Character String) with field length 4
  • VOGJAHR : Fiscal year for payment document number
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • VOBELNR : Payment Document Number
    Its data type is CHAR (Character String) with field length 10
  • .INCLU–AP : Joint Venture Accounting: Additional Account Assignments
  • .INCLUDE : Joint Venture Accounting: Additional Account Assignments
  • VNAME : Joint venture
    Its data type is CHAR (Character String) with field length 6
  • EGRUP : Equity group
    Its data type is CHAR (Character String) with field length 3
  • RECID : Recovery Indicator
    Its data type is CHAR (Character String) with field length 2
  • ORECID : Recovery Indicator
    Its data type is CHAR (Character String) with field length 2
  • BTYPE : Payroll Type
    Its data type is CHAR (Character String) with field length 2

    • FAGL_SPLINFO related tables

    • FAGL_SPLINFO : Splittling Information of Open Items
    • FAGL_EMP_PROCESS : Document Splitting: Process Adjustment for HR Postings
    • FAGL_VAL_LOG : Validation of Document Splitting: Log
    • FAGL_SPLINFO_VAL : Splitting Information of Open Item Values
    • FAGL_PRCTR_CONST : Profit Center Constant in Document Split
    • FAGL_VAL_PROCESS : Document Splitting: Validation Mode Dependent on Processes
    • FAGL_SPLINFO_LOG : New General Ledger Accounting: Log for Nonsplitted Documents
    • FAGL_CASHACC_TAX : Cash Account from Tax on Sales/Purchases Indicator
    • FAGL_SPLIT_VAL : Activation of Validation by Document Splitting

    FAGL_SPLINFO related transaction codes under SAP package FAGL_ONLINE_SPLITTER

    • FAGL_SUP_DOCS : FI Document Browser
    • FAGL_SCVA : Splitter Customizing:Analyze Changes
    • FAGL_VAL_LOG : Analysis: Validation Log

    Related References

    Related Tutorials

    FAGL_R_SPL SAP table for – Reorganization: Splitting Information of the Open Items

    FAGL_R_SPL table in SAP FI (General Ledger Accounting in FI) module. This table is used for storing data of Reorganization:...

    FAGL_MIG_OPITEMS SAP table for – Open Items from Period 0 (Creation of Split Information)

    FAGL_MIG_OPITEMS table in SAP FI (General Ledger Accounting in FI) module. This table is used for storing data of Open...

    FAGL_SPLINFO_VAL SAP table for – Splitting Information of Open Item Values

    FAGL_SPLINFO_VAL table in SAP FI (General Ledger Accounting in FI) module. This table is used for storing data of Splitting...

    FAGL_R_SPL_VAL SAP table for – Reorganization: Splitting Information of Open Item Values

    FAGL_R_SPL_VAL table in SAP FI (General Ledger Accounting in FI) module. This table is used for storing data of Reorganization:...

    EWUFI_SPLIT SAP table for – EMU Implementation: Table of FAGL_SPLINFO* to Be Corrected

    EWUFI_SPLIT table in SAP FI (General Ledger Accounting in FI) module. This table is used for storing data of EMU...

    FAGL_R_OI_TRACK1 SAP table for – Reorganization: Included Documents for Open Items

    FAGL_R_OI_TRACK1 table in SAP FI (General Ledger Accounting in FI) module. This table is used for storing data of Reorganization:...

    /SAPPCE/TDPCIDXO SAP table for – Down Payment Chain: Index for Open Items

    /SAPPCE/TDPCIDXO table in SAP FI (Additional Functions in FI) module. This table is used for storing data of Down Payment...

    «
    »