P_FINSTMTLEAFITEM

CDS View

P_FINSTMTLEAFITEM is a CDS View in S/4HANA. It contains 16 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_FinStmtHierarchy view union_all BASIC
P_FSVHierarchy view union_all BASIC

Fields (16)

KeyField CDS FieldsUsed in Views
KEY ergsl ergsl 2
KEY fkber fkber 2
KEY ktopl ktopl 2
KEY saknr saknr 2
KEY UniqueParentID UniqueParentID 2
KEY versn versn 2
child child 2
Description Description 2
ergs2 ergs2 2
id id 2
nextn nextn 2
parent parent 2
stufe stufe 2
type type 2
xhabn xhabn 2
xsoll xsoll 2

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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_FINSTMTLEAFITEM (
    ERGSL,
    FKBER,
    KTOPL,
    SAKNR,
    UNIQUEPARENTID,
    VERSN,
    CHILD,
    DESCRIPTION,
    ERGS2,
    ID,
    NEXTN,
    PARENT,
    STUFE,
    TYPE,
    XHABN,
    XSOLL,
    PRIMARY KEY (ERGSL, FKBER, KTOPL, SAKNR, UNIQUEPARENTID, VERSN)
);