FAGL_011PC

Transparent Table Customizing Table
14 Fields 7 CDS Views

Fin. Statement Structure: Items in Fin. Statement Structure

FAGL_011PC is an SAP database table in S/4HANA. Fin. Statement Structure: Items in Fin. Statement Structure. It contains 14 fields. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
FAC_CDS_FAGL_011PC view from CDS For FS Item Search Help
I_CN_CADEFinancialStatementItm view from BASIC List of FSItem for CADE
I_FinancialStatementItem view from BASIC Items in Financial Statement Version
P_fagl_011pc_Hier view from BASIC
P_FSHierarchy_Calc_Item view from BASIC
P_FSHierarchy_Calc_Item view union_all BASIC
P_FsvItemsWithCategory view from BASIC

Fields (14)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY versn VERSN_011 FS Version
KEY id SEU_ID ID
type SEU_TYPE Type
ergsl ERGSL FS Item
parent SEU_ID ID
child SEU_ID ID
nextn SEU_ID ID
stufe STUFE_F02E Hierarchy Level
summe SUMME_011P Ind: Totals
sign RR_RSIGN Chg of Sign(+/-)
aedat AEDAT Changed On
usnam USNAM User Name
aetim UP_TIME Time

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.

-- Fin. Statement Structure: Items in Fin. Statement Structure
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FAGL_011PC (
    MANDT,   -- Client [MANDT]
    VERSN,   -- FS Version [VERSN_011]
    ID,      -- ID [SEU_ID]
    TYPE,    -- Type [SEU_TYPE]
    ERGSL,   -- FS Item [ERGSL]
    PARENT,  -- ID [SEU_ID]
    CHILD,   -- ID [SEU_ID]
    NEXTN,   -- ID [SEU_ID]
    STUFE,   -- Hierarchy Level [STUFE_F02E]
    SUMME,   -- Ind: Totals [SUMME_011P]
    SIGN,    -- Chg of Sign(+/-) [RR_RSIGN]
    AEDAT,   -- Changed On [AEDAT]
    USNAM,   -- User Name [USNAM]
    AETIM,   -- Time [UP_TIME]
    PRIMARY KEY (MANDT, VERSN, ID)
);

Learn More