1. Home
  2. Resources
  3. SAP Tables
  4. FAGL_SPLINFO - Splittling Information of Open Items

SAP Table FAGL_SPLINFO

Splittling Information of Open Items

FAGL_SPLINFO (Splittling Information of Open Items) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link FAGL_SPLINFO to other SAP tables.

FAGL_SPLINFO table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
BELNR Accounting Document Number BELNR_D CHAR 10 0
GJAHR Fiscal Year GJAHR NUMC 4 0
BUKRS Company Code BUKRS CHAR 4 0
BUZEI Number of Line Item Within Accounting Document BUZEI NUMC 3 0
SPL_NO Sequence Number of Splitting Information FAGL_INDEX NUMC 6 0
AWSYS Logical system of source document AWSYS CHAR 10 0
AWTYP Reference Transaction AWTYP CHAR 5 0
AWREF Reference Document Number AWREF CHAR 10 0
AWORG Reference Organizational Units AWORG CHAR 10 0
GSBER Business Area GSBER CHAR 4 0
PRCTR Profit Center PRCTR CHAR 10 0
SEGMENT Segment for Segmental Reporting FB_SEGMENT CHAR 10 0
PARGB Trading partner's business area PARGB CHAR 4 0
PPRCTR Partner Profit Center PPRCTR CHAR 10 0
PSEGMENT Partner Segment for Segmental Reporting FB_PSEGMENT CHAR 10 0
AUFNR Order Number AUFNR CHAR 12 0
IMKEY Internal Key for Real Estate Object IMKEY CHAR 8 0
DABRZ Reference Date for Settlement DABRBEZ DATS 8 0
KDAUF Sales Order Number KDAUF CHAR 10 0
KDPOS Item Number in Sales Order KDPOS NUMC 6 0
KOSTL Cost Center KOSTL CHAR 10 0
KSTRG Cost Object KSTRG CHAR 12 0
NPLNR Network Number for Account Assignment NPLNR CHAR 12 0
APLZL Internal counter CIM_COUNT NUMC 8 0
AUFPL Routing number of operations in the order CO_AUFPL NUMC 10 0
PAOBJNR Profitability Segment Number (CO-PA) RKEOBJNR NUMC 10 0
PS_PSP_PNR Work Breakdown Structure Element (WBS Element) PS_PSP_PNR NUMC 8 0
FIPOS Commitment Item FIPOS CHAR 14 0
FISTL Funds Center FISTL CHAR 16 0
GEBER Fund BP_GEBER CHAR 10 0
BUDGET_PD FM: Budget Period FM_BUDGET_PERIOD CHAR 10 0
PGEBER Partner Fund FM_PFUND CHAR 10 0
PBUDGET_PD FM: Partner Budget Period FM_PBUDGET_PERIOD CHAR 10 0
ANLN1 Main Asset Number ANLN1 CHAR 12 0
ANLN2 Asset Subnumber ANLN2 CHAR 4 0
ANBWA Asset Transaction Type ANBWA CHAR 3 0
BZDAT Asset value date BZDAT DATS 8 0
SHKZG Debit/Credit Indicator SHKZG CHAR 1 0
H Credit
S Debit
BSCHL Posting Key BSCHL CHAR 2 0
MWSKZ Tax on sales/purchases code MWSKZ CHAR 2 0
XSKRL Indicator: Line item not liable to cash discount? XSKRL CHAR 1 0
X Yes
NULL No
FKBER Functional Area FKBER CHAR 16 0
HKONT General Ledger Account HKONT CHAR 10 0
PSWSL Update Currency for General Ledger Transaction Figures PSWSL CUKY 5 0
PSWBT Amount for Updating in General Ledger PSWBT CURR 13 2
MENGE Quantity MENGE_D QUAN 13 3
MEINS Base Unit of Measure MEINS UNIT 3 0
REL_VER Release Version: New General Ledger with Document Splitting REL_VERSION NUMC 3 0
FKIMG Actual Invoiced Quantity FKIMG QUAN 13 3
VRKME Sales unit VRKME UNIT 3 0
FKLMG Billing quantity in stockkeeping unit FKLMG QUAN 13 3
CC_BUKRS Company Code BUKRS CHAR 4 0
CC_ACCOUNT General Ledger Account HKONT CHAR 10 0
RE_BUKRS Cash Ledger: Company Code for Expense/Revenue FAGL_RE_BUKRS CHAR 4 0
RE_ACCOUNT Cash Ledger: Expense or Revenue Account FAGL_RE_ACCOUNT CHAR 10 0
CASH_BUKRS Cash Ledger: Company Code for Cash Transactions FAGL_CASH_BUKRS CHAR 4 0
CASH_ACCOUNT Cash Ledger: Cash-Relevant Account FAGL_CASH_ACCOUNT CHAR 10 0
GRANT_NRB Grant GM_GRANT_NBR CHAR 20 0
GRANT_NBR Grant GM_GRANT_NBR CHAR 20 0
PGRANT_NBR Partner Grant GM_GRANT_PARTNER CHAR 20 0
MEASURE Funded Program FM_MEASURE CHAR 24 0
KNBUKRS Company Code BUKRS CHAR 4 0
KNGJAHR Fiscal year for FI document number FM_KNGJAHR NUMC 4 0
KNBELNR FI document number FM_KNBELNR CHAR 10 0
KNBUZEI Document item for FI document number FM_KNBUZEI NUMC 3 0
VOBUKRS Company code for payment document number FM_VOBUKRS CHAR 4 0
VOGJAHR Fiscal year for payment document number FM_VOGJAHR NUMC 4 0
VOBELNR Payment Document Number FM_VOBELNR CHAR 10 0
VNAME Joint Venture JV_NAME CHAR 6 0
EGRUP Equity group JV_EGROUP CHAR 3 0
RECID Recovery Indicator JV_RECIND CHAR 2 0
ORECID Recovery Indicator JV_RECIND CHAR 2 0
BTYPE Payroll Type JV_BILIND CHAR 2 0

FAGL_SPLINFO foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
FAGL_SPLINFO ZZREGION FAGL_SPLINFO ZZREGION ZREG User Defined Regions ZZREGION
FAGL_SPLINFO ZZREGION SYST MANDT ZREG User Defined Regions MANDT
FAGL_SPLINFO ZZSPREG SYST MANDT ZZSPREG Check table for ZZSPREG = Special Region MANDT
FAGL_SPLINFO ZZSPREG FAGL_SPLINFO ZZSPREG ZZSPREG Check table for ZZSPREG = Special Region ZZSPREG
FAGL_SPLINFO ZZSTATE SYST MANDT T005S Taxes: Region (Province) Key MANDT
FAGL_SPLINFO ZZSTATE * T005S Taxes: Region (Province) Key LAND1
FAGL_SPLINFO ZZSTATE FAGL_SPLINFO ZZSTATE T005S Taxes: Region (Province) Key BLAND
FAGL_SPLINFO ZZUSERFLD1 SYST MANDT ZFU1 Check Table for User Field 1 MANDT
FAGL_SPLINFO ZZUSERFLD1 FAGL_SPLINFO ZZUSERFLD1 ZFU1 Check Table for User Field 1 ZZUSERFLD1