1. SAP Tutorial
  2. FI Module

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

    • FAGL_R_SPL related tables

    • FAGL_R_OBJTY : Reorganization: Object Type
    • FAGL_R_JBDISPTCH : Reorganization: Dispatching Jobs
    • FAGL_R_OBJTY_T : Reorganization: Text of an Object Type
    • FAGL_R_BLART : Reorganization: Document Type
    • FAGL_R_PL : Reorganization Plan
    • FAGL_R_JBSIZE : Reorg: Size of a Partition of Object Types to Be Processed
    • FAGL_R_PL_RES_G : Reorganization: General Restrictions of the Plan
    • FAGL_R_DERH_VERT : Reorganization: Text of a Hierarchy Version
    • FAGL_R_OBJTY_DI0 : Reorganization: Display Chars of an Obj. Type (SAP Entries)
    • FAGL_R_PL_COUNT : Tracking of Different Processes of a Plan
    • FAGL_R_JBPARTN : Reorganization: Packages of a Dispatching Job to Be Executed
    • FAGL_R_PL_DERH : Reorganization: Derivation Hierarchy of the Plan
    • FAGL_R_PLTY_RES : Reorganization: Restriction Characteristics of a Plan Type
    • FAGL_R_PER_TRACK : Reorganization: Log of Changed Posting Periods
    • FAGL_R_RMVCT : Reorganization: Transaction Type
    • FAGL_R_COMP_AA0 : Entities for Activation of Asset Accounting
    • FAGL_R_MAP_CUST : Reorganization: Object Number of the Signature Values
    • FAGL_R_JBPROCEED : Reorganization: Jobs of a Dispatching Job to Be Executed
    • FAGL_R_PLTY0 : Entities for Activation of Plan Type
    • FAGL_R_JBOBJTY : Object Type for Each Dispatcher for Special Activities

    FAGL_R_SPL related transaction codes under SAP package FAGL_REORGANIZATION_FW

    • FAGL_R_FILL_RMVCT : Transfer Balances to Cons.Trans.Type
    • FAGL_R_ARCHDEF : Definition of Residence Time
    • FAGL_R_INFO : Reorganization

    Related References

    Related Tutorials

    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:...

    FAGL_R_APAR_SPL SAP table for – Reorganization: Assignment Btwn FAGL_R_APAR and FAGL_R_SPL

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

    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_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:...

    FAGL_R_OI_TRACK0 SAP table for – Reorganization: Open Items for Inclusion

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

    FAGL_SPLINFO SAP table for – Splittling Information of Open Items

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

    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...

    «
    »