FAGL_011ZC

Transparent Table Customizing Table
9 Fields 6 CDS Views

Fin. Statement Structure: Assignment FS Items - G/L Account

FAGL_011ZC is an SAP database table in S/4HANA. Fin. Statement Structure: Assignment FS Items - G/L Account. It contains 9 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
I_CN_CADEFinStatementLeafItem view from BASIC FS Leaf Item for CADE
P_FAGL_011ZC view from BASIC
P_FinStmtLeafWithGLAcct view left_outer BASIC
P_FSLeafWithGLAcctCoA1 view from BASIC
P_FSLeafWithGLAcctCoA1 view union_all BASIC
P_FSVSEMTAG view left_outer BASIC

Fields (9)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY versn VERSN_011 FS Version
KEY ergsl ERGSL FS Item
KEY ktopl KTOPL Chart of Accts
KEY vonkt VONKT_011Z Account From
biskt BISKT_011Z Account To
xsoll XSOLL_F02E Debit Balance
xhabn XHABN_F02E Credit Balance
xverd XVERD_011Z Group Balance

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: Assignment FS Items - G/L Account
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FAGL_011ZC (
    MANDT,  -- Client [MANDT]
    VERSN,  -- FS Version [VERSN_011]
    ERGSL,  -- FS Item [ERGSL]
    KTOPL,  -- Chart of Accts [KTOPL]
    VONKT,  -- Account From [VONKT_011Z]
    BISKT,  -- Account To [BISKT_011Z]
    XSOLL,  -- Debit Balance [XSOLL_F02E]
    XHABN,  -- Credit Balance [XHABN_F02E]
    XVERD,  -- Group Balance [XVERD_011Z]
    PRIMARY KEY (MANDT, VERSN, ERGSL, KTOPL, VONKT)
);

Learn More