FAGL_SPLINFO_VAL
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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)
| 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 | |||
| 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)
);
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