FAGL_SPLINFO
Splittling Information of Open Items
FAGL_SPLINFO is an SAP database table in S/4HANA. Splittling Information of Open Items. It contains 101 fields. 13 CDS views read from this table.
CDS Views using this table (13)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| finoc_check_oi | view_entity | from | Org.Chg: Check for unenriched open items | |
| finoc_naoi_1 | view | from | OrgChange: Non-Assigned Open Items 1 | |
| FINOC_RULE_OI | view | from | OrgChange-Rule: Non-Assigned Open Items | |
| FINOC_SPL_DC_CLR | view | inner | OrgChange: Documents to be reconstructed | |
| FINOC_TRANSFER_APAR | view | from | Organization Change: Transfer for AP/AR items | |
| fins_cnv_rec_si_0 | view | from | LCC: Selection of split line items | |
| fins_cnv_rec_si_maxno | view | from | LCC: Selection of max SPL_NO | |
| fins_ic_spl_0 | view | from | IC: Selection of split line items | |
| fins_ic_spl_max | view | from | IC: Selection of max SPL_NO | |
| I_GteeMBillingSplitInfo | view | from | BASIC | Grantee Mgmt Billing Split Information |
| I_GteeMIndrctCostSplitInfo | view | from | BASIC | GM Indirect Cost Split Information |
| I_USFedOpenItemSplitInfo | view_entity | from | BASIC | |
| IC_SelectSplitLineItems | view | from | IC: Selection of split line items |
Fields (101)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | belnr | BELNR_D | Document Number | |||
| KEY | gjahr | GJAHR | Fiscal Year | |||
| KEY | bukrs | BUKRS | Company Code | |||
| KEY | buzei | BUZEI | Item | |||
| KEY | spl_no | FAGL_INDEX | Sequence Number | |||
| awsys | AWSYS | Logical System | ||||
| awtyp | AWTYP | Ref. procedure | ||||
| awref | AWREF | Reference Doc. | ||||
| aworg | AWORG | Refer. Org.Unit | ||||
| gsber | GSBER | Business Area | ||||
| prctr | PRCTR | Profit Center | ||||
| segment | FB_SEGMENT | Segment | ||||
| pargb | PARGB | Trdg Part.BA | ||||
| pprctr | PPRCTR | Partner PC | ||||
| psegment | FB_PSEGMENT | Partner Segment | ||||
| aufnr | AUFNR | Order | ||||
| imkey | IMKEY | Real Estate Key | ||||
| dabrz | DABRBEZ | Reference date | ||||
| kdauf | KDAUF | Sales Order | ||||
| kdpos | KDPOS | Sales Ord. Item | ||||
| kostl | KOSTL | Cost Center | ||||
| kstrg | KSTRG | Cost Object | ||||
| nplnr | NPLNR | Network | ||||
| aplzl | CIM_COUNT | Counter | ||||
| aufpl | CO_AUFPL | Plan No.f.Oper. | ||||
| paobjnr | RKEOBJNR | Profit. segment | ||||
| ps_psp_pnr | PS_PSP_PNR | WBS Element | ||||
| service_doc_type | FCO_SRVDOC_TYPE | Service Doc. Type | ||||
| service_doc_id | FCO_SRVDOC_ID | Service Document | ||||
| service_doc_item_id | FCO_SRVDOC_ITEM_ID | Service Doc. Item | ||||
| fipos | FIPOS | Commitment item | ||||
| fistl | FISTL | Funds Center | ||||
| geber | BP_GEBER | Fund | ||||
| budget_pd | FM_BUDGET_PERIOD | Budget Period | ||||
| pgeber | FM_PFUND | Partner Fund | ||||
| pbudget_pd | FM_PBUDGET_PERIOD | Par. BudPer | ||||
| bdgt_account | PSM_BDGT_ACCOUNT | Budget Account | ||||
| bdgt_account_cocode | PSM_BDGT_ACCOUNT_COCODE | Company Code for Budget Account | ||||
| fmcmmtstr | FMCMMTSTR | Commitment string | ||||
| fmfg_obj_cl | FMFG_OBJ_CL | Obj Class US Fed | ||||
| anln1 | ANLN1 | Asset | ||||
| anln2 | ANLN2 | Sub-number | ||||
| anbwa | ANBWA | Ast Transaction Type | ||||
| bzdat | BZDAT | Asset Val. Date | ||||
| dummy_incl_eew_cobl | CFD_DUMMY | Dummy | ||||
| shkzg | SHKZG | Debit/Credit | ||||
| bschl | BSCHL | Posting Key | ||||
| mwskz | MWSKZ | Tax Code | ||||
| txdat_from | FOT_TXDAT_FROM | Tax Rate Valid-From | ||||
| tax_country | FOT_TAX_COUNTRY | Tax Ctry/Reg. | ||||
| xskrl | XSKRL | W/o CashDsc. | ||||
| fkber | FKBER | Functional Area | ||||
| hkont | HKONT | G/L Acct | ||||
| pswsl | PSWSL | G/L Currency | ||||
| pswbt | PSWBT | G/L Amount | ||||
| menge | MENGE_D | Quantity | ||||
| meins | MEINS | Base Unit | ||||
| rel_ver | REL_VERSION | Release Version | ||||
| fkimg | FKIMG | Invoiced Qty | ||||
| vrkme | VRKME | Sales Unit | ||||
| fklmg | FKLMG | Bill.Qty in SKU | ||||
| hist_tax_factor | FOT_HIST_FACTOR_FOR_TAX_AMOUNT | CrcyCnvrsnFctrTaxAmt | ||||
| _dataaging | DATA_TEMPERATURE | Data Aging | ||||
| cc_bukrs | BUKRS | Company Code | ||||
| cc_account | HKONT | G/L Acct | ||||
| re_bukrs | FAGL_RE_BUKRS | Company Code | ||||
| re_account | FAGL_RE_ACCOUNT | Ex/Rv A/c in CL | ||||
| cash_bukrs | FAGL_CASH_BUKRS | Company Code | ||||
| cash_account | FAGL_CASH_ACCOUNT | Cash-Rel. Acct | ||||
| prctr_drvtn_source_type | FINOC_PRCTR_DRVTN_SOURCE_TYPE | Profit Center Source | ||||
| matnr | MATNR | Material | ||||
| werks | WERKS_D | Plant | ||||
| open_item_id | FINOC_OPENITEM_ID | Open Item ID | ||||
| grant_nrb | GM_GRANT_NBR | Grant | ||||
| measure | FM_MEASURE | Funded Program | ||||
| knbukrs | BUKRS | Company Code | ||||
| kngjahr | FM_KNGJAHR | Fiscal year | ||||
| knbelnr | FM_KNBELNR | FI document no. | ||||
| knbuzei | FM_KNBUZEI | Item | ||||
| vobukrs | FM_VOBUKRS | Company code | ||||
| vogjahr | FM_VOGJAHR | Fiscal year | ||||
| vobelnr | FM_VOBELNR | Payment Document No. | ||||
| kblnr | KBLNR | Earmarked Funds | ||||
| kblpos | KBLPOS | Document Item | ||||
| grant_nbr | GM_GRANT_NBR | Grant | ||||
| pgrant_nbr | GM_GRANT_PARTNER | Partner Grant | ||||
| rsponsored_prog | GM_SPONSORED_PROG | Sponsored Program | ||||
| rsponsored_class | GM_SPONSORED_CLASS | Sponsored Class | ||||
| vname | JV_NAME | Joint venture | ||||
| egrup | JV_EGROUP | Equity group | ||||
| recid | JV_RECIND | Recovery Ind. | ||||
| vptnr | JV_PART | Partner | ||||
| etype | JV_ETYPE | Equity Type | ||||
| prodper | JV_PRODPER | Prod.Month | ||||
| orecid | JV_RECIND | Recovery Ind. | ||||
| btype | JV_BILIND | Billing ind. | ||||
| billm | JV_BILLM | Billing Month | ||||
| pom | JV_POM | Proc.Oper.Month | ||||
| pvname | JV_PVNAME | Partner Venture JVA | ||||
| pegrup | JV_PEGRUP | Partner EG (JVA) |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Splittling Information of Open Items
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FAGL_SPLINFO (
MANDT, -- Client [MANDT]
BELNR, -- Document Number [BELNR_D]
GJAHR, -- Fiscal Year [GJAHR]
BUKRS, -- Company Code [BUKRS]
BUZEI, -- Item [BUZEI]
SPL_NO, -- Sequence Number [FAGL_INDEX]
AWSYS, -- Logical System [AWSYS]
AWTYP, -- Ref. procedure [AWTYP]
AWREF, -- Reference Doc. [AWREF]
AWORG, -- Refer. Org.Unit [AWORG]
GSBER, -- Business Area [GSBER]
PRCTR, -- Profit Center [PRCTR]
SEGMENT, -- Segment [FB_SEGMENT]
PARGB, -- Trdg Part.BA [PARGB]
PPRCTR, -- Partner PC [PPRCTR]
PSEGMENT, -- Partner Segment [FB_PSEGMENT]
AUFNR, -- Order [AUFNR]
IMKEY, -- Real Estate Key [IMKEY]
DABRZ, -- Reference date [DABRBEZ]
KDAUF, -- Sales Order [KDAUF]
KDPOS, -- Sales Ord. Item [KDPOS]
KOSTL, -- Cost Center [KOSTL]
KSTRG, -- Cost Object [KSTRG]
NPLNR, -- Network [NPLNR]
APLZL, -- Counter [CIM_COUNT]
AUFPL, -- Plan No.f.Oper. [CO_AUFPL]
PAOBJNR, -- Profit. segment [RKEOBJNR]
PS_PSP_PNR, -- WBS Element [PS_PSP_PNR]
SERVICE_DOC_TYPE, -- Service Doc. Type [FCO_SRVDOC_TYPE]
SERVICE_DOC_ID, -- Service Document [FCO_SRVDOC_ID]
SERVICE_DOC_ITEM_ID, -- Service Doc. Item [FCO_SRVDOC_ITEM_ID]
FIPOS, -- Commitment item [FIPOS]
FISTL, -- Funds Center [FISTL]
GEBER, -- Fund [BP_GEBER]
BUDGET_PD, -- Budget Period [FM_BUDGET_PERIOD]
PGEBER, -- Partner Fund [FM_PFUND]
PBUDGET_PD, -- Par. BudPer [FM_PBUDGET_PERIOD]
BDGT_ACCOUNT, -- Budget Account [PSM_BDGT_ACCOUNT]
BDGT_ACCOUNT_COCODE, -- Company Code for Budget Account [PSM_BDGT_ACCOUNT_COCODE]
FMCMMTSTR, -- Commitment string [FMCMMTSTR]
FMFG_OBJ_CL, -- Obj Class US Fed [FMFG_OBJ_CL]
ANLN1, -- Asset [ANLN1]
ANLN2, -- Sub-number [ANLN2]
ANBWA, -- Ast Transaction Type [ANBWA]
BZDAT, -- Asset Val. Date [BZDAT]
DUMMY_INCL_EEW_COBL, -- Dummy [CFD_DUMMY]
SHKZG, -- Debit/Credit [SHKZG]
BSCHL, -- Posting Key [BSCHL]
MWSKZ, -- Tax Code [MWSKZ]
TXDAT_FROM, -- Tax Rate Valid-From [FOT_TXDAT_FROM]
TAX_COUNTRY, -- Tax Ctry/Reg. [FOT_TAX_COUNTRY]
XSKRL, -- W/o CashDsc. [XSKRL]
FKBER, -- Functional Area [FKBER]
HKONT, -- G/L Acct [HKONT]
PSWSL, -- G/L Currency [PSWSL]
PSWBT, -- G/L Amount [PSWBT]
MENGE, -- Quantity [MENGE_D]
MEINS, -- Base Unit [MEINS]
REL_VER, -- Release Version [REL_VERSION]
FKIMG, -- Invoiced Qty [FKIMG]
VRKME, -- Sales Unit [VRKME]
FKLMG, -- Bill.Qty in SKU [FKLMG]
HIST_TAX_FACTOR, -- CrcyCnvrsnFctrTaxAmt [FOT_HIST_FACTOR_FOR_TAX_AMOUNT]
_DATAAGING, -- Data Aging [DATA_TEMPERATURE]
CC_BUKRS, -- Company Code [BUKRS]
CC_ACCOUNT, -- G/L Acct [HKONT]
RE_BUKRS, -- Company Code [FAGL_RE_BUKRS]
RE_ACCOUNT, -- Ex/Rv A/c in CL [FAGL_RE_ACCOUNT]
CASH_BUKRS, -- Company Code [FAGL_CASH_BUKRS]
CASH_ACCOUNT, -- Cash-Rel. Acct [FAGL_CASH_ACCOUNT]
PRCTR_DRVTN_SOURCE_TYPE, -- Profit Center Source [FINOC_PRCTR_DRVTN_SOURCE_TYPE]
MATNR, -- Material [MATNR]
WERKS, -- Plant [WERKS_D]
OPEN_ITEM_ID, -- Open Item ID [FINOC_OPENITEM_ID]
GRANT_NRB, -- Grant [GM_GRANT_NBR]
MEASURE, -- Funded Program [FM_MEASURE]
KNBUKRS, -- Company Code [BUKRS]
KNGJAHR, -- Fiscal year [FM_KNGJAHR]
KNBELNR, -- FI document no. [FM_KNBELNR]
KNBUZEI, -- Item [FM_KNBUZEI]
VOBUKRS, -- Company code [FM_VOBUKRS]
VOGJAHR, -- Fiscal year [FM_VOGJAHR]
VOBELNR, -- Payment Document No. [FM_VOBELNR]
KBLNR, -- Earmarked Funds [KBLNR]
KBLPOS, -- Document Item [KBLPOS]
GRANT_NBR, -- Grant [GM_GRANT_NBR]
PGRANT_NBR, -- Partner Grant [GM_GRANT_PARTNER]
RSPONSORED_PROG, -- Sponsored Program [GM_SPONSORED_PROG]
RSPONSORED_CLASS, -- Sponsored Class [GM_SPONSORED_CLASS]
VNAME, -- Joint venture [JV_NAME]
EGRUP, -- Equity group [JV_EGROUP]
RECID, -- Recovery Ind. [JV_RECIND]
VPTNR, -- Partner [JV_PART]
ETYPE, -- Equity Type [JV_ETYPE]
PRODPER, -- Prod.Month [JV_PRODPER]
ORECID, -- Recovery Ind. [JV_RECIND]
BTYPE, -- Billing ind. [JV_BILIND]
BILLM, -- Billing Month [JV_BILLM]
POM, -- Proc.Oper.Month [JV_POM]
PVNAME, -- Partner Venture JVA [JV_PVNAME]
PEGRUP, -- Partner EG (JVA) [JV_PEGRUP]
PRIMARY KEY (MANDT, BELNR, GJAHR, BUKRS, BUZEI, SPL_NO)
);Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA