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

Here we would like to draw your attention to FAGL_R_SPL 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_R_SPL is a SAP standard transp table used for storing Reorganization: Splitting Information of the Open Items related data in SAP. It comes under the package FAGL_REORGANIZATION_FW.

SAP FAGL_R_SPL table

Table FAGL_R_SPL technical data

TableFAGL_R_SPL
Data storingReorganization: Splitting Information of the Open Items
ModuleFI
Sub ModuleFI-GL-REO
SAP PackageFAGL_REORGANIZATION_FW
Delivery ClassA – Application table (master and transaction data)
ComponentSAP_FIN
Table CategoryTRANSP

SAP FAGL_R_SPL 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_R_SPL 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 : 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 : Current Distribution Info: OIs: Receiver Segment Objects
  • GSBER_CURRENT : Business Area
    Its data type is CHAR (Character String) with field length 4
  • PRCTR_CURRENT : Profit Center
    Its data type is CHAR (Character String) with field length 10
  • SEGMENT_CURRENT : 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 : Reorganization: Additional Document Splitting Attributes
  • KOSTL : Cost Center
    Its data type is CHAR (Character String) with field length 10
  • AUFNR : Order Number
    Its data type is CHAR (Character String) with field length 12
  • VORNR : Operation/Activity Number
    Its data type is CHAR (Character String) with field length 4
  • AUFPL : Routing number of operations in the order
    Its data type is NUMC (Character String with Digits Only) with field length 10
  • APLZL : Internal counter
    Its data type is NUMC (Character String with Digits Only) with field length 8
  • NPLNR : Network Number for Account Assignment
    Its data type is CHAR (Character String) with field length 12
  • AUBEL : Sales Document
    Its data type is CHAR (Character String) with field length 10
  • AUPOS : Sales Document Item
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • 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
  • EBELN : Purchasing Document Number
    Its data type is CHAR (Character String) with field length 10
  • EBELP : Item Number of Purchasing Document
    Its data type is NUMC (Character String with Digits Only) with field length 5
  • ZEKKN : Sequential Number of Account Assignment
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • KSTRG : Cost Object
    Its data type is CHAR (Character String) with field length 12
  • 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
  • PS_PSP_PNR : Work Breakdown Structure Element (WBS Element)
    Its data type is NUMC (Character String with Digits Only) with field length 8
  • WERKS : Plant
    Its data type is CHAR (Character String) with field length 4
  • REBZG_SPL_NO : Relation to SPL_NO of Invoice Ref. (Imparted by Splitter)
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • PRCTR_SIM : Profit Center
    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
  • KOART : Account type
    Its data type is CHAR (Character String) with field length 1
  • HKONT : General Ledger Account
    Its data type is CHAR (Character String) with field length 10
  • XREBZG : Item Had Invoice Reference at Time of First Simulation
    Its data type is CHAR (Character String) with field length 1
  • XCLEAR : Item Was Clearing Item in First Simulation
    Its data type is CHAR (Character String) with field length 1
  • XSPLINFO : SPLINFO Taken from Table Without Reorganization Simulation
    Its data type is CHAR (Character String) with field length 1
  • XSKV : Cash Discount Clearing Item
    Its data type is CHAR (Character String) with field length 1
  • SIMDATE : Time at which object was created
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15