FAGL_SPLINFO_VAL

Transparent Table Application Table

Splitting Information of Open Item Values

FAGL_SPLINFO_VAL is an SAP database table in S/4HANA. Splitting Information of Open Item Values. It contains 11 fields. 8 CDS views read from this table.

CDS Views using this table (8)

ViewTypeJoinVDMDescription
finoc_naoi_1 view inner OrgChange: Non-Assigned Open Items 1
FINOC_NAOI_2 view inner OrgChange: Non-Assigned Open Items 2
FINOC_TRANSFER_APAR view inner Organization Change: Transfer for AP/AR items
FINOC_TRANSFER_APAR_SIM_OI view inner Organization Change: Simulation of Transfer for non-enriched AP/AR items
fins_cnv_rec_si_0 view inner LCC: Selection of split line items
fins_ic_spl_0 view inner IC: Selection of split line items
I_GteeMIndrctCostSplitInfoVals view from BASIC GM Indirect Cost Split Information Values
IC_SelectSplitLineItems view inner IC: Selection of split line items

Fields (11)

KeyField Data ElementDescription DomainTypeLength
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
KEY curtp CURTP Crcy type/val.
waers WAERS Currency
wrbtr ACBTR Amount
currtyp CURRTYP Currency Type
_dataaging DATA_TEMPERATURE Data Aging

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.

-- Splitting Information of Open Item Values
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FAGL_SPLINFO_VAL (
    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]
    CURTP,       -- Crcy type/val. [CURTP]
    WAERS,       -- Currency [WAERS]
    WRBTR,       -- Amount [ACBTR]
    CURRTYP,     -- Currency Type [CURRTYP]
    _DATAAGING,  -- Data Aging [DATA_TEMPERATURE]
    PRIMARY KEY (MANDT, BELNR, GJAHR, BUKRS, BUZEI, SPL_NO, CURTP)
);