FAGL_011ZC

Transparent Table Customizing Table
9 Fields 6 CDS Views

Bil/GuV-Struktur: Zuordnung Bil/GuV-Pos. - Hauptbuchkonten

FAGL_011ZC is an SAP database table in S/4HANA. Bil/GuV-Struktur: Zuordnung Bil/GuV-Pos. - Hauptbuchkonten. 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 Assignment of Financial Statement Items to G/L Accounts
P_FinStmtLeafWithGLAcct view left_outer BASIC Fin Statement Item with G/L Account (assigned & unassigned)
P_FSLeafWithGLAcctCoA1 view from BASIC FS leaf item with assigned G/L Account (in Chart of Account)
P_FSLeafWithGLAcctCoA1 view union_all BASIC FS leaf item with assigned G/L Account (in Chart of Account)
P_FSVSEMTAG view_entity left_outer BASIC Semantic Tag.

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.

-- Bil/GuV-Struktur: Zuordnung Bil/GuV-Pos. - Hauptbuchkonten
-- 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