FAGL_R_SPL SAP (Reorganization: Splitting Information of the Open Items) Table details

Dictionary Type: Table
Description: Reorganization: Splitting Information of the Open Items




ABAP Code to SELECT data from FAGL_R_SPL
Related tables to FAGL_R_SPL
Access table FAGL_R_SPL




Table field list including key, data, relationships and ABAP select examples

FAGL_R_SPL is a standard SAP Table which is used to store Reorganization: Splitting Information of the Open Items data and is available within R/3 SAP systems depending on the version and release level.

The FAGL_R_SPL table consists of various fields, each holding specific information or linking keys about Reorganization: Splitting Information of the Open Items data available in SAP. These include MANDT (Client), BELNR (Accounting Document Number), GJAHR (Fiscal Year), BUKRS (Company Code).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP FAGL_R_SPL table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3Assigned to domainMANDT
BELNRAccounting Document Number BELNR_DCHAR10ALPHABELNRBLN
GJAHRFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
BUZEINumber of Line Item Within Accounting Document BUZEINUMC3BUZEIBUZ
SPL_NOSequence Number of Splitting Information FAGL_INDEXNUMC6NUMC06
GSBERBusiness Area GSBERCHAR4Assigned to domainGSBERGSB
PRCTRProfit Center PRCTRCHAR10Assigned to domainALPHAPRCTRPRCPRCTR_EMPTY
SEGMENTSegment for Segmental Reporting FB_SEGMENTCHAR10Assigned to domainALPHAFB_SEGMENT
GSBER_CURRENTBusiness Area GSBERCHAR4Assigned to domainGSBERGSB
PRCTR_CURRENTProfit Center PRCTRCHAR10Assigned to domainALPHAPRCTRPRCPRCTR_EMPTY
SEGMENT_CURRENTSegment for Segmental Reporting FB_SEGMENTCHAR10Assigned to domainALPHAFB_SEGMENT
PARGBTrading partner's business area PARGBCHAR4Assigned to domainGSBERGSB
PPRCTRPartner Profit Center PPRCTRCHAR10Assigned to domainALPHAPRCTRPPC
PSEGMENTPartner Segment for Segmental Reporting FB_PSEGMENTCHAR10Assigned to domainALPHAFB_SEGMENT
KOSTLCost Center KOSTLCHAR10Assigned to domainALPHAKOSTLKOS
AUFNROrder Number AUFNRCHAR12Assigned to domainALPHAAUFNRANR
VORNROperation/Activity Number VORNRCHAR4NUMCVVORNRVGN
AUFPLRouting number of operations in the order CO_AUFPLNUMC10AUFPL
APLZLInternal counter CIM_COUNTNUMC8CIM_COUNT
NPLNRNetwork Number for Account Assignment NPLNRCHAR12Assigned to domainALPHAAUFNRNET
AUBELSales Document VBELN_VACHAR10Assigned to domainALPHAVBELNAUN
AUPOSSales Document Item POSNR_VANUMC6Assigned to domainPOSNRAPO
KDAUFSales Order Number KDAUFCHAR10Assigned to domainALPHAVBELNAUN
KDPOSItem Number in Sales Order KDPOSNUMC6NUM06KPO
EBELNPurchasing Document Number EBELNCHAR10Assigned to domainALPHAEBELNBESMEKK_C
EBELPItem Number of Purchasing Document EBELPNUMC5Assigned to domainEBELPBSP
ZEKKNSequential Number of Account Assignment DZEKKNNUMC2NUM02
KSTRGCost Object KSTRGCHAR12Assigned to domainKSTRGKTR
ANLN1Main Asset Number ANLN1CHAR12Assigned to domainALPHAANLN1AN1
ANLN2Asset Subnumber ANLN2CHAR4Assigned to domainALPHAANLN2AN2
PS_PSP_PNRWork Breakdown Structure Element (WBS Element) PS_PSP_PNRNUMC8Assigned to domainKONPRPS_POSNR
WERKSPlant WERKS_DCHAR4Assigned to domainWERKSWRKH_T001W_C
REBZG_SPL_NORelation to SPL_NO of Invoice Ref. (Imparted by Splitter) FAGL_R_REBZG_SPLNONUMC6NUMC06
PRCTR_SIMProfit Center PRCTRCHAR10Assigned to domainALPHAPRCTRPRCPRCTR_EMPTY
PSWSLUpdate Currency for General Ledger Transaction Figures PSWSLCUKY5Assigned to domainWAERS
PSWBTAmount for Updating in General Ledger PSWBTCURR13(2) WERT7
KOARTAccount Type KOARTCHAR1KOART
HKONTGeneral Ledger Account HKONTCHAR10Assigned to domainALPHASAKNR
XREBZGItem Had Invoice Reference at Time of First Simulation FAGL_R_XREBZGCHAR1FLAG
XCLEARItem Was Clearing Item in First Simulation FAGL_R_XCLEARCHAR1FLAG
XSPLINFOSPLINFO Taken from Table Without Reorganization Simulation FAGL_R_XSPLINFOCHAR1FLAG
XSKVCash Discount Clearing Item FAGL_R_XSKVCHAR1FLAG
SIMDATETime at which object was created TSTRCREATSDEC15TZNTSTMPS

Key field Non-key field



How do I retrieve data from SAP table FAGL_R_SPL using ABAP code

The following ABAP code Example will allow you to do a basic selection on FAGL_R_SPL to SELECT all data from the table
DATA: WA_FAGL_R_SPL TYPE FAGL_R_SPL.

SELECT SINGLE *
FROM FAGL_R_SPL
INTO CORRESPONDING FIELDS OF WA_FAGL_R_SPL
WHERE...

How to access SAP table FAGL_R_SPL

Within an ECC or HANA version of SAP you can also view further information about FAGL_R_SPL and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!