Home SAP Development ABAP Coding SAP Fiori SAP Training SAP Tables SAP Objects...

FAGL_SPLINFO SAP (Splittling Information of Open Items) Table details

Dictionary Type: Table
Description: Splittling Information of Open Items

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

Table Field Attributes
Data Element Attributes
Domain Attributes
SAP Tables
Best ABAP Books

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

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

The FAGL_SPLINFO table consists of various fields, each holding specific information or linking keys about Splittling Information of 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_SPLINFO 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
MANDT	Client	MANDT	CLNT	3	Assigned to domain		MANDT
BELNR	Accounting Document Number	BELNR_D	CHAR	10		ALPHA	BELNR	BLN
GJAHR	Fiscal Year	GJAHR	NUMC	4		GJAHR	GJAHR	GJR
BUKRS	Company Code	BUKRS	CHAR	4	Assigned to domain		BUKRS	BUK	C_T001
BUZEI	Number of Line Item Within Accounting Document	BUZEI	NUMC	3			BUZEI	BUZ
SPL_NO	Sequence Number of Splitting Information	FAGL_INDEX	NUMC	6			NUMC06
AWSYS	Logical system of source document	AWSYS	CHAR	10	Assigned to domain	ALPHA	LOGSYS
AWTYP	Reference Transaction	AWTYP	CHAR	5	Assigned to domain		AWTYP
AWREF	Reference Document Number	AWREF	CHAR	10		ALPHA	AWREF
AWORG	Reference Organizational Units	AWORG	CHAR	10			AWORG
GSBER	Business Area	GSBER	CHAR	4	Assigned to domain		GSBER	GSB
PRCTR	Profit Center	PRCTR	CHAR	10	Assigned to domain	ALPHA	PRCTR	PRC	PRCTR_EMPTY
SEGMENT	Segment for Segmental Reporting	FB_SEGMENT	CHAR	10	Assigned to domain	ALPHA	FB_SEGMENT
PARGB	Trading partner's business area	PARGB	CHAR	4	Assigned to domain		GSBER	GSB
PPRCTR	Partner Profit Center	PPRCTR	CHAR	10	Assigned to domain	ALPHA	PRCTR	PPC
PSEGMENT	Partner Segment for Segmental Reporting	FB_PSEGMENT	CHAR	10	Assigned to domain	ALPHA	FB_SEGMENT
AUFNR	Order Number	AUFNR	CHAR	12	Assigned to domain	ALPHA	AUFNR	ANR
IMKEY	Internal Key for Real Estate Object	IMKEY	CHAR	8			IMKEY
DABRZ	Reference Date for Settlement	DABRBEZ	DATS	8			DDAT
KDAUF	Sales Order Number	KDAUF	CHAR	10	Assigned to domain	ALPHA	VBELN	AUN
KDPOS	Item Number in Sales Order	KDPOS	NUMC	6			NUM06	KPO
KOSTL	Cost Center	KOSTL	CHAR	10	Assigned to domain	ALPHA	KOSTL	KOS
KSTRG	Cost Object	KSTRG	CHAR	12	Assigned to domain		KSTRG	KTR
NPLNR	Network Number for Account Assignment	NPLNR	CHAR	12	Assigned to domain	ALPHA	AUFNR	NET
APLZL	Internal counter	CIM_COUNT	NUMC	8			CIM_COUNT
AUFPL	Routing number of operations in the order	CO_AUFPL	NUMC	10			AUFPL
PAOBJNR	Profitability Segment Number (CO-PA)	RKEOBJNR	NUMC	10			RKEOBJNR
PS_PSP_PNR	Work Breakdown Structure Element (WBS Element)	PS_PSP_PNR	NUMC	8	Assigned to domain	KONPR	PS_POSNR
FIPOS	Commitment Item	FIPOS	CHAR	14	Assigned to domain		FIPOS	FIP
FISTL	Funds Center	FISTL	CHAR	16	Assigned to domain		FISTL	FIS
GEBER	Fund	BP_GEBER	CHAR	10	Assigned to domain		BP_GEBER	FIC
BUDGET_PD	FM: Budget Period	FM_BUDGET_PERIOD	CHAR	10	Assigned to domain		FM_BUDGET_PERIOD	BUDPER
PGEBER	Partner Fund	FM_PFUND	CHAR	10	Assigned to domain		BP_GEBER	PARTNER_FUND
PBUDGET_PD	FM: Partner Budget Period	FM_PBUDGET_PERIOD	CHAR	10	Assigned to domain		FM_BUDGET_PERIOD	BUDPER
ANLN1	Main Asset Number	ANLN1	CHAR	12	Assigned to domain	ALPHA	ANLN1	AN1
ANLN2	Asset Subnumber	ANLN2	CHAR	4	Assigned to domain	ALPHA	ANLN2	AN2
ANBWA	Asset Transaction Type	ANBWA	CHAR	3	Assigned to domain		BWASL
BZDAT	Asset value date	BZDAT	DATS	8			DATUM
SHKZG	Debit/Credit Indicator	SHKZG	CHAR	1			SHKZG
BSCHL	Posting Key	BSCHL	CHAR	2	Assigned to domain		BSCHL
MWSKZ	Tax on sales/purchases code	MWSKZ	CHAR	2	Assigned to domain		MWSKZ
XSKRL	Indicator: Line item not liable to cash discount?	XSKRL	CHAR	1			XFELD
FKBER	Functional Area	FKBER	CHAR	16	Assigned to domain		FKBER	FBE
HKONT	General Ledger Account	HKONT	CHAR	10	Assigned to domain	ALPHA	SAKNR
PSWSL	Update Currency for General Ledger Transaction Figures	PSWSL	CUKY	5	Assigned to domain		WAERS
PSWBT	Amount for Updating in General Ledger	PSWBT	CURR	13(2)			WERT7
MENGE	Quantity	MENGE_D	QUAN	13(3)			MENG13
MEINS	Base Unit of Measure	MEINS	UNIT	3	Assigned to domain	CUNIT	MEINS
REL_VER	Release Version: New General Ledger with Document Splitting	REL_VERSION	NUMC	3
FKIMG	Actual Invoiced Quantity	FKIMG	QUAN	13(3)			MENG13
VRKME	Sales unit	VRKME	UNIT	3	Assigned to domain	CUNIT	MEINS
FKLMG	Billing quantity in stockkeeping unit	FKLMG	QUAN	13(3)			MENG13
.INCLU--AP				0
CC_BUKRS	Company Code	BUKRS	CHAR	4	Assigned to domain		BUKRS	BUK	C_T001
CC_ACCOUNT	General Ledger Account	HKONT	CHAR	10	Assigned to domain	ALPHA	SAKNR
.INCLU--AP				0
RE_BUKRS	Cash Ledger: Company Code for Expense/Revenue	FAGL_RE_BUKRS	CHAR	4	Assigned to domain		BUKRS
RE_ACCOUNT	Cash Ledger: Expense or Revenue Account	FAGL_RE_ACCOUNT	CHAR	10	Assigned to domain	ALPHA	SAKNR
CASH_BUKRS	Cash Ledger: Company Code for Cash Transactions	FAGL_CASH_BUKRS	CHAR	4	Assigned to domain		BUKRS
CASH_ACCOUNT	Cash Ledger: Cash-Relevant Account	FAGL_CASH_ACCOUNT	CHAR	10	Assigned to domain	ALPHA	SAKNR
.INCLU--AP				0
GRANT_NRB	Grant	GM_GRANT_NBR	CHAR	20		ALPHA	GM_GRANT_NBR	GM_GRANT_NBR	GRANTS_GENERIC
GRANT_NBR	Grant	GM_GRANT_NBR	CHAR	20		ALPHA	GM_GRANT_NBR	GM_GRANT_NBR	GRANTS_GENERIC
PGRANT_NBR	Partner Grant	GM_GRANT_PARTNER	CHAR	20		ALPHA	GM_GRANT_NBR		GRANTS_GENERIC
MEASURE	Funded Program	FM_MEASURE	CHAR	24	Assigned to domain		FM_MEASURE	FM_MEASURE
KNBUKRS	Company Code	BUKRS	CHAR	4	Assigned to domain		BUKRS	BUK	C_T001
KNGJAHR	Fiscal year for FI document number	FM_KNGJAHR	NUMC	4		GJAHR	GJAHR	GJR
KNBELNR	FI document number	FM_KNBELNR	CHAR	10		ALPHA	BELNR	BLN
KNBUZEI	Document item for FI document number	FM_KNBUZEI	NUMC	3			BUZEI
VOBUKRS	Company code for payment document number	FM_VOBUKRS	CHAR	4	Assigned to domain		BUKRS
VOGJAHR	Fiscal year for payment document number	FM_VOGJAHR	NUMC	4		GJAHR	GJAHR	GJR
VOBELNR	Payment Document Number	FM_VOBELNR	CHAR	10		ALPHA	BELNR	BLN
.INCLU--AP				0
VNAME	Joint Venture	JV_NAME	CHAR	6	Assigned to domain	ALPHA	JV_NAME	JVV
EGRUP	Equity group	JV_EGROUP	CHAR	3	Assigned to domain	ALPHA	JV_EGROUP	GJE
RECID	Recovery Indicator	JV_RECIND	CHAR	2	Assigned to domain	ALPHA	JV_RECIND
ORECID	Recovery Indicator	JV_RECIND	CHAR	2	Assigned to domain	ALPHA	JV_RECIND
BTYPE	Payroll Type	JV_BILIND	CHAR	2	Assigned to domain	ALPHA	JV_BILIND

Key field

Non-key field

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

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

SELECT SINGLE *
FROM FAGL_SPLINFO
INTO CORRESPONDING FIELDS OF WA_FAGL_SPLINFO
WHERE...

How to access SAP table FAGL_SPLINFO

Within an ECC or HANA version of SAP you can also view further information about FAGL_SPLINFO 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!